DBSchema::ColGroup(3pm) User Contributed Perl Documentation DBSchema::ColGroup(3pm)NAME
DBIx::DBSchema::ColGroup - Column group objects
SYNOPSIS
use DBIx::DBSchema::ColGroup;
$colgroup = new DBIx::DBSchema::ColGroup ( $lol_ref );
$colgroup = new DBIx::DBSchema::ColGroup ( @lol );
$colgroup = new DBIx::DBSchema::ColGroup (
[
[ 'single_column' ],
[ 'multiple_columns', 'another_column', ],
]
);
$lol_ref = $colgroup->lol_ref;
@sql_lists = $colgroup->sql_list;
@singles = $colgroup->singles;
DESCRIPTION
This class is deprecated and included for backwards-compatibility only. See DBIx::DBSchema::Index for the current class used to store
unique and non-unique indices.
DBIx::DBSchema::ColGroup objects represent sets of sets of columns. (IOW a "list of lists" - see perllol.)
METHODS
new [ LOL_REF ]
Creates a new DBIx::DBSchema::ColGroup object. Pass a reference to a list of lists of column names.
lol_ref
Returns a reference to a list of lists of column names.
sql_list
Returns a flat list of comma-separated values, for SQL statements.
For example:
@lol = (
[ 'single_column' ],
[ 'multiple_columns', 'another_column', ],
);
$colgroup = new DBIx::DBSchema::ColGroup ( @lol );
print join("
", $colgroup->sql_list), "
";
Will print:
single_column
multiple_columns, another_column
singles
Returns a flat list of all single item lists.
AUTHOR
Ivan Kohler <ivan-dbix-dbschema@420.am>
COPYRIGHT
Copyright (c) 2000 Ivan Kohler Copyright (c) 2000 Mail Abuse Prevention System LLC All rights reserved. This program is free software; you
can redistribute it and/or modify it under the same terms as Perl itself.
BUGS SEE ALSO
DBIx::DBSchema::Index, DBIx::DBSchema::Table, DBIx::DBSchema::ColGroup::Unique, DBIx::DBSchema::ColGroup::Index, DBIx::DBSchema, perllol,
perldsc, DBI
perl v5.14.2 2007-06-27 DBSchema::ColGroup(3pm)
Check Out this Related Man Page
DataSource(3) User Contributed Perl Documentation DataSource(3)NAME
DBIx::DataSource - Database-independant create and drop functions
SYNOPSIS
use DBIx::DataSource qw( create_database drop_database );
create_database( $data_source, $username, $password )
or warn $DBIx::DataSource::errstr;
drop_database( $data_source, $username, $password )
or warn $DBIx::DataSource::errstr;
DESCRIPTION
This module implements create_database and drop_database functions for databases. It aims to provide a common interface to database cre-
ation and deletion regardless of the actual database being used.
Currently supported databases are MySQL and PostgreSQL. Assistance adding support for other databases is welcomed and relatively simple -
see DBIx::DataSource::Driver.
FUNCTIONS
create_database DATA_SOURCE USERNAME PASSWORD
Create the database specified by the given DBI data source.
drop_database DATA_SOURCE
Drop the database specified by the given DBI data source.
AUTHOR
Ivan Kohler <ivan-dbix-datasource@420.am>
COPYRIGHT
Copyright (c) 2000 Ivan Kohler Copyright (c) 2000 Mail Abuse Prevention System LLC All rights reserved. This program is free software; you
can redistribute it and/or modify it under the same terms as Perl itself.
BUGS
If DBI data sources were objects, these functions would be methods.
SEE ALSO
DBIx::DataSource::Driver, DBIx::DataSource::mysql, DBIx::DataSource::Pg, DBI
perl v5.8.0 2000-09-25 DataSource(3)
Hey,
haha i'm back! Just when i thought everythign was working fine and dandy i found out that i screwed up my partitions way back when i set teh computer up like 5 months ago...lol. SO! I have decided to format....jus tcause this is my learning computer and install RH9 or whatever the... (15 Replies)
Hi all,
I want to create column names in a flat file and then load the data through some other application. For example, I have a file with emp.txt and I need column names as eno,ename,sal in the first line. The delimiter here is comma and record delimiter is end of line or unix new line. Could... (1 Reply)
Hi i have encountered a problem and i have tried many different things but my brain just has some limitations lol well anyways i was trying to make this program work down below so i can process multiple commands just by separating them with ;. I would apeciate if someone could just make it work kuz... (2 Replies)
suppose my one file has
>1|lol|hai i am cdfd
dafvshbejndjnudbnjdbyebjcb
bdhbdjndjndmdkmdkldhddjndj
dbdhbndjndjmdklm
sjskndknsknsknks
sbsjksnknsknknklsl
>2|lol|hai ia m cdfd123
jbsjbjbjbjbjbjbjbjbjbj
jkbkkkkkkkkkkkkk
khkkkkkkkkkkkkk
scbjbjbakbqlblabkla
>3lol|hai ia m cdfd3435... (2 Replies)
I've a file like this:
andrea andre@lol.com october
antonio@lol.com
marco 45247@pop.com
kk@pop.com may
pollo@lol.com
mary mary@lol.com
can I select only the column with email adress?
can I utilise a filter with @ ?
I want obtain this:
... (2 Replies)
Hi all,
I created file like this
AAb.lol
AAc.lol
AAx.lol
test.sh
My goal is to create a script (test.sh) which renames all the files to their original name without AA. I want to end up with this:
b.lol
c.lol
x.lol
Using sed how is it possible?
i tried to write the script
... (3 Replies)
Hello Guys
I want to sort a flat file by the third column (numeric ) and store it in some other name
I/P
9924873|20111114|00000000000013013|130|13|10/15/2010 12:36:22|W860944|N|00
9924873|20111114|00000000000013009|130|09|10/15/2010 12:36:22|W860944|N|00... (12 Replies)