]>
gitweb.pimeys.fr Git - scripts-20-100.git/blob - check_integrity.py
d0c49d958068bec876408be60336bbf352967c48
4 from commands
import getstatusoutput
as ex
7 req
="""SELECT numcbde,pseudo,gagne-perdu as calcul,effectif,effectif-(gagne-perdu) as a_enlever
9 (SELECT numcbde,pseudo,
10 (SELECT sum(montant*quantite)
12 WHERE destinataire=main.numcbde AND valide='t') as gagne,
13 (SELECT sum(montant*quantite)
15 WHERE emetteur=main.numcbde AND valide='t') as perdu,
17 FROM adherents WHERE numcbde=main.numcbde) as effectif
18 FROM adherents as main)
20 WHERE gagne-perdu!=effectif AND numcbde!=0 ORDER BY numcbde;"""
22 message
= "Vérification de l'intégrité\n"
23 integrite
=ex('psql bde -c "%s"'%(req))[1]
25 i
=integrite
.split()[-2]
28 message
+= "La base est intègre (sauf pour le compte du Bde)"
33 header
= "From: note-integrity@bde.crans.org\nTo: root\n"
34 header
+= "Subject: Integrity Check"+" ARG !"*oups
+"\n\n"
35 mailer
=os
.popen("/usr/sbin/sendmail -t", "w")
36 mailer
.write(header
+message
+'\n.')