name = entry4.text.get()
parent_table = entry5.text.get()
parent_id = entry6.text.get()
table1 = dm.MysqlTable(db1, name)
if parent_table != "" and parent_id != "":
foreign_key = {'parent': parent_table, 'parent_id': parent_id}
table1.add_foreign_key(foreign_key)
def gui_execute_query():
query = entry7.text.get()
db1.execute(query)
gui1 = dg.GUI(title="Dorm Builder GUI")
dg.Label(gui1.window, "Name", 1, 1)
dg.Label(gui1.window, "Columns", 1, 2)
dg.Label(gui1.window, "Types", 1, 3)
entry1 = dg.Entry(gui1.window, 2, 1, width=15)
entry2 = dg.Entry(gui1.window, 2, 2, width=50)
entry3 = dg.Entry(gui1.window, 2, 3, width=50)
dg.Button(gui1.window, "Create Table", gui_create_table, 3, 1)
dg.Button(gui1.window, "Drop Table", gui_drop_table, 3, 2)
dg.Label(gui1.window, "FK - table", 4, 1)
dg.Label(gui1.window, "FK - parent table", 4, 2)
dg.Label(gui1.window, "FK - parent_id", 4, 3)
entry4 = dg.Entry(gui1.window, 5, 1, width=15)
def upload_to_pypi():
os.system("python -m twine upload dist/*")
def change_directory():
new_dir=entry6.text.get()
os.chdir(new_dir)
new_dir=label21.text.set(new_dir)
print(os.getcwd())
current_dir=os.getcwd()
gui1=dg.GUI("Easy PyPI Tool")
label1=dg.Label(gui1.window,"Package name",3,1)
entry1=dg.Entry(gui1.window,3,2)
label2=dg.Label(gui1.window,"Version",4,1)
entry2=dg.Entry(gui1.window,4,2,"0.0.1")
btn1=dg.Button(gui1.window,"Create setup.py file",create_setup_py,5,4)
btn2=dg.Button(gui1.window,"Create MIT Licence file",create_licence,5,3)
btn6=dg.Button(gui1.window,"Create __init__.py file",create_init_file,4,3)
btn8=dg.Button(gui1.window,"Create README.md file",create_readme,4,4)
btn7=dg.Button(gui1.window,"Move python files to package folder",move_files_to_package_folder,6,4)
btn4=dg.Button(gui1.window,"Create package distribution",create_package,8,4)
btn5=dg.Button(gui1.window,"Upload package to PyPI",upload_to_pypi,9,4)
pass
import dbhydra.dbhydra.dbhydra_core as dh
db1 = dh.XlsxDB("RobosumaDB")
db1.create_database()
balances_table = dh.XlsxTable(db1, "balances",
["id", "account_name", "date", "amount"])
expenses_table = dh.XlsxTable(db1, "expenses",
["id", "category", "name", "date", "amount"])
incomes_table = dh.XlsxTable(db1, "incomes",
["id", "category", "name", "date", "amount"])
gui1 = dg.GUI("Robosuma")
today = datetime.datetime.now().strftime("%Y-%m-%d")
label3 = dg.Label(gui1.window, "Datum", 1, 2)
entry3 = dg.Entry(gui1.window, 1, 3, today)
combo1 = dg.Combobox(gui1.window, account_names, 2, 1)
label1 = dg.Label(gui1.window, "Aktuální stav", 2, 2)
entry1 = dg.Entry(gui1.window, 2, 3)
btn1 = dg.Button(gui1.window, "Submit", gui_add_balance, 2, 4)
label2 = dg.Label(gui1.window, "", 3, 1)
label3 = dg.Label(gui1.window, "Income and expenses:", 3, 2)
label4 = dg.Label(gui1.window, "Category:", 4, 2)
categories = [
'falk', 'fryb', 'rest', 'fast', 'vbuy', 'vpos', 'buy', 'obl', 'call',
'ubyt', 'food', 'cest', 'benz', 'rekr', 'mam', 'lost', 'int', 'eroz',
'drnk', 'hair', 'pokr', 'kb', 'douc', 'heal', 'games', 'sport', 'kolo',
'osvc', 'repl'
def gui_stop_threading():
tc.exit_all_threads()
def gui_refresh():
label1.text.set(tc.threads)
current_time = datetime.datetime.now()
time_elapsed = current_time - tc.start_time
label2.text.set(time_elapsed)
def gui_new_processing_thread():
tc.create_new_processing_thread("Thread-" + str(tc.threadID),
tc.work_queue, tc.threadID)
gui1 = dg.GUI()
gui1.function = gui_refresh
tc = threading_core.ThreadingCore(gui1)
tc.create_new_time_thread("Thread-" + str(tc.threadID), tc.work_queue,
tc.threadID)
label1 = dg.Label(gui1.window, "", 2, 1)
label2 = dg.Label(gui1.window, "", 2, 2)
dg.Button(gui1.window, "Stop threading", gui_stop_threading, 1, 1)
dg.Button(gui1.window, "Refresh", gui_refresh, 1, 2)
dg.Button(gui1.window, "New thread", gui_new_processing_thread, 1, 3)
gui1.build_gui()
name = entry4.text.get()
parent_table = entry5.text.get()
parent_id = entry6.text.get()
table1 = dh.MysqlTable(db1, name)
if parent_table != "" and parent_id != "":
foreign_key = {'parent': parent_table, 'parent_id': parent_id}
table1.add_foreign_key(foreign_key)
def gui_execute_query():
query = entry7.text.get()
db1.execute(query)
gui1 = dg.GUI(title="DB Hydra Builder GUI")
dg.Label(gui1.window, "Name", 1, 1)
dg.Label(gui1.window, "Columns", 1, 2)
dg.Label(gui1.window, "Types", 1, 3)
entry1 = dg.Entry(gui1.window, 2, 1, width=15)
entry2 = dg.Entry(gui1.window, 2, 2, width=50)
entry3 = dg.Entry(gui1.window, 2, 3, width=50)
dg.Button(gui1.window, "Create Table", gui_create_table, 3, 1)
dg.Button(gui1.window, "Drop Table", gui_drop_table, 3, 2)
dg.Label(gui1.window, "FK - table", 4, 1)
dg.Label(gui1.window, "FK - parent table", 4, 2)
dg.Label(gui1.window, "FK - parent_id", 4, 3)
entry4 = dg.Entry(gui1.window, 5, 1, width=15)