def getWordList():
db = Db('loe3', 'root', 'youwonder.')
wordlist = db.database('MetalArchives').table('Artist').select(
'distinct lyricalThemes').get()
uniqueWords = []
for row in wordlist:
words = row[0].split(',')
for word in words:
testWord = re.sub('\s\(.*?\)', '', word).strip().lower()
if testWord not in uniqueWords:
uniqueWords.append(testWord)
return uniqueWords
def getLyrics(songScriptUID):
db = Db('loe3', 'root', 'youwonder.')
result = db.database('LOE').table('SongScript').select('*').where(
"UID", "=", songScriptUID).get()
individualLyrics = re.sub('[\r\n]+', ' ', result[0][2]).strip().split(' ')
return individualLyrics
