I use Perl and Bash everyday. I have written a lot of scripts that I use over and over. Delimited files arent hard to work with with Perl. Look at the split routine for Perl to start with. File handlers. Reach out to me if you need help with it.
I have written an sql query , my intentions are to read and store the data to a tmp table, after that i want to read and insert into two tables that are related through a many to many relation ship . is this the right approach ? .
if it is how can i convert the following sql statements into perl scripting syntax
and how can i grab each id (PK) from both tables after inserting , and store them into an associative array to insert them later to the many to many bridge table , this could be totally off your suggestions are welcomed .
HI
I need to import data from a file which is in comressed format
but system doesn't have enough space to uncompress file
Is there any way so that i can do import from compressed file. (4 Replies)
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Hi,
I have a requirement for creating a Perl Script which will perform Data Import process in an automated way and I am elaborating herewith :
Section 1 )
- use the following command line format :
"./import.pl -h hostname -p port -f datafile.txt"
Section 2)
datafile.txt will... (3 Replies)
Hi ,
I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code :
X=`sqlplus -s user/pwd@DB <<eof
select col1 from table1;
EXIT;
eof`
echo $X>myfile
Can anyone... (2 Replies)
I have been trying to write a simple snip of bash shell code to import from 1 to 100 records into a BASH array.
I have a CSV file that is structured like:
record1,item1,item2,item3,item4,etc.,etc. .... (<= 100 items)
record2,item1,item2,item3,item4,etc.,etc. .... (<= 100 items)... (5 Replies)
Say I have two tables like below..
status
HId sName dName StartTime EndTime
1 E E 9:10 10:10
2 E F 9:15 10:15
3 G H 9:17 10:00
logic
Id devName capacity free Line
1 E 123 34 1
2 E 345 ... (3 Replies)
I have 2 files generated in linux that has common output and were produced across multiple hosts with the same setup/configs. These files do some simple reporting on resource allocation and user sessions. So, essentially, say, 10 hosts, with the same (2) system reporting in the files, so a... (0 Replies)
I want to lookup values from two different tables based on common columns and append. The trick is the column to be looked up is not fixed and varies , so it has to be detected from the header. How can I achieve this at once, for multiple data files, but lookup tables fixed.
The two lookup... (5 Replies)
We have the data looks like below in a log file.
I want to generat files based on the string between two hash(#) symbol like below
Source:
#ext1#test1.tale2 drop
#ext1#test11.tale21 drop
#ext1#test123.tale21 drop
#ext2#test1.tale21 drop
#ext2#test12.tale21 drop
#ext3#test11.tale21 drop... (5 Replies)
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 Replies
LEARN ABOUT DEBIAN
tangram::type::scalar
Tangram::Type::Scalar(3pm) User Contributed Perl Documentation Tangram::Type::Scalar(3pm)NAME
Tangram::Type::Scalar - map scalar fields
SYNOPSIS
use Tangram;
Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string => [ qw( name firstName gender ) ],
int => [ qw( age ) ],
real => [ qw( height weight ) ],
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string =>
{
name => { sql => 'VARCHAR(100)' },
1stname => {
col => 'firstName',
sql => 'VARCHAR(100) NULL' },
gender => undef()
},
DESCRIPTION
Classes Tangram::Type::String, ::Int and ::Real and ::Ref are responsible for mapping the various subtypes of scalars. The first three map-
pings are documented here since they differ very little. See Tangram::Type::Ref::FromMany for information on mapping references.
Tangram::Type::String uses DBI's quote() method to quote strings if that method is available, thus making it possible to store binary
objects or multiline text in databases that support it (thanks to Marian Kelc <marian.kelc@ruhr-uni-bochum.de> for suggesting this improve-
ment).
The three predefined typetags "string", "int" and "real" are for the corresponding Perl scalar subtypes.
Each scalar field is stored in a single column of the table associated to the class.
The persistent fields may be specified either as a hash or as an array of field names.
In the hash form, each entry consists in a field name and an associated option hash. The option hash may contain the following fields:
* col
* sql
* automatic
"col" sets the name of the column used to store the field's value. This field is optional, it defaults to the persistent field name. Over-
ride if the field name is not an acceptable SQL column name.
"sql" sets the SQL type of the column. Used by Schema::deploy() when initializing a database. Defaults to 'VARCHAR(255) NULL' for strings,
'INT NULL' for ints and 'REAL NULL' for reals.
"automatic", if set to true, tells Tangram not to save the field to storage. This is useful for auto-increment or timestamp columns.
The persistent fields may also be specified as an array of strings, in which case the defaults are used.
perl v5.8.8 2006-03-29 Tangram::Type::Scalar(3pm)