Python DBSession.query Exemples

Exemple #1

Fichier : send_message.py Projet : thm-tech/forward

def validate_phone_captcha(code, mobile):
    if str(code) == '111111':
        return {'is_success': True, 'success': True}
    dbsession = DBSession()
    try:
        row = dbsession.query(FD_T_Phoneauth).filter(FD_T_Phoneauth.phone_no == mobile).one()
        if row.auth_deadline > datetime.datetime.now() and str(row.auth_code) == str(code):
            return {'is_success': True, 'success': True}
        else:
            return {'is_success': False, 'success': False, 'des': '验证码错误或已过期'}
    except Exception, e:
        return {'is_success': False, 'success': False, 'des': str(e)}

Exemple #2

Fichier : send_message.py Projet : fanux/forward

def validate_phone_captcha(code, mobile):
    if str(code) == '111111':
        return {'is_success': True, 'success': True}
    dbsession = DBSession()
    try:
        row = dbsession.query(FD_T_Phoneauth).filter(
            FD_T_Phoneauth.phone_no == mobile).one()
        if row.auth_deadline > datetime.datetime.now() and str(
                row.auth_code) == str(code):
            return {'is_success': True, 'success': True}
        else:
            return {'is_success': False, 'success': False, 'des': '验证码错误或已过期'}
    except Exception, e:
        return {'is_success': False, 'success': False, 'des': str(e)}

Exemple #3

Fichier : phone_validate.py Projet : thm-tech/forward

def validate_phone_captcha(code, mobile):
    dbsession = DBSession()
    try:
        row = dbsession.query(FD_T_Phoneauth).filter(FD_T_Phoneauth.phone_no == mobile).one()
        if row.auth_deadline > datetime.datetime.now() and str(row.auth_code) == str(code):
            # dbsession.delete(row)

            return {'is_success': True}
        else:
            return {'is_success': False, 'des': '验证码错误或已过期'}
    except:
        pass
    finally:
        dbsession.commit()
        dbsession.close()

Exemple #4

Fichier : phone_validate.py Projet : fanux/forward

def validate_phone_captcha(code, mobile):
    dbsession = DBSession()
    try:
        row = dbsession.query(FD_T_Phoneauth).filter(
            FD_T_Phoneauth.phone_no == mobile).one()
        if row.auth_deadline > datetime.datetime.now() and str(
                row.auth_code) == str(code):
            # dbsession.delete(row)

            return {'is_success': True}
        else:
            return {'is_success': False, 'des': '验证码错误或已过期'}
    except:
        pass
    finally:
        dbsession.commit()
        dbsession.close()