def update(self,
username='',
email='',
realname='',
about_me='',
avatar_src=''):
update = {}
update_info = {}
if username:
update['username'] = username
if email:
update['email'] = email
if realname:
update['realname'] = realname
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update['update_time'] = update_time
if about_me:
update_info['about_me'] = about_me
if avatar_src:
update_info['avatar_src'] = avatar_src
try:
db_session.query(User).filter(
User.user_id == self.user_id).update(update)
#if update_info['about_me'] or update_info['avatar_src']:
# db_session.query(UserInfo).filter(UserInfo.user_id == self.user_id).update(update_info)
db_session.commit()
except:
db_session.rollback()
raise
def update(self, username='', email='', realname='', about_me='', avatar_src=''):
update = {}
update_info = {}
if username:
update['username'] = username
if email:
update['email'] = email
if realname:
update['realname'] = realname
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update['update_time'] = update_time
if about_me:
update_info['about_me'] = about_me
if avatar_src:
update_info['avatar_src'] = avatar_src
try:
db_session.query(User).filter(User.user_id == self.user_id).update(update)
#if update_info['about_me'] or update_info['avatar_src']:
# db_session.query(UserInfo).filter(UserInfo.user_id == self.user_id).update(update_info)
db_session.commit()
except:
db_session.rollback()
raise
def update(cls, news_id, category_id, title, content, create_uid, status):
update = {}
if category_id:
update['category_id'] = category_id
if title:
update['title'] = title
if content:
update['content'] = content
if create_uid:
update['create_uid'] = create_uid
if status:
update['status'] = status
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update['update_time'] = update_time
try:
db_session.query(News).filter(News.news_id == news_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update(cls, news_id, category_id, title, content, create_uid, status):
update = {}
if category_id:
update['category_id'] = category_id
if title:
update['title'] = title
if content:
update['content'] = content
if create_uid:
update['create_uid'] = create_uid
if status:
update['status'] = status
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update['update_time'] = update_time
try:
db_session.query(News).filter(
News.news_id == news_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update(cls,
user_id=0,
username='',
email='',
password='',
realname='',
role_id=0):
update = {}
if username:
update['username'] = username
if email:
update['email'] = email
if password:
update['password'] = password
if realname:
update['realname'] = realname
if role_id:
update['role_id'] = role_id
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update['update_time'] = update_time
try:
db_session.query(Admin).filter(
Admin.user_id == user_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update_email(self, email):
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {User.email: email, User.update_time: update_time}
db_session.query(User).filter(
User.user_id == self.user_id).update(update)
try:
return db_session.commit()
except:
db_session.rollback()
def update_password(self, password):
password = encrypt(password)
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {Admin.password: password, Admin.update_time: update_time}
db_session.query(Admin).filter(
Admin.user_id == self.user_id).update(update)
try:
return db_session.commit()
except:
db_session.rollback()
def update(cls, key, value):
update = {}
if key and value:
update['value'] = value
try:
db_session.query(Setting).filter(Setting.key == key).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update_email(self, email):
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {
Admin.email: email,
Admin.update_time: update_time
}
db_session.query(Admin).filter(Admin.user_id == self.user_id).update(update)
try:
return db_session.commit()
except:
db_session.rollback()
def update_password(self, password):
password = encrypt(password)
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {
Admin.password: password,
Admin.update_time: update_time
}
db_session.query(Admin).filter(Admin.user_id == self.user_id).update(update)
try:
return db_session.commit()
except:
db_session.rollback()
def update_login_info(self, last_login_ip):
current_time = datetime.now()
last_login_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {
Admin.last_login_time: last_login_time,
Admin.last_login_ip: last_login_ip,
Admin.login_times: Admin.login_times + 1
}
db_session.query(Admin).filter(Admin.user_id == self.user_id).update(update)
try:
return db_session.commit()
except:
db_session.rollback()
def update(cls, category_id, category_name):
update = {}
if category_name:
update['category_name'] = category_name
try:
db_session.query(NewsCategory).filter(NewsCategory.category_id == category_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update(cls, category_id, category_name):
update = {}
if category_name:
update['category_name'] = category_name
try:
db_session.query(NewsCategory).filter(
NewsCategory.category_id == category_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update_login_info(self, last_login_ip):
current_time = datetime.now()
last_login_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {
Admin.last_login_time: last_login_time,
Admin.last_login_ip: last_login_ip,
Admin.login_times: Admin.login_times + 1
}
db_session.query(Admin).filter(
Admin.user_id == self.user_id).update(update)
try:
return db_session.commit()
except:
db_session.rollback()
def update_login_info(self, last_login_ip):
current_time = datetime.now()
last_login_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {
User.last_login_time: last_login_time,
User.last_login_ip: last_login_ip,
User.login_times: User.login_times + 1
}
db_session.query(User).filter(User.user_id == self.user_id).update(update)
try:
db_session.commit()
return True
except:
db_session.rollback()
def update_login_info(self, last_login_ip):
current_time = datetime.now()
last_login_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update = {
User.last_login_time: last_login_time,
User.last_login_ip: last_login_ip,
User.login_times: User.login_times + 1
}
db_session.query(User).filter(
User.user_id == self.user_id).update(update)
try:
db_session.commit()
return True
except:
db_session.rollback()
def update(cls, role_id, role_name, description, list_order, status):
update = {}
if role_name:
update['role_name'] = role_name
if description:
update['description'] = description
if list_order:
update['list_order'] = list_order
if status:
update['status'] = status
try:
db_session.query(AdminRole).filter(AdminRole.role_id == role_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def update(cls, role_id, role_name, description, list_order, status):
update = {}
if role_name:
update['role_name'] = role_name
if description:
update['description'] = description
if list_order:
update['list_order'] = list_order
if status:
update['status'] = status
try:
db_session.query(AdminRole).filter(
AdminRole.role_id == role_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def gets(cls, offset=0, limit=20, title='', begin=0, end=0):
end = end if end else '2039-12-12'
rs = db_session.query(News.news_id, News.news_id.label('operate_id'), News.category_id, News.title,
News.create_time, News.create_uid, News.update_time, News.status,
NewsCategory.category_name, Admin.username).\
join(NewsCategory, Admin).\
filter(News.category_id == NewsCategory.category_id, News.create_uid == Admin.user_id).\
filter(News.title.like('%'+title+'%')).\
filter(News.create_time >= begin, News.create_time <= end).\
offset(offset).limit(limit)
return rs.all()
def gets(cls, offset=0, limit=20, title='', begin=0, end=0):
end = end if end else '2039-12-12'
rs = db_session.query(News.news_id, News.news_id.label('operate_id'), News.category_id, News.title,
News.create_time, News.create_uid, News.update_time, News.status,
NewsCategory.category_name, Admin.username).\
join(NewsCategory, Admin).\
filter(News.category_id == NewsCategory.category_id, News.create_uid == Admin.user_id).\
filter(News.title.like('%'+title+'%')).\
filter(News.create_time >= begin, News.create_time <= end).\
offset(offset).limit(limit)
return rs.all()
def update(cls, user_id=0, username='', email='', password='', realname='', role_id=0):
update = {}
if username:
update['username'] = username
if email:
update['email'] = email
if password:
update['password'] = password
if realname:
update['realname'] = realname
if role_id:
update['role_id'] = role_id
current_time = datetime.now()
update_time = current_time.strftime('%Y-%m-%d %H:%M:%S')
update['update_time'] = update_time
try:
db_session.query(Admin).filter(Admin.user_id == user_id).update(update)
db_session.commit()
return True
except:
db_session.rollback()
raise
def gets(cls):
_dict = {}
#get current config list
fields = setting
settingFields = setting.keys()
#get data from db
data = db_session.query(Setting.key, Setting.value).filter(Setting.key.in_(settingFields))
_dict['total'] = data.count()
data = data.all()
_data_dict = dict(data)
for key in fields:
#如果数据库不存在该设置项则从默认值中获取
fields[key]['value'] = _data_dict[key] if _data_dict[key] else fields[key]['default']
fields[key]['key'] = key
_dict['rows'] = fields.values()
return _dict
def get_info_by_uid(cls, user_id):
item = db_session.query(UserInfo).filter(
UserInfo.user_id == user_id).first()
return item and cls.initialize(item)
def get(cls, user_id):
item = db_session.query(User).filter(User.user_id == user_id).first()
return item and cls.initialize(item)
def get_by_username(cls, username):
item = db_session.query(User).filter(User.username == username).first()
return item and cls.initialize(item)
def get_by_rolename(cls, role_name):
item = db_session.query(AdminRole).filter(
AdminRole.role_name == role_name).first()
return item and cls.initialize(item)
def get_count(cls):
return db_session.query(AdminRole).count()
def get(cls, role_id):
item = db_session.query(AdminRole.role_id, AdminRole.role_name, AdminRole.description, AdminRole.list_order,
AdminRole.status).filter(AdminRole.role_id == role_id).first()
return item and cls.initialize(item)
def get_count(cls):
return db_session.query(AdminRole).count()
def get(cls, user_id):
item = db_session.query(User).filter(User.user_id == user_id).first()
return item and cls.initialize(item)
def gets(cls, start=0, limit=20):
rs = db_session.query(NewsCategory.category_id, NewsCategory.category_name).offset(start).limit(limit)
return rs.all()
def get_count(cls):
return db_session.query(NewsCategory).count()
def get_by_uid(cls, user_id):
item = db_session.query(Admin).filter(Admin.user_id == user_id).first()
return item and cls.initialize(item)
def get(cls, news_id):
item = db_session.query(
News.news_id, News.category_id, News.title, News.content,
News.create_uid, News.status, News.create_time,
News.update_time).filter(News.news_id == news_id).first()
return item and cls.initialize(item)
def get_count(cls):
return db_session.query(NewsCategory).count()
def gets(cls, start=0, limit=20):
rs = db_session.query(
NewsCategory.category_id,
NewsCategory.category_name).offset(start).limit(limit)
return rs.all()
def gets(cls, start=0, limit=20):
rs = db_session.query(Admin.user_id, Admin.realname, Admin.email,
Admin.username, Admin.last_login_ip,
Admin.last_login_time, Admin.login_times,
Admin.status).offset(start).limit(limit)
return [obj2dict(r) for r in rs.all()]
def get_info_by_uid(cls, user_id):
item = db_session.query(UserInfo).filter(UserInfo.user_id == user_id).first()
return item and cls.initialize(item)
def get(cls, category_id):
item = db_session.query(NewsCategory.category_id, NewsCategory.category_name)\
.filter(NewsCategory.category_id == category_id).first()
return item
def get(cls, category_id):
item = db_session.query(NewsCategory.category_id, NewsCategory.category_name)\
.filter(NewsCategory.category_id == category_id).first()
return item
def gets(cls, start=0, limit=20, sort='id', order='asc'):
return db_session.query(AdminRole.role_id, AdminRole.role_name, AdminRole.description, AdminRole.list_order,
AdminRole.status).offset(start).limit(limit).all()
def get(cls, user_id):
item = db_session.query(Admin.user_id, Admin.realname, Admin.email, Admin.username, Admin.last_login_ip,
Admin.login_times, Admin.status).filter(Admin.user_id == user_id).first()
return item and cls.initialize(item)
def get_by_rolename(cls, role_name):
item = db_session.query(AdminRole).filter(AdminRole.role_name == role_name).first()
return item and cls.initialize(item)
def get_by_uid(cls, user_id):
item = db_session.query(Admin).filter(Admin.user_id == user_id).first()
return item and cls.initialize(item)
def get_password(self):
return db_session.query(Admin).filter(Admin.user_id == self.user_id).first().password
def get_by_email(cls, email):
item = db_session.query(Admin).filter(Admin.email == email).first()
return item and cls.initialize(item)
def gets(cls, start=0, limit=20, sort='id', order='asc'):
return db_session.query(
AdminRole.role_id, AdminRole.role_name, AdminRole.description,
AdminRole.list_order,
AdminRole.status).offset(start).limit(limit).all()
def get_by_username(cls, username):
item = db_session.query(Admin).filter(Admin.username == username).first()
return item and cls.initialize(item)
def get_by_email(cls, email):
item = db_session.query(User).filter(User.email == email).first()
return item and cls.initialize(item)
def get_count(cls):
return db_session.query(News).count()
def get(cls, role_id):
item = db_session.query(
AdminRole.role_id, AdminRole.role_name, AdminRole.description,
AdminRole.list_order,
AdminRole.status).filter(AdminRole.role_id == role_id).first()
return item and cls.initialize(item)
def gets(cls, start=0, limit=20):
rs = db_session.query(Admin.user_id, Admin.realname, Admin.email, Admin.username, Admin.last_login_ip,
Admin.last_login_time, Admin.login_times, Admin.status).offset(start).limit(limit)
return [obj2dict(r) for r in rs.all()]
def get_password(self):
return db_session.query(User).filter(
User.user_id == self.user_id).first().password
def get(cls, news_id):
item = db_session.query(News.news_id, News.category_id, News.title, News.content, News.create_uid, News.status,
News.create_time, News.update_time).filter(News.news_id == news_id).first()
return item and cls.initialize(item)
def get(cls, user_id):
item = db_session.query(
Admin.user_id, Admin.realname, Admin.email, Admin.username,
Admin.last_login_ip, Admin.login_times,
Admin.status).filter(Admin.user_id == user_id).first()
return item and cls.initialize(item)
def get_count(cls):
return db_session.query(News).count()
