Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

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"; }

Replies are listed 'Best First'.
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.

Re: sql entry of file name n size
by linuxer (Curate) 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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://917244]
Approved by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2016-10-23 00:58 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (299 votes). Check out past polls.