gistfile1.py

class portscan(Base):
    __tablename__ = 'portscan'
    pk = Column(Integer,Sequence('pk'), primary_key=True)
    ip = Column(VARCHAR(39))
    dtime = Column(DATETIME) #because we're keeping a log and gonna update it every so
    p21 = Column(Boolean)
    p22 = Column(Boolean)
    p53 = Column(Boolean)
    p80 = Column(Boolean)
    p443 = Column(Boolean)
    p2082 = Column(Boolean)
    p2083 = Column(Boolean)
    p2086 = Column(Boolean)
    p8880 = Column(Boolean)
    p10000 = Column(Boolean)



    def __init__(self, ip, dtime,p21,p22,p53,p80,p443,p2082,p2083,p2086,p8880,p10000):  
        self.ip = ip
        self.dtime = dtime
        self.p21 = p21
        self.p22 = p22
        self.p53 = p53
        self.p80 = p80
        self.p443 = p443
        self.p2082 = p2082
        self.p2083 = p2083
        self.p2086 = p2086
        self.p8880 = p8880
        self.p10000 = p10000

    def __repr__(self):
        return "<portscan('%s','%s','%s','%s','%s','%s','%s','%s','%s')>" % (self.ip, self.dtime,self.p21, self.p22, self.p53,self.p80,self.p443,self.p2082,self.p2083,self.p2086,self.p8880,self.p10000)                                                                        














>>> Session.query(portscan).all()
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/home/pronto/git/SSH-Ranking/sqlclass.py", line 96, in __repr__
    return "<portscan('%s','%s','%s','%s','%s','%s','%s','%s','%s')>" % (self.ip, self.dtime,self.p21, self.p22, self.p53,self.p80,self.p443,self.p2082,self.p2083,self.p2086,self.p8880,self.p10000)
TypeError: not all arguments converted during string formatting