U++ framework: U++ SQL » Application with two different databases schema

Home » U++ Library support » U++ SQL » Application with two different databases schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Application with two different databases schema [message #53841]

Fri, 08 May 2020 17:41

forlano
Messages: 1244
Registered: March 2006
Location: Italy

Senior Contributor

Hello,

I have a program that stores data on a local Sqlite3 db. Moreover it needs to connect to an online MySql db.
Can this scenario be managed? In case of affermative answer how to do it? It is convenient to have one .sch file or two?...

After trying several possibilities, to avoid error from CLANG (many duplicate and redefinition), I found a solution that is accepeted by CLANG. I am using a single .SCH file with the definition of the two dbs. In a .h file I have

#define SCHEMADIALECT <plugin/sqlite3/Sqlite3Schema.h>
#define MODEL <OrionVR/db.sch>

#define SCHEMADIALECT2 <MySql/MySqlSchema.h>

#include <Sql/sch_header.h>

Then in a .cpp file I used

#include "Sql/sch_schema.h"
#include "Sql/sch_source.h"

It compiles but the program crash immediately.
I am sure I am doing weird things. Which is the correct way to do it?

Thanks,
Luigi

Report message to a moderator

[Message index]

		Application with two different databases schema By: forlano on Fri, 08 May 2020 17:41
		Re: Application with two different databases schema By: forlano on Sat, 09 May 2020 03:00
		Re: Application with two different databases schema By: slashupp on Sat, 09 May 2020 12:13
		Re: Application with two different databases schema By: forlano on Sat, 09 May 2020 12:46
		Re: Application with two different databases schema By: mirek on Mon, 11 May 2020 10:21
		Re: Application with two different databases schema By: forlano on Mon, 11 May 2020 12:08
		Re: Application with two different databases schema By: mirek on Wed, 13 May 2020 11:24
		Re: Application with two different databases schema By: forlano on Wed, 13 May 2020 15:49
		Re: Application with two different databases schema By: JeyCi on Wed, 02 June 2021 13:11

Previous Topic:	Jsonize() in database table structures (S_*) [patch]
Next Topic:	OleDBSession in Archive

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 31 00:09:02 GMT+1 2026

Total time taken to generate the page: 0.12081 seconds