Exemplo n.º 1
0
    def test_session_in_db(self):
        request.app_name = 'myapp'
        db = DAL('sqlite:memory')
        session = Session(secret="a", expiration=10, storage=DBStore(db))
        request.cookies.clear()
        session.on_request()
        session['key'] = 'value'
        session.on_success()
        cookie_name = session.local.session_cookie_name

        a, b = str(
            response._cookies)[len('Set-Cookie: '):].split(';')[0].split(
                '=', 1)
        request.cookies[a] = b
        request.cookies = response._cookies
        session.local.data.clear()

        session = Session(expiration=10, storage=DBStore(db))
        session.on_request()
        self.assertEqual(session.get('key'), 'value')

        request.cookies[a] = 'wrong_cookie'
        session = Session(expiration=10, storage=DBStore(db))
        session.on_request()
        self.assertEqual(session.get('key'), None)
Exemplo n.º 2
0
import os
from web3py import DAL, Field
from . import settings

db = DAL(settings.DB_URI,
         folder=settings.DB_FOLDER,
         pool_size=settings.DB_POOL_SIZE)

### Define you table below
#
# db.define_table('thing', Field('name'))
#
Exemplo n.º 3
0
import os
from web3py import action, request, DAL, Field, Session, Cache, user_in

# define session and cache objects
session = Session(secret='some secret')
cache = Cache(size=1000)

# define database and tables
db = DAL('sqlite://storage.db', folder=os.path.join(os.path.dirname(__file__), 'databases'))
db.define_table('todo', Field('info'))

# example index page using session, template and vue.js
@action('index')         # the function below is exposed as a GET action 
@action.uses('index.html')          # we use the template index.html to render it
@action.uses(session)               # action needs a session object (read/write cookies)
def index():
    session['counter'] = session.get('counter', 0) + 1
    session['user'] = {'id': 1}     # store a user in session
    return dict(session=session)

# example of GET/POST/DELETE RESTful APIs

@action('api')                      # a GET API function
@action.uses(session)               # we load the session
@action.requires(user_in(session))  # then check we have a valid user in session
@action.uses(db)                    # all before starting a db connection
def todo():
    return dict(items=db(db.todo).select(orderby=~db.todo.id).as_list())

@action('api', method='POST')
@action.uses(session)
Exemplo n.º 4
0
import os
from web3py import DAL, Field
db = DAL('sqlite://test', folder=os.path.join(os.path.dirname(__file__), 'databases'))
db.define_table('thing', Field('name'))
Exemplo n.º 5
0
import os
from web3py import action, request, DAL, Field, Session, Cache, user_in

# define session and cache objects
session = Session(secret='some secret')
cache = Cache(size=1000)

# define database and tables
db = DAL('sqlite://storage.db', folder=os.path.join(os.path.dirname(__file__), 'databases'))
db.define_table('todo', Field('info'))

# example index page using session, template and vue.js
@action('index')         # the function below is exposed as a GET action 
@action.uses('index.html')          # we use the template index.html to render it
@action.uses(session)               # action needs a session object (read/write cookies)
def index():
    session['counter'] = session.get('counter', 0) + 1
    session['user_id'] = 1          # store a user in session
    return dict(session=session)

# example of GET/POST/DELETE RESTful APIs

@action('api')           # a GET API function
@action.uses(session)               # we load the session
@action.requires(user_in(session))  # then check we have a valid user in session
@action.uses(db)                    # all before starting a db connection
def todo():
    return dict(items=db(db.todo).select(orderby=~db.todo.id).as_list())

@action('api', method='POST')
@action.uses(session)
Exemplo n.º 6
0
import multiprocessing
import os
import time
import unittest
import uuid

import mechanize

from web3py import action, DAL, Field, Session, Cache
from web3py.core import bottle

os.environ['WEB3PY_APPS_FOLDER'] = os.path.sep.join(
    os.path.normpath(__file__).split(os.path.sep)[:-2])

db = DAL('sqlite://storage_%s' % uuid.uuid4(), folder='/tmp/')
db.define_table('thing', Field('name'))
session = Session(secret='my secret')
cache = Cache()


@action('index')
@cache.memoize(expiration=1)
@action.uses(db, session)
def index():
    db.thing.insert(name='test')
    session['number'] = session.get('number', 0) + 1
    return 'ok %s %s' % (session['number'], db(db.thing).count())


class CacheAction(unittest.TestCase):
    def setUp(self):
Exemplo n.º 7
0
from web3py import DAL, Field, expose, tag, cat, safe, HTTP, url, Form, DALForm, current
from web3py.session import SessionCookieManager
from web3py.dal import Transact
from web3py.validators import IS_NOT_EMPTY

db = DAL('sqlite://storage.test')
db.define_table('person',Field('name',requires=IS_NOT_EMPTY()))

expose.common_cleaners = [SessionCookieManager('test'),Transact(db)]

@expose()
def index():
    form = Form(Field('name',requires=IS_NOT_EMPTY()),
                Field('area','text'),
                Field('check','boolean',default=True),
                Field('age','integer',comment='Try type in a number!'),
                Field('weight','double'),
                Field('a','time'),
                Field('b','date'),
                Field('c','datetime')).process()
    message = form.vars.name or ''
    return locals()

@expose()
def error():
    return 1/0

@expose()
def counter():
    current.session.counter = (current.session.counter or 0)+1
    return current.session.counter
Exemplo n.º 8
0
import os
from web3py import DAL, Field 

# define database and tables
db = DAL('sqlite://storage.db', folder=os.path.join(os.path.dirname(__file__), 'databases'))

db.define_table(
    'person',
    Field('name'),
    Field('job'))

db.define_table(
    'superhero',
    Field('name'),
    Field('real_identity', 'reference person'))

db.define_table(
    'superpower',
    Field('description'))

db.define_table(
    'tag',
    Field('superhero', 'reference superhero'),
    Field('superpower', 'reference superpower'),
    Field('strength', 'integer'))

if not db(db.person).count():
    db.person.insert(name='Clark Kent', job='Journalist')
    db.person.insert(name='Peter Park', job='Photographer')
    db.person.insert(name='Bruce Wayne', job='CEO')
    db.superhero.insert(name='Superman', real_identity=1)
Exemplo n.º 9
0
from web3py import DAL, Field, expose, tag, cat, safe, HTTP, url, Form, DALForm, current
from web3py.session import SessionCookieManager
from web3py.dal import Transact
from web3py.validators import IS_NOT_EMPTY

db = DAL("sqlite://storage.test")
db.define_table("person", Field("name", requires=IS_NOT_EMPTY()))

expose.common_cleaners = [SessionCookieManager("test"), Transact(db)]


@expose()
def index():
    form = Form(
        Field("name", requires=IS_NOT_EMPTY()),
        Field("area", "text"),
        Field("check", "boolean", default=True),
        Field("age", "integer", comment="Try type in a number!"),
        Field("weight", "double"),
        Field("a", "time"),
        Field("b", "date"),
        Field("c", "datetime"),
    ).process()
    message = form.vars.name or ""
    return locals()


@expose()
def error():
    return 1 / 0