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