def update_seg_row(self, seg_row):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('local_segs.update'), seg_row[1:] + (seg_row[0],))
return cur.rowcount
def del_seg_by_hash(self, seg_hash):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('local_segs.delete_by_pk'), (seg_hash,))
return cur.rowcount
def load_segs_by_file(self, file_hash):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('local_segs.select_by_fk'), (file_hash,))
return cur
def save_seg_row(self, seg_row):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('local_segs.insert'), seg_row)
return cur.rowcount
def load_seg_by_hash(self, hash):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('local_segs.select_by_pk'), (hash,))
return cur
def load_all_segs(self):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('local_segs.select_all'))
return cur
def del_by_name(self, name):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('prof_attrs.delete_by_pk'), (name,))
return cur.rowcount
def load_all(self):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('prof_attrs.select_all'))
return cur
def load_by_name(self, name):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('prof_attrs.select_by_pk'), (name,))
return cur
def update_row(self, row):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('prof_attrs.update'), (row[1], row[0]))
return cur.rowcount
def save_row(self, row):
self._check_conn()
cur = self._conn.execute(
supp.get_sql('prof_attrs.insert'), row)
return cur.rowcount