def all():
""" view all donation """
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def show_alice(donor_name="Alice"):
donations = Donation().select().join(Donor).where(Donor.name == donor_name)
return render_template('donations.jinja2', donations=donations)
def all():
"""Gets all donation from database
and return page with donation"""
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def all():
'''
All donations page
'''
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def all():
if 'username' not in session:
return redirect(url_for('login'))
return render_template('donations.jinja2', donations=Donation.select())
def show_all():
"""Handle a page showing all donors and donations."""
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def all():
"""
Returns all donors and their donations currently on record
"""
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def donations():
donations = Donation.select()
return render_template('donations.html', donations=donations)
import random
from passlib.hash import pbkdf2_sha256
from model import db, Donor, Donation
db.connect()
# This line will allow you "upgrade" an existing database by
# dropping all existing tables from it.
db.drop_tables([Donor, Donation])
db.create_tables([Donor, Donation])
alice = Donor(name="Alice", password=pbkdf2_sha256.hash("alice1"))
alice.save()
bob = Donor(name="Bob", password=pbkdf2_sha256.hash("bob2"))
bob.save()
charlie = Donor(name="Charlie", password=pbkdf2_sha256.hash("charlie3"))
charlie.save()
donors = [alice, bob, charlie]
for x in range(30):
Donation(donor=random.choice(donors),
value=round(random.uniform(100, 10000), 2)).save()
def all():
"""All Donations (http://localhost:6738/donations/)"""
donations = Donation.select()
return render_template('donations.html', donations=donations)
def donations():
""" list all the donations for all donors """
_donations = Donation.select()
return render_template('donations.jinja2', donations=_donations)
def donor_query(donor):
donations = Donation.select().join(Donor).where(Donor.name == donor.title())
return render_template('donations.jinja2', donations=donations)
import random
from model import db, Donor, Donation
db.connect()
# This line will allow you "upgrade" an existing database by
# dropping all existing tables from it.
db.drop_tables([Donor, Donation])
db.create_tables([Donor, Donation])
alice = Donor(name="Alice Stephenson", email="*****@*****.**")
alice.save()
bob = Donor(name="Bob Novak", email='*****@*****.**')
bob.save()
charlie = Donor(name="Charlie Harper", email='*****@*****.**')
charlie.save()
donors = [alice, bob, charlie]
for donor in donors:
Donation(donor=donor, value=random.randint(100, 10000)).save()
def all_donations():
"""list all donations in the db"""
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def all_name(name):
donations = [
donation for donation in Donation.select()
if donation.donor.name == name.capitalize()
]
return render_template('donations.jinja2', donations=donations)
def list_all():
donations = Donation.select()
return render_template("donations.jinja2", donations=donations)
# This line will allow you "upgrade" an existing database by
# dropping all existing tables from it.
db.drop_tables([Donor, Donation, Admin])
#
db.create_tables([Donor, Donation, Admin])
alice = Donor.create(name="Alice")
# alice.save()
bob = Donor.create(name="Bob")
# bob.save()
charlie = Donor.create(name="Charlie")
# charlie.save()
donors = [alice, bob, charlie]
for x in range(30):
Donation.create(donor=random.choice(donors),
value=random.randint(100, 10000))
user1 = Admin.create(user="******", password=pbkdf2_sha256.hash("password"))
user2 = Admin.create(user="******", password=pbkdf2_sha256.hash("123456"))
# try:
# user = Admin.get(Admin.user == 'admin')
# except DoesNotExist:
# user = None
# print(user)
def spec_user(donor):
donations = Donation.select().join(Donor).where(donor.name == donor)
return render_template('donations.jinja2', donations=donations)
def list_donations():
"""get Donation table and post it"""
return render_template('donations.jinja2', donations=Donation.select())
def all():
# donations = Donation.select()
if request.method == 'POST':
return redirect(url_for('create'))
return render_template('donations.jinja2', donations=Donation.select())
def all():
""" Function to display list of all donations """
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def donationsfordonor(dname):
donations = Donation.select()
return render_template('individualdon.jinja2', dname=dname, donations=donations)
def all():
donations = Donation.select().order_by(Donation.donor.asc(),
Donation.value.desc())
return render_template('donations.jinja2', donations=donations)
def all():
'''Displays all donations'''
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def single_donor(donor_name):
donations = Donation().select().join(Donor).where(Donor.name == donor_name)
return render_template('donations.jinja2', donations=donations)
def all():
""" Displays all donation records """
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def all():
donations = Donation.select()
return render_template('donations.jinja2', donations=donations)
def report():
donations = Donation.select(Donation.donor, fn.Sum(Donation.value).alias
('total'), fn.Avg(Donation.value).alias
('average')).group_by(Donation.donor)
return render_template('report.jinja2', donations=donations)
import random
from model import db, Donor, Donation, User
from passlib.hash import pbkdf2_sha256
db.connect()
# This line will allow you "upgrade" an existing database by
# dropping all existing tables from it.
db.drop_tables([Donor, Donation, User])
db.create_tables([Donor, Donation, User])
alice = Donor(name="Alice")
alice.save()
bob = Donor(name="Bob")
bob.save()
charlie = Donor(name="Charlie")
charlie.save()
donors = [alice, bob, charlie]
for x in range(30):
Donation(donor=random.choice(donors), value=random.randint(100,
10000)).save()
User(name='admin', password=pbkdf2_sha256.hash("password")).save()
def report():
return render_template('report.jinja2',
donor_info=donor_info(),
donations=Donation.select())
