# 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)
def session(cls):
return get_db_session()
def objects(cls):
"""
:rtype : sqlalchemy.orm.query.Query
"""
return get_db_session().query(cls)
