Download the PHP package croak-sqlite-dbmanagement/sqlite-dbmanagement without Composer
On this page you can find all versions of the php package croak-sqlite-dbmanagement/sqlite-dbmanagement. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download croak-sqlite-dbmanagement/sqlite-dbmanagement
More information about croak-sqlite-dbmanagement/sqlite-dbmanagement
Files in croak-sqlite-dbmanagement/sqlite-dbmanagement
Package sqlite-dbmanagement
Short Description a set of php objects and interfaces for a simple use of sqlite databases
License MIT
Homepage https://github.com/20centcroak/SqliteDbManagement
Informations about the package sqlite-dbmanagement
SqliteDbManagement
php classes to manage sqlite databases using Croak/DbManagement
This is an implementation of DbManagement (https://github.com/20centcroak/DBManagement) to be used with sqlite database. See this package for more information.
To install this package, use Composer :
composer require croak-sqlite-dbmanagement/sqlite-dbmanagement
This package is composed of a single class DbManagementSqlite and requires DbManagement
DbDbManagementSqlite implement DbManagement with the sqlite syntax and then allows quering very easily in sqlite database.
For querying with the GET verb, use the following keywords:
[fieldName]-up pour trier les données par ordre ascendant sur le champ [fieldName]
[fieldName]-down pour trier les données par ordre descendant sur le champ [fieldName]
[fieldName]-min=XXX pour sélectionner les données telles que [fieldName]>=XXX
[fieldName]-max=XXX pour sélectionner les données telles que [fieldName]<=XXX
[fieldName]=XXX pour sélectionner les données telles que [fieldName]=XXX
Let assume that the route localhost:8080/measures is defined in your app and the fields named "value" and "flag" are defined in the database table, here is an example of a GET request :
localhost:8080/measures?value-min=12&value-up&flag-down
An example of use can be found in https://github.com/20centcroak/api-iot