def init_db(username, password, email):
"""Initialize the DB with a single user."""
db.drop_all()
db.create_all()
print(f"Creating user '{username}' with password '{password}' and email '{email}'")
admin = User(username, password, email, is_admin=True, is_verified=True)
db.session.add(admin)
db.session.commit()
def init_db(username, password, email):
"""Initialize the DB with a single user."""
db.drop_all()
db.create_all()
print(
f"Creating user '{username}' with password '{password}' and email '{email}'"
)
admin = User(username,
password,
email,
is_admin=True,
is_verified=True)
db.session.add(admin)
db.session.commit()
#
# This is a short script to kill all tables and fill them with new test data.
# It should be run from a virtualenv.
#
from flamejam import db
from flamejam.models import Announcement, Participant, Jam, Entry, Rating, Comment, EntryScreenshot
from datetime import datetime, timedelta
# Kill everything and recreate tables
db.drop_all()
db.create_all()
# Make users
peter = Participant("peter", "omgdlaad21", "*****@*****.**")
paul = Participant("paul",
"lol",
"*****@*****.**",
is_admin=True,
is_verified=True)
per = Participant("per",
"lpdla",
"*****@*****.**",
is_verified=True,
receive_emails=False)
pablo = Participant("pablo", "lad112", "*****@*****.**")
paddy = Participant("paddy", "rqtjio4j1", "*****@*****.**")
# Add users
db.session.add(peter)
db.session.add(paul)
#
# This is a short script to kill all tables and fill them with new test data.
# It should be run from a virtualenv.
#
from flamejam import db
from flamejam.models import Announcement, Participant, Jam, Entry, Rating, Comment, EntryScreenshot
from datetime import datetime, timedelta
# Kill everything and recreate tables
db.drop_all()
db.create_all()
# Make users
peter = Participant("peter", "omgdlaad21", "*****@*****.**")
paul = Participant("paul", "lol", "*****@*****.**", is_admin=True, is_verified=True)
per = Participant("per", "lpdla", "*****@*****.**", is_verified = True, receive_emails = False)
pablo = Participant("pablo", "lad112", "*****@*****.**")
paddy = Participant("paddy", "rqtjio4j1", "*****@*****.**")
# Add users
db.session.add(peter)
db.session.add(paul)
db.session.add(per)
db.session.add(pablo)
db.session.add(paddy)
# Make jams
rgj1 = Jam("Reddit Game Jam 1", paul, datetime.utcnow() - timedelta(days=30))
rgj2 = Jam("Reddit Game Jam 2", pablo, datetime.utcnow() - timedelta(days=2))
rgj3 = Jam("Reddit Game Jam 3", peter, datetime.utcnow())
def seed_db(flood):
"""Initialize the DB with lots of test data."""
# Kill everything and recreate tables
db.drop_all()
db.create_all()
# Make users
peter = User("peter", "lol", "*****@*****.**")
paul = User("opatut",
"lol",
"*****@*****.**",
is_admin=True,
is_verified=True)
per = User("per",
"lol",
"*****@*****.**",
is_verified=True)
pablo = User("pablo",
"lol",
"*****@*****.**",
is_verified=True)
paddy = User("paddy", "löl", "*****@*****.**")
paddy.real_name = "löl"
# Add users
db.session.add(peter)
db.session.add(paul)
db.session.add(per)
db.session.add(pablo)
db.session.add(paddy)
paul.set_location("Hohenbalk")
paul.ability_programmer = True
paul.ability_gamedesigner = True
paul.ability_3dartist = True
paul.abilities_extra = "C++, Löve/Lua, Python, Java, SVG, HTML5, JS, Blender"
per.set_location("Thesdorfer Weg 20, Pinneberg")
pablo.set_location("Hamburg")
paddy.set_location("San Francisco")
# Make jams
rgj1 = Jam("BaconGameJam 01", datetime.utcnow() - timedelta(days=30))
rgj2 = Jam("BaconGameJam 2", datetime.utcnow() - timedelta(days=2))
rgj3 = Jam("BaconGameJam 3", datetime.utcnow())
loljam = Jam("Test Jam", datetime.utcnow() - timedelta(days=3))
rgj4 = Jam("BaconGameJam 4", datetime.utcnow() + timedelta(days=14))
rgj4.team_limit = 4
rgj1.theme = "Bacon"
rgj2.theme = "Zombies"
rgj3.theme = "Space"
loljam.theme = "Funny"
rgj4.theme = "HIDDEN, SHOULD NOT BE SHOWN"
# Add jams
db.session.add(rgj1)
db.session.add(rgj2)
db.session.add(rgj3)
db.session.add(loljam)
db.session.add(rgj4)
# Make people participate
peter.join_jam(rgj1)
paul.join_jam(rgj1)
paddy.join_jam(rgj2)
peter.join_jam(rgj3)
paul.join_jam(rgj3)
per.join_jam(rgj3)
pablo.join_jam(rgj3)
paddy.join_jam(rgj3)
paddy.join_jam(rgj4)
paul.join_jam(rgj4)
paul.join_jam(loljam)
paddy.join_jam(loljam)
pablo.join_jam(loljam)
aTeam = paul.get_team(rgj3)
aTeam.user_join(pablo)
# Make games
best_game = Game(paddy.get_team(rgj3), "Bessy the Best Game")
best_game.description = "Simply the best game"
space_game = Game(aTeam, "CloneStars - The war wars")
space_game.description = "A space shooter game."
lolgame = Game(pablo.get_team(loljam), "Lolol")
lolgame.description = "Lol."
clone = Game(peter.get_team(rgj3), "Shooterz")
clone.description = "I got this idea while taking a dump."
test_game = Game(per.get_team(rgj3), "RIP VIP")
# Add games
db.session.add(best_game)
db.session.add(space_game)
db.session.add(lolgame)
db.session.add(clone)
db.session.add(test_game)
# Add screenshots
s1 = GameScreenshot(
"http://2.bp.blogspot.com/_gx7OZdt7Uhs/SwwanX_-API/AAAAAAAADAM/vbZbIPERdhs/s1600/Star-Wars-Wallpaper-star-wars-6363340-1024-768.jpg",
"Awesome cover art", space_game)
s2 = GameScreenshot(
"http://images.psxextreme.com/wallpapers/ps3/star_wars___battle_1182.jpg",
"Sample vehicles", space_game)
s3 = GameScreenshot(
"http://sethspopcorn.com/wp-content/uploads/2010/10/CloneTrooper.jpg",
"Character selection screen", space_game)
db.session.add(s1)
db.session.add(s2)
db.session.add(s3)
# Make ratings
rating1 = Rating(best_game, peter, "Cool stuff", 3)
rating2 = Rating(best_game, paul, "", 10)
rating3 = Rating(space_game, paul, "Awesome space action!", 3)
rating4 = Rating(clone, paul, "Something something", 9)
rating5 = Rating(clone, paddy, "", 3)
# Add ratings
db.session.add(rating1)
db.session.add(rating2)
db.session.add(rating3)
db.session.add(rating4)
db.session.add(rating5)
# Make comments
comment1 = Comment("lol so bad", best_game, peter)
comment2 = Comment("the worst", best_game, paul)
comment3 = Comment(
"You don't provide a download for your game. "
"Please add one via \"Add package\".", space_game, paul)
comment4 = Comment("I really *love* this game. It is just awesome.",
space_game, paul)
comment5 = Comment("@paul Now you have a download", space_game, paddy)
# Add comments
db.session.add(comment1)
db.session.add(comment2)
db.session.add(comment3)
db.session.add(comment4)
db.session.add(comment5)
# Flood db
if flood:
for u in range(1000):
user = User("user{u}",
"lol",
"lol{u}@example.com",
is_verified=True)
user.join_jam(rgj3)
db.session.add(user)
# Commmit it all
db.session.commit()
def seed_db(flood):
"""Initialize the DB with lots of test data."""
# Kill everything and recreate tables
db.drop_all()
db.create_all()
# Make users
peter = User("peter", "lol", "*****@*****.**")
paul = User("opatut", "lol", "*****@*****.**", is_admin=True, is_verified=True)
per = User("per", "lol", "*****@*****.**", is_verified=True)
pablo = User("pablo", "lol", "*****@*****.**", is_verified=True)
paddy = User("paddy", "löl", "*****@*****.**")
paddy.real_name = "löl"
# Add users
db.session.add(peter)
db.session.add(paul)
db.session.add(per)
db.session.add(pablo)
db.session.add(paddy)
paul.set_location("Hohenbalk")
paul.ability_programmer = True
paul.ability_gamedesigner = True
paul.ability_3dartist = True
paul.abilities_extra = "C++, Löve/Lua, Python, Java, SVG, HTML5, JS, Blender"
per.set_location("Thesdorfer Weg 20, Pinneberg")
pablo.set_location("Hamburg")
paddy.set_location("San Francisco")
# Make jams
rgj1 = Jam("BaconGameJam 01", datetime.utcnow() - timedelta(days=30))
rgj2 = Jam("BaconGameJam 2", datetime.utcnow() - timedelta(days=2))
rgj3 = Jam("BaconGameJam 3", datetime.utcnow())
loljam = Jam("Test Jam", datetime.utcnow() - timedelta(days=3))
rgj4 = Jam("BaconGameJam 4", datetime.utcnow() + timedelta(days=14))
rgj4.team_limit = 4
rgj1.theme = "Bacon"
rgj2.theme = "Zombies"
rgj3.theme = "Space"
loljam.theme = "Funny"
rgj4.theme = "HIDDEN, SHOULD NOT BE SHOWN"
# Add jams
db.session.add(rgj1)
db.session.add(rgj2)
db.session.add(rgj3)
db.session.add(loljam)
db.session.add(rgj4)
# Make people participate
peter.join_jam(rgj1)
paul.join_jam(rgj1)
paddy.join_jam(rgj2)
peter.join_jam(rgj3)
paul.join_jam(rgj3)
per.join_jam(rgj3)
pablo.join_jam(rgj3)
paddy.join_jam(rgj3)
paddy.join_jam(rgj4)
paul.join_jam(rgj4)
paul.join_jam(loljam)
paddy.join_jam(loljam)
pablo.join_jam(loljam)
aTeam = paul.get_team(rgj3)
aTeam.user_join(pablo)
# Make games
best_game = Game(paddy.get_team(rgj3), "Bessy the Best Game")
best_game.description = "Simply the best game"
space_game = Game(aTeam, "CloneStars - The war wars")
space_game.description = "A space shooter game."
lolgame = Game(pablo.get_team(loljam), "Lolol")
lolgame.description = "Lol."
clone = Game(peter.get_team(rgj3), "Shooterz")
clone.description = "I got this idea while taking a dump."
test_game = Game(per.get_team(rgj3), "RIP VIP")
# Add games
db.session.add(best_game)
db.session.add(space_game)
db.session.add(lolgame)
db.session.add(clone)
db.session.add(test_game)
# Add screenshots
s1 = GameScreenshot("http://2.bp.blogspot.com/_gx7OZdt7Uhs/SwwanX_-API/AAAAAAAADAM/vbZbIPERdhs/s1600/Star-Wars-Wallpaper-star-wars-6363340-1024-768.jpg", "Awesome cover art", space_game)
s2 = GameScreenshot("http://images.psxextreme.com/wallpapers/ps3/star_wars___battle_1182.jpg", "Sample vehicles", space_game)
s3 = GameScreenshot("http://sethspopcorn.com/wp-content/uploads/2010/10/CloneTrooper.jpg", "Character selection screen", space_game)
db.session.add(s1)
db.session.add(s2)
db.session.add(s3)
# Make ratings
rating1 = Rating(best_game, peter, "Cool stuff", 3)
rating2 = Rating(best_game, paul, "", 10)
rating3 = Rating(space_game, paul, "Awesome space action!", 3)
rating4 = Rating(clone, paul, "Something something", 9)
rating5 = Rating(clone, paddy, "", 3)
# Add ratings
db.session.add(rating1)
db.session.add(rating2)
db.session.add(rating3)
db.session.add(rating4)
db.session.add(rating5)
# Make comments
comment1 = Comment("lol so bad", best_game, peter)
comment2 = Comment("the worst", best_game, paul)
comment3 = Comment("You don't provide a download for your game. "
"Please add one via \"Add package\".", space_game, paul)
comment4 = Comment("I really *love* this game. It is just awesome.", space_game, paul)
comment5 = Comment("@paul Now you have a download", space_game, paddy)
# Add comments
db.session.add(comment1)
db.session.add(comment2)
db.session.add(comment3)
db.session.add(comment4)
db.session.add(comment5)
# Flood db
if flood:
for u in range(1000):
user = User("user{u}", "lol", "lol{u}@example.com", is_verified=True)
user.join_jam(rgj3)
db.session.add(user)
# Commmit it all
db.session.commit()