Download the PHP package jasperfw/query-builder without Composer
On this page you can find all versions of the php package jasperfw/query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download jasperfw/query-builder
More information about jasperfw/query-builder
Files in jasperfw/query-builder
Package query-builder
Short Description System for dynamically generating database queries
License Apache-2.0
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 query-builder
Jasper FW - Query Builder
A library for building SQL database queries. Unlike many other query builders that require the entire query be built in the system, this library follows a hybrid approach, allowing the developer to create a complex query and pass it in as a template, replacing certain tokens with autogenerated SQL snippets.
Features
- Generates SQL queries from scratch
- Modifies passed SQL queries with generated SQL snippets
Instructions
Installation
Install using composer composer require "jasperfw/query-builder"
Basic Usage
Create a basic select
The produces the following query (with newlines added for readablity):
Use the Query object as a prepared statement
Query objects can be reused for efficiency.
Note that if the query structure is changed after the query is executed, the ResultSet object returned by execute will
be invalidated. These changes are any changes to columns, tables, query type, pagination. Changes to the parameters will
not cause this. Typically, changing the table structure after executing is not recommended, and instead a new Query
should be created or the existing Query object should be cloned.
Create a custom template
A base query can be passed in as a string using the template() function. The system will simply replace certain tokens
with generated SQL snippets. The query type setting function (select(), insert(), etc) must still be called so that
the Query object will generate the appropriate snippets. Note that the template can be passed to the query type function
as an argument, for simplicity.
The following tokens in a query will be replaced:
- {{columns}} will be replaced with a list of columns
- {{pagination}} will be replaced with either a limit or limit and offset
- {{tables}} will be replaced with the list of tables and joins
- {{where}} will be replaced with the where clause(s). By default, these where clauses are preceeded with "WHERE ". This
can be overridden by adding a | and a replacement keyword. eg
{{where|AND}}. Spaces will be automatically placed. - {{sort}} will be replaced with the sort clause(s). By default the sorts will be preceeded with "ORDER BY " but if the
{{sort}}is following existing sorts in the template, this can be overridden by adding a | and a new keywork or a comma, eg{{sort|,}}
Note that pagination, sort and where clauses will only be added if the query builder has been passed additonal clauses. This allows a good deal of flexibility for modifying queries on the fly.
