sql entry of file name n size


"be consistent"
	PerlMonks

sql entry of file name n size

by rajeshatbuzz (Novice)

on Jul 28, 2011 at 10:56 UTC ( #917244=perlquestion: print w/ replies, xml )

Need Help??

rajeshatbuzz has asked for the wisdom of the Perl Monks concerning the following question:

following program can list the directory all files along with their size. Now i was trying this info to sql table in manner such as file name | size... while doing this facing many issues. any idea how to do?

$DIR = "/home/rajesh";

@dirlist = `ls -l $DIR | tr -s " " " "| cut -d " " -f5,9`;
         foreach (@dirlist)
        {
                print "$_ \n";
        }
[download]

Comment on sql entry of file name n size Download Code
Re: sql entry of file name n size by Corion (Pope) on Jul 28, 2011 at 11:00 UTC
First, take a look at opendir and readdir to eliminate that `ls \| tr \| cut` pipe. Then, please take the time to tell us what you tried and what problems you encountered. That helps us to help you better. Maybe you want to interface to a database and store the information? Then DBI is what you need.	[reply] [d/l]
Re: sql entry of file name n size by linuxer (Deacon) on Jul 29, 2011 at 20:08 UTC
Just a quick thought in addition to Corion's answer: Once you have read the directory and its entries, you maybe want to have a look at the File::Spec module to create the file paths and the -s operator to determine the file sizes.	[reply]

Back to Seekers of Perl Wisdom

Node Status^?

node history
Node Type: perlquestion [id://917244]
Approved by Corion
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others cooling their heels in the Monastery: (6)

As of 2013-05-19 06:55 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

The best material for plates (tableware) is:

Results (397 votes), past polls