def create_tag_article(tag_id, post_id):
db = DBSession()
p = ArticleTag(tag_id=tag_id, article_id=post_id)
db.add(p)
db.commit()
db.close()
return
def create_tag(tag_name):
db = DBSession()
p = Tag(name=tag_name)
db.add(p)
db.commit()
db.close()
return
def add_comment(text, date, user_id, post_id):
db = DBSession()
p = Comment(text=text, date=date, user_id=user_id, article_id=post_id)
db.add(p)
try:
db.commit()
status = True
except IntegrityError:
db.rollback()
status = None
db.close()
return status
def create_user(name, password):
try:
s = DBSession()
u = User(name=name, password=password)
s.add(u)
s.commit()
result = True
except:
s.rollback()
result = False
s.close()
return result
def create_redirection(owner_id, url):
print(owner_id, url)
s = DBSession()
r = Redirection(owner_id=owner_id, redirect_value=url)
r.redirect_hash = uuid4().hex
s.add(r)
try:
s.commit()
result = True
except IntegrityError:
s.rollback()
result = False
s.close()
return result
def post_create():
text = request.form.get("text").strip()
if text:
if 'user' in session:
db = DBSession()
p = Post(text=text, user_id=session['id'], timestamp=int(time()))
db.add(p)
db.commit()
print("-{}- kisisi post atti".format(session['user']))
else:
print("-{}- kisisi post atamadi".format(session['user']))
else:
print("Gecerli Post girin")
return redirect('/user/profile')
def create_user(email, password, fullname, userinfo="..."):
db = DBSession()
user = User(email=email,
password=password,
fullname=fullname,
userinfo=userinfo)
db.add(user)
try:
db.commit()
except IntegrityError:
print("Bu kullanıcı zaten var")
db.rollback()
user = None
data = user.to_dict() if user else None
db.close()
return data
def create_user(email):
data = get_user(email)
if not data:
print('Yeni kullanıcı eklendi')
db = DBSession()
user = User(email=email)
db.add(user)
try:
db.commit()
except IntegrityError:
print('Veritabanı commit esnasında hata oluştu')
db.rollback()
user = None
data = user.to_dict() if user else None
db.close()
return data
def create_todo(data):
db_session = DBSession()
new_todo = Todo(title=data['title'],
content=data['content'],
due_date=data['due_date'],
checked=data['checked'],
user_id=data['user_id'])
db_session.add(new_todo)
db_session.commit()
new_todo = new_todo.to_dict()
db_session.close()
print('todo oluşturuldu.', new_todo['id'])
return new_todo
def create_user(data):
db_session = DBSession()
user = db_session.query(User).filter(User.email == data['email']).first()
if user:
abort(404, 'bu email kullanılmış.')
else:
password = sha512(data['password'].encode('utf-8')).hexdigest()
new_user = User(username=data['username'],
email=data['email'],
password=password)
try:
db_session.add(new_user)
db_session.commit()
result = [new_user.to_dict()]
except:
db_session.rollback()
result = {'status': 'error'}
db_session.close()
print('user oluşturuldu')
return result
def add_question(question, answer1, answer2, answer3, answer4, answer5,
true_answer):
db = DBSession()
question = Question(question=question,
answer1=answer1,
answer2=answer2,
answer3=answer3,
answer4=answer4,
answer5=answer5,
true_answer=true_answer)
db.add(question)
try:
db.commit()
except IntegrityError:
print('Veritabanı commit esnasında hata oluştu')
db.rollback()
question = None
data = question.to_dict() if question else None
db.close()
return data
def bootstrap(app):
from app.models import DBSession, Company, User
user = User(document=1128417376, name=u'Willington Vega', email=u'*****@*****.**', password=u'password')
company = Company.create(nit=9003671435, name=u'Inv. Sinapsis S.A.S', user=user)
DBSession.add(user)
DBSession.add(company)
DBSession.commit()
# environ = {
# 'path': '/company/create',
# 'method': 'POST',
# 'data': {
# 'nit': '9003671435',
# 'name': 'Inv. Sinapsis S.A.S',
# 'document': '1128417376',
# 'username': '******',
# 'email': '*****@*****.**',
# 'password': '******',
# 'confirm': 'password'
# }
# }
def new_user():
username = request.form.get("username").strip()
password = request.form.get("password").strip()
# Database icin bir session oluşturuldu.
db = DBSession()
exists = db.query(User).filter(User.username == username).first()
if not exists:
u = User(username=username,
password=password,
status=1)
db.add(u)
db.commit()
u = db.query(User).filter(User.username == username).first()
session['id'] = u.id
print(u.id)
session['user'] = username
db.close()
print("{} kisisi kaydoldu".format(session['user']))
else:
print("\'{}\' kisisi zaten var".format(username))
db.close()
return redirect('/')
