+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Gekko (https://forum.gekko.wizb.it/forum-13.html)
+--- Forum: Technical Support (https://forum.gekko.wizb.it/forum-19.html)
+--- Thread: Database file MERGE ? [SOLVED] (/thread-1485.html)
Database file MERGE ? [SOLVED] - susitronix - 02-13-2018
Is it possible to MERGE TWO DB-FILES into ONE COMPLETE FILE?
Is ther eny tools for it?
RE: Importer Database file MERGE ? - tommiehansen - 02-13-2018
Google is your friend
Try
nodejs sqlite merge
RE: Importer Database file MERGE ? - susitronix - 02-14-2018
DuckDuck could only find this:
Martin Pelletier, Software developer
Updated Aug 4 2014 · Author has 53 answers and 67.2k answer views
Connect to database A
Attach database B (ATTACH "c:\database_b\places.sqlite" AS SecondaryDB)
Transfer data from B to A (INSERT INTO MyTable SELECT * FROM SecondaryDB.MyTable) - Works assuming there is no primary key conflict. If there are, you might have to cheat and offset the B table's primary key by a large number, or tweak your query to use the auto increment of database A's table)
Disconnect from database A (no need to DETACH from database B if you're exiting at this point).
öch thats not too noobish to mess around with.
Since my new Kraken Account i found a db for every Exchange.
Did i missed somthing?
could i rename one of the two Binance db`s and drop them into the same /history?
Did not thought about this when starting with Gekko
RE: Importer Database file MERGE ? - tommiehansen - 02-14-2018
Try also searching for stuff such as
sqlite diff merge tool
RE: Importer Database file MERGE ? - susitronix - 02-14-2018
Hey thanks
Found phpLite and sqliteStudio. try it soon
RE: Importer Database file MERGE ? - susitronix - 02-14-2018
sqliteStudio is super neat.
Thats a good tool to have.
RE: Database file MERGE ? [SOLVED] - tommiehansen - 02-14-2018
So you worked it out? Great! (especially since you solved it yourself = new skill acquired)
Feel free to write a guide about it under the forum 'Guides'.
RE: Database file MERGE ? [SOLVED] - susitronix - 02-14-2018
With a little hint..!
Good idea!
RE: Database file MERGE ? [SOLVED] - susitronix - 02-15-2018
Find the tutorial here:
https://forum.gekko.wizb.it/thread-1494.html