Python DBSession.query方法代码示例

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def edit_user2(post, roles, useavatars):
    # Обновлеяем запись
    obj = get_user2(post["id"])
    if not obj:
        return False
    obj.username = post["username"]
    obj.email = post["email"]
    obj.profiles.fullname = post["fullname"]
    if useavatars == 1 and "avatarsource" in post:
        obj.profiles.avatar1 = post["avatarsource"]
        obj.profiles.avatar2 = post["avatarsize1"]
        obj.profiles.avatar3 = post["avatarsize2"]
    if post["password"] != "":
        obj.password = hash_password(post["password"])

    # Удаляем роли
    DBSession.query(RolesUsers).filter(RolesUsers.user_id == post["id"]).delete()

    # Добавляем роли
    for e in roles:
        ru = RolesUsers(post["id"], e)
        DBSession.add(ru)

    try:
        transaction.commit()
    except:
        DBSession.rollback()
        return False
    else:
        return True

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def edit_post2(post, tags):
    
    ts = time.time()
    
    obj = get_post2(post['id'])
    if not obj:
        return False
    obj.title = post['title']
    obj.slug = post['alias']
    obj.userid = post['userid']
    obj.intro = post['into']
    obj.content = post['content']
    obj.published = post['published']
    obj.comments = post['comments']
    obj.comments_premoderation = post['comments_premoderation']
    obj.last_edited = ts
    
    #Удаляем тэги
    DBSession.query(TagsPosts).filter(TagsPosts.post_id == post['id']).delete()
    
    #Добавляем тэги
    for e in tags:
        pt = TagsPosts(post['id'], e)
        DBSession.add(pt)
    
    try:
        transaction.commit()
    except:
        DBSession.rollback()
        return False
    else:
        return True

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def edit_role2(post, permissions):
    #Обновлеяем запись
    obj = get_role2(post['id'])
    if not obj:
        return False
    obj.name = post['rolename']
    obj.rolesgroup = post['rolegroup']
    obj.description = post['description']
    obj.ordering = post['order']  
    
    #Удаляем роли
    DBSession.query(PermissionsRoles).filter(PermissionsRoles.role_id == post['id']).delete()
            
    #Добавляем роли
    for e in permissions:
        pr = PermissionsRoles(post['id'], e)
        DBSession.add(pr)  
    
    try:
        transaction.commit()
    except:
        transaction.rollback()
        return False
    else:
        return True

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def get_posts(offset=None, limit=None):
    
    setallroute()
    
    if offset==None or limit==None:
        return DBSession.query(Blogs).all()
    else:
        return (DBSession.query(Blogs).all())[offset:limit]

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
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]

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
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]

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def get_users(offset=None, limit=None):

    # Форматирование даты и активности
    setallroute()

    if offset == None or limit == None:
        return DBSession.query(Users).all()
    else:
        return (DBSession.query(Users).all())[offset:limit]

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def delete_permissions(delitems):
    try:
        for e in delitems:
            DBSession.query(Permissions).filter(Permissions.id == e).delete()
        transaction.commit()
        result = 1
    except:
        transaction.rollback()
        result = 0
    return result

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def delete_posts(delitems, thread='blog'):
    try:
        for e in delitems:
            DBSession.query(Blogs).filter(Blogs.id == e).delete()
            DBSession.query(Comments).filter(Comments.thread == thread).filter(Comments.threadid == e).delete()
        transaction.commit()
        result = 1
    except:
        transaction.rollback()
        result = 0
    return result

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def delete_comment(itemid):

    DBSession.query(Comments).filter(Comments.id == itemid).delete()

    try:
        transaction.commit()
        result = 1
    except:
        DBSession.rollback()
        result = 0

    return result

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def get_accesslog_badlogin(ip, e=1, t=180, attempt=3):
    
    ls = DBSession.query(AccessLog).filter(AccessLog.event_id == e).filter(AccessLog.ip == ip).filter(AccessLog.eventdate > int(time.time())-180).count()
    if ls < attempt:
        return True
    else:
        return False

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
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

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def db_put_user(post, roles, token):
    user = DBSession.query(Users).filter(or_(Users.username == post['username'], Users.email == post['email'])).all()
    if not user:
        ts = time.time()
        DBSession.autoflush = False
        addprofiles = Profiles(post['fullname'], '', '', '')
        usersactivation = UsersActivation(token, ts)
        u = Users(post['username'], post['email'], hash_password(post['password']), ts, 1, addprofiles, usersactivation=usersactivation)
    
        DBSession.add(u)
        DBSession.flush()
        DBSession.refresh(u)
    
        for e in roles:
            ru = RolesUsers(u.id, e)
            DBSession.add(ru)
            DBSession.flush()
    
        try:
            transaction.commit()
        except:
            DBSession.rollback()
            return False
        else:
            return True
    else:
        return 3

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def count_comments(component, componentid):
    return (
        DBSession.query(Comments)
        .filter(Comments.thread == component)
        .filter(Comments.threadid == componentid)
        .filter(Comments.published == 1)
        .count()
    )

# 需要导入模块: from testproject.models import DBSession [as 别名]
# 或者: from testproject.models.DBSession import query [as 别名]
def db_count_comments(thread, threadid):
    return (
        DBSession.query(Comments)
        .filter(Comments.thread == thread)
        .filter(Comments.published == 1)
        .filter(Comments.threadid == threadid)
        .count()
    )