artFi/app/lib/collector.py

# Collects data the retarded way

from flask_login import current_user
from app.models import User, Art, List

def market_listing():
    listings = List.query.all()
    art = Art.query.all()
    user_list = User.query.all()
    return_list = list()

    # Creates a new list for art details
    for l in listings:
        for a in art:
            if l.filehash == a.filehash:
                for u in user_list:
                    if a.creator == u.id:
                        return_list.append([
                            a.name, # [0] name of art
                            a.description, # [1] description of art
                            a.owner, # [2] current owner id
                            u.username, # [3] creator's username
                            u.profile_image, # [4] creator's profilepic
                            a.dname, # [5] designated db name, also path filename
                            l.seller, # [6] current seller id
                            l.min_price, # [7] minimum bid price
                            l.out_price, # [8] minimum buyout price
                            l.timeout, # [9] closing bidding date
                            l.list_date, # [10] listing date
                            l.filehash # [11] listings/art filehash
                        ])
    return return_list

def check_listing():
    # returns list of art available to sell
    owned_art = Art.query.filter_by(owner=current_user.id).all() 
    listed_art = List.query.filter_by(seller=current_user.id).all()
    available_art = list()

    # to remove art that is already listed
    for oa in owned_art:
        for la in listed_art:
            if oa.filehash != la.filehash:
                available_art.append(oa)

    return available_art


def find_user_obj(user_id):
    user = User.query.filter_by(id=user_id).first()
    return user