def updateStatusSended(cls,id): try: #sql = "update sur_send_mail set status= 'F', sended_date='" + str(datetime.now()) + "' where id_send_mail = " + str(id); #result = DBSession.execute(sql); #DBSession.flush() ; #DBSession.execute("UNLOCK TABLES"); #email = DBSession.query(cls).filter(cls.id_send_mail == id).first(); #email.status = 'F'; DBSession.query(cls).filter(cls.id_send_mail == id).update({"status": 'F',"sended_date" : datetime.now() }) ; DBSession.flush() ; return True, 'success'; except Exception as e: print "Exception----------> : " print e; return False, 'Cannot delete.';#e.__str__();
def save (self): DBSession.add(self); DBSession.flush() ;
def deleteById(cls,id): result = DBSession.query(cls).filter(cls.id_user_social_network == id).delete() DBSession.flush() return result
def updateGroupUserCreator(self): result = DBSession.execute('insert into tg_user_group values(:user_id,:group_id)', {'user_id': self.user_id,'group_id':4}) DBSession.flush() ;
def updateGroupUserVoter(self): result = DBSession.execute('insert into tg_user_group values(:user_id,:group_id)', {'user_id': self.user_id,'group_id':2}) #DBSession.execute(s, user_id= self.user_id ).fetchall() DBSession.flush() ;
def updateStatus(self): self.status = 'F' self.sended_date = datetime.now() DBSession.flush() ;