ripoul commented on issue #5333: my model definition and table created don't 
match
URL: 
https://github.com/apache/incubator-superset/issues/5333#issuecomment-402631157
 
 
   I have to be an ass ; here my model : 
   ```
   class StructureBudgetaire(Model):
       __tablename__ = 'structure_budgetaire'
       numligne = Column(Integer, primary_key=True)
       imputation = Column(String(200))
       titre = Column(String(200))
       sousbudget = Column(String(100))
       regroupement = Column(String(100))
       journaux = Column(String(100))
       analytique = Column(String(100))
       cptessd = Column(String(200))
       cptessc = Column(String(200))
       cptesexclu = Column(String(200))
       type_budget = Column(String(2))
       budget = relationship('Budget', backref='structure_budgetaire', 
lazy=True)
   
   class Budget(Model):
       __tablename__ = 'budget'
       exercice = Column(Integer, primary_key=True)
       numligne = Column(Integer, ForeignKey('structure_budgetaire.numligne'), 
primary_key=True)
       mtbudget = Column(Float)
   ```
   
   I've created view to add/delete/show/edit my model (like you did with 
dashboard) but budget.numligne is not a list with all the 
StructureBudgetaire.numligne. it is not the purpose of a foreignKey ? or it's 
not automatic ? I'm missing something ?
   
   
       

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to