Python select Examples

Example #1

def create_task():
    description = request.form["description"]
    user_id = request.form["user_id"]
    duration = request.form["duration"]
    completed = request.form["completed"]
    user = user_repository.select(user_id)

    task = Task(description, user, duration, completed)

    task_repository.save(task)

    return redirect('/tasks')


# SHOW                                                  # for showing one thing in detail. {{task.description}} in the html can be placed inside an <a></a> tag
# GET '/tasks/<id>'

# EDIT                                                  # slightly harder code
# GET '/tasks/<id>/edit'

# UPDATE                                                # slightly harder code
# PUT '/tasks/<id>'

# DELETE
# DELETE '/tasks/<id>'

Example #2

File: users_controller.py Project: Tubbz-alt/Spending-Tracker

def show_user_transactions():
    print(request.form)
    user_id = request.form['user_id']
    user = user_repository.select(user_id)
    filter_transactions = transaction_repository.filter_by_user(user_id)
    filtered_total = transaction_repository.total_amount(filter_transactions)
    alert = user.alert_near_limit(filtered_total)
    return render_template("/users/show.html", user=user, filter_transactions=filter_transactions, filtered_total = filtered_total, alert=alert)

Example #3

def delete_user(id):
    transactions = transaction_repository.select_all()
    user = user_repository.select(id)
    for transaction in transactions:
        if transaction.user.id == user.id:
            transaction_repository.delete(transaction.id)
    user_repository.delete(user.id)
    return redirect("/users")

Example #4

File: watchlist_repository.py Project: ian-richard/codeclan_proj1_film_app

def select(id):
    sql = "SELECT * FROM films WHERE id = %s"
    values  = [id]
    result  = run_sql(sql, values)[0]
    user = user_repository.select(result['user_id'])
    film = film_repository.select(result['film_id'])
    watchlist_item = Watchlist(user, film, result['id'])
    return watchlist_item

Example #5

File: review_controller.py Project: ian-richard/codeclan_proj1_film_app

def create_review():
    user = user_repository.select(request.form['user_id'])
    film = film_repository.select(request.form['film_id'])
    customer_rating = request.form['customer_rating']
    comment = request.form['comment']
    review = Review(user, film, customer_rating, comment)
    review_repository.save(review)
    return redirect('/reviews')

Example #6

def create():
    description = request.form['description']
    duration = request.form['duration']
    completed = request.form['completed']
    user_id = request.form['user_id']
    user = user_repository.select(user_id)
    new_task = Task(description, user, duration, completed)
    task_repository.save(new_task)
    return redirect("/tasks")

Example #7

File: tasks_controller.py Project: petebrodie/full_stack_task_list.hwk

def update_task(id):
    description = request.form['description']
    user_id = request.form['user_id']
    duration = request.form['duration']
    completed = request.form['completed']
    user = user_repository.select(user_id)
    task = Task(description, user, duration, completed, id)
    task_repository.update(task)
    return redirect('/tasks')

Example #8

File: tasks_controller.py Project: sstewart1993/g21_coursework

def update(id):
    description = request.form["description"]
    duration = request.form["duration"]
    completed = request.form["completed"]
    user_id = request.form["user_id"]
    user = user_repository.select(user_id)
    updated_task =Task(description, user, duration, completed, id)
    task_repository.update(updated_task)
    return redirect("/tasks")

Example #9

def select(id):
    sql = "SELECT * FROM reviews WHERE id = %s"
    values = [id]
    result = run_sql(sql, values)[0]
    whisky = whisky_repository.select(result["whisky_id"])
    user = user_repository.select(result["user_id"])
    review = Review(whisky, user, result["rating"], result["date"],
                    result["description"], result["id"])
    return review

Example #10

File: transaction_repository.py Project: Cqyreall/cash_app

def select(id):
    sql = "SELECT * FROM transactions WHERE id = %s"
    values = [id]
    result = run_sql(sql, values)[0]
    tag = tag_repository.select(result['tag_id'])
    merchant = merchant_repository.select(result['merchant_id'])
    user = user_repository.select(result['user_id'])
    transaction = Transaction(tag, merchant, user, result['amount'], result['date'], result['id'])
    return transaction

Example #11

