Ticket #105: elixir1.py

from elixir import *
from sqlalchemy import *

class User(Entity):
    docs = ManyToMany("Document", table="document_sharer", 
                      local_colname="user_id", remote_colname="document_id")

document_sharer = Table('document_sharer',
                        metadata,
                        Column('id', Integer, primary_key=True, autoincrement=True),
                        Column('user_id'),
                        Column('document_id'),
                        Column("owner", Boolean, server_default="false"),
                        UniqueConstraint("document_id", "user_id"),
                        )
    
class Document(Entity):
    sharers = ManyToMany("User", table=document_sharer,
                         local_colname="document_id", remote_colname="user_id")


metadata.bind = "sqlite://"
setup_all()