Esempio n. 1
0
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
Esempio n. 2
0
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
Esempio n. 3
0
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
Esempio n. 4
0
 def setup(self):
     self.mdb = Watdb(conf='watmeta')
     self.mdb.connect()
     self.test = False