def InsertUser(self): user = Users(nickname=self.clear_author) try: db.add(user) db.commit() except sqlalchemy.exc.IntegrityError: db.rollback()
def InsertCompany(self): if self.isblog: try: company = Company(company_name=self.company_name) db.add(company) db.commit() except sqlalchemy.exc.IntegrityError: db.rollback()
def InsertPH(self): post_id = db.query(Posts).filter( Posts.post_id == self.post_id).one().id for tag in self.clear_hubs: hub_id = db.query(Hubs).filter(Hubs.hub == tag).one().id hubs_post = HubsPosts(post_id=post_id, hub_id=hub_id) db.add(hubs_post) db.commit()
def InsertHubs(self): for tag in self.clear_hubs: hub = Hubs(hub=tag) try: db.add(hub) db.commit() except sqlalchemy.exc.IntegrityError: db.rollback()
def InsertPC(self): if self.isblog: company_id = db.query(Company).filter( Company.company_name == self.company_name).one().id post_id = db.query(Posts).filter( Posts.post_id == self.post_id).one().id post_company = CompanyPosts(company_id=company_id, post_id=post_id) db.add(post_company) db.commit()
def InsertPost(self): author_id = db.query(Users).filter( Users.nickname == self.clear_author).one().id post = Posts( post_id=self.post_id, title=self.clear_title, view=self.clear_views, author=author_id, isblog=self.isblog, post_date=self.clear_date) try: db.add(post) db.commit() except sqlalchemy.exc.IntegrityError: db.rollback()