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