Subversion Repositories SmartDukaan

Rev

Rev 20242 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 20242 Rev 20244
Line 53... Line 53...
53 
    session.commit()
 53 
    session.commit()
54 
    return user_email.id
 54 
    return user_email.id
55 
 
 55 
 
56 
def get_emails_to_be_sent():
 56 
def get_emails_to_be_sent():
57 
    print "get_emails_to_be_sent"
 57 
    print "get_emails_to_be_sent"
58 
    return UserEmail.query.filter_by(UserEmail.status == 0).all()
 58 
    return UserEmail.query.filter(UserEmail.status == 0).all()
59 
 
 59 
 
60 
def mark_email_as_sent(email_id):
 60 
def mark_email_as_sent(email_id):
61 
    UserEmail.query.filter(UserEmail.status==1).delete()
 61 
    UserEmail.query.filter(UserEmail.status==1).delete()
62 
    query = 'INSERT INTO ' + str(UserEmailArchive.table) + ' (select * from ' + str(UserEmail.table) + ' where id = ' + str(email_id) + ')'
 62 
    query = 'INSERT INTO ' + str(UserEmailArchive.table) + ' (select * from ' + str(UserEmail.table) + ' where id = ' + str(email_id) + ')'
63 
    session.execute(query, mapper=UserEmailArchive)
 63 
    session.execute(query, mapper=UserEmailArchive)