[SOLVED] Table in mysql for pyramid

Table in mysql for pyramid_beaker session

what columns are need to defined in mysql for storing session using pyramid_beaker?

session.type=ext:database
session.secret=someThingReallyReallySecret
session.cookie_expires=true
session.key=WhatEver
session.url=mysql://user:password@host/database
session.timeout=3000
session.lock_dir=%(here)s/var/lock

as it doesn't give any clue.

Solution

Beaker will create the table itself if it hasn't been created already when it's first invoked.

You can see the code (and the columns it'll create) in the ext/database.py source file

cache = sa.Table(table_name, meta,
                 sa.Column('id', types.Integer, primary_key=True),
                 sa.Column('namespace', types.String(255), nullable=False),
                 sa.Column('accessed', types.DateTime, nullable=False),
                 sa.Column('created', types.DateTime, nullable=False),
                 sa.Column('data', types.PickleType, nullable=False),
                 sa.UniqueConstraint('namespace'),
                 schema=schema_name if schema_name else meta.schema
        ):