def main():
"""Main function for populating the database"""
donors = [('Toni Morrison', random.sample(range(100, 25000), 3)),
('Mike McHargue', random.sample(range(100, 25000), 3)),
("Flannery O'Connor", random.sample(range(100, 25000), 3)),
('Angelina Davis', random.sample(range(100, 25000), 3)),
('Bell Hooks', random.sample(range(100, 25000), 3))]
db.connect()
db.drop_tables([Donor, Donation])
db.create_tables([Donor, Donation])
bcrypt = Bcrypt()
for donor, donations in donors:
try:
Donor.create(name=donor,
email='.'.join(donor.lower().split()) + '@gmail.com',
password=bcrypt.generate_password_hash('password'),
total=sum(donations),
average=sum(donations) / len(donations))
except:
db.rollback()
for donor, donations in donors:
for donation in donations:
try:
Donation.create(donor=donor, amount=donation)
except:
db.rollback()
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([User, Donor, Donation])
db.create_tables([User, Donor, Donation])
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()
User(name="bob", password=pbkdf2_sha256.hash("bobbob")).save()
"""
Scripts to run to set up our database
"""
from datetime import datetime
from model import db, User, Task
from passlib.hash import pbkdf2_sha256
# Create the database tables for our model
db.connect()
db.drop_tables([User, Task])
db.create_tables([User, Task])
Task(name="Do the laundry.").save()
Task(name="Do the dishes.", performed=datetime.now()).save()
User(name="admin", password=pbkdf2_sha256.hash("password")).save()
User(name="bob", password=pbkdf2_sha256.hash("bobbob")).save()
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()
from model import db, Participant, Prize_Structure, Team
db.connect()
# This line will allow you "upgrade" an existing database by
# dropping all existing tables from it.
db.drop_tables([Participant, Prize_Structure, Team])
db.create_tables([Participant, Prize_Structure, Team])
play_in = Prize_Structure(advanced_to_round=0, money_share=0).save()
first = Prize_Structure(advanced_to_round=1, money_share=0).save()
second = Prize_Structure(advanced_to_round=2, money_share=0).save()
sweet_sixteen = Prize_Structure(advanced_to_round=3, money_share=0.03).save()
elite_eight = Prize_Structure(advanced_to_round=4, money_share=0.05).save()
final_four = Prize_Structure(advanced_to_round=5, money_share=0.1).save()
championship = Prize_Structure(advanced_to_round=6, money_share=0.16).save()
winner = Prize_Structure(advanced_to_round=7, money_share=0.2).save()
teams = [('Villanova', 'East', 1, first), ('Michigan', 'West', 3, first),
('Kansas', 'Midwest', 1, first), ('Loyola (IL)', 'South', 11, first),
('Kansas State', 'South', 9, first),
('Florida State', 'West', 9, first), ('Duke', 'Midwest', 2, first),
('Texas Tech', 'East', 3, first), ('Kentucky', 'South', 5, first),
('Nevada', 'South', 7, first), ('Gonzaga', 'West', 4, first),
('Texas A&M', 'West', 7, first), ('Clemson', 'Midwest', 5, first),
('Syracuse', 'Midwest', 11, play_in), ('W. Virginia', 'East', 5,
first),
('Purdue', 'East', 2, first), ('Marshall', 'East', 13, first),
('UMBC', 'South', 16, first), ('Buffalo', 'South', 13, first),
('Tennessee', 'South', 3, first), ('Cincinnati', 'South', 2, first),
from model import db, Message db.connect() db.drop_tables([Message]) db.create_tables([Message])
import random
from peewee import DoesNotExist
from passlib.hash import pbkdf2_sha256
from model import db, Donor, Donation, Admin
db.connect()
# db.execute_sql('PRAGMA foreign_keys = ON;')
# 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"))
""" Scripts to run to set up our database """ from model import db, SavedTotal # Create the database tables for our model db.connect() db.drop_tables([SavedTotal]) db.create_tables([SavedTotal])
import random
from model import db, User, Bill
db.connect()
# This line will allow you "upgrade" an existing database by
# dropping all existing tables from it.
db.drop_tables([User, Bill])
db.create_tables([User, Bill])
rent = Bill(name="Rent",
amount=1600,
first_day="2018-01-01",
last_day="2018-01-31")
rent.save()
electricity = Bill(name="Electricity",
amount=100,
first_day="2018-01-05",
last_day="2018-02-04")
electricity.save()
dennis = User(username="******", move_in="2018-01-01", move_out="2018-01-31")
dennis.save()
mac = User(username="******", move_in="2018-01-05", move_out="2018-02-15")
mac.save()
# charlie = User(username="******", move_in="2018/01/01", move_out="2018/01/25")
