Exemplo n.º 1
0
import caching_query
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from beaker import cache
import os

# Beaker CacheManager.  A home base for cache configurations.
cache_manager = cache.CacheManager()

# scoped_session.  Apply our custom CachingQuery class to it,
# using a callable that will associate the cache_manager
# with the Query.
Session = scoped_session(
                sessionmaker(
                    query_cls=caching_query.query_callable(cache_manager)
                )
            )

# global declarative base class.
Base = declarative_base()


root = "./beaker_data/"

if not os.path.exists(root):
    raw_input("Will create datafiles in %r.\n"
                "To reset the cache + database, delete this directory.\n"
                "Press enter to continue.\n" % root
                )
    os.makedirs(root)
Exemplo n.º 2
0
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from dogpile.cache.region import make_region
import os
import md5

# dogpile cache regions.  A home base for cache configurations.
regions = {}


# scoped_session.  Apply our custom CachingQuery class to it,
# using a callable that will associate the dictionary
# of regions with the Query.
Session = scoped_session(
                sessionmaker(
                    query_cls=caching_query.query_callable(regions)
                )
            )

# global declarative base class.
Base = declarative_base()

root = "./dogpile_data/"

if not os.path.exists(root):
    raw_input("Will create datafiles in %r.\n"
                "To reset the cache + database, delete this directory.\n"
                "Press enter to continue.\n" % root
                )
    os.makedirs(root)
Exemplo n.º 3
0

if config['DBCACHE_SVR']:
    import dogpile.cache
    import caching_query
    cache_region = dogpile.cache.make_region()
    cache_settings = {
        "cache.redis.backend": "dogpile.cache.redis",
        "cache.redis.arguments.host": config['DBCACHE_SVR'],
        "cache.redis.arguments.port": 6379,
    }
    cache_region.configure_from_config(cache_settings, "cache.redis.")
    cache_regions = {"default": cache_region}
    FromCache = caching_query.FromCache
    DB_Session = scoped_session(sessionmaker(
        bind=engine, query_cls=caching_query.query_callable(cache_regions)))

else:
    class FromCache(MapperOption):
        pass

    DB_Session = scoped_session(sessionmaker(bind=engine))


# 考虑更灵活的login机制,如login_required("student","teacher") 可以只让学生和老师登陆
def login_required(user_type="any"):
    """Decorate methods with this to require that the user be logged in."""
    def decorator(method):
        @functools.wraps(method)
        def wrapper(self, *args, **kwargs):
            if not self.current_user:
Exemplo n.º 4
0
"""
import caching_query
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from beaker import cache
import os

# Beaker CacheManager.  A home base for cache configurations.
cache_manager = cache.CacheManager()

# scoped_session.  Apply our custom CachingQuery class to it,
# using a callable that will associate the cache_manager
# with the Query.
Session = scoped_session(
    sessionmaker(query_cls=caching_query.query_callable(cache_manager)))

# global declarative base class.
Base = declarative_base()

root = "./beaker_data/"

if not os.path.exists(root):
    raw_input("Will create datafiles in %r.\n"
              "To reset the cache + database, delete this directory.\n"
              "Press enter to continue.\n" % root)
    os.makedirs(root)

dbfile = os.path.join(root, "beaker_demo.db")
engine = create_engine('sqlite:///%s' % dbfile, echo=True)
Session.configure(bind=engine)
import os
from hashlib import md5
import sys
py2k = sys.version_info < (3, 0)

if py2k:
    input = raw_input

# dogpile cache regions.  A home base for cache configurations.
regions = {}

# scoped_session.  Apply our custom CachingQuery class to it,
# using a callable that will associate the dictionary
# of regions with the Query.
Session = scoped_session(
    sessionmaker(query_cls=caching_query.query_callable(regions)))

# global declarative base class.
Base = declarative_base()

root = "./dogpile_data/"

if not os.path.exists(root):
    input("Will create datafiles in %r.\n"
          "To reset the cache + database, delete this directory.\n"
          "Press enter to continue.\n" % root)
    os.makedirs(root)

dbfile = os.path.join(root, "dogpile_demo.db")
engine = create_engine('sqlite:///%s' % dbfile, echo=True)
Session.configure(bind=engine)
Exemplo n.º 6
0
from sqlalchemy.orm import backref
from sqlalchemy.orm import joinedload
import sqlalchemy as sa

from caching_query import FromCache
from caching_query import RelationshipCache
from caching_query import query_callable

from dogpile.cache import make_region

import hashlib
cache_region = make_region()

regions = {"default": cache_region}

DBSession = scoped_session(sessionmaker(query_cls=query_callable(regions)))


def md5_key_mangler(key):
    """Receive cache keys as long concatenated strings;
    distill them into an md5 hash.

    """
    d = hashlib.md5(key.encode('utf-8'))
    return d.hexdigest()


class BaseModel(object):
    @declared_attr
    def pk(self):
        return sa.Column(sa.Integer, primary_key=True)