def setUp(self):
app.config['TESTING'] = True
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
self.app = app.test_client()
db.create_all()
self.display = Display(visible=0, size=(800, 600))
self.display.start()
self.driver = webdriver.Firefox()
def client():
from mysite import create_app
app = create_app(config_file=CONFIG_FILE)
with app.app_context():
from mysite import db
db.create_all()
app.config['TESTING'] = True
with app.test_client() as c:
yield c
def create_data_db():
#create the database if it doesn't exist, then query it for all the teams in it
bind_key = 'data_db'
try:
assert False
all_teams = models.team.query.all()
all_teams = [team.ncaaID for team in all_teams]
except:
db.create_all(bind=[bind_key])
def setUp(self):
app.config['TESTING'] = True
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
self.app = app.test_client()
db.create_all()
self.display = Display(visible=0, size=(800, 600))
self.display.start()
self.driver = webdriver.Firefox()
def make_raw_team_database():
'''This function should be called once/year to make the years new database'''
#delete all teams in database
try:
#assert False
all_teams = models.raw_team.query.all()
for team in all_teams:
db.session.delete(team)
db.session.commit()
except:
pass
#create the database if it doesn't exist, then query it for all the teams in it
bind_key = 'all_teams_db'
try:
all_teams = models.raw_team.query.all()
all_teams = [team.ncaaID for team in all_teams]
except:
db.create_all(bind=[bind_key])
all_teams = models.raw_team.query.all()
all_teams = [team.ncaaID for team in all_teams]
#this code adds the teams from a pre-existing db
teams = models.team.query.all()
for team in teams:
if team.ncaaID not in all_teams:
new_team = models.raw_team()
new_team.ncaaID = team.ncaaID
new_team.ncaa = team.ncaa
new_team.espn = team.espn
new_team.espn_name = team.espn_name
new_team.cbs1 = team.cbs1
new_team.cbs2 = team.cbs2
new_team.statsheet = team.statsheet
db.session.add(new_team)
print new_team.statsheet
db.session.commit()
from mysite import db, create_app db.create_all(app=create_app())
#!flask/bin/python from config import SQLALCHEMY_DATABASE_URI from mysite import db db.create_all()
#!flask/bin/python
from config import SQLALCHEMY_DATABASE_URI
from mysite import db
from flask import Flask
import mysite.user.models
import investments.models.assets
import investments.models.portfolio
import finances.models.budget
import finances.models.transaction
import finances.models.category
import finances.models.pattern
app = Flask(__name__)
app.config.from_object('config')
db.init_app(app)
with app.app_context():
db.create_all()
def create_tables():
# Create table for each model if it does not exist.
# Use the underlying peewee database object instead of the
# flask-peewee database wrapper:
db.create_all()
def setup(self):
db.create_all()
db.session.add( TaxRate('Illinois', 2015, 0, 0, 0.02, 'Single') )
def setUp(self):
logging.basicConfig(level=logging.ERROR)
db.create_all()
self.user = User(id=1, email='*****@*****.**', name='test')
db.session.add(self.user)
