import sqlite3
import colorama
con = sqlite3.connect('sifreler.db')
im =con.cursor()
a=True
while(a):
islem = input(colorama.Fore.RED + "islem secin\n 1 kayit olma \n 2 giris yapma\n 3 kayit silme\n 4 cikis\n :")
if(islem=='1'):
print(colorama.Fore.GREEN + "kayit olma\n")
site =input( "lutfen sitenin adini girin:")
kullaniciadi =input("lutfen kullanici adini girin:")
sifre =input("lutfen sifreyi girin:")
sql="INSERT INTO veriler(site,kullaniciadi,sifre) VALUES('" + site + "','"+ kullaniciadi+"','"+sifre+"');"
im.execute(sql)
con.commit()
elif(islem=='2'):
print(colorama.Fore.GREEN + "giris yapma\n")
im.execute("SELECT * FROM veriler")
veriler = im.fetchall()
for satir in veriler:
print(colorama.Fore.WHITE + str(satir[0]) + ") " +satir[1])
secim2 = input("lutfen almak istediginiz numarayi girin:")
sql2=veriler[int(secim2)]
print(" id:" + str(sql2[0]) + " site:" + str(sql2[1]) + " kullanici adi:" + str(sql2[2]) + " sifre:" + str(sql2[3]))
con.commit()
elif(islem=='3'):
print(colorama.Fore.GREEN + "kayit silme\n")
im.execute("SELECT * FROM veriler")
veriler = im.fetchall()
for satir in veriler:
print(colorama.Fore.WHITE + str(satir[0]) + ") " +satir[1])
secim3 = input("lutfen silmek istediginiz numarayi girin:")
im.execute("Delete From veriler where id = ?",(secim3))
con.commit()
elif(islem=='4'):
print(colorama.Fore.GREEN + "cikis")
a=False