def __init__(self, **options):
        verifier = options.pop("verifier", None)
        if verifier is None:
            verifier = vep.RemoteVerifier()
        else:
            verifier = maybe_resolve_name(verifier)
            if callable(verifier):
                verifier = verifier()
        self._verifier = verifier

        #sqlkw = {'pool_size': int(options.get('pool_size', 1)),
        #         'pool_recycle': int(options.get('pool_recycle', 3600)),
        #         'logging_name': 'appsync'}
        sqlkw = {}

        self.engine = create_engine(options['sqluri'], **sqlkw)
        for table in _TABLES:
            table.metadata.bind = self.engine
            if options.get('create_tables', True):
                table.create(checkfirst=True)

        self.session_ttl = int(options.get('session_ttl', '300'))
        cache_options = {
            'servers': options.get('cache_servers', '127.0.0.1'),
            'prefix': options.get('cache_prefix', 'appsyncsql')
        }

        self.cache = Cache(**cache_options)
        self.authentication = True
 def __init__(self, store_url, appid, **kwds):
     cache_activated = kwds.pop('cache_activated', False)
     if cache_activated:
         cache_options = {
             'servers': kwds.pop('cache_servers', '127.0.0.1'),
             'prefix': kwds.pop('cache_prefix', 'appsyncsauropod')
         }
         self.cache_ttl = kwds.pop('cache_ttl', 300)
         self.cache = Cache(**cache_options)
     else:
         self.cache = self.cache_ttl = None
     self._store = pysauropod.connect(store_url, appid, **kwds)
     self.authentication = True