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
