def _checkLogin(self, inputParams): db_session = database.getSession() user_query = db_session.query(User) r = user_query.filter(and_(User.username == inputParams.get('username'), User.password == inputParams.get('password'))).first() if r is None: self._sendError(self.LOGINCHECKERROR, '用户名或密码错误') else: self._loginUser(r)
def get(self): username_input = self.get_argument('username') db_session = database.getSession() r = db_session.execute('select * from user where username = "******"' % (username_input, )).first() if r is None: self.send_json(code=self.DEFAULT_ERROR_CODE) else: self.send_json(code=self.DEFAULT_SUCCESS_CODE)
# -*- coding: utf-8 -*- from sqlalchemy import Column from sqlalchemy.types import * from utils import database DataBaseModel = database.DataBaseModel db_session = database.getSession() class BaseModel(): pass