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.139.749 Times

DBIx::SQL::Abstract 0.07

  Date Added: June 25, 2010  |  Visits: 658

DBIx::SQL::Abstract

Report Broken Link
Printer Friendly Version


Product Homepage
Download (71 downloads)

DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) = $dbh->select($table, @fields, %where, @order); my($query, @bind) = $dbh->insert($table, %fieldvals || @values); my($query, @bind) = $dbh->update($table, %fieldvals, %where); my($query, @bind) = $dbh->delete($table, %where); Using DBI methods my $sth = $dbh->prepare($query); $sth->execute(@bind_params); ... my $rc = $dbh->begin_work; my $rc = $dbh->commit; my $rc = $dbh->rollback; my $rc = $dbh->disconnect; Anything else DBI method can be used, by Example: my $err = $dbh->err; my $err = $dbh->errstr; my $rv = $dbh->state; my $rc = $dbh->DESTROY; The intention of this module is to join some methods from the DBI and the SQL::Abstract modules, for a convenient and easy use. To begin, we create an object, but first we must create a hash which contains the database parameters as follows. my %dbcfg = { PrintError => 1, RaiseError => 0, AutoCommit => 0, ChopBlanks => 1 driver => Pg, dbname => db, host => undef, port => undef, user => user, passwd => undef }; Notice that this parameters are set as default unless you set your required values. my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); This object automatically creates the connection with the database, and gets the methods listed above..

Requirements: No special requirements
Platforms: Linux
Keyword: Abstraction Abstraction Layer Bind Convenient Dbix Dbixsqlabstract Libraries Module Perl Module Programming Query Rc Sql
Users rating: 0/10

License: Freeware Size: 4.1 KB
DBIX::SQL::ABSTRACT RELATED
Libraries  -  DBIx::EnumConstraints 0.01
DBIx::EnumConstraints is a Perl module that generates enum-like SQL constraints. SYNOPSIS use DBIx::EnumConstraints; my $ec = DBIx::EnumConstraints->new({ name => kind, fields => [ [ k1, a, b ] , [ k2, b ] ] }); # get enum field...
10.24 KB  
Libraries  -  DBIx::FetchLoop 0.6
DBIx::FetchLoop is a Perl module that can fetch with change detection and aggregates. SYNOPSIS use DBIx::FetchLoop; $lph = DBIx::FetchLoop->new($sth, $dbi_method); $hash_ref = $lph->fetch_current_data; $rowset = $hash_ref->{previous};...
6.14 KB  
Libraries  -  DBIx::MyParse 0.88
DBIx::MyParse is a Perl module that provides access to the MySQL SQL parser..
86.02 KB  
Libraries  -  DBIx::Timeout 1.01
DBIx::Timeout is a Perl module that provides a safe method of timing out DBI requests. The method described in the DBI documentation uses unsafe signals, which may cause memory corruption. DBIx::Timeout instead uses a separate timeout process....
6.14 KB  
Libraries  -  DBIx::Perlish 0.27
DBIx::Perlish is a Perl module that provides the ability to work with databases supported by the DBI module using Perls own syntax for four most common operations: SELECT, UPDATE, DELETE, and INSERT. By using DBIx::Perlish, you can write most of...
39.94 KB  
Libraries  -  DBIx::CGITables 0.001
DBIx::CGITables is a Perl module for easy DB access from a CGI. SYNOPSIS use DBIx::CGITables; my %parameters=(); my $query=DBIx::CGITables->new(%parameters)); $query->search_execute_and_do_everything_even_parse_the_template(); This module...
20.48 KB  
Libraries  -  DBIx::DWIW 0.44
DBIx::DWIW is a Perl module for robust and simple DBI wrapper to Do What I Want (DWIW). SYNOPSIS When used directly: use DBIx::DWIW; my $db = DBIx::DWIW->Connect(DB => $database, User => $user, Pass => $password, Host => $host); my...
22.53 KB  
Libraries  -  DBIx::XMLMessage 0.05
DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources. The package maintains simple XML templates that describe object structure. The package is capable of generating SQL statements based on these templates and...
25.6 KB  
Libraries  -  DBIx::DBStag 0.08
DBIx::DBStag is a Perl module for Relational Database to Hierarchical (Stag/XML) Mapping. SYNOPSIS use DBIx::DBStag; my $dbh = DBIx::DBStag->connect("dbi:Pg:dbname=moviedb"); my $sql = q[ SELECT studio.*, movie.*, star.* FROM studio...
133.12 KB  
Libraries  -  DBIx::TableHash 1.05
DBIx::TableHash is a Perl module that can tie a hash to a mysql table + SQL utils. SYNOPSIS use DBIx::TableHash; my $DBHash = DBIx::TableHash->create_or_die (my $Params = { DBIDriver => mysql, Database => mydatabase, HostName =>...
17.41 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.0
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