CRUDGENERATOR

import mysql.connector #MEMANGGIL MODUL mysql-connector
import os #MEMANGGIL MODUL os

os.system("clear")#MEMBERSIHKAN LAYAR
#replace karakter underscore dengan spasi
intab="_"
outtab=" "
trantab=str.maketrans(intab,outtab)

print("CRUD GENERATOR".center(49,"="))#TITLE
print("\n*Pastikan MySql Server sudah berjalan\n")

#MEMBUAT FILE FORM INPUT
print ("Membuat file Form Input")
laci=input("Disimpan dimana? ")
berkas=input("Nama script: ")
f= open(laci+berkas+".py","w+")

#MEMBUAT KONEKSI KE MYSQL
print ("\nKoneksi MySql Server")
host=input("Nama/IP Host: ")
user=input("Username: ")
paswd=input("Password: ")
db=mysql.connector.connect (
   host=host,
      user=user,
      password=paswd,
      )

#MEMBUAT DATABASE
cursor=db.cursor()
print ("\nMembuat Database")
nama=input("Nama Database: ")
sql="CREATE DATABASE "
cursor.execute (sql+nama)

#MEMBUAT TABLE
db1=mysql.connector.connect (
   host=host,
      user=user,
      password=paswd,
      database=nama
      )
text1=input("Nama Tabel: ")
cursor=db1.cursor()
table = "CREATE TABLE %s (temporary VARCHAR(255))"%(text1)
cursor.execute(table)

#MENULIS KODE KONEKSI PADA OUTPUT FILE
f.write ("import mysql.connector")
f.write ("\ndb=mysql.connector.connect(\n   host='"+host+"',\n   user='"+user+"',\n   password='"+paswd+"',\n   database='"+nama+"'\n   )")


#MEMBUAT FIELD dan PERULANGAN
jml_field=int(input("Jumlah Field:"))
field_now=0
while field_now<jml_field:
    tot_field=(field_now+1)
    text2=input(str(tot_field)+".")
    field_now=int(field_now)+1
    field="ALTER TABLE %s ADD %s VARCHAR(255)"%(text1,text2)
    cursor.execute(field)

    #MENULIS FORM INPUT PADA OUTPUT FILE
    f.write ("\n\n"+text2+"="+"input"+"('"+text2.capitalize().translate(trantab)+": ')")
f.close() #MENUTUP FILE

#HAPUS FIELD TEMPORARY
drop="ALTER TABLE %s DROP COLUMN temporary"%(text1)
cursor.execute(drop)

input("\nProses Selesai...")