<commit_before>-- Oressource
-- Copyright (C) 2014-2017  <NAME> and Oressource devellopers

-- This program is free software: you can redistribute it and/or modify
-- it under the terms of the GNU Affero General Public License as
-- published by the Free Software Foundation, either version 3 of the
-- License, or (at your option) any later version.

-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU Affero General Public License for more details.

-- You should have received a copy of the GNU Affero General Public License
-- along with this program.  If not, see <http://www.gnu.org/licenses/>.

-- Aller zou fini les oui/non.
UPDATE moyens_paiement set visible = (case when visible = 'oui' then 1 else 0 end);
alter table moyens_paiement MODIFY column visible boolean not null default true;

UPDATE filieres_sortie set visible = (case when visible = 'oui' then 1 else 0 end);
alter table filieres_sortie MODIFY column visible boolean not null default true;

UPDATE localites set visible = (case when visible = 'oui' then 1 else 0 end);
alter table localites MODIFY column visible boolean not null default true;

UPDATE grille_objets set visible = (case when visible = 'oui' then 1 else 0 end);
alter table grille_objets MODIFY column visible boolean not null default true;

UPDATE type_dechets_evac set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_dechets_evac MODIFY column visible boolean not null default true;

UPDATE types_poubelles set visible = (case when visible = 'oui' then 1 else 0 end);
alter table types_poubelles MODIFY column visible boolean not null default true;

UPDATE type_sortie set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_sortie MODIFY column visible boolean not null default true;

UPDATE type_collecte set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_collecte MODIFY column visible boolean not null default true;

UPDATE type_contenants set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_contenants MODIFY column visible boolean not null default true;

UPDATE type_dechets set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_dechets MODIFY column visible boolean not null default true;

UPDATE points_sortie set visible = (case when visible = 'oui' then 1 else 0 end);
alter table points_sortie MODIFY column visible boolean not null default true;<commit_msg>🏗 Gestion du champ ultime des types_poubelles.<commit_after>-- Oressource
-- Copyright (C) 2014-2017  <NAME> and Oressource devellopers

-- This program is free software: you can redistribute it and/or modify
-- it under the terms of the GNU Affero General Public License as
-- published by the Free Software Foundation, either version 3 of the
-- License, or (at your option) any later version.

-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU Affero General Public License for more details.

-- You should have received a copy of the GNU Affero General Public License
-- along with this program.  If not, see <http://www.gnu.org/licenses/>.

-- Aller zou fini les oui/non.
UPDATE moyens_paiement set visible = (case when visible = 'oui' then 1 else 0 end);
alter table moyens_paiement MODIFY column visible boolean not null default true;

UPDATE filieres_sortie set visible = (case when visible = 'oui' then 1 else 0 end);
alter table filieres_sortie MODIFY column visible boolean not null default true;

UPDATE localites set visible = (case when visible = 'oui' then 1 else 0 end);
alter table localites MODIFY column visible boolean not null default true;

UPDATE grille_objets set visible = (case when visible = 'oui' then 1 else 0 end);
alter table grille_objets MODIFY column visible boolean not null default true;

UPDATE type_dechets_evac set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_dechets_evac MODIFY column visible boolean not null default true;

UPDATE types_poubelles set visible = (case when visible = 'oui' then 1 else 0 end);
alter table types_poubelles MODIFY column visible boolean not null default true;

UPDATE types_poubelles set ultime = (case when ultime = 'oui' then 1 else 0 end);
alter table types_poubelles MODIFY column ultime boolean not null default true;

UPDATE type_sortie set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_sortie MODIFY column visible boolean not null default true;

UPDATE type_collecte set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_collecte MODIFY column visible boolean not null default true;

UPDATE type_contenants set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_contenants MODIFY column visible boolean not null default true;

UPDATE type_dechets set visible = (case when visible = 'oui' then 1 else 0 end);
alter table type_dechets MODIFY column visible boolean not null default true;

UPDATE points_sortie set visible = (case when visible = 'oui' then 1 else 0 end);
alter table points_sortie MODIFY column visible boolean not null default true;
{'fraction_non_alphanumeric': 0.05656866393747674, 'fraction_numerical': 0.01190919240788984, 'mean_word_length': 4.501535312180144, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3934530', 'n_tokens_mistral': 1500, 'n_tokens_neox': 1437, 'n_words': 789}