def update_transaction(id):
    amount = request.form['amount']
    category = category_repository.select(request.form['category_id'])
    date = request.form['date']
    merchant = merchant_repository.select(request.form['merchant_id'])
    user = user_repository.select(request.form['user_id'])
    transaction = Transaction(amount, category, date, merchant, user, id)
    transaction_repository.update(transaction)
    return redirect("/transactions")

Example #12

File: visit_controller.py Project: sstewart1993/cc_notes

def create_task():
    user_id = request.form['user_id']
    location_id = request.form['location_id']
    review = request.form['review']
    user = user_repository.select(user_id)
    location = location_repository.select(location_id)
    visit = Visit(user, location, review)
    visit_repository.save(visit)
    return redirect('/visits')

Example #13

File: review_repository.py Project: ian-richard/codeclan_proj1_film_app

def select(id):
    sql = "SELECT * FROM reviews WHERE id = %s"
    values = [id]
    result = run_sql(sql, values)[0]
    user = user_repository.select(result['user_id'])
    film = film_repository.select(result['film_id'])
    review = Review(user, film, result['customer_rating'],
                    result['customer_comment'], result['id'])
    return review

Example #14

def user_dashboard(id):
    user = user_repository.select(id)
    transactions = user_repository.select_transactions(user)
    total = 0
    for transaction in transactions:
        total += transaction.amount
    return render_template("/users/dashboard.html",
                           user=user,
                           total=total,
                           transactions=transactions)

Example #15

def select(id):
    sql = "SELECT * FROM transactions WHERE id = %s"
    values = [id]
    result = run_sql(sql, values)[0]
    user = user_repository.select(result["user_id"])
    tag = tag_repository.select(result["tag_id"])
    merchant = merchant_repository.select(result["merchant_id"])
    transaction = Transaction(result["amount"], user, merchant, tag,
                              result["id"])
    return transaction

Example #16

File: task_repository.py Project: Strd79/Class_Work

def select_all():
    tasks = []
    sql = "SELECT * FROM tasks"
    results = run_sql(sql)
    for row in results:
        user = user_repository.select(row['user_id'])
        task = Task(row['description'], user, row['duration'],
                    row['completed'], row['id'])
        tasks.append(task)
    return tasks

Example #17

File: task_repository.py Project: Katie-Sloan/w4_d2_DB_lab_KM_KS-musiclibrary

def select(id):
    task = None
    sql = "SELECT * FROM tasks WHERE id = %s"  
    values = [id] 
    result = run_sql(sql, values)[0]
    
    if result is not None:
        user = user_repository.select(result['user_id'])
        task = Task(result['description'], user, result['duration'], result['completed'], result['id'] )
    return task

Example #18

File: transaction_repository.py Project: Cqyreall/cash_app

def select_all():
    transactions = []
    sql = "SELECT * FROM transactions"
    results = run_sql(sql)
    for row in results:
        tag = tag_repository.select(row['tag_id'])
        merchant = merchant_repository.select(row['merchant_id'])
        user = user_repository.select(row['user_id'])
        transaction = Transaction(tag, merchant, user, row['amount'], row['date'], row['id'])
        transactions.append(transaction)
    return transactions

Example #19

def create_review():
    whisky_id = request.form["whisky_id"]
    whisky = whisky_repository.select(whisky_id)
    user_id = request.form["user_id"]
    user = user_repository.select(user_id)
    rating = request.form["rating"]
    date = request.form["date"]
    description = request.form["description"]
    new_review = Review(whisky, user, rating, date, description)
    review_repository.save(new_review)
    return redirect("/reviews")

Example #20

File: watchlist_repository.py Project: ian-richard/codeclan_proj1_film_app

def select_all():
    watchlist_list = []

    sql = "SELECT * FROM watchlist"
    results = run_sql(sql)

    for row in results:
        user = user_repository.select(row['user_id'])
        film = film_repository.select(row['film_id'])
        watchlist = Watchlist(user, film, row['id'])
        watchlist_list.append(watchlist)
    return watchlist_list

Example #21

def get_reviews_of_user(id):
    reviews = []
    sql = "SELECT * FROM reviews WHERE reviews.user_id = %s"
    values = [id]
    results = run_sql(sql, values)
    for result in results:
        whisky = whisky_repository.select(result["whisky_id"])
        user = user_repository.select(result["user_id"])
        review = Review(whisky, user, result["rating"], result["date"],
                        result["description"], result["id"])
        reviews.append(review)
    return reviews

