导入_MySQL转储到SQLite导入

篇首语：本文由编程笔记#小编为大家整理，主要介绍了MySQL转储到SQLite导入相关的知识，希望对你有一定的参考价值。

1. import re, fileinput
2.  
3. def main&＃40;&＃41;:
4. for line in fileinput.input&＃40;&＃41;:
5. process = False
6. for nope in &＃40;'BEGIN TRANSACTION','COMMIT',
7. 'sqlite_sequence','CREATE UNIQUE INDEX'&＃41;:
8. if nope in line: break
9. else:
10. process = True
11. if not process: continue
12. m = re.search&＃40;'CREATE TABLE "([a-z_]*)"(.*)', line&＃41;
13. if m:
14. name, sub = m.groups&＃40;&＃41;
15. line = '''DROP TABLE IF EXISTS %(name)s;
16. CREATE TABLE IF NOT EXISTS %(name)s%(sub)s
17. '''
18. line = line % dict&＃40;name=name, sub=sub&＃41;
19. else:
20. m = re.search&＃40;'INSERT INTO "([a-z_]*)"(.*)', line&＃41;
21. if m:
22. line = 'INSERT INTO %s%s
    ' % m.groups&＃40;&＃41;
23. line = line.replace&＃40;'"', r'"'&＃41;
24. line = line.replace&＃40;'"', "'"&＃41;
25. line = re.sub&＃40;r"([^'])'t'(.)", "1THIS_IS_TRUE2", line&＃41;
26. line = line.replace&＃40;'THIS_IS_TRUE', '1'&＃41;
27. line = re.sub&＃40;r"([^'])'f'(.)", "1THIS_IS_FALSE2", line&＃41;
28. line = line.replace&＃40;'THIS_IS_FALSE', '0'&＃41;
29. print line,
30.  
31. main&＃40;&＃41;