FilmDB is a website, which collects information about films and television series has been released or being released. The system provides basic information. Developers can access the information through system’s API.
| Method | Url | Parameter |
|---|---|---|
| get | /schema | |
| post | /select | <query> |
| post | /table | <name> |
| post | wh/video | <id>, <name> |
| post | wh/detail | <id> |
| post | wh/episode | <id>, <name> |
| post | wh/genre | <id>, <name> |
| post | wh/company | <id>, <name> |
| post | wh/person | <id>, <name> |
| post | wh/character | <id>, <name> |
| post | wh/director | <id> |
| post | wh/poster | <id>, <name> |
| post | wh/video/cn/detail | <id> |
| post | wh/video/cn/episode | <id> |
| post | wh/person/cn/character | <id> |
| post | wh/person/cn/director | <id> |
| post | wh/video/cr/company | <id> |
| post | wh/video/cr/genre | <id> |
| post | wh/video/cr/character | <id> |
| post | wh/video/cr/director | <id> |
| post | wh/video/cr/poster | <id> |
| post | wh/person/cr/poster | <id> |
/schema: return all tables schema of database in text format
curl -X GET <hostname>/schema
/select: execute <query> as select statement and return that result in JSON Array format
curl -d "query=SELECT * FROM Video" -X POST <hostname>/select
/table: return all records of <table> in JSON Array format
curl -d "name=Video" -X POST <hostname>/table
/wh/<table>: return all records from <table> where(wh) <id> is matched in JSON Array format
curl -d "id=1" -X POST <hostname>/wh/video
curl -d "name=The Fast and the Furious" -X POST <hostname>/wh/video
/wh/<table>/cn/<subtable>: return all records from <subtable> which connect(cn) and exist in <table> that <id> is matched in JSON Array format
curl -d "id=1" -X POST <hostname>/wh/video/cn/detail
/wh/<table>/cr/<subtable>: return all records from <subtable> which cross(cr) and exist in <table> that <id> is matched
curl -d "id=1" -X POST <hostname>/wh/video/cr/company
- Supachai Laparparat @supachailllpay
- Bodin Chinthanet @gotzillaz
- Saringkarn Pumjan @SaringkarnP