def __init__(self):
self.HandleConfig = HandleConfig()
self.MysqlRestore = MysqlRestore()
self.MysqlDump = MysqlDump()
self.Download = Download()
self.ConnDB = ConnDB()
self.conn = self.ConnDB.conndb()
def __init__(self):
self.HandleConfig = HandleConfig()
self.ConnDB = ConnDB()
self.MysqlDump = MysqlDump()
self.cleansql = self.HandleConfig.handle_config(
'g', 'referencefile', 'cleanexcel')
self.nickname = self.HandleConfig.handle_config(
'g', 'excelimporter', 'nickname')
def __init__(self):
self.HandleConfig = HandleConfig()
self.server = self.HandleConfig.handle_config("g", "global", "server")
self.host = self.HandleConfig.handle_config('g', self.server, 'host')
self.user = self.HandleConfig.handle_config('g', self.server, 'user')
self.passwd = self.HandleConfig.handle_config('g', self.server,
'password')
self.port = int(
self.HandleConfig.handle_config('g', self.server, 'port'))
def __init__(self, values):
self.values = values
self.ConnDB = ConnDB(values)
self.HandleConfig = HandleConfig()
self.conn_db = self.ConnDB.conndb(host=values['host'],
port=int(values['port']),
user=values['user'],
passwd=values['passwd'],
db=values['dbname'],
charset='utf8')
def __init__(self):
self.HandleConfig = HandleConfig()
self.DbToDownload = DbToDownload()
self.ConnDB = ConnDB()
"""
import PySimpleGUI as sg
import traceback
import sys
from common.handleconfig import HandleConfig
from gui.gui import Gui
Version = '4.6'
if len(sys.argv) <= 1:
# normal start, run with a gui
# cmd:python D:\Projects\ExcelToDatabase\main.py
# exe:ExcelToDatabase.exe
sg.ChangeLookAndFeel('dark')
HandleConfig = HandleConfig()
Gui = Gui()
def exception_format():
# format exception output
return "".join(
traceback.format_exception(sys.exc_info()[0],
sys.exc_info()[1],
sys.exc_info()[2],
limit=-1))
default_values = HandleConfig.get_defaults()
window = sg.Window('ExcelToDatabase {0}'.format(Version),
Gui.generate_layout(),
location=(700, 50))