class::dbi::loader::relationship(3pm) [debian man page]
Relationship(3pm) User Contributed Perl Documentation Relationship(3pm)NAME
Class::DBI::Loader::Relationship - Easier relationship specification in CDBI::L
SYNOPSIS
use Class::DBI::Loader::Relationship;
my $loader = Class::DBI::Loader->new( dsn => "mysql:beerdb",
namespace => "BeerDB");
Now instead of saying
BeerDB::Brewery->has_many(beers => "BeerDB::Beer");
BeerDB::Beer->has_a(brewery => "BeerDB::Brewery");
BeerDB::Handpump->has_a(beer => "BeerDB::Beer");
BeerDB::Handpump->has_a(pub => "BeerDB::Pub");
BeerDB::Pub->has_many(beers => [ BeerDB::Handpump => 'beer' ]);
BeerDB::Beer->has_many(pubs => [ BeerDB::Handpump => 'pub' ]);
Just say
$loader->relationship( "a brewery produces beers" );
$loader->relationship( "a pub has beers on handpumps" );
DESCRIPTION
This module acts as a mix-in, adding the "relationship" method to "Class::DBI::Loader". Since "Class::DBI::Loader" knows how to map between
table names and class names, there ought to be no need to replicate the names.
In addition, it is common (but not universal) to want reverse relationships defined for has-many relationships, and for has-a relationships
to be defined for the linkages surrounding a many-to-many table.
The aim of "CDBIL::Relationship" is to simplify the declaration of common database relationships by providing both of these features.
The "relationship" takes a string. It recognises table names (singular or plural, for convenience) and extracts them from the "sentence".
AUTHOR
Simon Cozens, "simon@cpan.org"
SEE ALSO
Class::DBI::Loader.
perl v5.10.1 2010-07-04 Relationship(3pm)
Check Out this Related Man Page
DBIx::Class::Schema::Loader::DBI::InterBase(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBI::InterBase(3pm)NAME
DBIx::Class::Schema::Loader::DBI::InterBase - DBIx::Class::Schema::Loader::DBI Firebird Implementation.
DESCRIPTION
See DBIx::Class::Schema::Loader and DBIx::Class::Schema::Loader::Base.
COLUMN NAME CASE ISSUES
By default column names from unquoted DDL will be generated in lowercase, for consistency with other backends.
Set the preserve_case option to true if you would like to have column names in the internal case, which is uppercase for DDL that uses
unquoted identifiers.
Do not use quoting (the quote_char option in connect_info when in the default "preserve_case => 0" mode.
Be careful to also not use any SQL reserved words in your DDL.
This will generate lowercase column names (as opposed to the actual uppercase names) in your Result classes that will only work with
quoting off.
Mixed-case table and column names will be ignored when this option is on and will not work with quoting turned off.
SEE ALSO
DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base, DBIx::Class::Schema::Loader::DBI
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-06-08 DBIx::Class::Schema::Loader::DBI::InterBase(3pm)
Hi all!
Here is my problem : I have a string like the following :
20030613170404;BAN_CAV ; starting script Loader.sh on ; 13/06/2003 at ; 17;04;03
I want to eraze all characters located after "Loader.sh", because there are unuseful.
I tried to use sed...but it didnt work....i guess i... (1 Reply)
Hi All,
I am getting coredump error, when I try to execute Oracle SQL*Loader from Shell script in Unix environment. But SQL*Loader from local machine runs fine with same database.
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Apr 23 05:23:47 2007
Copyright (c) 1982, 2002, Oracle... (3 Replies)
This is the sample sqlldr log:
------------------------------------------------------------------------------------------------------------
SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control... (13 Replies)
Hello,
Can somebody explain me the relationship between /sbin and /etc directories ? what is the relationship between them and what are the roles of files such as rcd.1 etc? (1 Reply)
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)