# Filename: post.py
# Revision: 0.1
#
# Copyright 2008 Christopher Myers and Justin Davis
#
# blogggg! poster
# Load the content, and you're almost done
#
# You have unlimited license to use this software however you want.  There
# is no warranty either expressed nor implied.  Actually, we recommend not 
# using it.  It just exists to prove a point.


from sqlalchemy import *
import datetime


db = create_engine('sqlite:////home/guido/blogg.db')

meta = MetaData(db)


blog_entries = Table('entries', meta,
    Column('entry', String(), primary_key = True),
    Column('url', String()),
    Column('date', DateTime, default=datetime.datetime.now())
)

class Entry(object):
    def __init__(self, text, url):
        self.entry = text
        self.url = url

orm.mapper(Entry, blog_entries)

session = orm.create_session(bind=db)


if __name__ == "__main__":
    import sys
    if sys.argv[1] == "create_db":
        blog_entries.create(bind=db)
    else:
        f = open(sys.argv[1]).read()
        entry = Entry(f, sys.argv[1])
        session.save(entry)
        session.flush()