def setup_database(db_file_path=settings.DB_FILE_PATH):
"""
Connect the database.
Create the database tables if they don't exists already.
"""
# import models here to avoid circular references
from models import BaseModel, Feed, FeedItem
BaseModel.db.connect()
Feed.create_table()
FeedItem.create_table()
def create_db():
logging.info("Creating SQLite database %s..." % DB_FILE)
# Define database
db = SqliteDatabase(DB_FILE, threadlocals=True)
# Connect to database
db.connect()
# Create tables
Category.create_table()
Feed.create_table()
Post.create_table()
Image.create_table()
# Create default Unsorted category
Category.create(name='Unsorted', comment='Uncategorised feeds', order=1)
logging.info("Database created.")
def create_db():
logging.info("Creating SQLite database %s..." % DB_FILE)
# Define database
db = SqliteDatabase(DB_FILE, threadlocals=True)
# Connect to database
db.connect()
# Create tables
Category.create_table()
Feed.create_table()
Post.create_table()
Image.create_table()
# Create default Unsorted category
Category.create(name='Unsorted', comment='Uncategorised feeds', order=1)
logging.info("Database created.")
