pysqlite smart search
alwaseem307ster at yahoo.com
Mon Feb 23 03:17:41 EST 2009
I am trying to develop a tiny program using python to search inside sqlite
database with file extension is .db in which the program will ask users to
enter their search query and base on that it will retrieve the results But
I need the program to have some smartness in search mechanism in which the
program will guess that the user is looking for these key words in the
so far i came up with this but the search ain't smart, i have to write the
full key word in order to retrieve specific information.
from pysqlite2 import dbapi2 as sqlite3
connection = sqlite3.connect('Photos.db')
memoryConnection = sqlite3.connect(':memory:')
cursor = connection.cursor()
prompt = 'Enter your search query?\n'
keyword = raw_input(prompt)
if cursor.execute('SELECT * FROM photos WHERE Tag LIKE ?',[keyword]):
cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
Any ideas and
thanks in advance
View this message in context: http://www.nabble.com/pysqlite-smart-search-tp22157116p22157116.html
Sent from the Python - python-list mailing list archive at Nabble.com.
More information about the Python-list