Coding with Flask and SQLAlchemy
16 May 2011
On my previous post, I’ve been working with Flask,SQLAlchemy, and Gnunicorn for some REST API.
Setting up virtualenv with the following pip requirements.
Flask==0.6.1 Flask-SQLAlchemy==0.11 Jinja2==2.5.5 LEPL==5.0.0 MySQL-python==1.2.3 SQLAlchemy==0.6.6 Werkzeug==0.6.2 distribute==0.6.10 gevent==0.13.4 greenlet==0.3.1 gunicorn==0.12.1 lockfile==0.9.1 wsgiref==0.1.2 yolk==0.4.1
The model.py:
from flask import Flask
from flaskext.sqlalchemy import SQLAlchemy
from sqlalchemy import Table, Column, Integer, String, Date, Float
import config
# DB class
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = config.DB_URI
db = SQLAlchemy(app)
# DB classess
class Player(db.Model):
__tablename__ = 'player'
playerid = db.Column('playerid', Integer, primary_key=True)
username = db.Column('username', String(30), unique=True)
email = db.Column('email', String(50), unique=True)
password = db.Column('password', String(100), unique=False)
avatarid = db.Column('avatarid', Integer,default=1)
language = db.Column('language', Integer,default=1)
regdate = db.Column('regdate', Date)
activation_key = db.Column('activation_key', String(60))
active = db.Column('active', Integer, default=0)
def __init__(self, username=None, email=None,password=None):
self.username = username
self.email = email
self.password = password
def __repr__(self):
return '<Player %s %s>' % (self.username, self.email)