OnLine.py 758 B

12345678910111213141516171819202122232425
  1. from app import db
  2. from datetime import datetime
  3. class OnLine(db.Model):
  4. __tablename__ = 'SYONLINE'
  5. ID = db.Column(db.String(36), primary_key=True)
  6. CREATEDATETIME = db.Column(db.DateTime, index=True, default=datetime.now)
  7. LOGINNAME = db.Column(db.String(100))
  8. IP = db.Column(db.String(100))
  9. TYPE = db.Column(db.String(1))
  10. def get_id(self):
  11. return str(self.ID)
  12. def __repr__(self):
  13. return '<Oneline %r>\n' %(self.LOGINNAME)
  14. def to_json(self):
  15. return {
  16. 'infoId': self.ID,
  17. 'loginTime': self.CREATEDATETIME.strftime('%Y-%m-%d %H:%M:%S'),
  18. 'userName': self.LOGINNAME,
  19. 'ipaddr': self.IP,
  20. 'type': self.TYPE
  21. }