[Tkinter] Manipulating Checkboxes

[teflon]

Hi, I have this Checkboxes,

any combination can be selected, and each checkbox selected results in a different query. Instead of using if else, can someone suggest an alternative method, because the combination is gonna be endless

[python]
from tkinter import *
import arcpy
from tkinter import ttk

def select_landuse():
    arcpy.env.workspace = C:/Users/umroot/Documents/ArcGIS/Projects/RecentINSE6421project/affectationpu"
    in_features = "AffectationPU.shp"
    out_feature_class = "C:/Users/umroot/Documents/ArcGIS/Projects/RecentINSE6421project/pythonOutput/affectationpu"
    if (landuse1.get() and landuse3.get() and landuse4.get() and landuse5.get()and landuse6.get()and landuse7.get() and landuse10.get())==TRUE :
        where_clause= "\"categorie\" IN (\'activites diversifiees\',\'conservation\', \'emplois\', \'infrastructure\', \'institution\', \'mixte\', \'residentiel\')"

    elif(landuse1.get() and landuse3.get()and landuse4.get() and landuse5.get() and landuse6.get() and landuse7.get() and landuse8.get() and landuse9.get() and landuse10.get())==TRUE:
     where_clause="\"categorie\" IN (\'activites diversifiees\',\'conservation\', \'emplois\', \'infrastructure\', \'institution\', \'mixte\', \'residentiel\')"

    elif (landuse1.get()and landuse2.get() and landuse4.get()and landuse4.get()and landuse6.get()and landuse7.get()and landuse9.get() and landuse10.get())==TRUE:
        where_clause= "\"categorie\" IN (\'activites diversifiees\',\'conservation\', \'emplois\', \'infrastructure\', \'institution\', \'mixte\',\'religieux\',\'residentiel\')"

    elif (landuse1.get()and landuse2.get() and landuse3.get()and landuse4.get()and landuse4.get()and landuse6.get()and landuse7.get()and landuse9.get() and landuse10.get())==TRUE:
        where_clause= "\"categorie\" IN (\'activites diversifiees\',\'conservation\',\'agricole\', \'emplois\', \'infrastructure\', \'institution\', \'mixte\', \'religieux\',\'residentiel\')"


    elif (landuse1.get()and landuse2.get() and landuse3.get()and landuse4.get()and landuse4.get()and landuse6.get()and landuse7.get()and landuse8.get() and landuse10.get())==TRUE:
        where_clause= "\"categorie\" IN (\'activites diversifiees\',\'conservation\',\'agricole\', \'emplois\', \'infrastructure\', \'institution\', \'mixte\', \'parc\',\'residentiel\')"

[/python]

[Yoriz]

You could do something like this where controls is all the various checkbox controls ie landuse1.get()

controls = (True, True, False, False, True, True, False, True, False)
clauses = (r"\'activites diversifiees\'", r"\'conservation\'", r"\'agricole\'", r"\'emplois\'",
           r"\'infrastructure\'", r"\'institution\'", r"\'mixte\'", r"\'parc\'", r"\'residentiel\'")
clauses = ', '.join(clause for clause, control in zip(clauses, controls) if control)
where_clause = f"\"categorie\" IN ({clauses})"
print(where_clause)

Output:
"categorie" IN (\'activites diversifiees\', \'conservation\', \'infrastructure\', \'institution\', \'parc\')

[teflon]

thank Yoriz

but I don't understand how I could use the status (checked or unchecked ie landuse1.get())of the checkboxes in controls without using if /else statements

[Yoriz]

Use the above instead of using if /else statements

[teflon]

Thanks, Yoriz

your the best it worked

[teflon]

Hi Yoriz
could you make the output like

Output:
\"categorie\" IN (\'activites diversifiees\', \'conservation\', \'infrastructure\', \'institution\', \'parc\')

[Yoriz]

Sure

controls = (True, True, False, False, True, True, False, True, False)
clauses = (r"\'activites diversifiees\'", r"\'conservation\'", r"\'agricole\'", r"\'emplois\'",
           r"\'infrastructure\'", r"\'institution\'", r"\'mixte\'", r"\'parc\'", r"\'residentiel\'")
clauses = ', '.join(clause for clause, control in zip(clauses, controls) if control)
where_clause = f'\\"categorie\\" IN ({clauses})'
print(where_clause)

Output:
\"categorie\" IN (\'activites diversifiees\', \'conservation\', \'infrastructure\', \'institution\', \'parc\')

[teflon]

Thanks Yoriz....

[teflon]

Hello All,

I need the python code for calculating the value of New_score for a column called ID_TRC using the values of 3 other columns called LENGTH, Category, and Score. The result is to be stored in a newly created new excel file for each unique ID_TRC and its corresponding New_Score. The image is a sample of the data
The rules for calculating the new scores are:

if ID_TRC exists elsewhere in the table, with a different LENGTH and different Category then the

new_score = {SUM((Score X LENGTH))[sum for each rows with the same ID_TRC]}divided by (sum of LENGTHS of all with the same ID_TRC)


if ID_TRC exists elsewhere in the table, with the same LENGTH and different Category then the

new_score = {[u]SUM((Score X LENGTH))[sum for each rows with the same ID_TRC]} divided by LENGTH