models.py 773 B

1234567891011121314151617181920212223242526272829303132
  1. # -*- coding: utf-8 -*-
  2. from datetime import datetime
  3. from flask_sqlalchemy import SQLAlchemy
  4. from . import app
  5. db = SQLAlchemy(app)
  6. class User_info(db.Model):
  7. user_id = db.Column(db.String, primary_key=True)
  8. timestamp = db.Column(db.DateTime, primary_key=True)
  9. class Cluster_result(db.Model):
  10. timestamp = db.Column(db.DateTime, unique=True, primary_key=True)
  11. normal_user = db.Column(db.Text)
  12. abnormal_user = db.Column(db.Text)
  13. normal_user_count = db.Column(db.Integer, default=0)
  14. abnormal_user_count = db.Column(db.Integer, default=0)
  15. nyms_count = db.Column(db.Integer, default=0)
  16. class Nym_info(db.Model):
  17. nym = db.Column(db.String, primary_key=True, unique=True)
  18. timestamp = db.Column(db.DateTime, primary_key=True)