U++ forum: Welcome to the forum

Re: How to use multiple schemas and databases? [message #45517 is a reply to message #45446]

Thu, 26 November 2015 23:55

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

Something like this:


#define NOAPPSQL

...

#include <plugin/sqlite3/Sqlite3.h>
#include <Sql/sch_schema.h>

Sqlite3Session db1;
Sqlite3Session db2;
{
#define MODEL <MySuperApp/db1.sch>
#include "Sql/sch_source.h"
    db1.Open("db1.db");

    SqlSchema sch1(SQLITE3);
    All_Tables(sch1);
    sch1.SaveNormal();
    SqlPerformScript(sch1.Upgrade());
    SqlPerformScript(sch1.Attributes());
}
#undef MODEL
{
#define MODEL <MySuperApp/db2.sch>
#include "Sql/sch_source.h"
    db2.Open("db2.db");

    SqlSchema sch2(SQLITE3);
    All_Tables(sch2);
    sch2.SaveNormal();
    SqlPerformScript(sch2.Upgrade());
    SqlPerformScript(sch2.Attributes());
}

...

Sql sql1(db1);
sql1 * Select .....


Sql sql2(db2);
sql2 * Insert .....

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator