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 34.359.887 Times

DBIx::SQL::Abstract 0.07

  Date Added: June 25, 2010  |  Visits: 749

DBIx::SQL::Abstract

Report Broken Link
Printer Friendly Version


Product Homepage
Download (78 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
USER REVIEWS
More Reviews or Write Review


DBIX::SQL::ABSTRACT RELATED
Programming  -  CAN Abstraction Layer 0.1.6
The CAN Abstraction Layer (CANAL) provides a single interface for programs to use different CAN drivers. It consists of a CANAL daemon that handles client and driver communication, a canalLogger that logs messages in a window, and a simple...
2.3 MB  
Database Tools  -  Database Independent Abstraction Layer for C 0.8.2
Database Independent Abstraction Layer for C (libdbi) implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl. Writing one generic set of code, programmers can leverage the power of multiple databases and...
1013.76 KB  
Database Tools  -  Simple Abstraction Layer 1.0
Simple Abstraction Layer handles establishing connections, while another query execution and results retrieval.
10 KB  
Database Tools  -  SQL Abstraction Layer 0.1
SQLaL is a PHP Abstraction Layer script which makes it is easy to access and run queries on a MySQL database. It is designed to simplify the use of MySQL databases.The PHP script can be used for connecting, accessing, querying and reading results...
10 KB  
Programming  -  Database Abstraction Layer for PHP 0.4.5
DAL is a Database Abstraction Layer written entirely in PHP. The goal is to provide users with a general way to access databases. Changing from one DBMS to another only needs changing the driver you want to use.
156.54 KB  
Libraries  -  dbi4php 1.0
php4dbi is a database abstraction layer for PHP. dbi4php is simple to use (a single file with a simple API) and lean enought to not bloat your PHP application. It provides a common API for accessing a variety of database systems. This allows you...
17.41 KB  
Libraries  -  libdbi-drivers 0.8.2-1
libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl. Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by...
952.32 KB  
Libraries  -  Momomoto 0.1.3
Momomoto software is a database abstraction layer / object relational mapper for PostgreSQL..
 
Libraries  -  libpreludedb 0.9.13
The PreludeDB Library provides an abstraction layer upon the type and format of the database used to store IDMEF alerts. libpreludedb allows developers to use the Prelude IDMEF database easily and efficiently without worrying about SQL, and to...
563.2 KB  
Utilities  -  GroundWork Foundation 1.1 Milestone 1
GroundWork Foundation is a network management data abstraction layer and development platform written in Java. With GroundWork Foundation, data from both open source tools and legacy management systems can be accessed via real time status views,...
1.1 MB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
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  -  Math::GMPf 0.29
Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.
30.72 KB  
Programming  -  Net::Wire10 1.08
Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...
30.72 KB  
Programming  -  logilab-common 0.56.2
a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...
174.08 KB  
Programming  -  OpenSSL for linux 1.0.0a
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...
3.83 MB  
Libraries  -  wolfSSL 4.0.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...
3.88 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