def get_user(username):
setopt(Users, 'check_password', Users_check_password)
user = DBSession.query(Users).filter(Users.username == username).all()
if user:
return user[0]
else:
return None
def get_roles(offset=None, limit=None):
#Добавить короткое описание
setopt(Roles, 'shortdesc', Roles_shortdesc)
if offset==None or limit==None:
return DBSession.query(Roles).all()
else:
return DBSession.query(Roles).all()[offset:limit]
def get_permissions2(offset=None, limit=None):
#Добавить короткое описание
setopt(Permissions, 'shortdesc', Permissions_shortdesc)
if offset==None or limit==None:
return DBSession.query(Permissions).all()
else:
return DBSession.query(Permissions).all()[offset:limit]
def get_comment2(id, ordering="id", component="blog", componentid=1):
# Вывод с форматированием даты
setopt(Comments, "datefromtimestamp", Comments_datefromtimestamp)
return (
DBSession.query(Comments)
.filter(Comments.id == id)
.filter(Comments.thread == component)
.filter(Comments.threadid == componentid)
.one()
)
def get_comments(ordering, component, componentid, offset, limit):
# Вывод с форматированием даты
setopt(Comments, "datefromtimestamp", Comments_datefromtimestamp)
order_by = asc(ordering)
return (
DBSession.query(Comments)
.filter(Comments.thread == component)
.filter(Comments.threadid == componentid)
.order_by(order_by)
.all()
)[offset:limit]
def get_comments2(get, ordering="id", thread="blog", threadid=1, offset=0, limit=100):
# Вывод с форматированием даты
setopt(Comments, "datefromtimestamp", Comments_datefromtimestamp)
# order_by = asc(ordering)
if get["sortorder"] == "asc":
order_by = asc(ordering)
if get["sortorder"] == "desc":
order_by = desc(ordering)
return (
DBSession.query(Comments)
.filter(Comments.thread == thread)
.filter(Comments.threadid == threadid)
.filter(Comments.published == 1)
.order_by(order_by)
.all()
)[offset:limit]
def set_userpassword(post):
setopt(Users, 'check_password', Users_check_password)
user = DBSession.query(Users).filter(Users.id == post['userid']).one()
if user.check_password(post['oldpassword']):
user.password = hash_password(post['password'])
try:
transaction.commit()
except:
DBSession.rollback()
return False
else:
return 1
else:
return 2
def get_roles2(post, orderbytable, offset, limit):
#Добавить короткое описание
setopt(Roles, 'shortdesc', Roles_shortdesc)
for key in orderbytable.keys():
if post['col'] == key:
order_by=orderbytable[key]
if post['asc'] == '1':
ordering = asc(order_by)
if post['asc'] == '0':
ordering = desc(order_by)
if 'phr' in post:
if post['phr'] != '':
phr = '%'+ post['phr'] +'%'
filter = (dict(Roles.__dict__))[post['lke']].like(phr)
roles = (DBSession.query(Roles).filter(filter).order_by(ordering).all())[offset:limit]
else:
roles = (DBSession.query(Roles).order_by(ordering).all())[offset:limit]
return roles
