""" COMP 364 Lecture 26 Author: Mathieu Perreault """ import sqlite3 # Connect to the database connection = sqlite3.connect('database.sql') # Get the cursor cursor = connection.cursor() # Accept keyboard input. keyboard_input = raw_input("Enter a list of artists, separated by a comma:\n") result_set = None for artist in keyboard_input.split(','): # ['artist1', 'artist2'] cursor.execute('SELECT * FROM tags WHERE artist_name=?', (artist,)) fetchone = cursor.fetchone() if fetchone is None: print "Unknown artist", artist else: # Known artists, print the tags taglist = fetchone[1].split(',') tagset = set(taglist) if result_set is None: result_set = tagset else: result_set = result_set.intersection(tagset) print "The intersection of the tags is: ", ",".join(result_set)