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)
