On Fri, Jul 18, 2014 at 12:33 PM, 'Frank Liou' via sqlalchemy
<sqlalchemy@googlegroups.com> wrote:
> 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()
>
What error are you getting? Please send the full stack trace.
Thanks,
Simon
--
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
