U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

Application with two different databases schema [message #53841]

Fri, 08 May 2020 17:41

forlano is currently offline

forlano
Messages: 1207
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

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Fri Apr 25 19:03:44 CEST 2025

Total time taken to generate the page: 0.00678 seconds