8 from sqlalchemy.orm import relationship, backref, object_session

     8 from sqlalchemy.orm import relationship, backref, object_session

     9 

     9 

    10 from sqlalchemy import and_

    10 from sqlalchemy import and_

    11 import sqlalchemy.sql.functions as func

    11 import sqlalchemy.sql.functions as func

    12 

    12 

    13 from ..error import JobNotFound

    14 from ..error import JobNotFound

    14 

    15 

    15 Base = declarative_base()

    16 Base = declarative_base()

    16 

    17 

    17 __tables__=["User", "Job", "Message", "Offer", "Userright"]

    18 __tables__=["User", "Job", "Message", "Offer", "Userright"]

    74     info = Column(String(100))

    75     info = Column(String(100))

    75     status = Column(Enum("init","started","sending","sended","error"))

    76     status = Column(Enum("init","started","sending","sended","error"))

    76     user_id = Column("user", String(100), ForeignKey('apiuser.name'))

    77     user_id = Column("user", String(100), ForeignKey('apiuser.name'))

    77     user = relationship("User", backref=backref('jobs'))

    78     user = relationship("User", backref=backref('jobs'))

    78 

    79 

    79     def __repr__(self):

    85     def __repr__(self):

    80         return "<Job('%s','%s','%s','%s')>"%(self.id,self.info, self.status, self.user_id)

    86         return "<Job('%s','%s','%s','%s')>"%(self.id,self.info, self.status, self.user_id)

    81 

    87 

    82 class User(Base):

    88 class User(Base):

    83     """Die Benutzerdatenbank von Iro. <em>ng_kunde</em> ist der verknüpfte netzguerilla.net Benutzer, der die Rechnung zahlt."""

    89     """Die Benutzerdatenbank von Iro. <em>ng_kunde</em> ist der verknüpfte netzguerilla.net Benutzer, der die Rechnung zahlt."""