# encoding: utf8 ## импортируем пути что бы видеть globals/ import py_path # Движек работы с базой, get_db_session вернет созданную сессию: from utils.db import get_db_session # Наша модель: from models.testmodel.sa_models import Test as TestModel if __name__ == "__main__": ## Получим сессию: session = get_db_session(echo=True) ## Выведем все записи из TestModel (используется slave): # print session.query(TestModel).all() lll = session.query(TestModel).all() # lll = session.query(TestModel).filter(TestModel.name=='test1') # lll = session.query(TestModel.id).scalar() print(type(lll[0])) print(lll) print(lll[0].name) for instance in lll: print(instance.name, instance.descr) ## Используя "master" удалим все записи: print session.using_bind('master').query(TestModel).delete() ## using_bind возвращает себя(Session), и ставит настройку
def session(cls): return get_db_session()
import logging import time, datetime from flask import abort, url_for, session as session from flaskcbv.response import Response, ResponseRedirect from gsettings import settings as global_settings from utils.db import get_db_session from models.users.sa_models import Users as UsersModel from models.groups.sa_models import Groups as GroupsModel from models.users_groups.sa_models import UsersGroups db_session = get_db_session(echo=False) from .sessions import Sessions class authMixin(object): def check_session(self): ## Allready checked: if hasattr(self.request, 'user') and self.request.user is not None: return True ## First of all, check user by session: session_ = 'session' in session.keys() and session['session'] or None uid = Sessions.check(session_) if uid is not None: user = db_session.query(UsersModel).filter( UsersModel.id == uid).first()
def objects(cls): """ :rtype : sqlalchemy.orm.query.Query """ return get_db_session().query(cls)
def get_user_seminars_query(cls, uid): db_session = get_db_session(echo=False) return db_session.query(cls).filter(cls.user_id == uid)
published="") book_rye = Book.insert(book_rye) print(book_rye.id) # update book_rye.price = 1200 book_rye.save() # delete book_rye.delete() # select print(Book.get(1)) book = get_db_session().query(Book).filter().all() print(book) book = get_db_session().query(Book).filter(Book.price == 122222).all() print(book) book = Book.objects().filter(Book.price == 122222).all() print(book) print(Book.objects().filter(Book.id == 1, Book.price != 1).all()) # insert book = Book(title="", price=123, publish="", published="") obj = Book.insert(book) print(obj.id)