I am trying to write a script which will read inputs form user and process those files, I have issue reading the input parameters in a loop. Following is the script...
here I am not able to capture table1 table2 and table3 in the loop it prints TableName as $1 $2 and $3 but not the names that are given as input.
I'm trying to create a script with a for loop that take strings in as the parameters. Some of the strings have spaces in them, and I can't get it to work properly. For example:
#!/bin/ksh
INFILE=snapshot.log
OUTFILE=summary.out
a="Lock waits"
b="Deadlocks detected"
for PARAM in... (6 Replies)
hi, unix wizards,
i have a question about the logic of my inner for loop below. first, what i am trying to do is to write a script called create_account that automatically creates mysql accounts. the user can provide a user_name or a group_id as an argument (and the script can take multiple... (1 Reply)
Hello,
I've got next problem:
I want to examine at the beginning of a script in an if loop that:
1. Is there 4 parameters given
2. If first state is true then: is there switches -e and -d?
3. At the end, how can i indentify them as variebles regardlees to its order.
I was thinking like... (2 Replies)
I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends.
As an example I've written a script called question (The fist command is to show what is the contents of the... (2 Replies)
Hi there
I'm new to UNIX scripting; I’m stuck with the following
I have an Oracle SQL script that takes three parameters
1- File Name
2- File Path
3- File creation date
Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need... (3 Replies)
Hello,
On Aix 5.2, we changed the parameters tcp_keepinit, tcp_keepintvl and tcp_keepidle with the no command.
tunrestore -R is present in inittab
in the directory /etc/tunables we can clearly see the inclusion of parameters during reboot, including the file lastboot.log
... (0 Replies)
#!/bin/bash
function check_num_args()
{
if ; then
echo "Please provide a file name"
else
treat_as_file $*
fi
}
function treat_as_file()
{
numFiles=$#
for((i=1;i<=$numFiles;i++));do
echo $i
... (3 Replies)
Hey guys,
How do I make a loop that reads all the parameters en then stop when there are no parameters anymore ?
Something that gives an output like this:
./Script.sh parameter1 parameter2 parameter3
parameter = parameter1
parameter = parameter2
parameter = parameter3
Thanks a lot,... (5 Replies)
I like to “optimize” / make more like a real program my bash script by replacing repetitious code which utilizes positional parameters.
I am having two issues I cannot solve and would appreciate some assistance with resolving them.
a) how to modify the whiptail checklist... (3 Replies)
Discussion started by: annacreek
3 Replies
LEARN ABOUT DEBIAN
cgi::session::driver::dbi
CGI::Session::Driver::DBI(3pm) User Contributed Perl Documentation CGI::Session::Driver::DBI(3pm)NAME
CGI::Session::Driver::DBI - Base class for native DBI-related CGI::Session drivers
SYNOPSIS
require CGI::Session::Driver::DBI;
@ISA = qw( CGI::Session::Driver::DBI );
DESCRIPTION
In most cases you can create a new DBI-driven CGI::Session driver by simply creating an empty driver file that inherits from
CGI::Session::Driver::DBI. That's exactly what sqlite does. The only reason why this class doesn't suit for a valid driver is its name
isn't in lowercase. I'm serious!
NOTES
CGI::Session::Driver::DBI defines init() method, which makes DBI handle available for drivers in Handle - object attribute regardless of
what "\%dsn_args" were used in creating session object. Should your driver require non-standard initialization you have to re-define init()
method in your .pm file, but make sure to set 'Handle' - object attribute to database handle (returned by DBI->connect(...)) if you wish to
inherit any of the methods from CGI::Session::Driver::DBI.
STORAGE
Before you can use any DBI-based session drivers you need to make sure compatible database table is created for CGI::Session to work with.
Following command will produce minimal requirements in most SQL databases:
CREATE TABLE sessions (
id CHAR(32) NOT NULL PRIMARY KEY,
a_session TEXT NOT NULL
);
Your session table can define additional columns, but the above two are required. Name of the session table is expected to be sessions by
default. You may use a different name if you wish. To do this you have to pass TableName as part of your " \%dsn_args ":
$s = CGI::Session->new('driver:sqlite', undef, {TableName=>'my_sessions'});
$s = CGI::Session->new('driver:mysql', undef,
{
TableName=>'my_sessions',
DataSource=>'dbi:mysql:shopping_cart'.
});
To use different column names, change the 'create table' statement, and then simply do this:
$s = CGI::Session->new('driver:pg', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
DataSource=>'dbi:pg:dbname=project',
});
or
$s = CGI::Session->new('driver:pg', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DRIVER ARGUMENTS
Following driver arguments are supported:
DataSource
First argument to be passed to DBI->connect(). If the driver makes the database connection itself, it will also explicitly disconnect
from the database when the driver object is DESTROYed.
User
User privileged to connect to the database defined in "DataSource".
Password
Password of the User privileged to connect to the database defined in "DataSource"
Handle
An existing DBI database handle object. The handle can be created on demand by providing a code reference as a argument, such as
"<sub{DBI-"connect}>>. This way, the database connection is only created if it actually needed. This can be useful when combined with
a framework plugin like CGI::Application::Plugin::Session, which creates a CGI::Session object on demand as well.
"Handle" will override all the above arguments, if any present.
TableName
Name of the table session data will be stored in.
LICENSING
For support and licensing information see CGI::Session
perl v5.12.4 2011-07-08 CGI::Session::Driver::DBI(3pm)