def initDatabases(self): self.items = ItemStorage(nextID=1000) self.db = sa.create_engine('sqlite://') # if os.path.exists('../test.db'): # os.unlink('../test.db') # self.db = sa.create_engine('sqlite:///../test.db') pysyncml.enableSqliteCascadingDeletes(self.db)
def _setupModel(self): createDb = not os.path.isfile('%s%s.db' % (self.dataDir, self.appLabel)) self.dbengine = sa.create_engine('sqlite:///%s%s.db' % (self.dataDir, self.appLabel)) pysyncml.enableSqliteCascadingDeletes(self.dbengine) self.dbsession = sessionmaker(bind=self.dbengine)() self._callHooks('model.setup.init') self.model = makeModel(self) self._callHooks('model.setup.extend') if createDb: self.model.DatabaseObject.metadata.create_all(self.dbengine) # TODO: implement detection of the schema changing... self._callHooks('model.setup.term')
def setUp(self): # create the databases self.serverSyncDb = sqlalchemy.create_engine('sqlite://') self.desktopSyncDb = sqlalchemy.create_engine('sqlite://') self.mobileSyncDb = sqlalchemy.create_engine('sqlite://') pysyncml.enableSqliteCascadingDeletes(self.serverSyncDb) pysyncml.enableSqliteCascadingDeletes(self.desktopSyncDb) pysyncml.enableSqliteCascadingDeletes(self.mobileSyncDb) self.serverItems = ItemStorage(nextID=1000) self.desktopItems = ItemStorage(nextID=2000) self.mobileItems = ItemStorage(nextID=3000) self.server = None self.desktop = None self.mobile = None self.resetAdapters()