reliq: Compose relational queries programmatically

Recommend this page to a friend!

Download .zip

Info

View files (76)

Download .zip

Reputation

Support forum (1)

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2012-03-08 (4 years ago)		Not enough user ratings				Total: 336		All time: 6,717 This week: 1,110

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

Description Author

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

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