Solved

Searching the values in a list for values of a list of mysql values

Posted on 2009-05-13
3
234 Views
Last Modified: 2012-05-06
If it's not obvious from the code, I'm really new to Python, but I've some experience in JavaScript and PHP.  In my code I'm attempting to check the extensions of a list of files to see if they have a certain extension.  I know that I could use the glob module to create a list of only the files with the extensions, but I the extensions I'm looking for need to be taken from a mysql database.  This is a cgi script.  Anyways, when the extensions list is printed it prints like this:
(('aac',), ('aif',), ('ape',), ('flac',)
I'm getting an error message about my regular expression, which I'm not really sure about:
<class 'sre_constants.error'>: nothing to repeat
Can you point out the mistake in my logic and or syntax?
I'd also accept an alternative method that would achieve the same thing.
Thanks ahead of time.
#!C:\Python26\python.exe

print "Content-Type: text/html"

print 

import cgitb

import MySQLdb

import os

import re
 

cgitb.enable()
 

db = MySQLdb.connect('localhost', 'root', 'rootpass', 'ccs', 3307)

c=db.cursor()
 

extensions = []

c.execute("""SELECT ext FROM fileext WHERE filetypeid=2""")

extensions = c.fetchall()

print extensions

c.close()
 

#files

path = 'H:\\'

allfiles = []

for root,dir,files in os.walk(path):

	filelist = [os.path.join(root,fi) for fi in files]

	for f in filelist:

		for ext in extensions:

			if re.search(fi, str(ext)):

				dbCheck(fi)

				break
 

def dbCheck(file):

	print file

	filesize = os.stat(file).st_size

	c=db.cursor()

	c.execute("""SELECT*FROM musicfiles WHERE (filepath, filesize) = (%s, %s)""", (file, filesize,))

	row = c.fetchone()

	if(row):

		print row

	else:

		print "No matches."
 

print "<title>Scan Music Folders</title>"

Open in new window

0
Comment
Question by:khsater
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24381443
Shouldn't that be:

if re.search(str(ext), fi):
0
 
LVL 4

Author Closing Comment

by:khsater
ID: 31581300
Wow, that's really embarrassing.  I was looking right at the manual when I typed that.
Thanks!
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24381456
:) glad to help, sometimes you just need that 2nd set of eyes!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

A set of related code is known to be a Module, it helps us to organize our code logically which is much easier for us to understand and use it. Module is an object with arbitrarily named attributes which can be used in binding and referencing. …
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now