args = parser.parse_args() db = sqlite3.connect(args.db) db.text_factory = str db = db.cursor() song = args.song if (song): song = allow_quotes(song) artist = args.artist if artist: artist = allow_quotes(artist) # replace popular proper-english spellings # with janky-ass internationalizations artist = translate_artist(artist) limit = args.limit if (artist and song): message = 'Searching for "%s" by %s' % (song, artist) plays = get_plays_by_artist_and_song(db, artist, song, limit=limit) elif(artist): message = 'Searching for Artist: "%s"' % (artist) plays = get_plays_by_artist(db, artist, limit=limit) elif(song): message = 'Searching for Song: "%s"' % (song,) plays = get_plays_by_song(db, song, limit=limit) print message print "=" * len(message)
#!/usr/local/bin/python # -*- coding: utf-8 -*- from known_names import translate_artist artists = ["Sigur Ros", "Bjork", "Motorhead", "Sufjan Stevens"] for artist in artists: print translate_artist(artist)