Skip to content

Latest commit

 

History

History
36 lines (21 loc) · 1.25 KB

README.md

File metadata and controls

36 lines (21 loc) · 1.25 KB
Raw

REST API for Oracle

This API is used to access througth web-server to database, using REST metodology.

My goal is to refuse a heavy database client on controller side, replacing it by lightweight web-requests.

Programming way is Java-oriented OOP, including Dependency Injection

Prerequisities

  • PHP 5.5 or higher
  • composer
  • PHP database connection module

Supported databases

  • Oracle

The new databases is easy to add with new Model/OracleDB.php and Model/OracleStorage.php -like files and modify the Dependencies.php file. Suggest, I will add.

The database have to be with stored procedures!

Request examples

$ curl http://dbuser:dbpass@localhost/dbtablename/4
$ curl http://dbuser:dbpass@localhost/dbtablename?TYPE=5&limit=2
$ curl http://dbuser:dbpass@localhost/dbtablename?TYPE=5&limit=2&fields=FIELDNAME1,FIELDNAME2
$ curl -i -X POST -H "Content-Type: application/json" -d '{"FIELDNAME1":"some text","FIELDNAME2":"0","FIELDNAME3":"1"}' http://dbuser:dbpass@localhost/dbtablename
$ curl -i -X POST -H "Content-Type: application/json" -d '{"FIELDNAME1":"some text","FIELDNAME2":0,"FIELDNAME3":1}' http://dbuser:dbpass@localhost/dbtablename

see more examples