예제 #1
0
def create_etat_civil(row):
    """Read an excel row and save the corresponding EtatCivil object in database"""
    errors = []
    ec = EtatCivil()
    ec.nom_insa = row['nom_insa'].capitalize()
    ec.nom_actuel = row['nom_actuel'].capitalize()
    ec.prenom = row['prenom'].capitalize()
    ec.num_etudiant = row['num_etudiant']
    ec.sexe = row['sexe'].upper()
    ec.date_naissance = datetime(
        *[int(i) for i in row['date_de_naissance'].split("/")][::-1])
    try:
        ec.nationalite = Pays.objects.get(nom=unicode(row['nationalite']))
    except Pays.DoesNotExist:
        ec.nationalite = Pays(nom=unicode(row['nationalite']))
    ec.adresse_1 = row['adresse_1_(personnelle)']
    ec.zip_adresse_1 = row['code_postal_1']
    ec.adresse_2 = row['adresse_2_(parentale)']
    ec.zip_adresse_2 = row['code_postal_2']
    ec.email_1 = row['email_1']
    ec.email_2 = row['email_2']
    try:
        ec.full_clean()
    except ValidationError, e:
        m = dict(e.message_dict)
        errors.append([
            str("%s %s" % (ec.prenom, ec.nom_insa)),
            [list(k) for k in zip(m.keys(), m.values())]
        ])
예제 #2
0
파일: views.py 프로젝트: brouberol/BS-BDD
def create_etat_civil(row):
    """Read an excel row and save the corresponding EtatCivil object in database"""
    errors = []
    ec = EtatCivil()
    ec.nom_insa = row['nom_insa'].capitalize()
    ec.nom_actuel = row['nom_actuel'].capitalize()
    ec.prenom =row['prenom'].capitalize()
    ec.num_etudiant = row['num_etudiant']
    ec.sexe = row['sexe'].upper()
    ec.date_naissance = datetime(*[int(i) for i in row['date_de_naissance'].split("/")][::-1])
    try:
        ec.nationalite = Pays.objects.get(nom=unicode(row['nationalite']))
    except Pays.DoesNotExist:
        ec.nationalite = Pays(nom=unicode(row['nationalite']))
    ec.adresse_1 = row['adresse_1_(personnelle)']
    ec.zip_adresse_1 = row['code_postal_1']
    ec.adresse_2 = row['adresse_2_(parentale)']
    ec.zip_adresse_2 = row['code_postal_2']
    ec.email_1 = row['email_1']
    ec.email_2 = row['email_2']
    try:
        ec.full_clean()
    except ValidationError, e:
        m = dict(e.message_dict)
        errors.append([str("%s %s"%(ec.prenom, ec.nom_insa)), [list(k) for k in zip(m.keys(),m.values())]])
예제 #3
0
파일: tests.py 프로젝트: brouberol/BS-BDD
 def setUp(self):
     ec = EtatCivil(nom_insa='Test')
     ec.nom_actuel = 'Test'
     ec.prenom = "Test"
     ec.num_etudiant = '26760'
     ec.sexe = 'F'
     ec.date_naissance = datetime.date(1960, 11, 4)
     ec.nationalite = 'Fr'
     ec.adresse_1 = 'adresse test 1'
     ec.zip_adresse_1 = '21897'
     ec.adresse_2 = 'adresse test 2'
     ec.zip_adresse_2 = '60410'
     ec.email_1 = 'email test 1'
     ec.email_2 = 'email test 2'
     ec.save()
예제 #4
0
파일: tests.py 프로젝트: brouberol/BS-BDD
 def setUp(self):
     ec = EtatCivil(nom_insa='Test')
     ec.nom_actuel = 'Test'
     ec.prenom = "Test"
     ec.num_etudiant = '26760'
     ec.sexe = 'F'
     ec.date_naissance = datetime.date(1960, 11, 4)
     ec.nationalite = 'Fr'
     ec.adresse_1 = 'adresse test 1'
     ec.zip_adresse_1 = '21897'
     ec.adresse_2 = 'adresse test 2'
     ec.zip_adresse_2 = '60410'
     ec.email_1 = 'email test 1'
     ec.email_2 = 'email test 2'
     ec.save()
