def db_dropall():
"Drops all database tables"
# db_dropall doesn't work if the models aren't imported
import_string('models', silent=True)
for blueprint_name, blueprint in app.blueprints.iteritems():
import_string('%s.models' % blueprint.import_name, silent=True)
db.drop_all()
def init():
from config import db
db.session.close()
db.drop_all()
db.session.commit()
db.create_all()
db.session.commit()
def setUp(self):
app.config['TESTING'] = True
app.config['DEBUG'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + \
os.path.join(basedir, 'test.db')
self.app = app.test_client()
db.drop_all()
db.create_all()
def setUp(self):
app.config['TESTING'] = True
app.config['DEBUG'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + \
os.path.join(basedir, 'test.db')
# Hardcode application start time for testing
app.config.app_start_time = 1
self.app = app.test_client()
db.drop_all()
db.create_all()
def test_update_3(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
s = Style(name="Old Western Ale", description="Taste's like the old west")
db.session.add(s)
db.session.commit()
s.name = "Old Eastern Ale"
db.session.commit()
result = db.session.query(Style).filter_by(name="Old Eastern Ale").first()
self.assertEqual(result.description, "Taste's like the old west")
def test_update_2(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
b = Brewery(name="Austin's Brew House")
db.session.add(b)
db.session.commit()
b.website = "http://www.austinbrew.com/"
db.session.commit()
result = db.session.query(Brewery).filter_by(name="Austin's Brew House").first()
self.assertEqual(result.website, "http://www.austinbrew.com/")
def test_update_1(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
beer1 = Beer(name='Coors Light', description="Taste's like urine.",
is_organic="N", abv=11.1, ibu=30)
db.session.add(beer1)
db.session.commit()
beer1.abv = 1234
db.session.commit()
result = db.session.query(Beer).filter_by(name="Coors Light").first()
self.assertEqual(result.abv, 1234)
def test_delete_1(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
beer1 = Beer(name='Coors Light', description="Taste's like urine.",
is_organic="N", abv=11.1, ibu=30)
db.session.add(beer1)
db.session.commit()
self.assertEqual(beer1._sa_instance_state.persistent, True)
db.session.delete(beer1)
db.session.commit()
self.assertEqual(beer1._sa_instance_state.persistent, False)
def test_relationship_1(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
coors_light = Beer(name='Coors Light', description="Taste's like urine.",
is_organic="N", abv=11.1, ibu=30)
austin_brew = Brewery(name="Austin's Brew House")
db.session.add(coors_light)
db.session.add(austin_brew)
self.assertEqual(austin_brew.beers, [])
austin_brew.beers = [coors_light]
db.session.commit()
self.assertEqual(austin_brew.beers[0].name, "Coors Light")
def test_delete_3(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
style1 = Style(name="Old Western Ales")
style2 = Style(name='Russian Blends', description="It's pretty much just vodka")
db.session.add(style1)
db.session.add(style2)
db.session.commit()
db.session.delete(style1)
db.session.commit()
self.assertEqual(style1._sa_instance_state.persistent, False)
self.assertEqual(style2._sa_instance_state.persistent, True)
def test_add_3(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
style1 = Style(name="Old Western Ales")
style2 = Style(name='Russian Blends', description="It's pretty much just vodka")
db.session.add(style1)
db.session.add(style2)
db.session.commit()
result = db.session.query(Style).filter_by(name="Old Western Ales").first()
self.assertEqual(result.name, "Old Western Ales")
result = db.session.query(Style).filter_by(style_id=2).first()
self.assertEqual(result.description, "It's pretty much just vodka")
self.assertEqual(style1.style_id, 1)
self.assertEqual(style2.style_id, 2)
def test_delete_2(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
brewery1 = Brewery(name="Austin's Brew House")
brewery2 = Brewery(name='The Brewski on 6th', description="Making good stuff",
website="http://www.brew6th.com/")
db.session.add(brewery1)
db.session.add(brewery2)
db.session.commit()
self.assertEqual(brewery1._sa_instance_state.persistent, True)
self.assertEqual(brewery2._sa_instance_state.persistent, True)
db.session.delete(brewery1)
db.session.commit()
self.assertEqual(brewery1._sa_instance_state.persistent, False)
self.assertEqual(brewery2._sa_instance_state.persistent, True)
def test_add_2(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
brewery1 = Brewery(name="Austin's Brew House")
brewery2 = Brewery(name='The Brewski on 6th', description="Making good stuff",
website="http://www.brew6th.com/")
db.session.add(brewery1)
db.session.add(brewery2)
db.session.commit()
result = db.session.query(Brewery).filter_by(name="Austin's Brew House").first()
self.assertEqual(result.name, "Austin's Brew House")
result = db.session.query(Brewery).filter_by(brewery_id=2).first()
self.assertEqual(result.name, "The Brewski on 6th")
self.assertEqual(brewery1.brewery_id, 1)
self.assertEqual(brewery2.brewery_id, 2)
def test_add_1(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
beer1 = Beer(name='Coors Light', description="Taste's like urine.",
is_organic="N", abv=12.2, ibu=30)
beer2 = Beer(name='Blue Moon Original', description="A gift from heaven",
is_organic="N", abv=9.8, ibu=70)
db.session.add(beer1)
db.session.add(beer2)
db.session.commit()
result = db.session.query(Beer).filter_by(abv=9.8).first()
self.assertEqual(result.name, "Blue Moon Original")
result = db.session.query(Beer).filter_by(name="Coors Light").first()
self.assertEqual(result.ibu, 30)
self.assertEqual(beer1.beer_id, 1)
self.assertEqual(beer2.beer_id, 2)
def test_relationship_2(self) :
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
db.drop_all()
db.create_all()
coors_light = Beer(name='Coors Light', description="Taste's like urine.",
is_organic="N", abv=11.1, ibu=30)
blue_moon = Beer(name='Blue Moon', description="Pretty good.",
is_organic="N", abv=6.3, ibu=50)
light_lager = Style(name="Light Hail Lager")
self.assertEqual(light_lager.beers, [])
light_lager.beers = [coors_light, blue_moon]
db.session.add(blue_moon)
db.session.add(coors_light)
db.session.add(light_lager)
self.assertEqual(light_lager.beers[0], coors_light)
self.assertEqual(light_lager.beers[1], blue_moon)
self.assertEqual(light_lager.style_id, blue_moon.style_id)
db.session.commit()
def reset_db(forced=False):
from model import Model, Dataset, ServiceType, Scope, TrainingAlgorithm, ModelMlEngine, DatasetCollector
from config import db, app, fs
if forced:
app.logger.warning("The database has been reset totally to default")
db.drop_all()
db.create_all()
else:
app.logger.warning(
"The Model, Dataset and Collector tables have been reset to default"
)
Model.__table__.drop(db.engine)
Dataset.__table__.drop(db.engine)
DatasetCollector.__table__.drop(db.engine)
Model.__table__.create(db.engine)
Dataset.__table__.create(db.engine)
DatasetCollector.__table__.create(db.engine)
dummy_algo = TrainingAlgorithm()
db.session.add_all([dummy_algo])
db.session.commit()
model_files_dir = os.path.join(app.config["HDFS_ROOT_DIR"],
app.config["HDFS_MODELS_DIR"])
not_trained_model_files_dir = os.path.join(
app.config["HDFS_ROOT_DIR"], app.config["HDFS_NOT_TRAINED_MODELS_DIR"])
metrics_dir = os.path.join(app.config["HDFS_ROOT_DIR"],
app.config["HDFS_METRICS_DIR"])
hdfs_dirs = [model_files_dir, not_trained_model_files_dir, metrics_dir]
for d in hdfs_dirs:
fs.delete(d, recursive=True)
fs.mkdir(d)
app.logger.warning(
"HDFS trained and not trained model directories have been emptied")
validate = db.Column(db.String(2048))
status_validate = db.Column(db.String(64))
header = db.Column(db.String(2048))
status_header = db.Column(db.String(64))
case_id = db.Column(db.Integer, db.ForeignKey('case.id'))
api_msg_id = db.Column(db.Integer, db.ForeignKey('api_msg.id'))
created_time = db.Column(db.DateTime, index=True, default=datetime.now)
update_time = db.Column(db.DateTime,
index=True,
default=datetime.now,
onupdate=datetime.now)
class Report(db.Model):
__tablename__ = 'report'
id = db.Column(db.Integer(), primary_key=True, comment='主键，自增')
case_names = db.Column(db.String(128), nullable=True, comment='用例的名称集合')
read_status = db.Column(db.String(16), nullable=True, comment='阅读状态')
performer = db.Column(db.String(16), nullable=True, comment='执行者')
project_id = db.Column(db.String(16), nullable=True)
create_time = db.Column(db.DateTime(), index=True, default=datetime.now)
#
# def __repr__(self):
# return '<TestCase %r>' % self.case_id
if __name__ == '__main__':
db.drop_all()
db.create_all()
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from models import User, Role
from config import app, db
from flask_security.utils import encrypt_password
from flask_security import Security, SQLAlchemyUserDatastore, \
UserMixin, RoleMixin, login_required, current_user
db.drop_all()
db.create_all()
user_datastore = SQLAlchemyUserDatastore(db, User, Role)
security = Security(app, user_datastore)
with app.app_context():
user_role = Role(name='user')
super_user_role = Role(name='superuser')
db.session.add(user_role)
db.session.add(super_user_role)
db.session.commit()
test_user = user_datastore.create_user(
username='******',
password=encrypt_password('admin'),
active=True,
roles=[user_role, super_user_role],
)
def db_reset():
db.drop_all()
db.create_all()
def tearDown(self):
db.session.remove()
db.drop_all()
self.app_context.pop()
def create_all():
db.drop_all()
return redirect(url_for('startquiz'))
product2 = Product(
2, '优衣库牛仔裤女装', 299, '武汉', 10, 210,
'D:\\tomcat9\\webapps\managerSys\\pictures\\women jeans1.jpg',
'UNIQLO', '秋冬 裤子', '100%棉')
product3 = Product(2, '纯羊毛帽男女', 199, '上海', 100, 200,
'D:\\tomcat9\\webapps\\managerSys\\pictures\\hat1.jpg',
'UNIQLO', '帽', '100%羊毛')
# product4=Product(3,'优衣库羽绒服男装',499,'武汉',195,400,'D:\\tomcat9\\webapps\\managerSys\\pictures\\UNIQLO man coat.jpg','UNIQLO','冬装 男装 衣服','填充白鸭绒，材料不错，不会钻毛,三色可以选择')
# product5=Product(4,'HM男帽秋冬',199,'武汉',195,400,'D:\\tomcat9\\webapps\\managerSys\\pictures\\hat2.jpg','HM','冬装 男帽','100%棉')
# order1=ProductOrder(1,2,499,datetime.date(2018,12,25),'超级棒',0)
# order2=ProductOrder(2,2,299,datetime.date(2018,12,25),'便宜又好',1)
# user1=User('herina yang','111111',datetime.date(1997,8,27),0,0,'北京市丰台区','18672019299',0)
# user2=User('herina','111111',datetime.date(1997,8,27),1,0,'湖北省武汉市武汉大学','18672019299',0)
# print(user1.birthday)
# db.session.add(user1)
# db.session.add(user2)
db.session.add(product1)
db.session.add(product2)
db.session.add(product3)
db.session.commit()
print(User.query.first())
# 测试代码结束
app.run(debug=True)
# app.run()
db.drop_all() # 删除所有表
print('exit.....')
def seed_data():
db.drop_all()
db.create_all()
hashed_password = bcrypt.hashpw(b'secretpassword', bcrypt.gensalt(12))
ronny = User(username='******', email='*****@*****.**', password=hashed_password, createdAt=datetime(2020, 3, 3))
brandon = User(username='******', email='*****@*****.**', password=hashed_password, createdAt=datetime(2020, 3, 3))
kaiser = User(username='******', email='*****@*****.**', password=hashed_password, createdAt=datetime(2020, 3, 18))
db.session.add(ronny)
db.session.add(brandon)
db.session.add(kaiser)
db.session.commit()
cards = []
decks = []
deck_of_cards = []
# UW Control (RTR Standard)
cards.append(Card(name="Azorius Charm", image="https://img.scryfall.com/cards/large/front/9/7/9740ceaf-4ef9-48dd-ab7d-cd5eb3be8cec.jpg?1562851619"))
cards.append(Card(name="Dissolve", image="https://img.scryfall.com/cards/large/front/b/4/b4fb87ab-8595-459a-a5f2-087296d9b120.jpg?1562853056"))
cards.append(Card(name="Doom Blade", image="https://img.scryfall.com/cards/large/front/9/0/90699423-2556-40f7-b8f5-c9d82f22d52e.jpg?1562851557"))
cards.append(Card(name="Hero's Downfall", image="https://img.scryfall.com/cards/large/front/5/9/596822f6-dbd4-4cc8-aa50-9331ff42544e.jpg?1562818494"))
cards.append(Card(name="Sphinx's Revelation", image="https://img.scryfall.com/cards/large/front/0/0/0038ea4d-d0a6-44a4-bee6-24c03313d2bc.jpg?1561759805"))
cards.append(Card(name="Supreme Verdict", image="https://img.scryfall.com/cards/large/front/a/6/a679cc74-6119-468f-8c64-5dcf216438d1.jpg?1562852509"))
cards.append(Card(name="Detention Sphere", image="https://img.scryfall.com/cards/large/front/a/f/afee5464-83b7-4d7a-b407-9ee7de21535b.jpg?1562791607"))
cards.append(Card(name="Elspeth, Sun's Champion", image="https://img.scryfall.com/cards/large/front/f/d/fd5b1633-c41d-42b1-af1b-4a872077ffbd.jpg?1562839369"))
cards.append(Card(name="Jace, Architect of Thought", image="https://img.scryfall.com/cards/large/front/d/4/d4df3a38-678e-42dc-a3fd-d1d399368f07.jpg?1562793747"))
cards.append(Card(name="Aetherling", image="https://img.scryfall.com/cards/large/front/9/c/9c93313b-cf43-47e9-a911-717b4d14b0b5.jpg?1562924171"))
cards.append(Card(name="Blood Baron of Vizkopa", image="https://img.scryfall.com/cards/large/front/5/6/56955e63-db6f-4f1d-b3c4-dd268c902653.jpg?1562848962"))
cards.append(Card(name="Godless Shrine", image="https://img.scryfall.com/cards/large/front/6/f/6fd672bb-18cf-44e3-8dda-5310b1e0fffe.jpg?1561831123"))
cards.append(Card(name="Hallowed Fountain", image="https://img.scryfall.com/cards/large/front/a/f/af7091c9-5f98-4078-a42b-c9e057346d9b.jpg?1562791585"))
cards.append(Card(name="Island", image="https://img.scryfall.com/cards/large/front/9/6/96ad5cbb-b64e-4e18-9aa0-ac076d4b2448.jpg?1583553498"))
cards.append(Card(name="Plains", image="https://img.scryfall.com/cards/large/front/2/2/2296cffa-be1f-49af-aaca-3166e7043de0.jpg?1583553460"))
cards.append(Card(name="Temple of Deceit", image="https://img.scryfall.com/cards/large/front/6/8/686559d7-8ac1-496b-a5a6-1467bf8fc7c5.jpg?1562819288"))
cards.append(Card(name="Temple of Silence", image="https://img.scryfall.com/cards/large/front/0/f/0f14b6b3-5f40-4328-a3be-28fe32dd7cb1.jpg?1562814674"))
cards.append(Card(name="Watery Grave", image="https://img.scryfall.com/cards/large/front/4/7/47fde349-010e-4a2e-838e-e924dbeec355.jpg?1561825120"))
# Combo Elves (Legacy)
cards.append(Card(name="Birchlore Rangers", image="https://img.scryfall.com/cards/large/front/8/c/8ce3a3a1-3569-4909-a604-f78d4888781e.jpg?1562928197"))
cards.append(Card(name="Heritage Druid", image="https://img.scryfall.com/cards/large/front/a/7/a726acbd-724e-46c5-a4cf-4aee7c2abb16.jpg?1562880575"))
cards.append(Card(name="Elvish Mystic", image="https://img.scryfall.com/cards/large/front/d/6/d618c3ea-f823-4fe0-8e11-65d5965528d3.jpg?1561759745"))
cards.append(Card(name="Elvish Reclaimer", image="https://img.scryfall.com/cards/large/front/3/9/39c431d7-d94b-46c4-bb89-f3db56214ab4.jpg?1563899381"))
cards.append(Card(name="Elvish Visionary", image="https://img.scryfall.com/cards/normal/front/f/a/faccfa5f-4d89-4a86-92d7-36cb5a16c5c9.jpg?1562711018"))
cards.append(Card(name="Fyndhorn Elves", image="https://img.scryfall.com/cards/large/front/4/5/45718e96-c7e4-45ef-9196-d3a1eea878fb.jpg?1562909070"))
cards.append(Card(name="Llanowar Elves", image="https://img.scryfall.com/cards/large/front/7/3/73542493-cd0b-4bb7-a5b8-8f889c76e4d6.jpg?1562302708"))
cards.append(Card(name="Multani's Acolyte", image="https://img.scryfall.com/cards/large/front/4/e/4e5fdecb-bca0-48ea-b5bb-d0886c7d3316.jpg?1562862815"))
cards.append(Card(name="Nettle Sentinel", image="https://img.scryfall.com/cards/large/front/f/9/f9f21681-fd36-4106-8395-3153599a08a6.jpg?1562947879"))
cards.append(Card(name="Quirion Ranger", image="https://img.scryfall.com/cards/large/front/5/6/56efe72c-6d7f-44f6-ac74-01af9305c4b6.jpg?1562277667"))
cards.append(Card(name="Wirewood Symbiote", image="https://img.scryfall.com/cards/large/front/4/9/49488b76-abaf-4dba-b01f-7b418e4ff295.jpg?1562528525"))
cards.append(Card(name="Craterhoof Behemoth", image="https://img.scryfall.com/cards/large/front/a/2/a249be17-73ed-4108-89c0-f7e87939beb8.jpg?1561879555"))
cards.append(Card(name="Natural Order", image="https://img.scryfall.com/cards/large/front/0/8/0845f0b0-9413-4ddd-861d-9607636bebc6.jpg?1562276959"))
cards.append(Card(name="Glimpse of Nature", image="https://img.scryfall.com/cards/large/front/1/d/1ddcd76b-a7a1-4ae6-bf4a-f929c6574bdc.jpg?1562757977"))
cards.append(Card(name="Green Sun's Zenith", image="https://img.scryfall.com/cards/large/front/0/2/02335747-54e3-4827-ae19-4e362863da9b.jpg?1562609284"))
cards.append(Card(name="Gaea's Cradle", image="https://img.scryfall.com/cards/large/front/2/5/25b0b816-0583-44aa-9dc5-f3ff48993a51.jpg?1562902898"))
cards.append(Card(name="Misty Rainforest", image="https://img.scryfall.com/cards/large/front/2/4/24a5cc2c-0fbf-4a5f-b175-6e0ffd0d0787.jpg?1562610639"))
cards.append(Card(name="Verdant Catacombs", image="https://img.scryfall.com/cards/large/front/7/a/7abd2723-2851-4f1a-b2d0-dfcb526472c3.jpg?1562613630"))
cards.append(Card(name="Windswept Heath", image="https://img.scryfall.com/cards/large/front/7/a/7a7c5941-9c8a-4a40-9efb-a84f05c58e53.jpg?1562923899"))
cards.append(Card(name="Bayou", image="https://img.scryfall.com/cards/normal/front/1/7/17db2b6a-eaa8-4a08-9e86-370bbd058574.jpg?1559591871"))
cards.append(Card(name="Cavern of Souls", image="https://img.scryfall.com/cards/large/front/1/3/1381c8f1-a292-4bdf-b20c-a5c2a169ee84.jpg?1561857492"))
cards.append(Card(name="Dryad Arbor", image="https://img.scryfall.com/cards/large/front/8/c/8cee476d-42e1-4997-87af-73e18f542167.jpg?1562923491"))
cards.append(Card(name="Forest", image="https://img.scryfall.com/cards/large/front/1/2/12a035fe-8847-4678-84f7-01bac77ae011.jpg?1583553465"))
decks.append(Deck(deck_name='UW Control', createdAt=datetime(2020, 3, 18), user_id=1))
decks.append(Deck(deck_name='Combo Elves', createdAt=datetime(2020, 3, 18), user_id=1))
decks.append(Deck(deck_name='UW Control', createdAt=datetime(2020, 3, 18), user_id=2))
decks.append(Deck(deck_name='UW Control', createdAt=datetime(2020, 3, 18), user_id=3))
# UW Control (RTR Standard)
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=1, count=4)) # Azorius Charm
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=2, count=3)) # Dissolve
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=3, count=3)) # Doom Blade
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=4, count=4)) # Hero's Downfall
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=5, count=3)) # Sphinx's Revelation
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=6, count=4)) # Sphinx's Revelation
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=7, count=3)) # Detention Sphere
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=8, count=2)) # Elspeth, Sun's Champion
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=9, count=4)) # Jace, Architect of Thought
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=10, count=1)) # Aetherling
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=11, count=2)) # Blood Baron of Vizkopa
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=12, count=4)) # Godless Shrine
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=13, count=4)) # Hallowed Fountain
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=14, count=4)) # Island
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=15, count=2)) # Plains
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=16, count=4)) # Temple of Deceit
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=17, count=4)) # Temple of Silence
deck_of_cards.append(Deck_Cards(deck_id=1, card_id=18, count=4)) # Watery Grave
# Combo Elves (Legacy)
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=19, count=2)) # Birchlore Rangers
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=20, count=4)) # Heritage Druid
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=21, count=1)) # Elvish Mystic
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=22, count=4)) # Elvish Reclaimer
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=23, count=4)) # Elvish Visionary
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=24, count=1)) # Fyndhorn Elves
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=25, count=1)) # Llanowar Elves
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=26, count=1)) # Multani's Acolyte
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=27, count=4)) # Nettle Sentinel
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=28, count=4)) # Quirion Ranger
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=29, count=4)) # Wirewood Symbiote
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=30, count=2)) # Craterhoof Behemoth
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=31, count=3)) # Natural Order
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=32, count=4)) # Glimpse of Nature
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=33, count=4)) # Green Sun's Zenith
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=34, count=4)) # Gaea's Cradle
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=35, count=3)) # Misty Rainforest
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=36, count=3)) # Verdant Catacombs
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=37, count=2)) # Windswept Heath
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=38, count=2)) # Bayou
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=39, count=1)) # Cavern of Souls
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=40, count=2)) # Dryad Arbor
deck_of_cards.append(Deck_Cards(deck_id=2, card_id=41, count=3)) # Forest
for playset in deck_of_cards:
db.session.add(playset)
for deck in decks:
db.session.add(deck)
for card in cards:
db.session.add(card)
db.session.commit()
print('DB deleted & reseeded!')
def drop_db():
db.drop_all()
def populatedb():
# Reset db.
print("==========")
print("Dropping db...")
db.drop_all()
print("db dropped!")
print("Creating db...")
db.create_all()
print("db created!")
print("Creating users...")
# Create users
wes = User(user_name="Wes")
joe = User(user_name="Joe")
sally = User(user_name="Sally")
bob = User(user_name="Bob")
jim = User(user_name="Jim")
tt = User(user_name="Tt")
sarah = User(user_name="Sarah")
john = User(user_name="John")
deb = User(user_name="Deb")
bryan = User(user_name="Bryan")
users = [wes, joe, sally, bob, jim, tt, sarah, john, deb, bryan]
print("Creating books...")
# Create books
book1 = Book(book_name="Book1")
book2 = Book(book_name="Book2")
book3 = Book(book_name="Book3")
book4 = Book(book_name="Book4")
book5 = Book(book_name="Book5")
book6 = Book(book_name="Book6")
book7 = Book(book_name="Book7")
book8 = Book(book_name="Book8")
book9 = Book(book_name="Book9")
book10 = Book(book_name="Book10")
book11 = Book(book_name="Book11")
book12 = Book(book_name="Book12")
book13 = Book(book_name="Book13")
book14 = Book(book_name="Book14")
book15 = Book(book_name="Book15")
book16 = Book(book_name="Book16")
book17 = Book(book_name="Book17")
book18 = Book(book_name="Book18")
book19 = Book(book_name="Book19")
book20 = Book(book_name="Book20")
books = [
book1,
book2,
book3,
book4,
book5,
book6,
book7,
book8,
book9,
book10,
book11,
book12,
book13,
book14,
book15,
book16,
book17,
book18,
book19,
book20,
]
for user in users:
db.session.add(user)
db.session.commit()
for book in books:
db.session.add(book)
db.session.commit()
# CHECKOUT SOME BOOKS
# User1 tries to check out books(1-5)
print("Attempting to check out books to users...")
for book in range(1, 6):
endpoint = f"library/checkout_book/1/{book}"
response = requests.put(BASE + endpoint)
print(response.json())
# User2 tries to check out books(6-9)
for book in range(6, 10):
endpoint = f"library/checkout_book/2/{book}"
response = requests.put(BASE + endpoint)
print(response.json())
# User3 tries to check out books(10-12)
for book in range(10, 13):
endpoint = f"library/checkout_book/3/{book}"
response = requests.put(BASE + endpoint)
print(response.json())
# User4 tries to check out books(13-14)
for book in range(13, 15):
endpoint = f"library/checkout_book/4/{book}"
response = requests.put(BASE + endpoint)
print(response.json())
# User5 tries to check out book(15)
for book in range(15, 16):
endpoint = f"library/checkout_book/5/{book}"
response = requests.put(BASE + endpoint)
print(response.json())
print("==========")
from models import User, Role
import io
import sys
import datetime
import pymysql
from flask import Flask, request, jsonify
import flask_sqlalchemy
import flask_restless
from flask_jwt_extended import (JWTManager, jwt_required, get_jwt_identity,
create_access_token, create_refresh_token,
jwt_refresh_token_required, get_raw_jwt)
from werkzeug.security import safe_str_cmp, generate_password_hash, check_password_hash
# Create the Flask application and the Flask-SQLAlchemy object.
################################################################################################################
'''
db.drop_all()
db.create_all()
role_admin = Role(name=u'Admin')
user_tom = User(username=u'tom',password=generate_password_hash('abc'),role=role_admin,userrole=1)
db.session.add(user_tom )
user_jim = User(username=u'jim',password=generate_password_hash('abc'),role=role_admin,userrole=1)
user_tim = User(username=u'tim',password=u'abc',role=role_admin,userrole=1)
user_sam = User(username=u'sam',password=u'abc',role=role_admin,userrole=4)
user_gas = User(username=u'gas',password=u'打开',role=role_admin,userrole=5)
db.session.commit()
'''
'''
#这里是修改密码
users = User.query.all()
username_table = {u.username: u for u in users}
def reset_db():
db.drop_all()
db.create_all()
db.session.commit()
def remove_old_data():
db.drop_all(bind=None)
db.create_all()
def drop_all_tables():
db.drop_all()
db.session.commit()
from __init__ import creat_app
from config import login_manager,mail,db
app = creat_app()
db.init_app(app)
login_manager.init_app(app=app)
mail.init_app(app=app)
db.drop_all(app=app)
db.create_all(app=app)
if __name__ == '__main__':
app.run()
def tearDown(self):
db.session.remove()
db.drop_all()
def tearDown(self):
db.session.remove()
db.drop_all()
self.worker.work(burst=True)
def create_db():
app.config['SQLALCHEMY_ECHO'] = True
db.drop_all()
db.create_all()
def teardown():
_db.session.commit()
_db.drop_all()
def build_or_refresh_db():
db.drop_all()
db.create_all()
load_db()
print("data refreshed!")
