Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
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"; }

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.

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.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (17)
As of 2014-10-20 14:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (77 votes), past polls