def _update(self, sql):
try:
db = Database()
db.executeWithoutQuery(sql)
return None
except Exception, e:
# TODO:if have any duplicated account
log = Log()
errmsg = traceback.format_exec()
log.error(errmsg)
return str(e)
def test():
id = "111112"
author = "quanrui"
title = "helle"
content = "hello world"
href = "www.sina.com.cn"
timestampUsec = "123123123"
website = "THEOLDREADER"
insertArt = '''insert into Articals(id,author,title,website,content,href,timestampUsec) values("%s","%s","%s","%s","%s","%s","%s")''' % (id,author,title,website,content,href,timestampUsec)
account = "qr"
password = "******"
website = "THEOLDREADER"
insertProxy = '''insert into ProxyAccounts values("%s","%s","%s") ''' % (account,password,website)
insertMain = '''insert into MainAccounts values("%s","%s")''' % (account,password)
selectsql = '''select * from Articals'''
deleteArt = '''delete from Articals'''
deleteProxy = '''delete from ProxyAccounts'''
deleteMain = '''delete from MainAccounts'''
db = Database()
db.executeWithoutQuery(insertArt)
db.executeWithoutQuery(insertProxy)
db.executeWithoutQuery(insertMain)
res = db.query(selectsql)
print res
# db.executeWithoutQuery(deleteArt)
# db.executeWithoutQuery(deleteProxy)
# db.executeWithoutQuery(deleteMain)
#
# res = db.query(selectsql)
# print res
db.close()
