Filtering and Grouping: A Comparison of SQL, Linux Scripting, and Ruby
Learn some of the transferable concepts common to Oracle SQL, Linux commands, and scripting to address problems that involve data sets that need to be grouped, sorted, and filtered.
I need following code in linux bash:
Step 1:
run a command and create file1
run a command and create file2
compare file1 and 2
if any difference go to step 1 (keep trying 4 times, if no success, abort program)
else do nothing and continue program.
now I'm... (2 Replies)
Hello people, I'm scratching my head to find a solution to this query.
I have a simple SQL table:
data | tot
==================
111201/0000 | 3
111201/0001 | 5
111201/0002 | 7
111201/0003 | 2
.....
111201/0059 | 1
111201/0100 | 5
111201/0101 | 8
111201/0102 | 6... (7 Replies)
I have a scenario to implement in Korn shell script. Here it is..
I need to compare two values to see whether they are same or not. The issue is that the values coming in for comparison can be a string or an integer which can be determined during run time only.
Which korn shell comparison... (2 Replies)
Hi,
I have an array of strings. Each string has 4 comma separated values. I am binding this array to a SQL where I am required to do an INSERT after grouping.
The binding is done as :
$insertADWSth->bind_param_array(1,A_CONSTANT_STRING);... (1 Reply)
Still new to bash. Using debian lenny 5, bash version 3.2.39. I'm working on three scripts. I need help completing them.
One script that inputs a plain text file, echo then chop it up into separate whitespace-delimited strings as an output. Not sure how to do this...
for example, the... (4 Replies)
Hi,
I need sample code to compare the two files line by line which contains text strings and to print the difference in the third file.
Thanks in advance (1 Reply)
SQL::Translator::Parser::DBI(3pm) User Contributed Perl Documentation SQL::Translator::Parser::DBI(3pm)NAME
SQL::Translator::Parser::DBI - "parser" for DBI handles
SYNOPSIS
use DBI;
use SQL::Translator;
my $dbh = DBI->connect('dsn', 'user', 'pass',
{
RaiseError => 1,
FetchHashKeyName => 'NAME_lc',
}
);
my $translator = SQL::Translator->new(
parser => 'DBI',
dbh => $dbh,
);
Or:
use SQL::Translator;
my $translator = SQL::Translator->new(
parser => 'DBI',
parser_args => {
dsn => 'dbi:mysql:FOO',
db_user => 'guest',
db_password => 'password',
}
);
DESCRIPTION
This parser accepts an open database handle (or the arguments to create one) and queries the database directly for the information.
The following are acceptable arguments:
o dbh
An open DBI database handle. NB: Be sure to create the database with the "FetchHashKeyName => 'NAME_lc'" option as all the DBI
parsers expect lowercased column names.
o dsn
The DSN to use for connecting to a database.
o db_user
The user name to use for connecting to a database.
o db_password
The password to use for connecting to a database.
There is no need to specify which type of database you are querying as this is determined automatically by inspecting
$dbh->{'Driver'}{'Name'}. If a parser exists for your database, it will be used automatically; if not, the code will fail automatically
(and you can write the parser and contribute it to the project!).
Currently parsers exist for the following databases:
o MySQL
o SQLite
o Sybase
o PostgreSQL (still experimental)
Most of these parsers are able to query the database directly for the structure rather than parsing a text file. For large schemas, this
is probably orders of magnitude faster than traditional parsing (which uses Parse::RecDescent, an amazing module but really quite slow).
Though no Oracle parser currently exists, it would be fairly easy to query an Oracle database directly by using DDL::Oracle to generate a
DDL for the schema and then using the normal Oracle parser on this. Perhaps future versions of SQL::Translator will include the ability to
query Oracle directly and skip the parsing of a text file, too.
AUTHOR
Ken Y. Clark <kclark@cpan.org>.
SEE ALSO
DBI, SQL::Translator.
perl v5.14.2 2012-05-01 SQL::Translator::Parser::DBI(3pm)
