Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/batch/questions/compute_latest.sh

    r1293 r1575  
    1616  sql_string='SELECT source FROM question_ecrite WHERE reponse = "" AND motif_retrait IS NULL'
    1717else
    18   sql_string='SELECT source FROM question_ecrite WHERE reponse = "" AND motif_retrait IS NULL AND date > DATE_SUB(CURDATE(), INTERVAL 75 DAY)'
     18  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))'
    1919fi
    2020echo $sql_string | mysql $MYSQLID $DBNAME | grep -v source > liste_sans_reponse.txt
  • cpc/trunk/project/batch/questions/download_questions_old.pl

    r1130 r1575  
    4343print $count." questions récentes\n\n";
    4444
    45 open(FILE, 'liste_sans_reponse.txt') ;
     45open(FILE, 'liste_sans_reponse.txt');
    4646@string = <FILE>;
    4747$string = "@string";
Note: See TracChangeset for help on using the changeset viewer.