| Recommend this page to a friend! |
| All class groups | > | All authors | > | Packages of Arthur Borisow (3) | > | Mission progress status | > | Reputation |
|
|||||||||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| ||||
| This class can be used to compose MySQL queries chaining functions that define query parameters. It can create and compose the SQL statement of a query by performing chained calls to different functions of the class that take parameters to define different values of the queries. The class provides functions for defining the type of query (SELECT, INSERT, UPDATE and DELETE), involved fields and field values, condition clauses, result grouping and ordering, and the result set row range. 1.1 added JOIN, LEFT JOIN, RIGHT JOIN, USING, ON added IN to the where method as a valid operand |
| Ratings | Utility | Consistency | Documentation | Examples | Tests | Videos | Overall | Rank |
| All time: | 75% | 58% | - | 66% | - | - | 49% | 2781 |
| Month: | Not yet rated by the users | |||||||
| ||||
| This package can compose relational queries programmatically in a similar way to Arel for Ruby. There are several manager classes that can compose SELECT, INSERT, UPDATE and DELETE queries. The manager classes have functions to define parameters the parameters of the queries like table names, field names and values, condition and limit clauses, etc.. The manager classes can assemble the queries from the specified parameters and return a resulting SQL string. |
| Not enough user ratings |
| ||||||||||||||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |