python 3.6
mysqlcreate database eulerdb_schema;
create table p_db_meta (
database_name VARCHAR(256),
database_type VARCHAR(256),
table_name VARCHAR(256) ,
table_anonymous VARCHAR(256),
col_info VARCHAR(256),
key_info VARCHAR(256)
);$ git clone [email protected]:FancyXun/EulerDB.git$ cd EulerDB
$ pip install -r requirements.txtBefore start, you must have a database created in mysql. the database info(include user and password) could be set in handler_test.py
$ python service.py$ python eulerdb_test.py| SQL Type | Status | SQL Type | Status |
|---|---|---|---|
| SQL select | DONE |
SQL unique | TODO(low) |
| SQL distinct | DONE |
SQL drop | DONE |
| SQL where | DONE |
SQL avg | DONE |
| SQL and & or | DONE |
SQL count | DONE |
| SQL order by | DONE |
SQL max | DONE |
| SQL insert | DONE |
SQL min | DONE |
| SQL update | DONE |
SQL sum | DONE |
| SQL delete | DONE |
SQL having | TODO |
| SQL top(SQL Server) | TODO(low) | SQL group by | TODO |
| SQL like | DONE |
SQL round | TODO |
| SQL in | TODO | SQL len | TODO |
| SQL between | TODO | SQL nulls | TODO |
| SQL join | DONE |
SQL now | TODO |
| SQL inner join | DONE |
SQL first | TODO |
| SQL left join | DONE |
SQL last | TODO |
| SQL right join | DONE |
SQL limit | DONE |
| SQL full join | TODO | SQL alter | DONE(not support) |
| SQL union | TODO | SQL primary key | TODO |
| SQL create db | TODO(low) | SQL foreign key | TODO |
| SQL create table | DONE |
SQL select into | TODO |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent