def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ('12345', salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() client_int = Clients(client_key= "altarest", client_secret=hash_pass, status="True", salt=salt) client_noint = Clients(client_key= "alul", client_secret=hash_pass, status="False", salt=salt) db.session.add(client_int) db.session.add(client_noint) db.session.commit() book = Books(title='Judul Buku', isbn="123-456-789", writer="Alul") db.session.add(book) db.session.commit() user = Users (name='Alul', age=23 , sex='Male' , client_id=1 ) db.session.add(user) db.session.commit() rent = Rent(book_id=1, user_id=1) db.session.add(rent) db.session.commit() yield db db.drop_all()
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("th1s1s1nt3n4lcl13nt", salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() salt2 = uuid.uuid4().hex encoded2 = ('%s%s' % ("alterra", salt2)).encode('utf-8') hash_pass2 = hashlib.sha512(encoded2).hexdigest() client_internal = Clients(client_key="internal", client_secret=hash_pass, status="True", salt=salt) client_noninternal = Clients(client_key="asa", client_secret=hash_pass2, status="False", salt=salt2) db.session.add(client_internal) db.session.add(client_noninternal) db.session.commit() user = Users(name="andre", age=23, sex="Female", weight= 97, height=167, food='olives') user1 = Users(name="andrey", age=50, sex="Male", weight= 200, height=100, food='olives') user2 = Users(name="andreyi", age=23, sex="Male", weight= 60, height=165, food='olives') db.session.add(user) db.session.add(user1) db.session.add(user2) db.session.commit() yield db
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("super_secret_client", salt)).encode('utf-8') hashpass = hashlib.sha512(encoded).hexdigest() encoded2 = ('%s%s' % ("alta123", salt)).encode('utf-8') hashpass2 = hashlib.sha512(encoded2).hexdigest() client_internal = Clients(client_key='internal', client_secret=hashpass, salt=salt, status="True") client_noninternal = Clients(client_key='client1', client_secret=hashpass2, salt=salt, status="False") db.session.add(client_internal) db.session.add(client_noninternal) db.session.commit() user = Users(client_id=1, name='client', age=11, sex='male') db.session.add(user) db.session.commit() yield db db.drop_all()
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("password", salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() user_required = Users(name="shofi", username="******", password=hash_pass, bio="ini shofi", pict_profile="ini pict", pict_bg="ini pict", salt=salt) # user_nonrequired = Users(name="noshofi", username="******", password=hash_pass, bio="ini shofi", pict_profile="ini pict", pict_bg="ini pict", salt=salt, status="false") db.session.add(user_required) # db.session.add(user_nonrequired) db.session.commit() follower = Followers(follower=6, user_id=1) tweet = Tweets(tweet="ini twit", user_id=1) # db.session.add(user) db.session.add(follower) db.session.add(tweet) db.session.commit() yield db
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("rahasia", salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() encoded2 = ('%s%s' % ('secret01', salt)).encode('utf-8') hash_pass2 = hashlib.sha512(encoded2).hexdigest() client_internal = Clients(client_key="internal", client_secret=hash_pass, status=True, salt=salt) client_non_internal = Clients(client_key="client01", client_secret=hash_pass2, status=False, salt=salt) db.session.add(client_internal) db.session.add(client_non_internal) db.session.commit() user = Users(name="andre", age=23, sex="male", client_id=1) db.session.add(user) db.session.commit()
def reset_db(): db.drop_all() db.create_all() password_1 = hashlib.md5("charisma".encode()).hexdigest() user1 = Users( 'fadzri', 'Charisma Fadzri Triprakoso', '*****@*****.**', password_1, 'jember', '085746363633', 'https://avatars3.githubusercontent.com/u/57993771?s=400&v=4') db.session.add(user1) db.session.commit() password_2 = hashlib.md5("wahyuni".encode()).hexdigest() user2 = Users( 'dwiwahyuni', 'Dwi Umi Wahyuni', '*****@*****.**', password_2, 'Tulungagung', '085749600262', 'https://pbs.twimg.com/profile_images/959677400928862208/4wfFlFCI.jpg') db.session.add(user2) db.session.commit() product1 = Products( "Banpresto Onepiece Stampede Movie", 3, 1000000, "Onepiece", "https://images-na.ssl-images-amazon.com/images/I/511GxF-3htL._SL1000_.jpg", "https://images-na.ssl-images-amazon.com/images/I/51z0wD77tGL._SL1000_.jpg", "https://images-na.ssl-images-amazon.com/images/I/51DdOvafhGL._SL1000_.jpg", "https://images-na.ssl-images-amazon.com/images/I/61Y%2BMTEJbNL._SL1000_.jpg", 1000, "Based on the One Piece: Stampede movie, Monkey D. Luffy joins the DXF series! This figure stands about 6 inches tall and is made of PVC and ABS." ) db.session.add(product1) db.session.commit()
def reset_db(): db.drop_all() db.create_all() user1 = Users("user1", hashlib.md5("Alta@123".encode()).hexdigest(), "*****@*****.**", "123") user2 = Users("user2", hashlib.md5("Alta@123".encode()).hexdigest(), "*****@*****.**", "456") user3 = Users("user3", hashlib.md5("Alta@123".encode()).hexdigest(), "*****@*****.**", "789") db.session.add(user1) db.session.add(user2) db.session.add(user3) db.session.commit() shop1 = Shops(user2.id) shop1.email = "*****@*****.**" shop1.name = "Shop 1" shop1.contact = "02199999" shop1.province = "Banten" shop1.city_type = "Kota" shop1.city_name = "Tangerang" shop1.postalcode = "15510" db.session.add(shop1) db.session.commit() product1 = Products(shop1.id, "lukisan", 50000, "Art", "Paint", "link", True, "", 1, 2000) product2 = Products(shop1.id, "lukisan2", 10000, "Art", "Paint", "link", False, "", 10, 2000) db.session.add(product1) db.session.add(product2) db.session.commit()
def init_database(): # create the database and the database table db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("password", salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() # insert user data client_internal = Clients(client_key="internal", client_secret=hash_pass, status="True", salt=salt) client_noninternal = Clients(client_key="noninternal", client_secret=hash_pass, status="False", salt=salt) db.session.add(client_internal) db.session.add(client_noninternal) db.session.commit() user = Users(name="andre", age=23, sex="male", client_id=1) book = Books(title="elektro", isbn=123456, writer="watt") db.session.add(user) db.session.add(book) db.session.commit() rent = Rent(book_id=1, user_id=1) db.session.add(rent) db.session.commit()
def init_database() : db.drop_all() db.create_all() strdata = 'rahasia0' strdata2 = 'rahasia1' salt = uuid.uuid4().hex hs = ('%s%s' % (strdata, salt)).encode('utf-8') clientsec = hashlib.sha512(hs).hexdigest() randstr = clientsec.encode('utf-8') client1 = Clients(status=1, client_secret=randstr, client_key=strdata, salt=salt, password=randstr) hs2 = ('%s%s' % (strdata2, salt)).encode('utf-8') clientsec2 = hashlib.sha512(hs2).hexdigest() randstr2 = clientsec2.encode('utf-8') client2 = Clients(status=0, client_secret=randstr2, client_key=strdata2, salt=salt, password=randstr2) db.session.add(client1) db.session.add(client2) db.session.commit()
def reset_database(): db.drop_all() db.create_all() admin = { 'user_name': 'admin', 'password': '******', 'alamat': 'jahgad', 'rekening': 'kjashad', 'hp': 'jdh', 'email': 'inga', 'foto': 'adhag' } user_1 = { 'user_name': 'alzimnae', 'password': '******', 'alamat': 'jahgad', 'rekening': 'kjashad', 'hp': 'jdh', 'email': 'inga', 'foto': 'adhag' } user_2 = { 'user_name': 'tabipo', 'password': '******', 'alamat': 'jahgad', 'rekening': 'kjashad', 'hp': 'jdh', 'email': 'inga', 'foto': 'adhag' } buku = { "user_id": 2, "user_name": "alzimnae", "judul": "Conan", "pengarang": "Aoyama Gosho", "penerbit": "Gramedia", "harga": 50000, "stok": 100, "url_picture": "https://upload.wikimedia.org/wikipedia/commons/7/77/Sherlock_Holmes_%26_Watson_-_The_Greek_Interpreter_-_Sidney_Paget.jpg", "deskripsi": "ngasal", "tipe": "komik" } admin = ListUser(admin) user_1 = ListUser(user_1) user_2 = ListUser(user_2) buku = DaftarBuku(buku) db.session.add(buku) db.session.add(admin) db.session.add(user_1) db.session.add(user_2) db.session.commit()
def reset_db(): db.drop_all() db.create_all() user1 = Users("user1", hashlib.md5("W@wew123".encode()).hexdigest()) user2 = Users("user2", hashlib.md5("W@wew123".encode()).hexdigest()) user3 = Users("user3", hashlib.md5("W@wew123".encode()).hexdigest()) user4 = Users("user4", hashlib.md5("W@wew123".encode()).hexdigest()) db.session.add(user1) db.session.add(user2) db.session.add(user3) db.session.add(user4) db.session.commit()
def init_database(): # db.drop.all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ('password', salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() user_internal = Users(full_name="Aisyah Putri Utami", email="*****@*****.**", password=hash_pass, avatar="", status=True, salt=salt) # user_internal = session.query(Users).filter(Users.email=="user_internal").one() # if user_internal is None: # user_internal = Users(full_name="Aisyah Putri Utami", email="*****@*****.**", password=hash_pass, avatar="", status=True, salt=salt) user_noninternal = Users(full_name="aaa", email="*****@*****.**", password=hash_pass, avatar="", status=True, salt=salt) db.session.add(user_internal) db.session.add(user_noninternal) db.session.commit() article = Articles( user_id=1, title="My Cat", text= "Hi, everyone! This is my first post in Medium. Above is my cat. Her name is Lollipop, because she is as sweet as a candy. She’s spoiled, yet so adorable.", image="", image_caption="This is my cat, Lollipop", topic=10, published=True, popular=True, top_article=False, editors_pick=False, ) db.session.add(article) db.session.commit() article_topic = ArticleTopics(topic="Hobbies") db.session.add(article_topic) db.session.commit() yield db db.drop_all()
def reset_db(): db.drop_all() db.create_all() Client=Users("Ub28f07794c710049e376239fe95e2d2s", "NN") db.session.add(Client) db.session.commit() Security=Admin(("Ub28f07794c710049e376239fe95e2d2s", "NN", "123456", None, None ) db.session.add(Security) db.session.commit() @pytest.fixture def client(request): return app.test_client(request) def create_token(isinternal=True): if isinternal: cachename='test-internal-token' data={ 'client_name':'admin', 'client_password':'******' } else: cachename= 'test-noninternal-token' data={ 'client_name':'non-admin', 'client_password':'******' } token=cache.get(cachename) if token is None: req=app.test_client(request) res=req.get('/login', query_string=data ) res_json=json.loads(res.data) logging.warning('RESULT: %s', res_json) if res.status_code==200: assert res.status_code==200 cache.set(cachename, res_json['token'], timeout=60) return res_json['token'] else: pass else: return token
def reset_database(): db.drop_all() db.create_all() # create test non-admin user user = UserModel("agathar", "iopklm", "jl joko kandung 136", 0, "08953797508") penjual = UserModel("tania", "weqryqa", "jl. cisitu indah baru no. 6", 1, "087615729131") # save users to database db.session.add(user) db.session.add(penjual) db.session.commit()
def reset_db(): db.drop_all() db.create_all() secret = hashlib.md5('FIRST01'.encode()).hexdigest() client = Clients(key='NUMBER01', secret=secret, status=True) db.session.add(client) db.session.commit() user = Users(name='Akira', age=26, sex='Male', client_id=1) db.session.add(user) db.session.commit() book = Books(title='Book01', isbn='123-456-789', writer='Unknown') db.session.add(book) db.session.commit()
def reset_database(): db.drop_all() db.create_all() pembeli = Pembeli("Kuntet", 'kunt', "082283511672","*****@*****.**","agh765vx765", True) # barang = Barang("TOYOTA X8", "TOYOTA", "MAHAL", "7200000", "raden", "2017", "ohyeah") # create test non-admin user keranjang = Keranjang("1", "1", "toyota", "kun", "kuntet", "4500000", "faking") # save users to database db.session.add(pembeli) db.session.commit()
def init_database(): # create the database and the database table db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("password", salt)).encode('utf-8') hash_pass = hashlib.sha512(encoded).hexdigest() user_internal1 = Users(username='******', phone_number='085735950340', password=hash_pass, salt=salt, status_internal=True) user_internal2 = Users(username='******', phone_number='085735950342', password=hash_pass, salt=salt, status_internal=True) user_noninternal = Users(username='******', phone_number='085735950341', password=hash_pass, salt=salt, status_internal=False) conversation = Conversations(1, 2) message_group = MessageGroup(1, 1, 'halo') list_group = ListGroup('KITT') member_group = MemberGroup(1, 1) personal_message = PersonalMessages(1, 1, 'tes') status = StatusWA(1, 'status', 'gambar.jpg') db.session.add(user_internal1) db.session.add(user_internal2) db.session.add(user_noninternal) db.session.commit() db.session.add(list_group) db.session.commit() db.session.add(member_group) db.session.commit() db.session.add(message_group) db.session.commit() db.session.add(conversation) db.session.commit() db.session.add(personal_message) db.session.commit() db.session.add(status) db.session.commit() yield db db.drop_all()
def db_reset(): db.drop_all() db.create_all() password_1 = hashlib.md5("l3l11234".encode()).hexdigest() user1 = User('Lelianto', '*****@*****.**', password_1, 'None', 'None', 'None', 'None') db.session.add(user1) db.session.commit() password_2 = hashlib.md5("l3l1123456".encode()).hexdigest() user2 = User('Lelianto', '*****@*****.**', password_2, 'None', 'None', 'None', 'None') db.session.add(user2) db.session.commit()
def reset_database(): db.drop_all() db.create_all() admin = Admins("tes", "tes", "*****@*****.**") client = Clients("tes", "tes", "*****@*****.**") # client_detail = ClientDetails(1, "fullname", "081208520813", "address") product = Products("name", "description", "category", "image", 10000, 10, 9000, 20) # save users to database db.session.add(admin) db.session.add(client) # db.session.add(client_detail) db.session.add(product) db.session.commit()
def reset_database(): db.drop_all() db.create_all() buyer_client = Clients('buyer_1', 'buyer1', 0) seller_client = Clients('seller_2', 'seller2', 1) buyer = BuyerDetails('Buyer 1', '*****@*****.**', '081buyer1', 'alamat 1', '40611', 1) seller = SellerDetails('Seller 1', 'Store 1', '*****@*****.**', '081seller1', 'alamat 2', '40612', 2) product_category1 = ProductCategory('mainan anak', 'semua mainan anak') product_category2 = ProductCategory('perlengkapan anak', 'semua perlengkapan anak') product_category3 = ProductCategory('baju anak', 'semua baju anak') product1 = Product(1, 'Store 1', 'mainan 1', 1, 'description', 1000, 'image', 50, 0) product2 = Product(1, 'Store 1', 'perlengkapan 1', 1, 'description', 1000, 'image', 50, 0) product3 = Product(1, 'Store 1', 'baju 1', 1, 'description', 1000, 'image', 50, 0) # admin = UserModel("admin-tria", bcrypt.generate_password_hash("triapass"), "0986463", "Balikpapan", "admin") # create test non-admin user # save users to database db.session.add(buyer_client) db.session.add(seller_client) db.session.commit() db.session.add(buyer) db.session.add(seller) db.session.commit() db.session.add(product_category1) db.session.add(product_category2) db.session.add(product_category3) db.session.commit() db.session.add(product1) db.session.add(product2) db.session.add(product3) db.session.commit()
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("admin", salt)).encode('utf-8') hashpass = hashlib.sha512(encoded).hexdigest() encoded2 = ('%s%s' % ("alta123", salt)).encode('utf-8') hashpass2 = hashlib.sha512(encoded2).hexdigest() client_internal = Clients(username='******', password=hashpass, salt=salt, status=True) client_noninternal = Clients(username='******', password=hashpass2, salt=salt, status=False) db.session.add(client_internal) db.session.add(client_noninternal) db.session.commit() category = Categories(imgURL="google.com", name='Makanan') db.session.add(category) db.session.commit() subcategory = SubCategories(name="makanan", category_id=1) db.session.add(subcategory) db.session.commit() product = Products(seller_id=1, category_id=1, subcategory_id=1, url_image="google.com", name="makan", price=10, stock=12, promo="Ya") db.session.add(product) db.session.commit() yield db db.drop_all()
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encode = ('%s%s' % ('password', salt)).encode('utf-8') hash_pass = hashlib.sha512(encode).hexdigest() user = Users(username="******", password=hash_pass, status="user", salt=salt, name="yopi ragil", email="*****@*****.**", no_hp="0812333333", alamat="jombang", avatar="test") usernonInternal = Users(username="******", password=hash_pass, status="admin", salt=salt, name="ragil permana", email="*****@*****.**", no_hp="0812444444", alamat="Malang", avatar="testing") db.session.add(user) db.session.add(usernonInternal) db.session.commit() order = Orders( penjual_id=1, nama_pembeli="Joni", alamat_pembeli="Jl. Tidar, Malang", produk_dipesan="Sikat gigi", harga=10000, status="dikirim", kode_resi="25367718", ) db.session.add(order) db.session.commit() yield db db.drop_all()
def init_database(): db.drop_all() db.create_all() salt = uuid.uuid4().hex encoded = ('%s%s' % ("alta123", salt)).encode('utf-8') hashpass = hashlib.sha512(encoded).hexdigest() encoded2 = ('%s%s' % ("alta123", salt)).encode('utf-8') hashpass2 = hashlib.sha512(encoded2).hexdigest() user_internal = Users(username='******', password=hashpass, email='*****@*****.**', phone='0829718268162', status=True, salt=salt) user_noninternal = Users(username='******', password=hashpass2, email='*****@*****.**', phone='082971868162', status=False, salt=salt) db.session.add(user_internal) db.session.add(user_noninternal) tag = Tags(name='Funny', img_url='facebook.com') db.session.add(tag) db.session.commit() image = Images(img_title='kadal', img_url='facebook.com', deskripsi='aaaa', user_id=1, tag_id=1) db.session.add(image) db.session.commit() komen = Komens(komen='asasa', user_id=1, image_id=1) db.session.add(komen) db.session.commit() yield db db.drop_all()
def reset_db(): db.drop_all() db.create_all() password = hashlib.md5('Hedyy1'.encode()).hexdigest() user = Users('TEST', password, "hahaha", "hehe", "alamat", 12345, "user") user.image = "lian" db.session.add(user) user = Users('TEST1', password, "hahaha", "hehe", "alamat", 12345, "user") db.session.add(user) agent = Users("Agent", password,"hahaha", "hehe", "alamat", 12345, "agent") agent.image = "bambamb" db.session.add(agent) agent = Users("Agent1", password,"hahaha", "hehe", "alamat", 12345, "agent") db.session.add(agent) seller= Sellers("seller",password,"kuda","ok","ok","ok", 1234,"seller") db.session.add(seller) db.session.commit() product = Products(seller.id,"makanan","makanan",70,100,"wrap",3,True,"sweet") db.session.add(product) db.session.commit()
def reset_db(): db.drop_all() db.create_all() client = Costumers( "admin", "woka", 'Yudi', '098765678', '*****@*****.**', 23, ) db.session.add(client) db.session.commit() hiden = hashlib.md5('non-woka'.encode()).hexdigest() client = Costumers("non-admin", hiden, 'Bambang', '098765678', '*****@*****.**', 23) db.session.add(client) db.session.commit()
def reset_database(): db.drop_all() db.create_all() nama = ['aul', 'syamsul', 'raden', 'yovan', 'dummy'] email = '*****@*****.**' status_penjual = [False, True, True, True, False] rating = [8, 8, 8, 8, 8] saldo = [0, 100000, 200000, 250000, 20000] password = '******' for i in range(len(nama)): user = User(nama[i], password, email, status_penjual[i], rating[i], saldo[i]) db.session.add(user) db.session.commit() nama_barang = [ 'baju', 'sepatu', 'kulkas', 'bola', 'raket', 'jam tangan', 'barang kosong' ] id_pemilik = [2, 3, 4, 2, 3, 4, 2] harga_satuan = [1000, 3000, 7000, 2000, 6000, 100000, 1000] qty = [100, 3, 1, 3, 2, 1, 0] rating_penjual = 8 url = [ 'https://m.media-amazon.com/images/I/A13usaonutL._CLa%7C2140,2000%7C61hLBkLke6L.png%7C0,0,2140,2000+0.0,0.0,2140.0,2000.0._UX342_.png', 'https://www.static-src.com/wcsstore/Indraprastha/images/catalog/medium//93/MTA-2945316/nike_nike-air-more-uptempo-supreme-sepatu-sneakers-pria---red-white_full05.jpg', 'http://sinarberlianelektronik.com/wp-content/uploads/2016/09/Kulkas-SHARP-SJ-421KP_ADJ.png', 'https://cdn2.tstatic.net/pekanbaru/foto/bank/images/ilustrasi_sepak_bola_sepakbolajpg_20170724_121315.jpg', 'https://www.4muda.com/wp-content/uploads/2015/08/raket-bulutangkis-wilson-1.jpg', 'https://www.jakartanotebook.com/images/products/77/63/28045/2/jam-tangan-wanita-unique-dial-black-13.jpg', '' ] deleted_status = False for i in range(len(nama_barang)): barang = Barang(nama_barang[i], id_pemilik[i], harga_satuan[i], qty[i], url[i]) db.session.add(barang) db.session.commit()
def reset_db(): db.drop_all() db.create_all() password = hashlib.md5("rahasia123".encode()).hexdigest() user = User("Mohammad Daffa", "*****@*****.**", "Fadafuq", password) db.session.add(user) db.session.commit() toko = Toko(1, "Test1", "Deskripsi toko test1", "Fadafuq") db.session.add(toko) db.session.commit() user = User.query.get(1) user.designer_status = True db.session.commit() barang = Barang( 1, "Barang1", "Rp. 150000", 150000, "Deskripsi barang1", "Combed 30s", "https://s0.bukalapak.com/img/0347408453/w-1000/Kaos_Indonesia_Baju_Distro_Timnas_Lambang_Gambar_Timnas_Garu.jpg" ) db.session.add(barang) db.session.commit() user = User("Saipul Zuhair", "*****@*****.**", "PigeonHole", password) db.session.add(user) db.session.commit() keranjang = Keranjang(1, "Barang1", 150000, "Rp. 150000", 1, 1, "XL") db.session.add(keranjang) db.session.commit() user = User("Bukan Dobleh", "*****@*****.**", "bukanDobleh", password) db.session.add(user) db.session.commit() toko = Toko(3, "Test2", "Deskripsi toko test2", "bukanDobleh") db.session.add(toko) db.session.commit() barang = Barang( 2, "Barang2", "Rp. 150000", 150000, "Deskripsi barang2", "Combed 30s", "https://s0.bukalapak.com/img/0347408453/w-1000/Kaos_Indonesia_Baju_Distro_Timnas_Lambang_Gambar_Timnas_Garu.jpg" ) db.session.add(barang) db.session.commit()
def resetDatabase(): db.drop_all() db.create_all() passwordHashed = hashlib.md5("Password1".encode()).hexdigest() recipe = Recipes(1, "name", 1, 1, "beanName", "beanProcess", "beanRoasting", 1, 1, 1, 1) recipe2 = Recipes(2, "name", 1, 1, "beanName", "beanProcess", "beanRoasting", 1, 1, 1, 1) user2 = Users("*****@*****.**", passwordHashed, "name", "photo", "bio") user = Users("*****@*****.**", passwordHashed, "name", "photo", "bio") admin = Users("*****@*****.**", passwordHashed, "name", "photo", "bio") step = Steps(1, 1, 1, "note", 1, 1) step2 = Steps(2, 1, 1, "note", 1, 1) recipeDetail = RecipeDetails(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, "note", 2, 92) recipeDetail2 = RecipeDetails(2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, "note", 2, 92) bean = Beans(5, "nama11", "photo11", 0.4, 0.2, 0.7, 0.1, 0.8, 0.3, 0.5, 0.2, 0.45, 0.5, "deskripsi", "cupping", "advatage", "disadvantage", "lokasi") # save users to database db.session.add(recipe) db.session.add(recipe2) db.session.add(recipeDetail) db.session.add(recipeDetail2) db.session.add(user2) db.session.add(user) db.session.add(admin) admin.role = 1 db.session.add(step) db.session.add(step2) db.session.add(bean) db.session.commit()
def db_reset(): db.drop_all() db.create_all() # ---------- Create Users ---------- # User 1 encrypted_1 = hashlib.md5('Hedygading1'.encode()).hexdigest() user_1 = Users(email='*****@*****.**', password=encrypted_1) db.session.add(user_1) db.session.commit() # User 2 encrypted_2 = hashlib.md5('Garryac1'.encode()).hexdigest() user_2 = Users(email='*****@*****.**', password=encrypted_2) db.session.add(user_2) db.session.commit() # ---------- Create Outlets ---------- outlet_1 = Outlets(id_user=1, name='Surabaya', phone_number='089145672345', address='Jl. Tidar No. 25', tax=10, city='Surabaya') db.session.add(outlet_1) db.session.commit() outlet_2 = Outlets(id_user=1, name='Malang', phone_number='089245572345', address='Jl. Semeru No. 31', tax=10, city='Malang') db.session.add(outlet_2) db.session.commit() outlet_3 = Outlets(id_user=1, name='Jakarta', phone_number='089245571758', address='Jl. Merbabu No. 42', tax=15, city='Jakarta') db.session.add(outlet_3) db.session.commit() # ---------- Create Cashier ---------- encrypted_4 = hashlib.md5('Budisetiawan1'.encode()).hexdigest() cashier_1 = Employees(id_outlet=1, full_name='Budi Setiawan', username='******', password=encrypted_4, position='Kasir') db.session.add(cashier_1) db.session.commit() encrypted = hashlib.md5('Cashierpass'.encode()).hexdigest() cashier_2 = Employees(id_outlet=1, full_name='Cashier02', username='******', password=encrypted, position='Kasir') db.session.add(cashier_2) db.session.commit() encrypted = hashlib.md5('Cashierpass'.encode()).hexdigest() cashier_3 = Employees(id_outlet=1, full_name='Cashier03', username='******', password=encrypted, position='Kasir') db.session.add(cashier_3) db.session.commit() encrypted = hashlib.md5('Cashierpass'.encode()).hexdigest() cashier_4 = Employees(id_outlet=1, full_name='Cashier04', username='******', password=encrypted, position='Kasir') db.session.add(cashier_4) db.session.commit() encrypted = hashlib.md5('Cashierpass'.encode()).hexdigest() cashier_5 = Employees(id_outlet=1, full_name='Cashier05', username='******', password=encrypted, position='Kasir') db.session.add(cashier_5) db.session.commit() # ---------- Create Admin ---------- encrypted_5 = hashlib.md5('Stevejobs1'.encode()).hexdigest() admin_1 = Employees(id_outlet=1, full_name='Steve Jobs', username='******', password=encrypted_5, position='Admin') db.session.add(admin_1) db.session.commit() encrypted_admin = hashlib.md5('Adminpass'.encode()).hexdigest() admin_2 = Employees(id_outlet=1, full_name='AdminPass02', username='******', password=encrypted_admin, position='Admin') db.session.add(admin_2) db.session.commit() encrypted_admin = hashlib.md5('Adminpass'.encode()).hexdigest() admin_3 = Employees(id_outlet=1, full_name='AdminPass03', username='******', password=encrypted_admin, position='Admin') db.session.add(admin_3) db.session.commit() encrypted_admin = hashlib.md5('Adminpass'.encode()).hexdigest() admin_4 = Employees(id_outlet=1, full_name='AdminPass04', username='******', password=encrypted_admin, position='Admin') db.session.add(admin_4) db.session.commit() encrypted_admin = hashlib.md5('Adminpass'.encode()).hexdigest() admin_5 = Employees(id_outlet=1, full_name='AdminPass05', username='******', password=encrypted_admin, position='Admin') db.session.add(admin_5) db.session.commit() # ---------- Create Customer ---------- customer_1 = Customers(id_users=1, fullname='Buzz Lightyear', phone_number='089514145654', email='*****@*****.**') db.session.add(customer_1) db.session.commit() customer_2 = Customers(id_users=1, fullname='Tsubasa Ozora', phone_number='089514145657', email='') db.session.add(customer_2) db.session.commit() # ---------- Create Product ---------- product_1 = Products(id_users=1, name='Indomie Goreng', category='Indomie', price=12000, image='http://dummy.jpg', show=True) db.session.add(product_1) db.session.commit() product_2 = Products(id_users=1, name='Indomie Kaldu Ayam', category='Indomie', price=15000, image='http://dummy.jpg', show=True) db.session.add(product_2) db.session.commit() product_3 = Products(id_users=1, name='Indomie Ayam Geprek', category='Indomie', price=12000, image='http://dummy.jpg', show=True) db.session.add(product_3) db.session.commit() product_4 = Products(id_users=1, name='Indomie Cabe Hijau', category='Indomie', price=12000, image='http://dummy.jpg', show=False) db.session.add(product_4) db.session.commit() product_5 = Products(id_users=1, name='Mie Ayam Biasa', category='Mie Ayam', price=10000, image='http://dummy.jpg', show=True) db.session.add(product_5) db.session.commit() product_6 = Products(id_users=1, name='Mie Ayam Bawang', category='Mie Ayam', price=15000, image='http://dummy.jpg', show=True) db.session.add(product_6) db.session.commit() product_7 = Products(id_users=1, name='Mie Ayam Bakso', category='Mie Ayam', price=18000, image='http://dummy.jpg', show=False) db.session.add(product_7) db.session.commit() # ---------- Create Inventory ---------- inventory_1 = Inventories(id_users=1, name='Mie', total_stock=10000, unit='gram', unit_price=0, times_edited=0) db.session.add(inventory_1) db.session.commit() inventory_2 = Inventories(id_users=1, name='Garam', total_stock=800, unit='gram', unit_price=0, times_edited=0) db.session.add(inventory_2) db.session.commit() inventory_3 = Inventories(id_users=1, name='Daun Bawang', total_stock=285, unit='gram', unit_price=0, times_edited=0) db.session.add(inventory_3) db.session.commit() inventory_4 = Inventories(id_users=1, name='Cabe Hijau', total_stock=700, unit='gram', unit_price=0, times_edited=0) db.session.add(inventory_4) db.session.commit() inventory_5 = Inventories(id_users=1, name='Ayam', total_stock=2000, unit='gram', unit_price=0, times_edited=0) db.session.add(inventory_5) db.session.commit() inventory_6 = Inventories(id_users=1, name='Indomie Goreng', total_stock=30, unit='pcs', unit_price=0, times_edited=0) db.session.add(inventory_6) db.session.commit() inventory_7 = Inventories(id_users=1, name='Indomie Kaldu Ayam', total_stock=30, unit='pcs', unit_price=0, times_edited=0) db.session.add(inventory_7) db.session.commit() # ---------- Create Recipe ---------- recipe_1 = Recipe(id_inventory=6, id_product=1, amount=1) db.session.add(recipe_1) db.session.commit() recipe_2 = Recipe(id_inventory=3, id_product=1, amount=50) db.session.add(recipe_2) db.session.commit() recipe_3 = Recipe(id_inventory=7, id_product=2, amount=1) db.session.add(recipe_3) db.session.commit() recipe_4 = Recipe(id_inventory=3, id_product=2, amount=50) db.session.add(recipe_4) db.session.commit() recipe_5 = Recipe(id_inventory=1, id_product=5, amount=120) db.session.add(recipe_5) db.session.commit() recipe_6 = Recipe(id_inventory=2, id_product=5, amount=20) db.session.add(recipe_6) db.session.commit() recipe_7 = Recipe(id_inventory=3, id_product=5, amount=50) db.session.add(recipe_7) db.session.commit() recipe_8 = Recipe(id_inventory=4, id_product=5, amount=50) db.session.add(recipe_8) db.session.commit() recipe_9 = Recipe(id_inventory=5, id_product=5, amount=50) db.session.add(recipe_9) db.session.commit() # ---------- Create Stock Outlet ---------- stock_outlet_1 = StockOutlet(id_outlet=1, id_inventory=1, reminder=500, stock=3000) db.session.add(stock_outlet_1) db.session.commit() stock_outlet_2 = StockOutlet(id_outlet=2, id_inventory=1, reminder=1000, stock=4000) db.session.add(stock_outlet_2) db.session.commit() stock_outlet_3 = StockOutlet(id_outlet=3, id_inventory=1, reminder=700, stock=3000) db.session.add(stock_outlet_3) db.session.commit() stock_outlet_4 = StockOutlet(id_outlet=1, id_inventory=2, reminder=50, stock=300) db.session.add(stock_outlet_4) db.session.commit() stock_outlet_5 = StockOutlet(id_outlet=2, id_inventory=2, reminder=100, stock=500) db.session.add(stock_outlet_5) db.session.commit() stock_outlet_6 = StockOutlet(id_outlet=1, id_inventory=3, reminder=300, stock=285) db.session.add(stock_outlet_6) db.session.commit() stock_outlet_7 = StockOutlet(id_outlet=1, id_inventory=4, reminder=1000, stock=700) db.session.add(stock_outlet_7) db.session.commit() stock_outlet_8 = StockOutlet(id_outlet=1, id_inventory=5, reminder=500, stock=3000) db.session.add(stock_outlet_8) db.session.commit() stock_outlet_9 = StockOutlet(id_outlet=1, id_inventory=6, reminder=10, stock=30) db.session.add(stock_outlet_9) db.session.commit() stock_outlet_10 = StockOutlet(id_outlet=1, id_inventory=7, reminder=10, stock=30) db.session.add(stock_outlet_10) db.session.commit() # ---------- Create Cart ---------- cart_1 = Carts(id_users=1, id_outlet=1, id_employee=1, order_code='A32BC1', name='Lelianto Eko Pradana', total_item=1, payment_method='Tunai', total_payment=12000, total_discount=0, total_tax=1200, paid_price=15000) db.session.add(cart_1) db.session.commit() cart_2 = Carts(id_users=1, id_outlet=1, order_code='A32BC2', name='Willy Sumarno', total_item=1, payment_method='Tunai', total_payment=12000, total_discount=0, total_tax=1200, paid_price=15000) db.session.add(cart_2) db.session.commit() cart_3 = Carts(id_users=1, id_outlet=1, id_customers=1, order_code='A52BCX', name='Buzz Lightyear', total_item=2, payment_method='Kartu', total_payment=12000, total_discount=0, total_tax=1200, paid_price=27000) db.session.add(cart_3) db.session.commit() cart_4 = Carts(id_users=1, id_outlet=1, id_customers=1, order_code='A52BCY', name='Buzz Lightyear', total_item=3, payment_method='Tunai', total_payment=37000, total_discount=0, total_tax=3700, paid_price=45000) db.session.add(cart_4) db.session.commit() cart_5 = Carts(id_users=1, id_outlet=1, id_customers=1, order_code='A62BCY', name='Buzz Lightyear', total_item=1, payment_method='Tunai', total_payment=24000, total_discount=0, total_tax=2400, paid_price=50000) db.session.add(cart_5) db.session.commit() # ---------- Create Cart Detail ---------- cart_detail_1 = CartDetail(id_cart=1, id_product=1, quantity=1, total_price_product=10000) db.session.add(cart_detail_1) db.session.commit() cart_detail_2 = CartDetail(id_cart=2, id_product=1, quantity=1, total_price_product=10000) db.session.add(cart_detail_1) db.session.commit() cart_detail_3 = CartDetail(id_cart=3, id_product=1, quantity=1, total_price_product=12000) db.session.add(cart_detail_3) db.session.commit() cart_detail_4 = CartDetail(id_cart=3, id_product=6, quantity=1, total_price_product=15000) db.session.add(cart_detail_4) db.session.commit() cart_detail_5 = CartDetail(id_cart=4, id_product=1, quantity=1, total_price_product=12000) db.session.add(cart_detail_5) db.session.commit() cart_detail_6 = CartDetail(id_cart=4, id_product=2, quantity=1, total_price_product=15000) db.session.add(cart_detail_6) db.session.commit() cart_detail_7 = CartDetail(id_cart=4, id_product=5, quantity=1, total_price_product=10000) db.session.add(cart_detail_7) db.session.commit() cart_detail_8 = CartDetail(id_cart=5, id_product=1, quantity=2, total_price_product=24000) db.session.add(cart_detail_8) db.session.commit()
def reset_db(): db.drop_all() db.create_all() daerah = Daerah("Kabupaten Bandung Barat") db.session.add(daerah) db.session.commit() officer = Officer("P2001", "d54d1702ad0f8326224b817c796763c9", "officer1", "officer", 1) surveyor = Officer("P2002", "d54d1702ad0f8326224b817c796763c9", "surveyor1", "surveyor", 1) payer = Payer("P1002", "d54d1702ad0f8326224b817c796763c9", "payer1", 1, "Warung Pecel Ayam", "Jalan Galunggung") db.session.add(officer) db.session.add(surveyor) db.session.add(payer) db.session.commit() objek_pajak1 = ObjekPajak( 1, '1001', 'Iklan Perumahan', 'Harga mulai dari 300 juta', 'Reklame Non Permanen', 'Spanduk, Umbul-umbul, Banner, Layar Toko', 'https://sribu-sg.s3.amazonaws.com/assets/media/contest_detail/2016/11/desain-banner-untuk-center-park-5839ad95faaa266f0000a583/normal_d432e6fb30.jpg', 1, 2, 3, 3, '2020-01-15 14:29:36', '2020-01-25 14:29:36', 'Januari 2020', '112.609817', '-7.965917', 'Jalan Tidar, Malang', 1, 2, 'Non Rokok/Miras', 'Kawasan Umum', 'Jalan Kabupaten', '1 arah', 'Mingguan') objek_pajak2 = ObjekPajak( 1, '1002', 'Iklan Konser', 'Konser Akbar Raisa', 'Reklame Permanen', 'Billboard/Bando', 'https://sribu-sg.s3.amazonaws.com/assets/media/contest_detail/2016/11/desain-banner-untuk-center-park-5839ad95faaa266f0000a583/normal_d432e6fb30.jpg', 1, 2, 3, 2, '2020-01-15 14:29:36', '2020-01-25 14:29:36', 'Februari 2020', '112.6237303', '-7.97509837', 'Jalan Tenes, Malang', 1, 2, 'Non Rokok/Miras', 'Kawasan Umum', 'Jalan Kabupaten', '1 arah', 'Tahunan') db.session.add(objek_pajak1) db.session.add(objek_pajak2) db.session.commit() laporan1 = Laporan(1, '5001', 60000, 240000, 87500, 50000, 0, 0, 28000, 14000, 28000, 387500, 415500, 0.25, 207750, 1) laporan2 = Laporan(2, '5002', 60000, 240000, 87500, 50000, 0, 0, 28000, 14000, 28000, 387500, 415500, 0.25, 207750, 1) db.session.add(laporan1) db.session.add(laporan2) db.session.commit() bukti_pembayaran1 = BuktiPembayaran(1, 1, 9001, 3) bukti_pembayaran2 = BuktiPembayaran(2, 1, 9002, 2) db.session.add(bukti_pembayaran1) db.session.add(bukti_pembayaran2) bukti_pembayaran2.status_buat_kode_qr = True db.session.commit() kode_qr1 = KodeQR( 1, 'alterratax123451', 'https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=alterratax123451' ) kode_qr2 = KodeQR( 1, 'alterratax123452', 'https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=alterratax123452' ) kode_qr3 = KodeQR( 1, 'alterratax123453', 'https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=alterratax123453' ) db.session.add(kode_qr1) db.session.add(kode_qr2) db.session.add(kode_qr3) kode_qr1.status_scan = True db.session.commit() variabel1 = VariabelPerhitungan('Tarif Pajak Reklame', '', 'TPR', 0.25) variabel2 = VariabelPerhitungan('Non Rokok/Miras', 'TTM', 'TTNR', 0) variabel3 = VariabelPerhitungan('Rokok/Miras', 'TTM', 'TTR', 0.25) variabel4 = VariabelPerhitungan('Reklame Permanen', 'JR', 'JR-RP', 0) variabel5 = VariabelPerhitungan('Billboard/Bando', 'JR-RP', 'JR-RP-B', 0) variabel6 = VariabelPerhitungan('Reklame Non Permanen', 'JR', 'JR-RNP', 0) variabel7 = VariabelPerhitungan('Spanduk, Umbul-umbul, Banner, Layar Toko', 'JR-RNP', 'JR-RNP-KS', 0) variabel8 = VariabelPerhitungan('HDUR Billboard/Bando < 10m2', 'HDUR', 'HDUR-JR-RP-B-0', 525000) variabel9 = VariabelPerhitungan('HDUR Billboard/Bando 10-50m2', 'HDUR', 'HDUR-JR-RP-B-10', 800000) variabel10 = VariabelPerhitungan('HDUR Billboard/Bando > 50m2', 'HDUR', 'HDUR-JR-RP-B-50', 1200000) variabel11 = VariabelPerhitungan( 'HDUR Spanduk, Umbul-umbul, Banner, Layar Toko', 'HDUR', 'HDUR-JR-RNP-KS', 14000) variabel12 = VariabelPerhitungan('HDKR Billboard/Bando', 'HDKR', 'HDKR-JR-RP-B', 75000) variabel13 = VariabelPerhitungan( 'HDKR Spanduk, Umbul-umbul, Banner, Layar Toko', 'HDKR', 'HDKR-JR-RNP-KS', 0) variabel14 = VariabelPerhitungan('HDNS Reklame Permanen - Luas - 0-3m2', 'HDNSPR', 'HDNS-JR-RP-0', 220000) variabel15 = VariabelPerhitungan('HDNS Reklame Permanen - Luas - 3-3,99m2', 'HDNSPR', 'HDNS-JR-RP-3', 450000) variabel16 = VariabelPerhitungan('HDNS Reklame Permanen - Luas - 10-50m2', 'HDNSPR', 'HDNS-JR-RP-10', 527000) variabel17 = VariabelPerhitungan('HDNS Reklame Permanen - Luas - >50m2', 'HDNSPR', 'HDNS-JR-RP-50', 1000000) variabel18 = VariabelPerhitungan( 'HDNS Reklame Spanduk, Umbul-umbul, Banner, Layar Toko', 'HDNSPR', 'HDNS-JR-RNP-KS', 50000) variabel19 = VariabelPerhitungan('Kawasan Khusus', 'FR', 'FRKK', 6) variabel20 = VariabelPerhitungan('Kawasan Umum', 'FR', 'FRKU', 4.8) variabel21 = VariabelPerhitungan('Jalan Kabupaten', 'FJ', 'FJJK', 1.2) variabel22 = VariabelPerhitungan('1 arah', 'FSP', 'FSP1', 1.75) db.session.add(variabel1) db.session.add(variabel2) db.session.add(variabel3) db.session.add(variabel4) db.session.add(variabel5) db.session.add(variabel6) db.session.add(variabel7) db.session.add(variabel8) db.session.add(variabel9) db.session.add(variabel10) db.session.add(variabel11) db.session.add(variabel12) db.session.add(variabel13) db.session.add(variabel14) db.session.add(variabel15) db.session.add(variabel16) db.session.add(variabel17) db.session.add(variabel18) db.session.add(variabel19) db.session.add(variabel20) db.session.add(variabel21) db.session.add(variabel22) db.session.commit()