def update_operator(operator, oid, db, redis): """Update operator status. :arg operator: dict, e.g. { 'address':'', 'email':'', } :arg oid: string :arg db: database instance :arg redis: redis instance """ set_clause_dct = DotDict() fields = DotDict(address="address = '%s'", email="email = '%s'") for key, value in operator.iteritems(): set_clause_dct.setdefault(key, fields[key] % value) set_clause = ','.join( [v for v in set_clause_dct.itervalues() if v is not None]) if set_clause: db.execute("UPDATE T_OPERATOR SET " + set_clause + " WHERE oid = %s", oid)
def update_corp(corp, cid, db, redis): """Update corp status. :arg corp: dict, e.g. { 'c_name':'', 'c_mobile':'', 'c_alert_mobile':'', 'c_address':'', 'c_linkman':'', 'c_email':'', } :arg cid: string :arg db: database instance :arg redis: redis instance """ set_clause_dct = DotDict() fields = DotDict(c_name="name = '%s'", c_mobile="mobile = '%s'", c_alert_mobile="alert_mobile = '%s'", c_address="address = '%s'", c_linkman="linkman = '%s'", c_email="email = '%s'") for key, value in corp.iteritems(): set_clause_dct.setdefault(key, fields[key] % value) set_clause = ','.join( [v for v in set_clause_dct.itervalues() if v is not None]) if set_clause: db.execute("UPDATE T_CORP SET " + set_clause + " WHERE cid = %s", cid)