def _extract_all_last_update(self):
self._info("Extracting data for " + self.table
+ " table (last_update)")
cursor = DB.remote_cursor()
cursor.execute(self.queries['query_last_update'],
(self.last_update, self.last_update))
self.db_data = cursor.fetchall()
self._debug("Rows returned: %d" % (cursor.rowcount))
def extract(self):
start = datetime.now()
self._extract_no_last_update()
cursor = DB.remote_cursor()
cursor.execute(self.tenant_owner_query)
self.tenant_owner_data = cursor.fetchall()
cursor.execute(self.tenant_member_query)
self.tenant_member_data = cursor.fetchall()
self.extract_time = datetime.now() - start
def _extract_all(self):
self._info("Extracting data for table " + self.table)
cursor = DB.remote_cursor()
cursor.execute(self.queries['query'])
self.db_data = cursor.fetchall()
self._debug("Rows returned: %d" % (cursor.rowcount))
