PHP Classes
elePHPant
Icontem

reliq: Compose relational queries programmatically

Recommend this page to a friend!
     
  Info   View files View files (76)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2012-03-08 (4 years ago) RSS 2.0 feedNot enough user ratingsTotal: 336 All time: 6,717 This week: 1,110Up
Version License PHP version Categories
reliq 1.0MIT/X Consortium ...5.3PHP 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.

Picture of Arthur Borisow
Name: Arthur Borisow <contact>
Classes: 3 packages by
Country: Ukraine Ukraine
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Files folder imagereliq (3 files, 5 directories)
Files folder imagetest (8 files)

  Files folder image Files  /  reliq  
File Role Description
Files folder imageconnections (1 file, 1 directory)
Files folder imageexceptions (12 files)
Files folder imagemanagers (5 files)
Files folder imagenodes (43 files)
Files folder imagevisitors (2 files)
  Accessible without login Plain text file autoload.php Conf. Configuration script
  Plain text file factory.php Class Class source
  Plain text file table.php Class Class source

  Files folder image Files  /  reliq  /  connections  
File Role Description
Files folder imagedrivers (2 files)
  Plain text file connection.php Class Class source

  Files folder image Files  /  reliq  /  connections  /  drivers  
File Role Description
  Plain text file driver.php Class Class source
  Plain text file mysql_driver.php Class Class source

  Files folder image Files  /  reliq  /  exceptions  
File Role Description
  Plain text file no_column_exception.php Class Class source
  Plain text file no_sql_driver_exception.php Class Class source
  Plain text file unsupported_node_exception.php Class Class source
  Plain text file wrong_columns_for_insert_exception.php Class Class source
  Plain text file wrong_columns_for_update_exception.php Class Class source
  Plain text file wrong_db_driver_config_exception.php Class Class source
  Plain text file wrong_having_exception.php Class Class source
  Plain text file wrong_limit_exception.php Class Class source
  Plain text file wrong_node_type_exception.php Class Class source
  Plain text file wrong_offset_exception.php Class Class source
  Plain text file wrong_order_data_exception.php Class Class source
  Plain text file wrong_parameters_exception.php Class Class source

  Files folder image Files  /  reliq  /  managers  
File Role Description
  Plain text file delete_manager.php Class Class source
  Plain text file insert_manager.php Class Class source
  Plain text file manager.php Class Class source
  Plain text file select_manager.php Class Class source
  Plain text file update_manager.php Class Class source

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

  Files folder image Files  /  reliq  /  visitors  
File Role Description
  Plain text file sql_visitor.php Class Class source
  Plain text file visitor.php Class Class source

  Files folder image Files  /  test  
File Role Description
  Accessible without login Plain text file AutoLoadTest.php Test Unit test script
  Accessible without login Plain text file DeleteManagerTest.php Test Unit test script
  Accessible without login Plain text file FactoryTest.php Test Unit test script
  Accessible without login Plain text file InsertManagerTest.php Test Unit test script
  Accessible without login Plain text file ManagerTest.php Test Unit test script
  Accessible without login Plain text file SelectManagerTest.php Test Unit test script
  Accessible without login Plain text file TableTest.php Test Unit test script
  Accessible without login Plain text file UpdateManagerTest.php Test Unit test script

Downloadreliq-2012-03-08.zip 32KB
Downloadreliq-2012-03-08.tar.gz 11KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:336
This week:0
All time:6,717
This week:1,110Up
User Comments (1)
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.