[TKINTER]Résidu dans le fond de mon application lors de l'affichage de différent menu

**la_fouine1806** · 14/04/2017, 16h53

Bonjour,

J'ai un soucis j'ai fait une application avec Tkinter.

J'ai crée une barre de menu. Cependant quand je navigue d'un menu à l'autre, il ne me rafraîchit pas l'arrière plan. Du coup je me retrouve avec la superposition dans la fenêtre principale des écrans voulu (cf. Screenshot)

Nom : Sans titre.png
Affichages : 116
Taille : 2,2 Ko

Avez-vous une idée ? Peut être que je prends mal pour naviguer entre les menus.

Merci par avance de votre retour

Cordialement

**wiztricks** · 14/04/2017, 17h21

Salut,

Envoyé par la_fouine1806

Avez-vous une idée ? Peut être que je prends mal pour naviguer entre les menus.

C'est le résultat de votre code, non?
Si vous ne le montrez pas, pas facile d'en dire plus.
Mais si vous postez tout votre code sans le réduire aux éléments qui constituent ce que vous appelez "naviguer entre les menus"... Peut être que pas grand monde aura la patience/le temps de le lire.

- W

**la_fouine1806** · 14/04/2017, 18h53

Re Bonjour

Effectivement c'etait un peu léger. Tout mes excuses

Mon script se décompose en 3 fichiers python :
1 -GUI.py contient l'interface en TKINTER
2 - param.py contient les variables que je souhaite dans un second temps ajouter à l'interface
3 - sql_function.py contient mes fonctions que j'utilise lorsque je clique sur un bouton

Juste pour résumer, lorsque je navigue dans les données il y a des résidus des menus précédents. J'ai l'impression que le contenu de la fenêtre principale ne se rafraichit pas mais superpose les contenus des autres menus.
cf image de mon premier post.

voici mes scripts :
GUI.py

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
 
import xlrd
import os
import shutil
 
from tkinter import *
 
from function.sql_function import *
from parameter.param import *
from function.menu import *
 
master = Tk()
 
def select_all():
    var1.set(1)
    var2.set(1)
    var3.set(1)
    var4.set(1)
    var5.set(1)
    var6.set(1)
    var7.set(1)
 
def deselect_all():
    var1.set(0)
    var2.set(0)
    var3.set(0)
    var4.set(0)
    var5.set(0)
    var6.set(0)
    var7.set(0)
 
def env_generate():
    if not os.path.exists(script_directory + env_directory):
        os.makedirs(script_directory + env_directory)
    hostname=var8.get()
    dbname = var10.get()
    user = var9.get()
    passwd = var11.get()
    gen_env = aster_env_gen('type_env',hostname,dbname,user,passwd)
    env_file = open(script_directory + env_directory + env_filename, 'w')
    env_file.write(gen_env)
    env_file.close()
 