예제 #5
0
파일: tests.py 프로젝트: brouberol/BS-BDD
    def test_create_etat_civil(self):
        """ Save/Get testing """
        ec = EtatCivil(nom_insa='Bidochon')
        ec.nom_actuel = 'Galopin'
        ec.prenom = "Raymonde"
        ec.num_etudiant = '2676'
        ec.sexe = 'F'
        ec.date_naissance = datetime.date(1967, 11, 4)
        ec.nationalite = 'Fr'
        ec.adresse_1 = '2 rue de la bidoche'
        ec.zip_adresse_1 = '21897'
        ec.adresse_2 = '4 rue de la tranche de mortadelle'
        ec.zip_adresse_2 = '60410'
        ec.email_1 = '*****@*****.**'
        ec.email_2 = '*****@*****.**'
        ec.save()

        # ec exists in DB ?
        self.assertNotEqual(ec.id, 0)

        # can we retrieve ec in DB ?
        ec_id = ec.id
        ec = None
        ec = EtatCivil.objects.get(nom_insa='Bidochon')
        self.assertEqual(ec.id, ec_id)
        self.assertEqual(ec.nom_actuel, 'Galopin')
        self.assertEqual(ec.prenom, 'Raymonde')
        self.assertEqual(ec.num_etudiant, long(2676))
        self.assertEqual(ec.sexe, 'F')
        self.assertEqual(ec.date_naissance, datetime.date(1967, 11, 4))
        self.assertEqual(ec.nationalite, 'Fr')
        self.assertEqual(ec.adresse_1, '2 rue de la bidoche')
        self.assertEqual(ec.zip_adresse_1, long(21897))
        self.assertEqual(ec.adresse_2, '4 rue de la tranche de mortadelle')
        self.assertEqual(ec.zip_adresse_2, long(60410))
        self.assertEqual(ec.email_1, '*****@*****.**')
        self.assertEqual(ec.email_2, '*****@*****.**')
예제 #6
0
파일: tests.py 프로젝트: brouberol/BS-BDD
    def test_create_etat_civil(self):
        """ Save/Get testing """
        ec = EtatCivil(nom_insa='Bidochon')
        ec.nom_actuel = 'Galopin'
        ec.prenom = "Raymonde"
        ec.num_etudiant = '2676'
        ec.sexe = 'F'
        ec.date_naissance = datetime.date(1967, 11, 4)
        ec.nationalite = 'Fr'
        ec.adresse_1 = '2 rue de la bidoche'
        ec.zip_adresse_1 = '21897'
        ec.adresse_2 = '4 rue de la tranche de mortadelle'
        ec.zip_adresse_2 = '60410'
        ec.email_1 = '*****@*****.**'
        ec.email_2 = '*****@*****.**'
        ec.save()

        # ec exists in DB ?
        self.assertNotEqual(ec.id, 0)

        # can we retrieve ec in DB ?
        ec_id = ec.id     
        ec = None
        ec = EtatCivil.objects.get(nom_insa = 'Bidochon')
        self.assertEqual(ec.id, ec_id)
        self.assertEqual(ec.nom_actuel, 'Galopin')
        self.assertEqual(ec.prenom, 'Raymonde')
        self.assertEqual(ec.num_etudiant, long(2676))
        self.assertEqual(ec.sexe, 'F')
        self.assertEqual(ec.date_naissance, datetime.date(1967, 11, 4))
        self.assertEqual(ec.nationalite, 'Fr')
        self.assertEqual(ec.adresse_1, '2 rue de la bidoche')
        self.assertEqual(ec.zip_adresse_1, long(21897))
        self.assertEqual(ec.adresse_2, '4 rue de la tranche de mortadelle')
        self.assertEqual(ec.zip_adresse_2, long(60410))
        self.assertEqual(ec.email_1, '*****@*****.**')
        self.assertEqual(ec.email_2, '*****@*****.**')