tttdb.py

   1 #!/usr/bin/python
   2 # Author: Daniel Garcia <dani@danigm.net>
   3 # License: GPLv3
   4
   5 from sqlobject import *
   6 import os
   7
   8 class Tracker(SQLObject):
   9     project = StringCol()
  10     task = StringCol()
  11     ticket = IntCol()
  12     start = DateTimeCol()
  13     end = DateTimeCol()
  14
  15 def get_hub():
  16     connection_string = 'sqlite://%s/devdata.sqlite' % os.getcwd()
  17     connection = connectionForURI(connection_string)
  18     sqlhub.processConnection = connection
  19
  20     return sqlhub
  21
  22 def create_db():
  23     # You need to create the database before.
  24     sqlhub = get_hub()
  25
  26     Tracker.createTable()
  27
  28 if __name__ == '__main__':
  29     create_db()