def sql_generate():
    global workbook
    workbook = xlrd.open_workbook(xls_wkb_filename)
    if var2.get() == 1:
        if not os.path.exists(script_directory + sql_directory):
            os.makedirs(script_directory + sql_directory)
        #####################SQL Processing
        # Select dictionary sheet
        dic_worksheet = workbook.sheet_by_name(xls_sheet_dico)
        tmp_dic_nrows = dic_worksheet.nrows
        # Create staging table file
        sql_stg_statement = aster_stg_sql_statment(dic_worksheet, tmp_dic_nrows)
        sql_stg_file = open(script_directory + sql_directory + stg_filename + '.sql', 'w')
        sql_stg_file.write(sql_stg_statement)
        sql_stg_file.close()
    if var3.get() == 1:
        if not os.path.exists(script_directory + sql_directory):
            os.makedirs(script_directory + sql_directory)
        #####################SQL Processing
        # Open Excel Files
        workbook = xlrd.open_workbook(xls_wkb_filename)
        # Select dictionary sheet
        dic_worksheet = workbook.sheet_by_name(xls_sheet_dico)
        tmp_dic_nrows = dic_worksheet.nrows
        # Create prep table file
        sql_prep_statement = aster_prep_sql_statment(dic_worksheet, tmp_dic_nrows)
        sql_prep_file = open(script_directory + sql_directory + prep_filename + '.sql', 'w')
        sql_prep_file.write(sql_prep_statement)
        sql_prep_file.close()
    if var4.get() == 1:
        if not os.path.exists(script_directory + sql_directory):
            os.makedirs(script_directory + sql_directory)
        #####################SQL Processing
        # Open Excel Files
        workbook = xlrd.open_workbook(xls_wkb_filename)
        # Select dictionary sheet
        dic_worksheet = workbook.sheet_by_name(xls_sheet_dico)
        tmp_dic_nrows = dic_worksheet.nrows
        # Create prep table file
        sql_insert_prep_statement = aster_insert_prep_sql_statment(dic_worksheet, tmp_dic_nrows)
        sql_insert_prep_file = open(script_directory + sql_directory + insert_prep_filename + '.sql', 'w')
        sql_insert_prep_file.write(sql_insert_prep_statement)
        sql_insert_prep_file.close()
    if var5.get() == 1:
        #####################bash Processing
        # Create staging bash file
        gen_stg = aster_sh_gen(stg_filename, 'Staging', env_directory, type_env, env_filename, sql_directory)
        sh_stg_file = open(script_directory + stg_filename + '.sh', 'w')
        sh_stg_file.write(gen_stg)
        sh_stg_file.close()
 
        # Create prep bash file
        gen_prep = aster_sh_gen(prep_filename, 'Preparation', env_directory, type_env, env_filename, sql_directory)
        sh_prep_file = open(script_directory + prep_filename + '.sh', 'w')
        sh_prep_file.write(gen_prep)
        sh_prep_file.close()
 
        # Create insert prep bash file
        gen_insert = aster_sh_gen(insert_prep_filename, 'Insertion', env_directory, type_env, env_filename,
                                  sql_directory)
        sh_insert_file = open(script_directory + insert_prep_filename + '.sh', 'w')
        sh_insert_file.write(gen_insert)
        sh_insert_file.close()
 
def dataloader_generate():
    if var6.get() == 1:
        if not os.path.exists(loader_directory):
            os.makedirs(loader_directory)
            shutil.copyfile('dataloader library/function', loader_directory + 'function')
        hostname = var8.get()
        dbname = var10.get()
        user = var9.get()
        passwd = var11.get()
        ####################Loader param Processing
        param_worksheet = workbook.sheet_by_name(xls_sheet_param)
        tmp_param_nrows = param_worksheet.nrows
        param_gen = loader_param_gen(param_worksheet, tmp_param_nrows, hostname, dbname, user, passwd)
        param_gen_file = open(loader_directory + loader_filename, 'w')
        param_gen_file.write(param_gen)
        param_gen_file.close()
    if var7.get() == 1:
        if not os.path.exists(loader_directory):
            os.makedirs(loader_directory)
            shutil.copyfile('dataloader library/function', loader_directory + 'function')
        #####################Loader param Processing
        dataloader_worksheet = workbook.sheet_by_name(xls_sheet_param)
        tmp_param_nrows = dataloader_worksheet.nrows
        dataloader_gen = loader_dataloader_gen(dataloader_worksheet, tmp_param_nrows)
        param_gen_file = open(loader_directory + dataloader_filename + '.sh', 'w')
        param_gen_file.write(dataloader_gen)
        param_gen_file.close()
 
 
