Author: esj@rezo.net
Date: 2007-10-04 11:45:26 +0200 (jeu, 04 oct 2007)
New Revision: 10504
Log:
Abstraction des clauses avec WHERE, GROUP BY et ORDER BY, sans HAVING ni LIMIT
Dépot obtenu par:
{{{
for i in $(grep -l 'spip_query..SELECT.*FROM.*WHERE[^HYL]*BY[^HYL]*BY[^GL]*; *$' [a-i]*/*php|grep -v inc/meta.php)
do
echo $i
sed 's/spip_query..SELECT *\(.*[^ ]\) *FROM *\(.*[^ ]\) *WHERE *\([^HYL]*\)GROUP BY\([^HYL]*\)ORDER BY\([^GL]*;\)$/sql_select("\1", "\2", "\3", "\4", "\5/;s/ "" *\.//;s/ch(sql_select\(.*\));/sel\1;/' $i > x
mv x $i
done
}}}
Modified:
spip/ecrire/action/ical.php
spip/ecrire/action/rss.php
spip/ecrire/exec/auteurs.php
spip/ecrire/exec/brouteur_frame.php