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

DBIx::Class::Manual::Cookbook 0.08001

  Date Added: April 11, 2010  |  Visits: 849

DBIx::Class::Manual::Cookbook

Report Broken Link
Printer Friendly Version


Product Homepage
Download (72 downloads)

DBIx::Class::Manual::Cookbook is a Perl module that contains miscellaneous recipes. Paged results When you expect a large number of results, you can ask DBIx::Class for a paged resultset, which will fetch only a small number of records at a time: my $rs = $schema->resultset(Artist)->search( undef, { page => 1, # page to return (defaults to 1) rows => 10, # number of results per page }, ); return $rs->all(); # all records for page 1 The page attribute does not have to be specified in your search: my $rs = $schema->resultset(Artist)->search( undef, { rows => 10, } ); return $rs->page(1); # DBIx::Class::ResultSet containing first 10 records In either of the above cases, you can return a Data::Page object for the resultset (suitable for use in e.g. a template) using the pager method: return $rs->pager(); Complex WHERE clauses Sometimes you need to formulate a query using specific operators: my @albums = $schema->resultset(Album)->search({ artist => { like, %Lamb% }, title => { like, %Fear of Fours% }, }); This results in something like the following WHERE clause: WHERE artist LIKE %Lamb% AND title LIKE %Fear of Fours% Other queries might require slightly more complex logic: my @albums = $schema->resultset(Album)->search({ -or => [ -and => [ artist => { like, %Smashing Pumpkins% }, title => Siamese Dream, ], artist => Starchildren, ], }); This results in the following WHERE clause: WHERE ( artist LIKE %Smashing Pumpkins% AND title = Siamese Dream ) OR artist = Starchildren For more information on generating complex queries, see "WHERE CLAUSES" in SQL::Abstract..

Requirements: No special requirements
Platforms: Linux
Keyword: Artist Dbix Dbixclassmanualcookbook Libraries Like Page Perl Module Programming Results Resultset Return Search Where
Users rating: 0/10

License: Freeware Size: 286.72 KB
DBIX::CLASS::MANUAL::COOKBOOK RELATED
Libraries  -  DBIx::SQL::Abstract 0.07
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) =...
4.1 KB  
Libraries  -  DBIx::Recordset::Playground 1.12
DBIx::Recordset::Playground is a Perl module with working sample usages of DBIx::Recordset. This document serves several purposes. One, it makes it easy to get started with DBIx::Recordset. Two, it serves as a place for those experienced with...
1.12 MB  
Libraries  -  DBIx::Class::LibXMLdoc 0.03
DBIx::Class::LibXMLdoc is a Perl module to create an adjunct "Doc" accessor of a columns data which is automatically parsed into a LibXML documentElement (alpha-software). SYNOPSIS package My::DB::thingy; __PACKAGE__->load_components(qw/...
5.12 KB  
Libraries  -  DBIx::DBStag::Cookbook 0.08
DBIx::DBStag::Cookbook is a Perl module for building and querying databases from XML. SYNOPSIS stag-autoddl.pl stag-storenode.pl selectall_xml.pl This will give an outline of how to build a normalised relational database from XML source...
133.12 KB  
Libraries  -  DBIx::SQLCrosstab::Format 1.17
DBIx::SQLCrosstab::Format is a Perl module with formats results created by DBIx::SQLCrosstab. SYNOPSIS use DBIx::SQLCrosstab::Format; my $dbh=DBI->connect("dbi:driver:database" "user","password", {RaiseError=>1}) or die "error in connection...
66.56 KB  
Libraries  -  DBIx::Wrapper 0.24
DBIx::Wrapper library is a Perl module that serves as a wrapper around DBI, providing additional functionality and convenience methods. Whats New in This Release: - This release adds convenience methods for generating CSV, XML, and bencoded...
27.65 KB  
Libraries  -  DBIx::HTML::ClientDB 1.05
DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit...
11.26 KB  
Libraries  -  DBIx::Migration::Directories 0.05
DBIx::Migration::Directories is a Perl module to install/remove/upgrade/downgrade SQL schemas. SYNOPSIS use DBIx::Migration::Directories; use DBI; my $dbh = DBI->connect(db:something:some=where, user, pass); my $m =...
28.67 KB  
Libraries  -  Weather::Bug 0.01
Weather::Bug is a Perl module that can get realtime weather where available. SYNOPSIS use Weather::Bug; my $w = get_live_weather( KCMI ); print "It is $w->{temp} degrees in $w->{location}n"; Weather::Bug uses data from aws.coms live Java...
3.07 KB  
Libraries  -  SVN::Log::Index 0.51
SVN::Log::Index is a Perl module that can index and search over Subversion commit logs. SYNOPSIS my $index = SVN::Log::Index->new({ index_path => /path/to/index }); if($creating) { # Create from scratch if necessary $index->create({...
13.31 KB  
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 3.15.3
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