def setUp(self): super().setUp() db.create_all() admin_role = Role(name='admin') self.user = User( username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) self.admin = User( username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]) self.try_add_entities([ self.user, self.admin, admin_role, Currency(code='USD', rate=0.5), Currency(code='RUR', rate=0.5), Country(id='c1', name='country1'), Product(id='0000', name='Test product', price=10, weight=10) ])
def setUp(self): super().setUp() db.create_all() admin_role = Role(id=10, name='admin') self.try_add_entities([ User( id=0, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]), User( id=10, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True), User( id=20, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True), admin_role, Currency() ])
def setUp(self): super().setUp() self.maxDiff = None db.create_all() admin_role = Role(id=10, name='admin') self.admin = User( id=0, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]) self.user = User( id=10, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) self.try_add_entities([ admin_role, self.user, self.admin, User( id=20, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True), Order(id='test-api-admin-2', user_id=20) ])
def test_creating_bucketlist(self): """Tests successfully creating a bucketlist""" # this test would conflict with bucketlist defined in the setup # clear everythin before running it db.drop_all() db.create_all() # Instantiating a bucketlist object bucketlist = Bucketlist("Cook") # save the object to database db.session.add(bucketlist) db.session.commit() # asssert the attributes self.assertEqual(bucketlist.id, 1) self.assertEqual(bucketlist.name, "Cook") self.assertEqual(bucketlist.created_by, None) year = str(datetime.today().year) self.assertIn(year, str(bucketlist.date_created)) self.assertIn(year, str(bucketlist.date_modified)) self.assertEqual(len(bucketlist.items), 0) # test querying bucketlists bucketlist_query = Bucketlist.query.all() self.assertIn("<Bucketlist 'Cook'>", str(bucketlist_query)) self.assertFalse("<Bucketlist 'Random'>" in str(bucketlist_query))
def database(app): with app.app_context(): db.init_app(app) db.create_all() yield app db.session.close() db.drop_all()
def setUp(self): super().setUp() db.create_all() admin_role = Role(id=10, name='admin') self.user = User(id=10, username='******', email='*****@*****.**', password_hash='pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) self.admin = User(username='******', email='*****@*****.**', password_hash='pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]) self.try_add_entities([ self.user, self.admin, admin_role ])
def setUp(self): super().setUp() db.create_all() self.user = User( id=100, username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) try: entities = [ self.user, Country(id='c1', name='country1'), Currency(code='USD', name='US Dollar', rate=1), Currency(code='RUR', name='Russian rouble', rate=1), Country(id='c2', name='country2'), Shipping(id=1, name='Shipping1'), Shipping(id=2, name='Shipping2'), Shipping(id=3, name='Shipping3'), DHL(), ShippingRate(id=1, shipping_method_id=1, destination='c1', weight=100, rate=100), ShippingRate(id=5, shipping_method_id=2, destination='c1', weight=200, rate=110), ShippingRate(id=2, shipping_method_id=2, destination='c2', weight=100, rate=100), ShippingRate(id=3, shipping_method_id=2, destination='c2', weight=1000, rate=150), ShippingRate(id=4, shipping_method_id=3, destination='c2', weight=2000, rate=160) ] db.session.add_all(entities) db.session.commit() except: db.session.rollback()
def setUp(self): super().setUp() db.create_all() admin_role = Role(name='admin') self.user = User(username='******', email='*****@*****.**', password_hash='pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) self.admin = User(username='******', email='*****@*****.**', password_hash='pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]) self.try_add_entities([ self.user, self.admin, admin_role, Currency(code='USD', rate=0.5), Currency(code='RUR', rate=0.5) ])
def test_creating_bucketlist_with_a_missing_name(self): """Tests successfully creating a bucketlist""" # this test would conflict with bucketlist defined in the setup # clear everythin before running it db.drop_all() db.create_all() with self.assertRaises(Exception) as context: # Instantiating a bucketlist object bucketlist = Bucketlist() # save the object to database db.session.add(bucketlist) db.session.commit() self.assertEqual('kjfdjkgf', 'nndnnv')
def setUp(self): super().setUp() db.create_all() db.session.execute("INSERT INTO countries VALUES('ua', 'Ukraine', 0)") db.session.execute("INSERT INTO dhl_zones VALUES(1)") db.session.execute("INSERT INTO dhl_zones VALUES(2)") db.session.execute("INSERT INTO dhl_zones VALUES(3)") db.session.execute("INSERT INTO dhl_zones VALUES(4)") db.session.execute("INSERT INTO dhl_zones VALUES(5)") db.session.execute("INSERT INTO dhl_zones VALUES(6)") db.session.execute("INSERT INTO dhl_zones VALUES(7)") db.session.execute("INSERT INTO dhl_zones VALUES(8)") db.session.execute('INSERT INTO dhl_countries VALUES(8, \'ua\')') db.session.execute('INSERT INTO dhl_rates VALUES(8, 0.5, 44339)') db.session.execute('INSERT INTO dhl_rates VALUES(8, 10, 180919)') db.session.execute('INSERT INTO dhl_rates VALUES(8, 99999, 13975)')
def setUp(self): super().setUp() db.create_all() admin_role = Role(id=10, name='admin') self.try_add_entities([ User(username='******', email='*****@*****.**', password_hash='pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]), User(id=10, username='******', email='*****@*****.**', password_hash='pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True), admin_role, Country(id='c1', name='country1'), Currency(code='USD', rate=0.5), Product(id='SHIPPING', name='Shipping', weight=0, available=False, synchronize=False, separate_shipping=False, purchase=False) ])
def setUp(self): super().setUp() db.create_all() admin_role = Role(name='admin') self.user = User( username='******' + str(__name__), email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) self.admin = User( username='******' + str(__name__), email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True, roles=[admin_role]) self.try_add_entities([self.admin, self.user, admin_role])
def setUp(self): super().setUp() db.create_all() self.user = User( username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=True) self.try_add_entities([ self.user, User( username='******', email='*****@*****.**', password_hash= 'pbkdf2:sha256:150000$bwYY0rIO$320d11e791b3a0f1d0742038ceebf879b8182898cbefee7bf0e55b9c9e9e5576', enabled=False) ])
def reset_db(): db.drop_all() db.create_all()
def init_db(): db.drop_all() db.create_all()
def setUp(self): super().setUp() db.create_all()
def setUp(self): db.create_all()
def setUp(self): db.create_all() create_user(id=1) db.session.commit()