#Action du menu
def MenuRequest(page,menu_items):
    global var1,var2,var3,var4,var5,var6,var7,var8,var9,var10,var11,var12
 
    var1 = IntVar()
    var2 = IntVar()
    var3 = IntVar()
    var4 = IntVar()
    var5 = IntVar()
    var6 = StringVar()
    var7 = StringVar()
    var8 = StringVar()
    var9 = StringVar()
    var10 = StringVar()
    var11 = StringVar()
    var12 = StringVar()
 
    master.option_clear()
 
    if menu_items == "Env":
 
       var8.set("------Hostname IP------")
       Entry(page, textvariable=var8).grid(row=1 , sticky=W, pady=10)
       var10.set("dbname")
       Entry(page, textvariable=var10).grid(row=1, sticky=E, pady=10)
       var9.set("user")
       Entry(page, textvariable=var9).grid(row=2, sticky=W, pady=10)
       var11.set("password")
       Entry(page, textvariable=var11).grid(row=2, sticky=E, pady=10)
       Button(page, text='Execute', command=env_generate).grid(row=5, sticky=EW, pady=10)
    if menu_items == "About":
 
       Label(page, text="", font="bold").grid(row=1, sticky=EW)
       Label(page, text="tototototototototototototototo", font="bold").grid(row=2, sticky=EW)
       Label(page, text="", font="bold").grid(row=3, sticky=EW)
       Label(page, text="", font="bold").grid(row=4, sticky=EW)
       Label(page, text="", font="bold").grid(row=5, sticky=EW)
    if menu_items == "Script":
 
       Checkbutton(master, text="1 : Create Staging Table   ", variable=var2).grid(row=1,  sticky=W ,pady=10)
       Checkbutton(master, text="2 : Create Preparation Table", variable=var3).grid(row=1 , sticky=E ,pady=10)
       Checkbutton(master, text="3 : Insert into preparation", variable=var4).grid(row=2 , sticky=W ,pady=10)
       Checkbutton(master, text="4 : SH Execution  Generation", variable=var5).grid(row=2 , sticky=E ,pady=10)
       Button(master, text='Select All', command=select_all).grid(row=4,sticky=W  ,pady=10)
       Button(master, text='Deselect All', command=deselect_all).grid(row=4,sticky=E  ,pady=10)
       Button(master, text='Execute', command=sql_generate).grid(row=5, sticky=EW, pady=4)
    if menu_items == "Dataloader" :
 
       Checkbutton(master, text="1 : Param_fact Generation", variable=var6).grid(row=1, sticky=W ,pady=10)
       Checkbutton(master, text="2 : Dataloader Generation", variable=var7).grid(row=1, sticky=E ,pady=10)
       Button(master, text='Select All', command=select_all).grid(row=4,sticky=W  ,pady=10)
       Button(master, text='Deselect All', command=deselect_all).grid(row=4,sticky=E  ,pady=10)
       Button(master, text='Execute', command=dataloader_generate).grid(row=5, sticky=EW ,pady=10)
 
 
MenuRequestTmp=""
 
#application header
master.wm_title("ToolKit")
 
######################################################"
#Menu
######################################################"
 
mainmenu = Menu(master)
 
menuMain = Menu(mainmenu)  ## Menu fils menuExample
menuMain.add_command(label="Quit" , command = master.quit)
 
menuParam = Menu(mainmenu) ## Menu Fils
menuParam.add_command(label="Project", command = lambda : MenuRequest(master,"Project"))
menuParam.add_separator()
menuParam.add_command(label="Environment ", command = lambda : MenuRequest(master,"Env"))
 
print(MenuRequestTmp)
 
 
menuScript = Menu(mainmenu) ## Menu Fils
menuScript.add_command(label="Script Generation",command = lambda : MenuRequest(master,"Script"))
menuScript.add_command(label="Dataloader Generation",command = lambda : MenuRequest(master,"Dataloader"))
 
menuAbout = Menu(mainmenu) ## Menu Fils
menuAbout.add_command(label="A propos",command = lambda : MenuRequest(master,"About"))
 
 
 
#Menu level 1
mainmenu.add_cascade(label = "File", menu=menuMain)
mainmenu.add_cascade(label = "Parameters", menu=menuParam)
mainmenu.add_cascade(label = "Script Generation", menu=menuScript)
mainmenu.add_cascade(label = "About", menu=menuAbout)
 
bg_image = PhotoImage(file ="./img/logo.png")
x = Label (image = bg_image)
x.grid(row = 0 )
 
master.config(menu = mainmenu)
 
mainloop()

param.py

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
####################################################################
##Input
####################################################################
#Data dictionnary input
xls_wkb_filename = 'DICO.xlsx'
xls_sheet_dico = 'Dictionnaire'
xls_sheet_param = 'Param'
 
#Directory input
script_directory='D:\\test\\02_script\\'
loader_directory='D:\\test\\03_loader\\'
sql_directory='sql\\'
env_directory='env\\'
 
#Pattern file input
stg_filename='00_DLL_CREATE_STG'
prep_filename='01_DLL_CREATE_PREP'
insert_prep_filename='02_DLL_INSERT_PREP'
env_filename='param'
loader_filename='param_fact'
dataloader_filename='Dataloader'
 
