reliq: Compose relational queries programmatically

Recommend this page to a friend!

Download

Info

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 338		All time: 7,088 This week: 455

Version		License		PHP version		Categories
`reliq` 1.0		MIT/X Consortium ...		5.3		PHP 5, Databases

Description

Author

Arthur Borisow

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.

Arthur Borisow

Name:	Arthur Borisow `<contact>`
Classes:	3 packages by Arthur Borisow
Country:	Ukraine

Innovation award

Nominee: 1x

Files (76)

File	Role	Description
`reliq` (3 files, 5 directories)
`test` (8 files)

File	Role	Description
`connections` (1 file, 1 directory)
`exceptions` (12 files)
`managers` (5 files)
`nodes` (43 files)
`visitors` (2 files)
`autoload.php`	Conf.	Configuration script
`factory.php`	Class	Class source
`table.php`	Class	Class source

File	Role	Description
`drivers` (2 files)
`connection.php`	Class	Class source

File	Role	Description
`driver.php`	Class	Class source
`mysql_driver.php`	Class	Class source

File	Role	Description
`no_column_exception.php`	Class	Class source
`no_sql_driver_exception.php`	Class	Class source
`unsupported_node_exception.php`	Class	Class source
`wrong_columns_for_insert_exception.php`	Class	Class source
`wrong_columns_for_update_exception.php`	Class	Class source
`wrong_db_driver_config_exception.php`	Class	Class source
`wrong_having_exception.php`	Class	Class source
`wrong_limit_exception.php`	Class	Class source
`wrong_node_type_exception.php`	Class	Class source
`wrong_offset_exception.php`	Class	Class source
`wrong_order_data_exception.php`	Class	Class source
`wrong_parameters_exception.php`	Class	Class source

File	Role	Description
`delete_manager.php`	Class	Class source
`insert_manager.php`	Class	Class source
`manager.php`	Class	Class source
`select_manager.php`	Class	Class source
`update_manager.php`	Class	Class source

File	Role	Description
`aggregation_node.php`	Class	Class source
`alias_node.php`	Class	Class source
`and_x_node.php`	Class	Class source
`as_x_node.php`	Class	Class source
`avg_node.php`	Class	Class source
`base_node.php`	Class	Class source
`brackets_node.php`	Class	Class source
`count_node.php`	Class	Class source
`cross_join_node.php`	Class	Class source
`delete_query_node.php`	Class	Class source
`eq_node.php`	Class	Class source
`func_node.php`	Class	Class source
`gte_node.php`	Class	Class source
`gt_node.php`	Class	Class source
`having_node.php`	Class	Class source
`inner_join_node.php`	Class	Class source
`insert_query_node.php`	Class	Class source
`in_node.php`	Class	Class source
`is_node.php`	Class	Class source
`is_not_node.php`	Class	Class source
`join_node.php`	Class	Class source
`left_outer_join_node.php`	Class	Class source
`like_node.php`	Class	Class source
`lte_node.php`	Class	Class source
`lt_node.php`	Class	Class source
`max_node.php`	Class	Class source
`min_node.php`	Class	Class source
`natural_join_node.php`	Class	Class source
`node.php`	Class	Class source
`not_eq_node.php`	Class	Class source
`not_in_node.php`	Class	Class source
`not_like_node.php`	Class	Class source
`on_node.php`	Class	Class source
`order_node.php`	Class	Class source
`or_x_node.php`	Class	Class source
`outer_join_node.php`	Class	Class source
`quoted_node.php`	Class	Class source
`right_outer_join_node.php`	Class	Class source
`select_query_node.php`	Class	Class source
`set_node.php`	Class	Class source
`sql_node.php`	Class	Class source
`sum_node.php`	Class	Class source
`update_query_node.php`	Class	Class source

File	Role	Description
`sql_visitor.php`	Class	Class source
`visitor.php`	Class	Class source

File	Role	Description
`AutoLoadTest.php`	Test	Unit test script
`DeleteManagerTest.php`	Test	Unit test script
`FactoryTest.php`	Test	Unit test script
`InsertManagerTest.php`	Test	Unit test script
`ManagerTest.php`	Test	Unit test script
`SelectManagerTest.php`	Test	Unit test script
`TableTest.php`	Test	Unit test script
`UpdateManagerTest.php`	Test	Unit test script