TestsScoDoc7API/misc/count_inscriptions.py

44 lines
1.4 KiB
Python
Raw Permalink Normal View History

2020-09-26 16:19:37 +02:00
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""Affiche nombre d'inscriptions aux semestres pour chaque etudiant
et supprime les etudiants jamais inscrits ayant un homonyme exact
(erreur passage GEA, fev 2007)
"""
import pdb,os,sys,psycopg
import csv
DBCNXSTRING = 'host=localhost user=scogea dbname=SCOXXXX password=XXXXX'
SCO_ENCODING = 'utf-8'
cnx = psycopg.connect( DBCNXSTRING )
cursor = cnx.cursor()
cursor.execute("select * from identite i order by nom")
R = cursor.dictfetchall()
nzero = 0
nhomonoins = 0
print 'etudid, nom, prenom, nb_inscriptions'
for e in R:
cursor.execute("select count(*) from notes_formsemestre_inscription where etudid=%(etudid)s", { 'etudid' : e['etudid'] } )
nbins = cursor.fetchone()[0]
if nbins == 0:
nzero += 1
# recherche homonyme
cursor.execute("select * from identite i where nom=%(nom)s and prenom=%(prenom)s", e )
H = cursor.dictfetchall()
if len(H) == 2:
nhomonoins += 1
print e['etudid'], e['nom'], e['prenom'], nbins
# etudiant non inscrit ayant un homonyme exact:
# il doit etre supprimé !!!
#cursor.execute("delete from admissions where etudid=%(etudid)s", e)
#cursor.execute("delete from identite where etudid=%(etudid)s", e)
cnx.commit()
print '= %d etudiants, %d jamais inscrits, %d avec homo' % (len(R), nzero, nhomonoins)