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")