Pyramid

Pyramid with postgresql and SQLAlchemy
Requirements

• Pip
• PostgreSQL
• Virtualenv (optional VirtualenvWrapper)
• SQLAlchemy (sudo apt-get install python-dev && pip install SQLAlchemy)

Install

easy_install "pyramid==1.6.1" 

or

sudo apt-get install python-pyramid

Create proyect

pcreate --list # shows options
pcreate -s alchemy indeed

run development server

pserve development.ini

Postgresql database config

in production.ini and development.in set:

sqlalchemy.url = postgresql://user:password@host/indeed

Migrations

from project folder:

initialize_proyectname_db

Insert into db script

import sys
from models import Rooms, DBSession
from sqlalchemy import engine_from_config
from pyramid.paster import get_appsettings, setup_logging

from sqlalchemy.orm import (
    scoped_session,
    sessionmaker,
    )
from zope.sqlalchemy import ZopeTransactionExtension

config_uri = '../development.ini'
setup_logging(config_uri)
engine = engine_from_config(get_appsettings(config_uri), 'sqlalchemy.')

Session = sessionmaker(bind=engine)
session = Session()

try:
    a = int(sys.argv[1])
except:
    print "Parametro erroneo, debe especificar id numerico", sys.argv
    exit()

new = Rooms(id=a)

try:
    session.add(new)
    session.commit()
    print "Insertada Room", new.id

except Exception as e:
    print "Error insertando Room {romid}: {error}".format(romid=new.id, error=e)
finally:
    session.close()