create_timescale_table.py 591 B

12345678910111213141516171819202122232425
  1. # -*- coding: utf-8 -*-
  2. #!/usr/bin/env python
  3. """
  4. 将重复的用户按组归并
  5. """
  6. import os
  7. import sys
  8. PROJECT_ROOT = os.path.join(os.path.abspath(os.path.split(os.path.realpath(__file__))[0] + "/.."), '..')
  9. sys.path.insert(0, PROJECT_ROOT)
  10. os.environ.update({"DJANGO_SETTINGS_MODULE": "configs.testing"})
  11. import django
  12. django.setup()
  13. print u'导入所有充值的设备数据,以修改simStatus字段'
  14. createStr = 'CREATE TABLE powers (\
  15. time timestamp NOT NULL,\
  16. orderno text NOT NULL,\
  17. power integer NOT NULL\
  18. );'
  19. print u'全部完成'