my_migrate.py 406 B

12345678910111213141516171819
  1. import traceback
  2. import copy
  3. import operator
  4. import codecs
  5. import sys
  6. import os
  7. import searchconsole
  8. import dataset
  9. import datetime
  10. import random
  11. local_db = dataset.connect('sqlite:///c:/tmp/hhh.db')
  12. #db = dataset.connect('mysql://choozmo:pAssw0rd@139.162.121.30:33306/hhh?charset=utf8mb4')
  13. cursor=local_db.query('select * from monitor_kw_raw')
  14. #table=db['monitor_kw_raw']
  15. for c in cursor:
  16. print(c)