cV3HPKtP

1import sqlite3
2import time
3import sqlite3
4Dbase = 'test0.db'
5conn = sqlite3.connect(Dbase)
6c = conn.cursor()
7c.execute('''
8CREATE VIRTUAL TABLE IF NOT EXISTS merge
9USING FTS3(file, keyword);
10''')
11
12Dbase = 'test1.db'
13con = sqlite3.connect(Dbase)
14cc = con.cursor()
15cc.execute('''
16CREATE VIRTUAL TABLE IF NOT EXISTS merge 
17USING FTS3(file0, keyword0);
18''')
19
20Dbase = 'test2.db'
21co = sqlite3.connect(Dbase)
22ccc = co.cursor()
23ccc.execute('''
24CREATE VIRTUAL TABLE IF NOT EXISTS merge 
25USING FTS3(file1, keyword1);
26''')
27co.commit()
28
29file = """
30second time - This is data for database test0.db
31"""
32keyword = "SQLite inserting one database into another"
33c.execute("INSERT INTO merge VALUES (?,?)", (file, keyword))
34conn.commit()
35for row in c.execute("select * FROM merge"):
36    print row[0],row[1]
37    ccc.execute("INSERT INTO merge VALUES (?,?)", (row[0],row[1]))
38    co.commit()
39conn.close()
40
41file0 = """
42SECOND ENTRY - This is data for database test1.db
43"""
44keyword0 = "SQLite inserting test0.db database into test1.db"
45cc.execute("INSERT INTO merge VALUES (?,?)", (file0, keyword0))
46con.commit()
47for row1 in cc.execute("select * FROM merge"):
48    print row1[0],row1[1]
49    ccc.execute("INSERT INTO merge VALUES (?,?)", (row1[0],row1[1]))
50    co.commit()
51
52con.close()
53print ("--------------------------------------")
54Dbase = 'test2.db'
55co = sqlite3.connect(Dbase)
56ccc = co.cursor()
57for rowz in ccc.execute("select rowid,* FROM merge"):
58    print  'test2.db: ROW:',rowz[0],"\n",rowz[1],rowz[1]