def update_mailbox(shelter_phone, mailbox_number, url):
mailbox = DBSession.query(MailboxGreeting) \
.filter(MailboxGreeting.shelter_phone==shelter_phone) \
.filter(MailboxGreeting.mailbox==mailbox_number).first()
mailbox.url = url
DBSession.merge(mailbox)
DBSession.commit()
def update_mailbox_password(shelter_phone, mailbox_number, password):
mailbox = DBSession.query(MailboxGreeting) \
.filter(MailboxGreeting.shelter_phone==shelter_phone) \
.filter(MailboxGreeting.mailbox==mailbox_number).first()
mailbox.password = password
DBSession.merge(mailbox)
DBSession.commit()
DBSession.flush()
def create_mailbox(shelter_phone, mailbox_number):
print 'creating mailbox', mailbox_number
mailbox = MailboxGreeting(shelter_phone=shelter_phone,
mailbox=mailbox_number)
DBSession.add(mailbox)
DBSession.commit()
