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()