TornadoPractice
Practice for using tornado.
Online multiplayer chat website.
DEMO is here.
Used packages: pymysql, tornado, Pillow
Structure of database
ws_account:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| uid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| username | varchar(25) | NO | UNI | NULL | |
| varchar(50) | NO | UNI | NULL | ||
| password | varchar(64) | NO | NULL | ||
| reg_time | datetime | NO | NULL | ||
| session | varchar(64) | YES | NULL |
ws_record:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| uid | int(10) unsigned | NO | MUL | NULL | |
| content | text | NO | NULL | ||
| date | datetime | YES | NULL |
ws_permission:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| uid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| speak | tinyint(1) | NO | 1 | ||
| connect | tinyint(1) | NO | 1 | ||
| gag | tinyint(1) | NO | 0 | ||
| root | tinyint(1) | NO | 0 | ||
| admin | tinyint(1) | NO | 0 |
Change Log
Version 1
Register and login function.
Online chat function supported by webscoket.
Version 1.0.1
Save server information and mysql information in the json file
/info/server.json and /info/mysql.json
instead of saving in the source code.
Version 1.0.2
Add some page style.
Version 1.1.0
Add style to all pages.
Add authority management system.
Version 1.1.1
Setup function.
Automatically create tables.