when i use relationship
my add session will fail
is it need do some else to map there's connection?
plaese help me
flask route code:
@app.route('/company/<business_account_number>/<address>/<company_status>/<company_captial_amount>/<business_description>/<company_name>',
methods=['POST'])
def
new_company_generation(business_account_number,address,company_status,company_captial_amount,business_description,company_name):
try:
company = Company()
company.create_new_company(business_account_number,address,company_status,company_captial_amount,business_description,company_name)
return "Success!"
except Exception:
return "Failed!"
this is my table code:
class CompanyEntity(base):
#Table name
__tablename__ = 'Company'
#Primary key column
CompanyId = Column("CompanyId", Integer, primary_key=True)
BusinessAccountNumber = Column("BusinessAccountNumber", String(8))
Address = Column("Address", String(100))
CompanyStatus = Column("CompanyStatus", Integer)
CompanyCapitalAmount = Column("CompanyCapitalAmount", Integer)
BusinessDescription = Column("BusinessDescription", String(150))
CreateDatetime = Column("CreateDatetime", DateTime(timezone=True))
ModifyDatetime = Column("ModifyDatetime", DateTime(timezone=True))
ModifyBy = Column("ModifyBy", String(255))
CompanyName = Column("CompanyName", String(50))
Clerk = relationship("ClerkEntity")
Product = relationship("ProductEntity")
Logo = relationship("CompanyLogoEntity")
Edm = relationship("CompanyEDMEntity")
Announcement = relationship("CompanyAnnouncementEntity")
Activity = relationship("CompanyActivityEntity")
AllianceProductMap = relationship("CompanyAllianceProductMapEntity")
CustomerFeedBack = relationship("CustomerFeedbackEntity")
CashCoupon = relationship("CashCouponEntity")
GroupBuyingRequest = relationship("GroupBuyingRequestEntity")
CompanyCustomerList = relationship("CompanyCustomerListEntity")
CustomerSegmentGroup = relationship("CustomerSegmentGroupEntity")
MarketingPlan = relationship("MarketingPlanEntity")
ShoppingCar = relationship("ShoppingCarEntity")
CompanyAllianceRequest = relationship("CompanyAllianceRequestEntity")
CompanyStory = relationship("CompanyStoryEntity",
backref="CompanyStory", uselist=False)
CompanyBusinessItemList = relationship("CompanyBusinessItemListEntity")
CompanyAllianceMap = relationship("CompanyAllianceMapEntity")
Order = relationship("OrderEntity")
this is my session code:
def
create_new_company(self,business_account_number,address,company_status,company_captial_amount,business_description,company_name
):
self.session = super(Company, self).get_session()
last_company_id =
self.session.query(CompanyEntity.CompanyId).order_by(CompanyEntity.CompanyId.desc()).first()
new_company_id = last_company_id[0] + 1
new_company = CompanyEntity(CompanyId=new_company_id,
BusinessAccountNumber=business_account_number, Address=address,
CompanyStatus=company_status, CompanyCapitalAmount=company_captial_amount,
BusinessDescription=business_description, CreateDatetime=datetime.now(),
ModifyDatetime=None, ModifyBy=None, CompanyName=company_name)
self.session.add(new_company)
self.session.flush()
self.session.commit()
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
