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()