Jun-11-2019, 05:20 AM
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\')