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()
