def query_one_by_id( id): sql = _query_sql isdelete = state.Boole['false'] sql = sql + ' and id = %s ' yz = (isdelete, id) func = mysql.find_one(sql, yz, _query_col) return func
def login(user_id, user_password): user_password = _format_user_password_md5(user_password) # user = str_helper.utf8(mysql.find_one(_login_sql,(name, password),_login_col)) user = mysql.find_one(_login_sql,(user_id, user_password), _login_col) print(user) if None == user: return None return user
def query_one_by_path( path): sql = _query_sql isdelete = state.Boole['false'] sql = sql + ' and path = %s ' yz = (isdelete, path) func = mysql.find_one(sql, yz, _query_col) return func
def query_one_by_name( name = ''): sql = _query_sql isdelete = state.Boole['false'] sql = sql + ' and name = %s ' yz = (isdelete, name) role = mysql.find_one(sql, yz, _query_col) if None != role: role['statusname'] = state.Status.get(role['status']) return role
def query_one_by_name(self, name = ''): sql = self._query_sql isdelete = state.Boole['false'] sql = sql + ' and name = %s ' yz = (isdelete, name) project = mysql.find_one(sql, yz, self._query_col) if None != project: project['statusname'] = state.ProjectStatus.get(project['status']) return project
def query_one_by_name(name=''): sql = _query_sql isdelete = state.Boole['false'] sql = sql + ' and name = %s ' yz = (isdelete, name) dep = mysql.find_one(sql, yz, _query_col) if None != dep: dep['statusname'] = state.Status.get(dep['status']) return dep
def query_one_by_name(self, name=''): sql = self._query_sql isdelete = state.Boole['false'] sql = sql + ' and name = %s ' yz = (isdelete, name) product = mysql.find_one(sql, yz, self._query_col) if None != product: product['statusname'] = state.Status.get(product['status']) return product
def query_one_by_name(self, name = ''): sql = self._query_sql isdelete = state.Boole['false'] sql = sql + ' and name = %s ' yz = (isdelete, name) app = mysql.find_one(sql, yz, self._query_col) if None != app: app['statusname'] = state.Status.get(app['status']) return app
def query_one_by_name(self, name = ''): sql = self._query_sql isdelete = state.Boole['false'] sql = sql + ' and name = %s ' yz = (isdelete, name) user = mysql.find_one(sql, yz, self._query_col) if None != user: user['statusname'] = state.UserStatus.get(user['status']) return user
def query_one_by_name( name = ''): sql = _query_sql isdelete = state.Boole['false'] sql = sql + ' and u.name = %s ' yz = (isdelete, name) user = mysql.find_one(sql, yz, _query_col) if None != user: user['beginDate'] = str(user['beginDate'])[0:10] user['endDate'] = str(user['endDate'])[0:10] user['statusname'] = state.UserStatus.get(user['status']) return user
def query_one(self, id=0): sql = self._query_sql ps = [isdelete] isdelete = state.Boole['false'] if 0 != id: sql = sql + ' and id = %s ' ps.append(id) else: return None yz = tuple(ps) task = mysql.find_one(sql, yz, self._query_col) task = self._format_task_status(task) return task
def query_one(self, id = 0): sql = self._query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != id: sql = sql + ' and t.id = %s ' ps.append(id) else: return None yz = tuple(ps) task = mysql.find_one(sql, yz, self._query_col) task = self._format_task_status_type(task) return task
def query_one(self, code = ''): sql = self._query_sql isdelete = state.Boole['false'] ps = [isdelete] if '' != code: sql = sql + ' and code = %s ' ps.append(code) else: return None yz = tuple(ps) app = mysql.find_one(sql, yz, self._query_col) if None != app: app['statusname'] = state.Status.get(app['status']) return app
def query_one(self, id=0): sql = self._query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != id: sql = sql + ' and id = %s ' ps.append(id) else: return None yz = tuple(ps) product = mysql.find_one(sql, yz, self._query_col) if None != product: product['statusname'] = state.Status.get(product['status']) return product
def query_one( id = 0): sql = _query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != id: sql = sql + ' and id = %s ' ps.append(id) else: return None yz = tuple(ps) role = mysql.find_one(sql, yz, _query_col) if None != role: role['statusname'] = state.Status.get(role['status']) return role
def query_one(self, id = 0): sql = self._query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != id: sql = sql + ' and id = %s ' ps.append(id) else: return None yz = tuple(ps) project = mysql.find_one(sql, yz, self._query_col) if None != project: project['statusname'] = state.ProjectStatus.get(project['status']) return project
def query_one(code=''): sql = _query_sql isdelete = state.Boole['false'] ps = [isdelete] if '' != code: sql = sql + ' and code = %s ' ps.append(code) else: return None yz = tuple(ps) app = mysql.find_one(sql, yz, _query_col) if None != app: app['statusname'] = state.Status.get(app['status']) return app
def query_one(id=0): sql = _query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != id: sql = sql + ' and id = %s ' ps.append(id) else: return None yz = tuple(ps) dep = mysql.find_one(sql, yz, _query_col) if None != dep: dep['statusname'] = state.Status.get(dep['status']) return dep
def query_one(self, id = 0): sql = self._query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != id: sql = sql + ' and id = %s ' ps.append(id) else: return None yz = tuple(ps) usergroup = mysql.find_one(sql, yz, self._query_col) if None != usergroup: usergroup['statusname'] = state.Status.get(usergroup['status']) return usergroup
def query_one_by_key(user_key = 0): sql = _query_sql isdelete = state.Boole['false'] ps = [isdelete] if 0 != user_key: sql = sql + ' and u.user_key = %s ' ps.append(user_key) else: return None yz = tuple(ps) user = mysql.find_one(sql, yz, _query_col) if None != user: user['beginDate'] = str(user['beginDate'])[0:10] user['endDate'] = str(user['endDate'])[0:10] user['statusname'] = state.UserStatus.get(user['status']) return user
def get_group_role(id): yz = (id) info = mysql.find_one(_get_group_role_sql, yz, _get_group_role_col) return info
def get_group_user(id): yz = (id) info = mysql.find_one(_get_group_user_sql, yz, _get_group_user_col) return info
def login( name, password): password = _format_user_password_md5(password) user = mysql.find_one(_login_sql, (name, password, state.statusActive, state.Boole['false']), _login_col) return user
def get_user_role( id): yz = (id) info = mysql.find_one(_get_user_role_sql, yz, _get_user_role_col) return info
def get_group_user( id): yz = (id) info = mysql.find_one(_get_group_user_sql, yz, _get_group_user_col) return info
def login(self, name, password): password = self._format_user_password_md5(password) user = mysql.find_one(self._login_sql, (name, password, state.User['leave'], state.Boole['false']), self._login_col) return user