After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 567054 - Merge two databases
Merge two databases
Status: RESOLVED FIXED
Product: chronojump
Classification: Other
Component: chronojump
unspecified
Other All
: Normal enhancement
: ---
Assigned To: Xavier de Blas
Xavier de Blas
Depends on:
Blocks:
 
 
Reported: 2009-01-08 18:18 UTC by Xavier de Blas
Modified: 2020-12-25 12:36 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Xavier de Blas 2009-01-08 18:18:44 UTC
designed for people who is working with different computers and have data spared in several db files:

this (replacing sqlite for sqlite3)
http://osdir.com/ml/db.sqlite.general/2003-03/msg00229.html
is good for not creating again every table (only created one time), but it doesn't manage the repeated IDs of every table entry

the 'cat' command says:
INSERT INTO "person" VALUES(34,'Xavi2','M','1/1/1900',0,-1,2,-1,0,'',-1,1,-1);
SQL error: PRIMARY KEY must be unique


read this:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg12675.html

read also this for a coded aproach:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg12681.html

also read this:
http://marc.info/?l=sqlite-users&m=118294015331423&w=2

To merge tables this thread can be useful:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg27594.html