import datetime
from flask.ext.sqlalchemy import SQLAlchemy
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker, scoped_session
from flask.ext.login import UserMixin
from board import app
config = ConfigParser.ConfigParser()
config.read("/home/luapz/public_html/do-lazy/config")
db_id = config.get('db', 'db_id')
db_password = config.get('db', 'db_password')
db_name = config.get('db', 'db_name')
app.config['SQLALCHEMY_DATABASE_URI'] = ('mysql://%s:%s@localhost/%s?charset=utf8' % (db_id, db_password, db_name))
db = SQLAlchemy(app)
db.echo=True
class SiteInfo(db.Model):
id = db.Column(db.Integer(), primary_key=True)
title = db.Column(db.Unicode(255))
slogan = db.Column(db.Unicode(255))
description = db.Column(db.Unicode(255))
class Board(db.Model):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.Unicode(255))
slogan = db.Column(db.Unicode(255))
description = db.Column(db.Unicode(255))
total_article_number = db.Column(db.Integer())
class Article(db.Model):
