'''
==================================
# PRENSENSI SETIAP BUKA TERMINAL #
==================================
# Require this package
sudo apt install python3-pymysql

# to run script every start terminal(bash)
sudo echo "python3 absen.py" >> .bashrc

#don't forget to add your own database
'''



import os
import pymysql
import datetime
import sys
import time

#tampilan welcome
os.system("printf 'Welcome, Jati \nhave a great day! \n'; fortune | cowsay -f turtle ")

# membuat timestamp
ts = time.time()
st = datetime.datetime.fromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')

#membuat koneksi
conn = pymysql.connect(host='localhost',user='root', password='password',db='absensi')
x = conn.cursor()

#membuat input
absen = input('Mau absen?(B,P) ')


#ekseskusi based input
if absen == 'B' or absen == 'b':
	try:
   		x.execute("INSERT INTO absen(berangkat) VALUES (%s)",(st,))
   		conn.commit()
   		print("anda berhasil absen berangkat di : ",st)
	except:
   		conn.rollback()
elif absen == 'P' or absen == 'p':
	try:
   		x.execute("INSERT INTO absen(pulang) VALUES (%s)",(st,))
   		conn.commit()
   		print("anda berhasil absen pulang di : ",st)
	except:
   		conn.rollback()
else:
	sys.exit()

#close koneksi
conn.close()