RE: Php/python questions:Recursing directories,renaming files,and updating mysql records
- From: "Ken Perry" <whistler@xxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Thu, 18 Jun 2009 21:52:10 -0400
No use walk its in the os module. It does all the work for you.
Ken
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Tyler
Littlefield
Sent: Thursday, June 18, 2009 9:07 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Php/python questions:Recursing directories,renaming files,and
updating mysql records
Hello list,
I've got a quick question.
I would like to index all of my music in a mysql database, with something
like python.
First I'd like to recurse through the directories, rename everything with
spaces, and cap letters to lowercase and replace space with underline. I
think I could use a str.replace in python, then tolower, and rename the
file, but I'm a bit confused with the recursing.
I'm trying to figure out how I'd recurse through a list of directories, say
I have top level dirs of animals, food, and automobiles,
Then under each one wsay for animals I have pet, and wild,
Then pet would have dog, cat, etc.
I would start at the top level (/), drop to animals, then see pet and wild,
drop to wild, then cat as it would be the first alphabetically.
How would I then go back and go to dog (always remembering that I just did
cat), and once I was done with everything under the pets directory go back
to animals and move to the next unused directory?
Second, I'd like to be able to update the database easily, lets say I add a
new album or artest, the idea would be to run the script that would check
the list of everything, then add what wasn't there, or update what changed.
Could I just delete everything in a table and restart?
I know about drop table, and I suppose I could just use a drop, then create,
but that seems kind of messy.
I could also use something like select * from music where artest = 'artest',
size='size', but if I add a larger file, it won't catch that and will just
end up adding a new record, which means I'm left with multiples of the same
thing.
Hopefully the message made some sense, and input would be great, as I'm
slightly lost with this. :)
Thanks,
Tyler Littlefield
Web: tysdomain.com
email: tyler@xxxxxxxxxxxxx
My programs don't have bugs, they're called randomly added features.
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
