class Watmeta200(Watmeta): def __init__(self): logger.warning("Don't call directly") def recordMetaFormals(self): """schema 200""" return ["application", "task", "scope", "dsname", "source", "market", "sitekey", "datestamp", "host", "retained", "likelihood", "version", "revision", "schema"] def recordMetaActuals(self): """schema 200""" return [self.application, self.task, self.scope, self.dsname, self.source, self.market, self.sitekey, self.datestamp, self.host, self.retained, self.likelihood, self.version, self.revision, self.schema] def setup(self): self.mdb = Watdb(conf='watmeta') self.mdb.connect() self.test = False def teardown(self): self.mdb = self.mdb.disconnect() def recordMeta(self, prop, facet, val): """schema 200""" formals = self.recordMetaFormals() formals.extend(["prop", "facet", "val"]) values = self.recordMetaActuals() values.extend([str(prop), str(facet), str(val)]) table = "watmeta" insert = self.mdb.insertionQuery(table, formals, values) self.mid = self.mdb.maybeQuery(insert) return self.mid
def read_area_codes(): sql = "select a.areacode, a.state from areacode a" db = Watdb(conf='wataux', engine=None) db.connect() rows = db.cxn.query(sql) for row in rows: ac = row.areacode state = row.state AREA_CODES[str(ac)] = state db = db.disconnect() return AREA_CODES
def setup(self): self.mdb = Watdb(conf='watmeta') self.mdb.connect() self.test = False