def simpleBedUpdateWrapper(self, valueDict, db, genome, column):
"""
If your details-mode classifier has BED records for values in its valueDict, use this.
"""
with sql_lib.ExclusiveSqlConnection(db) as cur:
sql_lib.updateRows(cur, genome, self.primaryKeyColumn, column,
self.detailsEntryIter(valueDict.iteritems()))
def simpleUpdateWrapper(self, valueDict, db, genome, column):
"""
If your classifier is going to do a simple 1-1 update with a valueDict, use this.
"""
with sql_lib.ExclusiveSqlConnection(db) as cur:
sql_lib.updateRows(cur, genome, self.primaryKeyColumn, column,
self.invertDict(valueDict))
def buildNameRow(self, db, genome, aug_aIds, aIds, primaryKey):
with sql_lib.ExclusiveSqlConnection(db) as cur:
cur.execute(
"""ALTER TABLE '{}' ADD COLUMN aId TEXT """.format(genome))
sql_lib.updateRows(cur, genome, primaryKey, "aId",
izip(aIds, aug_aIds))
def simpleBedUpdateWrapper(self, valueDict, db, genome, column):
"""
If your details-mode classifier has BED records for values in its valueDict, use this.
"""
with sql_lib.ExclusiveSqlConnection(db) as cur:
sql_lib.updateRows(cur, genome, self.primaryKeyColumn, column, self.detailsEntryIter(valueDict.iteritems()))
def simpleUpdateWrapper(self, valueDict, db, genome, column):
"""
If your classifier is going to do a simple 1-1 update with a valueDict, use this.
"""
with sql_lib.ExclusiveSqlConnection(db) as cur:
sql_lib.updateRows(cur, genome, self.primaryKeyColumn, column, self.invertDict(valueDict))
def buildNameRow(self, db, genome, aug_aIds, aIds, primaryKey):
with sql_lib.ExclusiveSqlConnection(db) as cur:
cur.execute("""ALTER TABLE '{}' ADD COLUMN aId TEXT """.format(genome))
sql_lib.updateRows(cur, genome, primaryKey, "aId", izip(aIds, aug_aIds))