Example #22

def select_all():
    visits = []

    sql = "SELECT * FROM visits"
    results = run_sql(sql)

    for row in results:
        user = user_repository.select(row['user_id'])
        location = location_repository.select(row['location_id'])
        visit = Visit(user, location, row['review'], row['id'])
        visits.append(visit)
    return visits

Example #23

File: transactions_controller.py Project: willjatlas/project_spending_tracker

def user_transactions():
    user_id = request.form["user_id"]
    user = user_repository.select(user_id)
    transactions = transaction_repository.select_by_user(user_id)
    total_amount = 0.00
    for transaction in transactions:
        total_amount += float(transaction.amount)
    return render_template("transactions/user_index.html",
                           transactions=transactions,
                           user=user,
                           total_amount=format(total_amount, '.2f'),
                           title="User Transactions")

Example #24

File: transactions_controller.py Project: Cqyreall/cash_app

def update_transaction(id):
    tag_id = request.form['tag_id']
    merchant_id = request.form['merchant_id']
    user_id = request.form['user_id']
    amount = request.form['amount']
    date = request.form['date']
    tag = tag_repository.select(tag_id)
    merchant = merchant_repository.select(merchant_id)
    user = user_repository.select(user_id)
    updated_transaction = Transaction(tag, merchant, user, amount, date, id)
    transaction_repository.update(updated_transaction)
    return redirect("/transactions")

Example #25

File: transaction_repository.py Project: Tubbz-alt/Spending-Tracker

def sort_transactions(transactions):
    transactions = []
    sql = "SELECT * FROM transactions ORDER BY date ASC"
    results = run_sql(sql)

    for row in results:
        merchant = merchant_repository.select(row['merchant_id'])
        category = category_repository.select(row['category_id'])
        user = user_repository.select(row['user_id'])
        transaction = Transaction(row['amount'], category, row['date'],
                                  merchant, user, row['id'])
        transactions.append(transaction)
    return transactions

Example #26

File: transaction_repository.py Project: Tubbz-alt/Spending-Tracker

def select(id):
    transaction = None
    sql = "SELECT * FROM transactions WHERE id = %s"
    values = [id]
    result = run_sql(sql, values)[0]

    if result is not None:
        merchant = merchant_repository.select(result['merchant_id'])
        category = category_repository.select(result['category_id'])
        user = user_repository.select(result['user_id'])
        transaction = Transaction(result['amount'], category, result['date'],
                                  merchant, user, result['id'])
    return transaction

Example #27

def select_all():
    # This function gets all the data from the database and returns a list of Task Objects
    tasks = []

    sql = "SELECT * FROM tasks"
    results = run_sql(sql)

    for row in results:
        user = user_repository.select(row['user_id'])
        task = Task(row['description'], user, row['duration'],
                    row['completed'], row['id'])
        tasks.append(task)
    return tasks

Example #28

def create_transaction():
    amount = request.form["amount"]
    user = user_repository.select(request.form["user"])
    merchant = merchant_repository.select(request.form["merchant"])
    tag = tag_repository.select(request.form["tag"])
    new_transaction = Transaction(amount, user, merchant, tag)
    transaction_repository.save(new_transaction)
    tags = tag_repository.select_all()
    transactions = user_repository.select_transactions(user)
    total = 0
    for transaction in transactions:
        total += transaction.amount
    return render_template("/users/dashboard.html", user = user, transactions = transactions, total = total, tags = tags)

Example #29

def select_all():
    reviews = []
    sql = "SELECT * FROM reviews"
    results = run_sql(sql)
    for result in results:
        whisky_id = result["whisky_id"]
        whisky = whisky_repository.select(whisky_id)
        user_id = result["user_id"]
        user = user_repository.select(user_id)
        review = Review(whisky, user, result["rating"], result["date"],
                        result["description"], result["id"])
        reviews.append(review)
    return reviews

Example #30

def welcome():
    id = request.form["user.id"]
    user = user_repository.select(id)
    transactions = user_repository.select_transactions(user)
    total = 0
    tags = tag_repository.select_all()
    for transaction in transactions:
        total += transaction.amount
    return render_template("/users/dashboard.html",
                           user=user,
                           transactions=transactions,
                           tags=tags,
                           total=total)