dbix::class::schema::loader::dbi::writing(3pm) [debian man page]
DBIx::Class::Schema::Loader::DBI::Writing(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBI::Writing(3pm)NAME
DBIx::Class::Schema::Loader::DBI::Writing - Loader subclass writing guide for DBI
SYNOPSIS
package DBIx::Class::Schema::Loader::DBI::Foo;
# THIS IS JUST A TEMPLATE TO GET YOU STARTED.
use strict;
use warnings;
use base 'DBIx::Class::Schema::Loader::DBI';
use mro 'c3';
sub _table_uniq_info {
my ($self, $table) = @_;
# ... get UNIQUE info for $table somehow
# and return a data structure that looks like this:
return [
[ 'keyname' => [ 'colname' ] ],
[ 'keyname2' => [ 'col1name', 'col2name' ] ],
[ 'keyname3' => [ 'colname' ] ],
];
# Where the "keyname"'s are just unique identifiers, such as the
# name of the unique constraint, or the names of the columns involved
# concatenated if you wish.
}
sub _table_comment {
my ( $self, $table ) = @_;
return 'Comment';
}
sub _column_comment {
my ( $self, $table, $column_number ) = @_;
return 'Col. comment';
}
1;
DETAILS
The only required method for new subclasses is "_table_uniq_info", as there is not (yet) any standardized, DBD-agnostic way for obtaining
this information from DBI.
The base DBI Loader contains generic methods that *should* work for everything else in theory, although in practice some DBDs need to
override one or more of the other methods. The other methods one might likely want to override are: "_table_pk_info", "_table_fk_info",
"_tables_list" and "_extra_column_info". See the included DBD drivers for examples of these.
To import comments from the database you need to implement "_table_comment", "_column_comment"
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::Writing(3pm)
Check Out this Related Man Page
DBIx::Class::Schema::Loader::DBObject::Sybase(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBObject::Sybase(3pm)NAME
DBIx::Class::Schema::Loader::DBObject::Sybase - Class for Database Objects for Sybase ASE and MSSQL Such as Tables and Views in
DBIx::Class::Schema::Loader
DESCRIPTION
This is a subclass of DBIx::Class::Schema::Loader::DBObject that adds support for fully qualified objects in Sybase ASE and MSSQL including
both "database" and schema of the form:
database.owner.object_name
METHODS
database
The database name this object belongs to.
Returns undef if ignore_schema is set.
sql_name
Returns the properly quoted full identifier with "database", schema and name.
SEE ALSO
DBIx::Class::Schema::Loader::Table::Sybase, DBIx::Class::Schema::Loader::DBObject, DBIx::Class::Schema::Loader::Table,
DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base
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-05-05 DBIx::Class::Schema::Loader::DBObject::Sybase(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!
here is the file i am trying to sort :
GREIMBAJ00;BAN_CAV;Loader.sh;2003/06/13;17:04:04
GREIMBAJ00;PER_COT;Loader.sh;2003/06/13;17:04:16
GREIMBAJ00;PER_COT;Traitement.sh;2003/06/13;17:04:18
GREIMBAJ00;BAN_PAK;Loader.sh;2003/06/13;17:04:11... (3 Replies)
Hi all again,
here is the file i am working on :
GREIMBAJ00;BAN_CAV;Loader.sh;2003/06/13;17:04:04
GREIMBAJ00;BAN_CAV;Loader.sh;2003/06/13;17:04:06
GREIMBAJ00;BAN_PAK;Loader.sh;2003/06/13;17:04:11
GREIMBAJ00;BAN_PAK;Loader.sh;2003/06/13;17:04:18... (5 Replies)
Hi,
We are running a perl script to upload some data using SQL* Loader. We pipe the data in a http request to SQL*Loader which loads the data to the database. We encounter the error "Inappropirate ioctl for device" when we try to upload huge data. Any solution would be greatly appreciated.... (4 Replies)
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)
Hi Guys,
I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically.
Let me break it down a bit more,... (2 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)
Hi,
I have a log file whose size is number of characters in the file with multiple lines.
Example:
SQL*Loader: Release 10.2.0.4.0 - Production on Sat Sep 12 07:55:29 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Control File: ../adm/ctl/institution.ctl
Character Set... (4 Replies)
Hi
I am running Sql Loader script in Unix Shell Script, I want to make shell script failure when Sql Loader script gives any warnings or failed. Please advise on this.
Thanks (1 Reply)