예제 #1
0
def upload_import():
    schema = ImportSchema()
    json_import = request.get_json(force=True)

    errors = schema.validate(json_import)
    if errors:
        print(errors)
        abort(400)

    citizens_list = []

    for node in json_import['citizens']:
        print(node)
        citizens_list.append(Citizen(node))
    new_import = Import(citizens=citizens_list)
    session.add(new_import)
    session.add_all(citizens_list)
    session.commit()

    for node, citizen in zip(json_import['citizens'], citizens_list):
        relatives = node['relatives']
        print(relatives)
        for relative in relatives:
            print(relative)
            relative_citizens = get_one_citizen_by_unique_pair(
                new_import.id, relative)
            citizen.relatives.append(relative_citizens)
    session.commit()

    response = jsonify({"data": {"import_id": new_import.id}})
    response.status_code = 201
    return response
예제 #2
0
 def add_post(cls, image_url, username):
     user = User.check_username(username)  # 返回一个user实例
     post = Post(image_url=image_url, user_id=user.id)
     session.add(post)
     session.commit()
     post_id = post.id
     session.close()
     return post_id
예제 #3
0
    def add_post(cls, image_url, username):
        user = User.check_username(username)  # 返回user实例
        post = Post(image_url=image_url, user_id=user.id)
        session.add(post)
        session.commit()
        session.close()


# backref="posts"原理如下
#图片实例.user===>拿到对应的user实例
#用户实例.posts===>拿到对应的posts(图片)实例
예제 #4
0
 def add_post(cls, title, content, image_url, thumbnail_url, username,
              posttype_id):
     user = User.check_username(username)  #返回 user实例
     post = Post(title=title,
                 content=content,
                 image_url=image_url,
                 thumbnail_url=thumbnail_url,
                 user_id=user.id,
                 posttype_id=posttype_id)
     session.add(post)
     session.commit()
     session.close()
예제 #5
0
 def add_user(cls, username, password, **kwargs):
     user = User(username=username, password=password, **kwargs)
     session.add(user)
     session.commit()
     session.close()