Hello people please i need a quick help this is my py file:
class gestion_eleve(osv.osv):
_name = "gestion.eleve"
_rec_name= "nome"
_description = "Table des eleves"
_order = "nome asc"
_columns = {
'nume': fields.char('Num Eleve',required=True),
'nome': fields.char('Nom',required=True),
'group_id': fields.many2one('gestion.groupe','Groupe',ondelete='cascade'),
'anneescolaire': fields.char('Année Scolaire'),
'prenom': fields.char('Prénom'),
'daten': fields.date('Date Naissance'),
'lieunaissance': fields.char('Lieu de Naissance'),
'adresse': fields.char('Adresse'),
'niveau': fields.char('Niveau scolaire'),
'nompere': fields.char('Nom Père /Tuteur'),
'prenompere': fields.char('Prénom Père / Tuteur'),
'professionpere': fields.char('Profession Père / Tuteur'),
'telephonepere': fields.char('Téléphone Père / Tuteur'),
'emailpere': fields.char('Email Père / Tuteur'),
'nommere': fields.char('Nom Mère /Tuteur'),
'prenommere': fields.char('Prénom Mère / Tuteur'),
'professionmere': fields.char('Profession Mère / Tuteur'),
'telephonemere': fields.char('Téléphone Mère / Tuteur'),
'emailmere': fields.char('Email Mère / Tuteur'),
'image_small': fields.binary('Photo'),
'absence_ids' :fields.one2many('gestion.absence','eleve_id','Absences'),
'matiere_ids' :fields.many2many('gestion.matiere','note_rel','asso2_id','asso1_id','Matière'),
}
class gestion_matiere(osv.osv):
_name = "gestion.matiere"
_rec_name= "libelle"
_description = "Table des matieres"
_order = "numm asc"
_columns = {
'numm': fields.integer('Code matiére',required=True),
'libelle': fields.char('Libelle'),
'classe1_id': fields.many2one('gestion.classe','Classe',ondelete='cascade'),
'coef' : fields.integer('Coefficient matière'),
'prof_ids': fields.one2many('gestion.prof','matiere_id','Enseignants'),
'eleve_ids' :fields.many2many('gestion.eleve','note_rel','asso1_id','asso2_id','Elève'),
}
class gestion_note_matiere(osv.osv):
_name = "gestion.note.matiere"
_description = "table des notes"
_table = "note_rel"
_columns = {
'c1': fields.float('Controle 1'),
'c2': fields.float('Controle 2'),
'asso1_id': fields.many2one('gestion.matiere','Matière'),
'asso2_id': fields.many2one('gestion.eleve','Elève'),
'observation': fields.char('Observation'),
'note_general': fields.integer('Note/20'),
}
everithing ok when upgrading the module but when trying to get the list of the associative class i'm getting an error:
ProgrammingError: column note_rel.id does not exist LINE 1: SELECT "note_rel".id FROM "note_rel" ORDER BY "note_rel"."id...
1# remove this one _table = "note_rel"
because it's the same table used even if i changed the name i'm getting the same error message