def refresh_db(): if prompt_bool('Are you sure you want to lose all current data'): with app.app_context(): print('Dropping Tables') db.drop_all() print('Creating Tables') db.create_all() print('Refresh Complete')
def createdb(testdata=False): app = create_app() with app.app_context(): db.drop_all() db.create_all() if testdata: u = User(username='******', password_hash='test') db.session.add(u) db.session.commit()
def setUp(self): self.app = create_app("test_config") self.ctx = self.app.app_context() self.ctx.push() db.drop_all() db.create_all() u = User(username=self.default_username, password=self.default_password) db.session.add(u) db.session.commit() self.client = TestClient(self.app, u.generate_auth_token(), "")
def setUp(self): self.app = create_app() self.db_fd, self.app.config['DATABASE'] = tempfile.mkstemp() self.app.config['TESTING'] = True self.ctx = self.app.app_context() self.ctx.push() db.drop_all() db.create_all() u = User(username=self.default_username, password=self.default_password) db.session.add(u) db.session.commit() self.client = self.app.test_client()
def createdb(testdata=False): app = create_app() with app.app_context(): db.drop_all() db.create_all() if testdata: classes = ['Algebra', 'Literature', 'Chemistry', 'Spanish', 'Game Development', 'History', 'Music', 'Psychology', 'Science', 'Photography', 'Drama', 'Business', 'Python Programming'] for name in classes: c = Class(name=name) db.session.add(c) u = User(username='******', password='******') db.session.add(u) db.session.commit()
def tearDown(self): db.session.remove() db.drop_all() self.ctx.pop()
def createdb(): app = create_app() with app.app_context(): db.drop_all() db.create_all()
def createdb(): """Drop all the data from tables and create/rearrange new tables""" app = create_app() with app.app_context(): db.drop_all() db.create_all() # Adding default data if data is dropped and created again # u1 = User(username='******', group = 'USER', password='******') u2 = User(username='******', group = 'ADMIN', password='******') u3 = User(username='******', group = 'ADMIN', password='******') # hub1 = Hub(hub_id=1234, hub_type = 10, description='testinghub',external_url='192.168.0.117',internal_url='10.0.0.2',status=True,activated_at=datetime.today(),last_changed_by='BackendUser',last_changed_on=datetime.today()) # Section Types eg. # Hub Types eg. 10=Switching, 11=TV Remote, 12=Camera, 11=Kitchen, 12=Bedroom, 13=Bathroom etc, hub_type1 = HubTypes(hub_type=10, hub_type_desc='Switching', last_changed_by='BackendUser', last_changed_on=datetime.today()) hub_type2 = HubTypes(hub_type=11, hub_type_desc='TV Remote', last_changed_by='BackendUser', last_changed_on=datetime.today()) hub_type3 = HubTypes(hub_type=12, hub_type_desc='Camera', last_changed_by='BackendUser', last_changed_on=datetime.today()) # Section Types eg. # Section Types eg. 10=House:Living Room, 11=Kitchen, 12=Bedroom, 13=Bathroom etc, sec_type1 = SectionTypes(section_type=10, section_type_desc='Balcony', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type2 = SectionTypes(section_type=11, section_type_desc='Bathroom', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type3 = SectionTypes(section_type=12, section_type_desc='Bedroom', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type4 = SectionTypes(section_type=13, section_type_desc='Cellar', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type5 = SectionTypes(section_type=14, section_type_desc='Common Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type6 = SectionTypes(section_type=15, section_type_desc='Dining Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type7 = SectionTypes(section_type=16, section_type_desc='Drawing Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type8 = SectionTypes(section_type=17, section_type_desc='Dressing Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type9 = SectionTypes(section_type=18, section_type_desc='Family Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type10 = SectionTypes(section_type=19, section_type_desc='Front Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type11 = SectionTypes(section_type=20, section_type_desc='Garden', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type12 = SectionTypes(section_type=21, section_type_desc='Guest Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type13 = SectionTypes(section_type=22, section_type_desc='Kitchen', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type14 = SectionTypes(section_type=23, section_type_desc='Living room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type15 = SectionTypes(section_type=24, section_type_desc='Lobby', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type16 = SectionTypes(section_type=25, section_type_desc='Servant room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type17 = SectionTypes(section_type=26, section_type_desc='Store room', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type18 = SectionTypes(section_type=27, section_type_desc='Terrace', last_changed_by='BackendUser', last_changed_on=datetime.today()) sec_type19 = SectionTypes(section_type=28, section_type_desc='Waiting Room', last_changed_by='BackendUser', last_changed_on=datetime.today()) # Node Types eg. 10=Webswitch, 11=TouchPanel, 12=TV, 13=Music, 14=AC ep_type1 = EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1000, endpoint_type_desc = 'Switch', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type2 = EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1001, endpoint_type_desc = 'Dimmer', status_min=1, status_max=10,method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type3 = EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1002, endpoint_type_desc = '30A Switch', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type4 = EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1003, endpoint_type_desc = 'Curtain', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type5 = EndpointTypes(node_type=11, node_type_desc = 'SparshTouchSwitch', endpoint_type=1100, endpoint_type_desc = 'Switch', status_min=0, status_max=1, method='touchswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type6 = EndpointTypes(node_type=11, node_type_desc = 'SparshTouchSwitch', endpoint_type=1101, endpoint_type_desc = 'Dimmer', status_min=1, status_max=10,method='touchswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type7 = EndpointTypes(node_type=11, node_type_desc = 'SparshTouchSwitch', endpoint_type=1102, endpoint_type_desc = '30A Switch', status_min=0, status_max=1, method='touchswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type8 = EndpointTypes(node_type=11, node_type_desc = 'SparshTouchSwitch', endpoint_type=1103, endpoint_type_desc = 'Curtain', status_min=0, status_max=1, method='touchswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type9 = EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1200, endpoint_type_desc = 'Channel +', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type10= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1201, endpoint_type_desc = 'Channel -', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type11= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1202, endpoint_type_desc = 'Volume +', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type12= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1203, endpoint_type_desc = 'Volume -', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type13= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1204, endpoint_type_desc = 'Mute', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type14= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1205, endpoint_type_desc = 'Menu', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type15= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1206, endpoint_type_desc = 'Ok', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type16= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1207, endpoint_type_desc = 'Source', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type17= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1208, endpoint_type_desc = 'On/Off', status_min=2, status_max=2, method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type49= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1299, endpoint_type_desc = 'TV', status_min=99,status_max=99,method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today(), node_category='complex') ep_type18= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1300, endpoint_type_desc = 'On/Off', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type19= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1301, endpoint_type_desc = 'Channel +', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type20= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1302, endpoint_type_desc = 'Channel -', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type21= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1303, endpoint_type_desc = 'Volume +', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type22= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1304, endpoint_type_desc = 'Volume -', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type23= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1305, endpoint_type_desc = 'Mute', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type24= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1306, endpoint_type_desc = 'Menu', status_min=2, status_max=2, method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type50= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1399, endpoint_type_desc = 'Settop Box', status_min=99,status_max=99,method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today(), node_category='complex') ep_type25= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1400, endpoint_type_desc = 'Temp +', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type26= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1401, endpoint_type_desc = 'Temp -', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type27= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1402, endpoint_type_desc = 'Fan +', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type28= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1403, endpoint_type_desc = 'Fan -', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type29= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1404, endpoint_type_desc = 'Swing', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type30= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1405, endpoint_type_desc = 'Mode', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type48= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1406, endpoint_type_desc = 'On/Off', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type51= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1499, endpoint_type_desc = 'AC', status_min=99,status_max=99,method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today(), node_category='complex') ep_type31= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1004, endpoint_type_desc = 'Computer', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type32= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1005, endpoint_type_desc = 'Iron', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type33= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1006, endpoint_type_desc = 'Refrigerator', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type34= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1007, endpoint_type_desc = 'Washing Machine',status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type35= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1008, endpoint_type_desc = 'Printer', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type36= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1009, endpoint_type_desc = 'Geyser', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type37= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1010, endpoint_type_desc = 'Dressing Table',status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type38= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1011, endpoint_type_desc = 'Microwave', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type39= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1012, endpoint_type_desc = 'Tubelight', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type40= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1013, endpoint_type_desc = 'Focus Lamp', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type41= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1014, endpoint_type_desc = 'Table Lamp', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type42= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1015, endpoint_type_desc = 'Outer Light', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type43= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1016, endpoint_type_desc = 'CFL', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type44= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1017, endpoint_type_desc = 'Socket', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type45= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1018, endpoint_type_desc = 'Chandelier', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type46= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1019, endpoint_type_desc = 'Music Player', status_min=0, status_max=1, method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) ep_type47= EndpointTypes(node_type=10, node_type_desc = 'Webswitch', endpoint_type=1020, endpoint_type_desc = 'Fan', status_min=1, status_max=10,method='webswitch', last_changed_by='BackendUser', last_changed_on=datetime.today()) # ep_type48= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1406, endpoint_type_desc = 'On/Off', status_min=2, status_max=2, method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today()) # ep_type49= EndpointTypes(node_type=12, node_type_desc = 'TV', endpoint_type=1299, endpoint_type_desc = 'TV', status_min=99,status_max=99,method='tvremote', last_changed_by='BackendUser', last_changed_on=datetime.today(), node_category='complex') # ep_type50= EndpointTypes(node_type=13, node_type_desc = 'Settop Box', endpoint_type=1399, endpoint_type_desc = 'Settop Box', status_min=99,status_max=99,method='settopbox', last_changed_by='BackendUser', last_changed_on=datetime.today(), node_category='complex') # ep_type51= EndpointTypes(node_type=14, node_type_desc = 'AC', endpoint_type=1499, endpoint_type_desc = 'AC', status_min=99,status_max=99,method='acremote', last_changed_by='BackendUser', last_changed_on=datetime.today(), node_category='complex') dbg_prop = Properties(key='DEBUG', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='true') ser_prop = Properties(key='ServerAPI', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='http://shubansolutions.com/etct/ws/') cph_prop = Properties(key='ContactPh', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='1234567890') cad_prop = Properties(key='ContactAd', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='1, street2, area3, city4, pin5') cws_prop = Properties(key='ContactWs', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='http://www.etct.in') cml_prop = Properties(key='ContactMl', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='*****@*****.**') seu_prop = Properties(key='ServerUsr', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='admin') sep_prop = Properties(key='ServerPwd', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='et111ct') wsc_prop = Properties(key='WbSwtComm', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='/dev/ttyUSB0') wsb_prop = Properties(key='WbSwtBaud', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='9600') wsf_prop = Properties(key='WbSwtSFrq', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='3') stc_prop = Properties(key='StSwtComm', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='/dev/ttyAMA0') stb_prop = Properties(key='StSwtBaud', last_changed_by='BackendUser', last_changed_on=datetime.today(), value='19200') # db.session.add(hub1) # db.session.add(hub_type1) db.session.add(hub_type2) db.session.add(hub_type3) # # db.session.add(u1) db.session.add(u2) db.session.add(u3) # db.session.add(sec_type1) db.session.add(sec_type2) db.session.add(sec_type3) db.session.add(sec_type4) db.session.add(sec_type5) db.session.add(sec_type6) db.session.add(sec_type7) db.session.add(sec_type8) db.session.add(sec_type9) db.session.add(sec_type10) db.session.add(sec_type11) db.session.add(sec_type12) db.session.add(sec_type13) db.session.add(sec_type14) db.session.add(sec_type15) db.session.add(sec_type16) db.session.add(sec_type17) db.session.add(sec_type18) db.session.add(sec_type19) # db.session.add(ep_type1) db.session.add(ep_type2) db.session.add(ep_type3) db.session.add(ep_type4) db.session.add(ep_type5) db.session.add(ep_type6) db.session.add(ep_type7) db.session.add(ep_type8) db.session.add(ep_type9) db.session.add(ep_type10) db.session.add(ep_type11) db.session.add(ep_type12) db.session.add(ep_type13) db.session.add(ep_type14) db.session.add(ep_type15) db.session.add(ep_type16) db.session.add(ep_type17) db.session.add(ep_type18) db.session.add(ep_type19) db.session.add(ep_type20) db.session.add(ep_type21) db.session.add(ep_type22) db.session.add(ep_type23) db.session.add(ep_type24) db.session.add(ep_type25) db.session.add(ep_type26) db.session.add(ep_type27) db.session.add(ep_type28) db.session.add(ep_type29) db.session.add(ep_type30) db.session.add(ep_type31) db.session.add(ep_type32) db.session.add(ep_type33) db.session.add(ep_type34) db.session.add(ep_type35) db.session.add(ep_type36) db.session.add(ep_type37) db.session.add(ep_type38) db.session.add(ep_type39) db.session.add(ep_type40) db.session.add(ep_type41) db.session.add(ep_type42) db.session.add(ep_type43) db.session.add(ep_type44) db.session.add(ep_type45) db.session.add(ep_type46) db.session.add(ep_type47) db.session.add(ep_type48) db.session.add(ep_type49) db.session.add(ep_type50) db.session.add(ep_type51) # db.session.add(dbg_prop) db.session.add(ser_prop) db.session.add(cph_prop) db.session.add(cad_prop) db.session.add(cws_prop) db.session.add(cml_prop) db.session.add(seu_prop) db.session.add(sep_prop) db.session.add(wsc_prop) db.session.add(wsb_prop) db.session.add(wsf_prop) db.session.add(stc_prop) db.session.add(stb_prop) # db.session.commit()
def drop_db(): """Drops database tables""" if prompt_bool("Are you sure you want to lose all your data?"): app = create_app('default') with app.app_context(): db.drop_all()
from api.app import create_app from api.models import db, User app = create_app() with app.app_context(): db.drop_all() db.create_all() u = User(username='******', password='******') db.session.add(u) db.session.commit() app.run(debug=True)
def tearDown(self): db.session.remove() db.drop_all()
def tearDown(self): db.session.remove() db.drop_all() self.app_context.pop()
def recreate_db(): db.drop_all() db.create_all() db.session.commit()