[Tkinter] Manipulating Checkboxes

[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\')