#Environment
type_env="dev"

sql_function.py

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
 
import xlrd
from tkinter import *
 
MenuRequestTmp="test"
 
def aster_env_gen(type_env,hostname,dbname,user,passwd):
    aster_sh_gen_text="##############Environnement input\n\n"+ type_env +"_host_name="+ hostname +"\n"+ type_env +"_user="+ user +"\n"+ type_env +"_password="+passwd+"\n"+ type_env +"_dbname="+dbname+"\n\n#Superuser credential\n"+ type_env +"_sp=db_superuser\n"+ type_env +"_sp_pw=db_superuser\n"
    return aster_sh_gen_text
 
def aster_sh_gen(sql_input,type_script,env_directory,type_env,env_filename,sql_directory):
    aster_sh_gen_text=". "+ env_directory + env_filename +"\n \n echo \"-----------------Execution start : 00_DDL_CREATE_STG.sh--------------------Time : \" $(date +'%r')\n echo \"----------------------"+type_script+" table creation---------------------------- Time : \" $(date +'%r')\n act -h ${"+type_env+"_host_name} --username ${"+type_env+"_user} --password ${"+type_env+"_password} --dbname ${"+type_env+"_dbname} -f "+ sql_directory + sql_input +'.sql'
    return aster_sh_gen_text
 
def aster_stg_sql_statment(worksheet, tmp_nrows):
    global sql_core_statement
    distribute_2=""
    sql_core_statement = ''
    tmp = 1
 
 
    distribute = worksheet.cell(tmp, 3).value
    while tmp < tmp_nrows - 1:
        if tmp == 1 :
            sql_start_statement = "\echo *--------------------------Staging table creation : " + worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value + " -----------------------\nDROP TABLE IF EXISTS " + worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value + ";\n" + "CREATE TABLE " + worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp, 2).value + "(\nsource text\n," + worksheet.cell(tmp,3).value + " " + worksheet.cell(tmp, 6).value + worksheet.cell(tmp, 7).value + "\n"
            tmp += 1
        # current distribute key
        if worksheet.cell(tmp + 1, 8).value == "x" and tmp > 1:
            distribute_2 = worksheet.cell(tmp + 1, 3).value
        # current end statement
        if worksheet.cell(tmp, 0).value != worksheet.cell(tmp + 1, 0).value:
            sql_core_statement = sql_core_statement + ')\nDISTRIBUTE BY HASH(' + distribute + ') \nCOMPRESS HIGH;\n\n\echo *--------------------------Staging table creation : ' + worksheet.cell(tmp + 1, 1).value + "." + worksheet.cell(tmp + 1,2).value + ' -----------------------\nDROP TABLE IF EXISTS ' + worksheet.cell(tmp + 1, 1).value + "." + worksheet.cell(tmp + 1, 2).value + ";\n" + "CREATE TABLE " + worksheet.cell(tmp + 1, 1).value + "." + worksheet.cell(tmp + 1, 2).value + "(\nsource text,\n" + worksheet.cell(tmp + 1,3).value + " "+ worksheet.cell(tmp + 1, 6).value + worksheet.cell(tmp + 1, 7).value +"\n"
            distribute = distribute_2
            tmp += 1
        # current core statement
        if worksheet.cell(tmp, 0).value == worksheet.cell(tmp + 1, 0).value and tmp != 1:
            sql_core_statement = sql_core_statement + "," + worksheet.cell(tmp + 1, 3).value + " " + worksheet.cell(tmp + 1, 6).value + worksheet.cell(tmp + 1, 7).value +"\n"
            tmp += 1
    # build all the statment
    sql_statement = sql_start_statement + sql_core_statement + ")\nDISTRIBUTE BY HASH(" + distribute_2 + ")\nCOMPRESS HIGH;"
    return sql_statement
 
