Download the PHP package anax/database-query-builder without Composer
On this page you can find all versions of the php package anax/database-query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download anax/database-query-builder
More information about anax/database-query-builder
Files in anax/database-query-builder
Package database-query-builder
Short Description Anax Database Query Builder module, create queries through methods.
License MIT
Homepage https://dbwebb.se/anax
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package database-query-builder
Anax Database Query Builder
Anax Database Query Builder module as an extension to anax/database to enable querying the datase using methods instead of SQL.
This module is used to implement the module Database Active Record anax\database-active-record.
The module is tested using MySQL and SQLite.
Table of content
- Install
- Development
- Class, interface, trait
- Exceptions
- DI service
- Access as framework service
- Basic usage
- Dependency
- License
Install
You can install the module from anax/database-query-builder on Packagist using composer.
You can then copy the default configuration files as a start.
Development
To work as a developer you clone the repo and install the local environment through make. Then you can run the unit tests.
Class, interface, trait
The following classes, interfaces and traits exists.
The following parts are related to the feature of a SQL query builder.
| Class, interface, trait | Description |
|---|---|
Anax\Database\QueryBuilderTrait |
A trait implementing SQL query builder, based upon Anax\Database\Database. |
Anax\Database\DatabaseQueryBuilder |
A database class using the SQL query builder trait (used by the Active Record module) and extending the database class. |
Exceptions
All exceptions are in the namespace Anax\DatabaseQueryBuilder\Exception\. The following exceptions exists and may be thrown.
| Exception | Description |
|---|---|
BuildException |
When failing to build a SQL query. |
DI service
The database query builder is created as a framework service within $di. The following is a sample on how the database query builder service is created through config/di/dbqb.php.
Access as framework service
You can access the module as a framework service and use it as an ordinary database service.
This is since the class \Anax\DatabaseQueryBuilder\DatabaseQueryBuilder extends the database class \Anax\Database\Database.
Basic usage
This is the basic usage of the query builder.
You start by creating a database object from the query builder class and connect to the database.
This is more or less the same as retrieving the class from the $di container.
You can now create a table.
The table is created.
You can now insert rows into the table.
You can now query the table.
That is the basic usage and the idea is to create the SQL-queries using class methods and build tha actual SQL query behind the scene.
Dependency
This module depends upon, and extends, the database abstraction layer anax\database.
The module is usually used within an Anax installation but can also be used without Anax.
License
This software carries a MIT license. See LICENSE.txt for details.
