def persist_add(domein, botskey, value):
''' store persistent values in db.
'''
content = pickle.dumps(value, 0)
if botsglobal.settings.DATABASE_ENGINE != 'sqlite3' and len(
content) > 1024:
raise botslib.PersistError(_(
u'Data too long for domein "$domein", botskey "$botskey", value "$value".'
),
domein=domein,
botskey=botskey,
value=value)
try:
botslib.change(
u'''INSERT INTO persist (domein,botskey,content)
VALUES (%(domein)s,%(botskey)s,%(content)s)''',
{
'domein': domein,
'botskey': botskey,
'content': content
})
except:
raise botslib.PersistError(_(
u'Failed to add for domein "$domein", botskey "$botskey", value "$value".'
),
domein=domein,
botskey=botskey,
value=value)
def persist_update(domein,botskey,value):
''' store persistent values in db.
'''
content = pickle.dumps(value,0)
if botsglobal.settings.DATABASE_ENGINE != 'sqlite3' and len(content)>1024:
raise botslib.PersistError(_(u'Data too long for domein "$domein", botskey "$botskey", value "$value".'),domein=domein,botskey=botskey,value=value)
botslib.change(u'''UPDATE persist
SET content=%(content)s
WHERE domein=%(domein)s
AND botskey=%(botskey)s''',
{'domein':domein,'botskey':botskey,'content':content})
def persist_add(domein, botskey, value):
''' store persistent values in db.
'''
content = pickle.dumps(value).decode('iso-8859-1')
try:
botslib.changeq(
u''' INSERT INTO persist (domein,botskey,content)
VALUES (%(domein)s,%(botskey)s,%(content)s)''', {
'domein': domein,
'botskey': botskey,
'content': content
})
except:
raise botslib.PersistError(
_(u'Failed to add for domein "%(domein)s", botskey "%(botskey)s", value "%(value)s".'
), {
'domein': domein,
'botskey': botskey,
'value': value
})