[GitHub] ripoul removed a comment on issue #5333: my model definition and table created don't match

[GitBox <gi...@apache.org>]

ripoul removed a comment 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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org