Changeset 1575 for cpc/trunk/project/batch

Timestamp:

Oct 3, 2010, 4:32:37 PM (11 years ago)

Author:

roux

Message:

chopper le texte des questions des leur premier load ce sera mieux a priori :)

Location:

cpc/trunk/project/batch/questions

Files:

• compute_latest.sh (modified) (1 diff)
• download_questions_old.pl (modified) (1 diff)

cpc/trunk/project/batch/questions/compute_latest.sh

@@ -16 +16 @@
   sql_string='SELECT source FROM question_ecrite WHERE reponse = "" AND motif_retrait IS NULL'
 else
-  sql_string='SELECT source FROM question_ecrite WHERE reponse = "" AND motif_retrait IS NULL AND date > DATE_SUB(CURDATE(), INTERVAL 75 DAY)'
+  sql_string='SELECT source FROM question_ecrite WHERE question IS NULL OR (reponse = "" AND motif_retrait IS NULL AND date > DATE_SUB(CURDATE(), INTERVAL 75 DAY))'
 fi
 echo $sql_string | mysql $MYSQLID $DBNAME | grep -v source > liste_sans_reponse.txt

cpc/trunk/project/batch/questions/download_questions_old.pl

@@ -43 +43 @@
 print $count." questions récentes\n\n";
 
-open(FILE, 'liste_sans_reponse.txt') ;
+open(FILE, 'liste_sans_reponse.txt');
 @string = <FILE>;
 $string = "@string";