Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 30.159.102 Times

Text::Query::BuildSQL 0.09

  Date Added: November 27, 2010  |  Visits: 606

Text::Query::BuildSQL

Report Broken Link
Printer Friendly Version


Product Homepage
Download (73 downloads)

Text::Query::BuildSQL is a base class for SQL query builders. SYNOPSIS package Text::Query::BuildSQLsqldb; use Text::Query::BuildSQL; use vars qw(@ISA); @ISA = qw(Text::Query::BuildSQL); Defines all the build_* functions to build a syntax tree. The tree nodes are [ operator scope operand operand... ]. The build_final_expression function translate the syntax tree in a where clause using the resolve method. If the scope of the search is not specified (simple query or advanced query without scope operator), the scope is set to the list of comma separated fields provided by the -fields_searched option. The resulting where clause is placed in the select order provided with the -select option, if any. SYNTAX TREE The string enclosed in single quotes must match exactly. The < string > token stands for an arbitrary string. A description enclosed in [something ...] means repeated 0 or N times. expr: or scope expr [expr ...] and scope expr [expr ...] not scope expr near scope expr_literal expr_literal forbiden scope expr_literal [expr_literal ...] mandatory scope expr_literal [expr_literal ...] optional scope expr_literal [expr_literal ...] literal scope < string > expr_literal: literal scope < string > scope: < string > METHODS resolve([], Q1) Returns a where clause string corresponding to the Q1 syntax tree. sortplusminus([], Q1) Translate the mandatory and forbiden syntactic nodes to their boolean equivalents. If it has_relevance returns false and there is at least one mandatory word, the first mandatory word is added to the list of optional words. has_relevance() Returns true if relevance ranking is possible, false if not. It is used by the sortplusminus function. Returns false by default. If relevance ranking is not possible, the semantic of the simple search is slighthly modified. When asking for +a b c it shows all the documents containing a and (b or c). The normal behaviour is to return all the documents containing a and to sort them to show first those containing (b or c). When relevance ranking is not available the b, c search terms are therefore useless. That is why we decided to change the semantic of the query if no relevance ranking is available. OPTIONS -select STRING If provided the string returned by build_final_expression substitutes the __WHERE__ tag with the where string generated by the resolve function. The substituted string is the return value of the build_final_expression. If not set the return value of the build_final_expression is the result of the resolve function. -fields_searched FIELDS_LIST FIELDS_LIST is a list of comma separated field names. It is used as the default scope if no scope is provided in the query string. The build_final_expression function will croak if this option is not provided and no scope operator were used..

Requirements: No special requirements
Platforms: Linux
Keyword: Base Class Build Buildsql Expr Libraries Literal Programming Query Relevance Ranking Scope Sql Query String Syntax Tree Textquerybuildsql
Users rating: 0/10

License: Freeware Size: 19.46 KB
TEXT::QUERY::BUILDSQL RELATED
Libraries  -  Class::Cloneable 0.03
Class::Cloneable is a base class for Cloneable objects. SYNOPSIS package MyObject; our @ISA = (Class::Cloneable); # calling clone on an instance of MyObject # will give you full deep-cloning functionality This module provides a flexible...
8.19 KB  
Libraries  -  Class::StrongSingleton 0.02
Class::StrongSingleton is a stronger and more secure Singleton base class. SYNOPSIS package My::Singleton::Class; use base qw(Class::StrongSingleton); sub new { my ($class, %my_params) = @_; # create our object instance my $instance = {...
6.14 KB  
Database Tools  -  EMS SQL Query 2011 for PostgreSQL 3.3.0.1
EMS SQL Query for PostgreSQL is an useful software that enables you to quickly build SQL queries to PostgreSQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to...
 
Libraries  -  ASNMTAP::Asnmtap 3.000.011
ASNMTAP::Asnmtap is an object-oriented Base Class to build modules that provides a nice object oriented interface for ASNMTAP. SYNOPSIS use ASNMTAP::Asnmtap; my $objectAsnmtap = ASNMTAP::Asnmtap->new ( _programName => test-asnmtap.pl,...
1.6 MB  
Libraries  -  C++ base 1.0
C++ base is a base class suite contains several powerful c++ base classes for basic encapsulation of low level operating system calls and basic library functions. Further packages you may access from this page require the installation of this...
102.4 KB  
Libraries  -  Persistent::Base 0.52
Persistent::Base is an Abstract Persistent Base Class. SYNOPSIS ### we are a subclass of ... ### use Persistent::Base; @ISA = qw(Persistent::Base); ABSTRACT This is an abstract class used by the Persistent framework of classes to...
38.91 KB  
Libraries  -  dtRdr::GUI::Wx::Tree::Base 0.0.11
dtRdr::GUI::Wx::Tree::Base is a base class for sidebar trees. SYNOPSIS init $tree->init($frame); select_item Select the tree item for a given $id. $tree->select_item($id) The id is probably the id of whatever your widget associated...
2.8 MB  
Libraries  -  Class::ObjectTemplate 0.7
Class::ObjectTemplate is a Perl extension for an optimized template builder base class. SYNOPSIS package Foo; use Class::ObjectTemplate; require Exporter; @ISA = qw(Class::ObjectTemplate Exporter); attributes(one, two, three); #...
6.14 KB  
Libraries  -  Image::Button 0.53
Image::Button is a base class for building PNG buttons using GD. SYNOPSIS use Image::Button::Rect; my $b1 = new Image::Button::Rect(text => text b1, font => newsgotn.ttf, fontsize => 20, file => b1.png); # $b2 is like $b1, but with...
8.19 KB  
Libraries  -  MP3::Find::Base 0.06
MP3::Find::Base is a base class for MP3::Find backends. SYNOPSIS package MyFinder; use base MP3::Find::Base; sub search { my $self = shift; my ($query, $dirs, $sort, $options) = @_; # do something to find and sort the mp3s... my...
29.7 KB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  wolfSSL 3.12.2
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
2.73 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB