-
Notifications
You must be signed in to change notification settings - Fork 0
/
model.py
76 lines (65 loc) · 2.32 KB
/
model.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
#!/usr/bin/env python
#coding=utf8
from flask import Flask, request, render_template,redirect,make_response,flash,session
import flask
import os
import sys
import flask.ext.whooshalchemy as whooshalchemy
from flask.ext.sqlalchemy import SQLAlchemy
from config import Config
basedir = os.path.abspath(os.path.dirname(__file__))
app = Flask(__name__)
app.config.from_object(Config)
db = SQLAlchemy(app)
class User(db.Model):
__tablename__ = 'Users'
id = db.Column(db.Integer, primary_key=True)
UserId = db.Column(db.String(50))
TrueName = db.Column(db.String(50))
EMail = db.Column(db.String(64))
PassWord = db.Column(db.String(50))
StuNumber = db.Column(db.String(15))
RegTime = db.Column(db.String(50))
def __str__ (self):
return "User(Id='%s')" % self.id
def dict(self):
return {'Id':self.id,
'UserId':self.UserId,
'TrueName':self.TrueName,
'EMail':self.Email,
'PassWord':self.PassWord,
'StuNumber':self.StuNumber,
'RegTime':self.RegTime}
class UserData(db.Model):
__tablename__ = 'NoticeData'
__searchable__ = ["Header", "Place", "ThingsType", "Type", "Content", "ContactWay", "Time"]
UserId = db.Column(db.String(20))
Id = db.Column(db.Integer,primary_key=True)
Time = db.Column(db.String(50))
Header = db.Column(db.String(50))
Place = db.Column(db.String(100))
ThingsType = db.Column(db.String(20))
Type = db.Column(db.String(10))
Content = db.Column(db.String(400))
ImgPath = db.Column(db.String(150))
Reward = db.Column(db.Integer)
#ThumbnailPath = db.Column(db.String(150))
LostStatus = db.Column(db.Boolean,default=True)
ContactWay = db.Column(db.String(100))
Verify = db.Column(db.Boolean,default=False)
SubTime=db.Column(db.String(30))
class AdminUser(db.Model):
__tablename__ = "AdminUsers"
Id = db.Column(db.Integer, primary_key=True)
UserId = db.Column(db.String(50))
PassWord = db.Column(db.String(50))
RegTime = db.Column(db.String(50))
whooshalchemy.whoosh_index(app, UserData)
if __name__ == '__main__':
db.create_all()
admin = AdminUser()
admin.UserId = "20144483"
admin.PassWord = "7ff5ae861e302ac269518883ce0a2dea"
db.session.add(admin)
db.session.commit()
db.session.close()