def aster_prep_sql_statment(worksheet, tmp_nrows):
    global sql_core_statement
    distribute_2 = ""
    sql_core_statement = ''
    tmp = 1
    sql_start_statement = "\echo *--------------------------Preparation table creation : " + worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value + " -----------------------\nDROP TABLE IF EXISTS " + worksheet.cell(1, 1).value + "." + worksheet.cell(1,2).value + ";\n" + "CREATE TABLE " + worksheet.cell(1, 1).value + "." + worksheet.cell(1, 2).value + "(\n" + worksheet.cell(1, 3).value + " "+ worksheet.cell(1, 4).value + worksheet.cell(1, 5).value + "\n"
    distribute = worksheet.cell(tmp, 3).value
    while tmp < tmp_nrows - 1:
        # current distribute key
        if worksheet.cell(tmp + 1, 8).value == "x" and tmp > 1:
            distribute_2 = worksheet.cell(tmp + 1, 3).value
        # current end statement
        if worksheet.cell(tmp, 0).value != worksheet.cell(tmp + 1, 0).value:
            sql_core_statement = sql_core_statement + ')\nDISTRIBUTE BY HASH(' + distribute + ') \nCOMPRESS HIGH;\n\n\echo *--------------------------Preparation table creation : ' + worksheet.cell(tmp, 1).value + '.' + worksheet.cell(tmp,2).value + ' -----------------------\nDROP TABLE IF EXISTS ' + worksheet.cell(
                tmp + 1, 1).value + "." + worksheet.cell(tmp + 1, 2).value + ";\n" + "CREATE TABLE " + worksheet.cell(
                tmp + 1, 1).value + "." + worksheet.cell(tmp + 1, 2).value + "(\n" + worksheet.cell(tmp + 1,3).value + " " + worksheet.cell(tmp + 1, 4).value + worksheet.cell(tmp + 1, 5).value + "\n"
            distribute = distribute_2
            tmp += 1
        # current core statement
        if worksheet.cell(tmp, 0).value == worksheet.cell(tmp + 1, 0).value:
            sql_core_statement = sql_core_statement + "," + worksheet.cell(tmp + 1, 3).value + " "+ worksheet.cell(tmp + 1, 4).value + worksheet.cell(tmp + 1, 5).value + "\n"
            tmp += 1
    # build all the statment
    sql_statement = sql_start_statement + sql_core_statement + ")\nDISTRIBUTE BY HASH(" + distribute_2 + ")\nCOMPRESS HIGH;"
    return sql_statement
 
def aster_insert_prep_sql_statment(worksheet, tmp_nrows):
    global sql_core_statement
    distribute_2 = ""
    sql_core_statement = ''
    tmp = 1
    while tmp < tmp_nrows - 1:
        if tmp == 1 :
            sql_start_statement = "\echo *--------------------------Insert into : "+ worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value +" -----------------------\nINSERT INTO " + worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value + "\n" + "SELECT " + cast_sql_statment(worksheet.cell(tmp,3).value, worksheet.cell(tmp,4).value, worksheet.cell(tmp,6).value) + "\n"
            tmp += 1
        # current end statement
        if worksheet.cell(tmp, 0).value != worksheet.cell(tmp + 1, 0).value and tmp != 1 :
            sql_core_statement = sql_core_statement + 'FROM '+ worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value +";\n\n\echo *--------------------------Insert into : "+ worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value +" -----------------------\nINSERT INTO "  + worksheet.cell(tmp, 1).value + "." + worksheet.cell(tmp,2).value + "\nSELECT " + cast_sql_statment(worksheet.cell(tmp,3).value, worksheet.cell(tmp,4).value, worksheet.cell(tmp,6).value) + "\n"
            tmp += 1
        # current core statement
        if worksheet.cell(tmp, 0).value == worksheet.cell(tmp + 1, 0).value and tmp!=1:
            sql_core_statement = sql_core_statement + "," + cast_sql_statment(worksheet.cell(tmp,3).value, worksheet.cell(tmp,4).value, worksheet.cell(tmp,6).value) + "\n"
            tmp += 1
    # build all the statment
    sql_statement = sql_start_statement + sql_core_statement + " FROM " + worksheet.cell(tmp_nrows-1, 1).value + "." + worksheet.cell(tmp_nrows-1,2).value
    return sql_statement
 
def cast_sql_statment(field, type_origin, type_dest):
    cast=''
    if type_origin == type_dest:
        cast = field
    if type_origin != type_dest:
        cast='cast(' + str(field) + ' as ' + str(type_dest) + ') as ' + str(field)
    return cast
 
