eddywebs/db-to-api

composer package for https://github.com/project-open-data/db-to-api

db-to-api-package

Composer package for converting database to api (github.com/project-open-data/db-to-api), _(*1)

USAGE

intialize the api variable in routes/controller as:, _(*2)

$var = Eddywebs\DbToApi\DbToApi::getApi($param, $config);

Where $param has the parameters for returning data, params little different from the paramater url in the readme file of original code at github.com/project-open-data/db-to-api., _(*3)

$config is array of configuration in following format:, _(*4)

$config = array( 
             'name' => 'database-name',
             'username' => 'username',
             'password' => 'password',
             'server' => 'hostname',
             'port' => port-number,
             'type' => 'supported-database-type', 
             'table_blacklist' => array(),
             'column_blacklist' => array(),
 );

Databases Supported

• 4D
• CUBRID
• Firebird/Interbase
• IBM
• Informix
• MS SQL Server
• MySQL
• ODBC and DB2
• Oracle
• PostgreSQL
• SQLite

Param/url structure

• All rows in table: db={database-name}&table={table-name}&format=json
• A specific row in a table using ID/primary key column of the table : db={database-name}&table={table-name}&value={ID/primary key value}&format=json *A specific row in table using the value in column: /db={database-name}&table={table-name}&column={column-name}&value={search-value}&format=json