12-22-2009
Iam using Mysql database.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
My first post..:)
Right...I want to move existing files (with some date in their name) currently in $mainftp, to $mainfolder/$foldate/system1.
I'd like to be able to increment date in the for loop? Is this possible or should I use a different technique.
The script return the... (4 Replies)
Discussion started by: SunnyK
4 Replies
2. Shell Programming and Scripting
Hi,
I want to increment date, using Shell Script, a loop to add one day after 24hrs. :confused:
Cheers
Kunal (1 Reply)
Discussion started by: niceboykunal123
1 Replies
3. Shell Programming and Scripting
export a=`date`
a=`expr $a + 1`
Is it possible?
if not how can i increment or decrement a date variable? (2 Replies)
Discussion started by: arghya_owen
2 Replies
4. Shell Programming and Scripting
I need to increment a date value through shell script.
Input value consist of start date and end date in DATE format of unix.
For eg.
I need increment a date value of 1/1/09 to 31/12/09 i.e for a whole yr.
The output must look like
1/1/09
2/2/09
.
.
.
31/1/09
.
.
1/2/09
.
28/2/09... (1 Reply)
Discussion started by: sunil087
1 Replies
5. Shell Programming and Scripting
Hi,
I have a perl script which prints epoch value of date in milliseconds as the output.
My reuirement is that once the output is printed,the day variable shld increment by 1 and when i execute the script for the second time the output shld be for the new day value.
My script looks as... (11 Replies)
Discussion started by: jyothi_wipro
11 Replies
6. Shell Programming and Scripting
Hi,
I have a variable lets say DATA_DATE.
I have to pass some value to this variable in YYYYMMDD format.
lets say today I have passed this variable as :
DATA_DATE=20100107
Then pls help me how to calculate another variable DATA_DATE1 (which is DATA_DATE+1).
The code should work... (3 Replies)
Discussion started by: 46019
3 Replies
7. Shell Programming and Scripting
hi Friends,
Today_Dt=`date "+%Y-%m-%d"`
So the Today date is 2010-05-03
I have a file which has date values as below
2010-04-27
2010-04-02
2010-04-18
2010-04-28
2010-04-29
.. (1 Reply)
Discussion started by: Gopal_Engg
1 Replies
8. Shell Programming and Scripting
hi experts,
my requirement is like this i need to develop a shell script to update date part with new incremental date time in file some 'X' which is kept at some server location incrementing every two hours.as i am new to this scripting i need support from u people,thanx in advance (1 Reply)
Discussion started by: amanmro
1 Replies
9. Shell Programming and Scripting
Need to increment the date from "currentdate + 90days" inside the for loop (i=1 to i=50) (5 Replies)
Discussion started by: aroragaurav.84
5 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have parameter file wo_location.prm which has a date variable $last_upd_date= 02032016.
I need to write a unix shell script to find that variable and increment it by 1 day.
The path to the file is root/dir_lc/shared/param/wo_location.prm and the variable is $last_upd_date.
Any... (2 Replies)
Discussion started by: isenhiem
2 Replies
LEARN ABOUT DEBIAN
tangram::relational
Tangram::Relational(3pm) User Contributed Perl Documentation Tangram::Relational(3pm)
NAME
Tangram::Relational - Orthogonal Object Persistence in Relational Databases
SYNOPSIS
use Tangram;
$schema = Tangram::Relational->schema( $hashref );
Tangram::Relational->deploy($schema, $dbh);
$storage = Tangram::Relational->connect( $schema,
$data_source, $username, $password );
$storage->disconnect();
Tangram::Relational->retreat($schema, $dbh);
DESCRIPTION
This is the entry point in the vanilla object-relational persistence backend. Vendor-specific backends should be used when they exist. Cur-
rently Mysql, Sybase and Oracle have such backends; see Tangram::mysql, Tangram::Sybase and Tangram::Oracle.
More backends could be added in the future; they might implement persistence in XML documents, pure object databases, using C database
libraries to bypass the need for an RDBMS, etc.
CLASS METHODS
schema
$schema = Tangram::Relational->schema( $hashref );
Returns a new Schema object. See Tangram::Schema.
deploy
Tangram::Relational->deploy($schema);
Tangram::Relational->deploy($schema, HANDLE);
Tangram::Relational->deploy($schema, @dbi_args);
Writes SQL statements for preparing a database for use with the given $schema.
Called with a single argument, writes SQL statements to STDOUT.
Called with two arguments, writes SQL statements to HANDLE. HANDLE may be a DBI connection handle or a file handle.
Called with more than two arguments, passes all but the first to DBI::connect() and writes statements to the resulting DBI handle, which is
automatically closed.
The SQL code is only guaranteed to work on newly created databases.
connect
$storage = Tangram::Relational->connect( $schema,
$data_source, $user, $password, \%options )
Connects to a storage and return a handle object. Dies in case of failure.
$schema is a Schema object describing the system of classes stored in the database.
$data_source, $user and $password are passed directly to DBI::connect().
\%options is a reference to a hash containing connection options. See Tangram::Storage for a description of available options.
retreat
Tangram::Relational->retreat($schema);
Tangram::Relational->retreat($schema, HANDLE);
Tangram::Relational->retreat($schema, @dbi_args);
Remove the tables created by deploy(). Only guaranteed to work against a database that was deployed using exactly the same schema.
For an explanation of the possible argument lists, see deploy.
WRITING A VENDOR DRIVER
Like Charles Moore (inventor of Forth) used to say, "standards are great, everybody should have one!".
Tangram can take advantage of extensions available in some SQL dialects.
To create a vendor-specific driver, call it "Tangram::Foo" (where "Foo" is the name of the DBI driver, as would be selected with the DBI
connection string "dbi:Foo:"), and derive "Tangram::Relational".
For now, the existing back-ends should be used as examples of how to extend Tangram to support different databases or utilise some of their
more exotic features.
perl v5.8.8 2006-03-29 Tangram::Relational(3pm)