Author: esj@rezo.net
Date: 2007-10-03 22:44:21 +0200 (mer, 03 oct 2007)
New Revision: 10493
Log:
Abstraction de tous les appels {{{ spip_query("SELECT ..... WHERE ... }}} pour que les champs de type Date dans la clause WHERE soient transformé pour Postgres.
Dépot obtenu par:
{{{
for i in $(grep -l 'spip_query..SELECT.*FROM.*WHERE[^A-Z]*;$' [a-i]*/*php)
do
# Pour la clause DISTINCT, laisser intact pour le moment.
sed 's/spip_query..SELECT *\([^D]*[^ ]\) *FROM *\(.*[^ ]\) *WHERE *\([^A-Z]*;\)$/sql_select("\1", "\2", "\3/;s/ "" *\.//;s/ch(sql_select\(.*\));/sel\1;/' $i > x
echo $i
mv x $i
done
#}}}
et deux suppressions manuelles de lourdeurs syntaxiques résultantes.
Pas d'intervention sur le fichier inc/meta: au test, include manquant. À controler.
Modified:
spip/ecrire/action/acceder_document.php
spip/ecrire/action/copier_local.php
spip/ecrire/action/dater.php
spip/ecrire/action/editer_article.php
spip/ecrire/action/editer_auteur.php
spip/ecrire/action/editer_breve.php
spip/ecrire/action/editer_mot.php
spip/ecrire/action/editer_rubrique.php
spip/ecrire/action/editer_signatures.php
spip/ecrire/action/editer_site.php
spip/ecrire/action/ical.php
spip/ecrire/action/instituer_forum.php
spip/ecrire/action/instituer_langue_rubrique.php
spip/ecrire/action/instituer_mot.php
spip/ecrire/action/pass.php
spip/ecrire/action/referencer_traduction.php
spip/ecrire/action/reorganiser.php
spip/ecrire/action/rss.php
spip/ecrire/action/supprimer.php
spip/ecrire/action/supprimer_traduction.php
spip/ecrire/action/tester_taille.php
spip/ecrire/action/tourner.php
spip/ecrire/balise/formulaire_inscription.php
spip/ecrire/exec/articles.php
spip/ecrire/exec/articles_forum.php
spip/ecrire/exec/articles_versions.php
spip/ecrire/exec/auteur_infos.php
spip/ecrire/exec/breves_edit.php
spip/ecrire/exec/breves_voir.php
spip/ecrire/exec/brouteur.php
spip/ecrire/exec/controle_forum.php
spip/ecrire/exec/controle_petition.php
spip/ecrire/exec/dater.php
spip/ecrire/exec/editer_mot.php
spip/ecrire/exec/export_all.php
spip/ecrire/exec/forum_envoi.php
spip/ecrire/exec/grouper_mots.php
spip/ecrire/exec/iconifier.php
spip/ecrire/exec/instituer_auteur.php
spip/ecrire/exec/message.php
spip/ecrire/exec/message_edit.php
spip/ecrire/exec/mots_edit.php
spip/ecrire/exec/mots_tous.php
spip/ecrire/exec/mots_type.php
spip/ecrire/exec/naviguer.php
spip/ecrire/exec/puce_statut.php
spip/ecrire/exec/rechercher.php
spip/ecrire/exec/referencer_traduction.php
spip/ecrire/exec/rubriques_edit.php
spip/ecrire/exec/sites.php
spip/ecrire/exec/sites_edit.php
spip/ecrire/exec/statistiques_repartition.php
spip/ecrire/exec/virtualiser.php
spip/ecrire/genie/syndic.php
spip/ecrire/inc/acces.php
spip/ecrire/inc/actions.php
spip/ecrire/inc/afficher_objets.php
spip/ecrire/inc/agenda.php
spip/ecrire/inc/article_select.php
spip/ecrire/inc/auth_ldap.php
spip/ecrire/inc/auth_spip.php
spip/ecrire/inc/autoriser.php
spip/ecrire/inc/chercher_rubrique.php
spip/ecrire/inc/distant.php
spip/ecrire/inc/documenter.php
spip/ecrire/inc/documents.php
spip/ecrire/inc/editer_auteurs.php
spip/ecrire/inc/editer_mot.php
spip/ecrire/inc/extra.php
spip/ecrire/inc/forum.php
spip/ecrire/inc/forum_insert.php
spip/ecrire/inc/import_insere.php
spip/ecrire/inc/informer.php
spip/ecrire/inc/informer_auteur.php
spip/ecrire/inc/legender.php
spip/ecrire/inc/modifier.php
spip/ecrire/inc/notifications.php
spip/ecrire/inc/petitionner.php
spip/ecrire/inc/presentation.php
spip/ecrire/inc/puce_statut.php
spip/ecrire/inc/referencer_traduction.php
spip/ecrire/inc/regler_moderation.php
spip/ecrire/inc/revisions.php
spip/ecrire/inc/rubriques.php
spip/ecrire/inc/securiser_action.php
spip/ecrire/inc/selectionner.php
spip/ecrire/inc/signatures.php
spip/ecrire/inc/tourner.php
spip/ecrire/install/etape_4.php