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))