def loader_param_gen(worksheet,tmp_param_nrows,hostname,dbname,user,passwd):
 
    loader_gen_temp=''
    tmp_param=1
    loader_gen_temp_head ="\n########################################################\n##General parameter\n########################################################\nHostname="+ hostname +"             #host de la queen\nUsername="+user+"                     #Utilisateur de la database\nPassword="+ passwd +"                     #mots de passe\nDbname="+ dbname +"                       #Nom de la base de données\nSource=                              #Chemin du dossier contenant l'arborescence des données \nNb_Param=1                           #Number of paramter\nVerbose=                             #Active le paramètre verbose en entrant --verbose\n\n"
    while tmp_param < tmp_param_nrows:
        loader_gen_temp = loader_gen_temp + "\n########################################################\n##Parameters to load : "+worksheet.cell(tmp_param, 2).value+" \n########################################################\nSkip_rows["+str(tmp_param)+"]="+ str(int(worksheet.cell(tmp_param, 1).value)) +"\nTableName["+str(tmp_param)+"]="+ worksheet.cell(tmp_param, 2).value+"\nFolder["+str(tmp_param)+"]="+ worksheet.cell(tmp_param, 3).value+"\nDelimiter["+str(tmp_param)+"]=\""+ worksheet.cell(tmp_param, 4).value+"\"\nCSV["+str(tmp_param)+"]="+ worksheet.cell(tmp_param, 5).value+"\nDateFormat["+str(tmp_param)+"]="+ worksheet.cell(tmp_param, 6).value+"\nFilePattern["+str(tmp_param)+"]="+ worksheet.cell(tmp_param, 7).value+"\nNullValue["+str(tmp_param)+"]="+ worksheet.cell(tmp_param, 8).value
        tmp_param+=1
        loader_gen = loader_gen_temp_head + loader_gen_temp
    return loader_gen
 
def loader_dataloader_gen(worksheet,tmp_param_nrows):
 
    loader_gen_temp=''
    tmp_param=1
    loader_gen_temp_head ="\n########################################################\n##DataLoader Version 1.0\n########################################################\n. function\n"
    while tmp_param < tmp_param_nrows:
        loader_gen_temp = loader_gen_temp + "\nLoad_fact 'd' '" + str(int(worksheet.cell(tmp_param, 0).value)) + "' ##Load : "+ worksheet.cell(tmp_param, 2).value
        tmp_param+=1
        loader_gen = loader_gen_temp_head + loader_gen_temp
    return loader_gen
 
def var_states() :
    print(
        "ENV: %d,ENV: %s,ENV: %s,ENV: %s,ENV: %s,\nSQL_STG: %d,\nSQL_PREP: %d,\nSQL_PREP_INSERT: %d,\nBASH: %d,\nPARAM: %d,\nDATALOADER: %d" % (
        var1.get(), var8.get(), var9.get(), var10.get(), var11.get(), var2.get(), var3.get(), var4.get(), var5.get(),
        var6.get(), var7.get()))
 
#Action du menu
def MenuRequest(page,menu_items):
    global MenuRequestTmp
    print(MenuRequestTmp)
    if menu_items == "Env":
       MenuRequestTmp = "Env"
       Label(page, text="\nEnv Variable Generator:", font="bold").grid(row=1, sticky=EW)
       var8 = StringVar()
       var8.set("------Hostname IP------")
       Entry(page, textvariable=var8).grid(row=2, sticky=W, pady=10)
       var10 = StringVar()
       var10.set("beehive")
       Entry(page, textvariable=var10).grid(row=2, sticky=E, pady=10)
       var9 = StringVar()
       var9.set("es186015")
       Entry(page, textvariable=var9).grid(row=3, sticky=W, pady=10)
       var11 = StringVar()
       var11.set("es186015")
       Entry(page, textvariable=var11).grid(row=3, sticky=E, pady=10)
       Button(page, text='Execute', command=var_states).grid(row=19, sticky=EW, pady=4)
    if menu_items == "About":
        Label(page, text="\nThis product was designed by Etienne SIGWALD\n who is  a part from Teradata company ", font="bold").grid(row=2, sticky=EW)

Merci par avance de votre retour

Cordialement

[TKINTER]Résidu dans le fond de mon application lors de l'affichage de différent menu

Tkinter Python

Vue hybride

Discussions similaires

Partager

Partager