def populateTables(self): for d in self._durationList: with self._connection: _c = self._connection.cursor() _c.execute('INSERT INTO Durations VALUES (?,?)', (None, d.name)) lastRowID = _c.lastrowid e = MultipleEventsSavingObject(d.events, self._filename, lastRowID) e.populateTables()
def populateTables(self): with self._connection: self._populateRolesTables() self._populatePopulationTables() self._populateTimesTable() e = MultipleEventsSavingObject(self._institution.templates, self._filename, None) d = DurationSavingObject(self._institution.durations, self._filename) e.populateTables() d.populateTables()
def loadTables(self, institution, personCacheDict=None): listOfDurationTupples = [] with self._connection: _c = self._connection.cursor() for row in _c.execute('SELECT * FROM Durations'): d = Duration(institution) d.name = row[1] listOfDurationTupples.append((row[0], d)) e = MultipleEventsSavingObject([], self._filename, 0) for t in listOfDurationTupples: e.loadEvents(t[1], t[0], personCacheDict) institution.durations.append(t[1])