diff options
author | Jon Bergli Heier <snakebite@jvnv.net> | 2010-01-26 19:45:27 +0100 |
---|---|---|
committer | Jon Bergli Heier <snakebite@jvnv.net> | 2010-01-26 19:45:27 +0100 |
commit | d6337a93a34836fd479839697d9d82c045b01da2 (patch) | |
tree | 37db42ee1ae8ad85d2dd52f30d1842ba31a9e196 /db.py | |
parent | dc94a7a45a7fcd6722f40ac0210b1c37c7756bc5 (diff) |
Cache formatted text.
Diffstat (limited to 'db.py')
-rw-r--r-- | db.py | 19 |
1 files changed, 18 insertions, 1 deletions
@@ -1,4 +1,4 @@ -from sqlalchemy import create_engine, Column, Integer, String, DateTime, Text, Index +from sqlalchemy import create_engine, Column, Integer, String, DateTime, Text, Index, ForeignKey from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker, relation, backref import settings @@ -29,5 +29,22 @@ class Paste(Base): def __repr__(self): return '<Paste(%d, "%s", "%s", "%s", "%s")>' % (self.id, self.hash, self.nick, self.date.ctime(), self.title) +class Cache(Base): + __tablename__ = 'cache' + + id = Column(Integer, primary_key = True) + paste_hash = Column(String, ForeignKey('paste.hash'), index = True) + paste = relation(Paste, primaryjoin = paste_hash == Paste.hash, lazy = False) + syntax_name = Column(String) + text = Column(Text) + + def __init__(self, hash, syntax_name, text): + self.paste_hash = hash + self.syntax_name = syntax_name + self.text = text + + def __repr__(self): + return '<Cache(%d, "%s")>' % (self.id, self.paste_hash) + Base.metadata.create_all() Session = sessionmaker(bind = engine, autoflush = True, autocommit = False) |