def buildVisualNovelReply(searchText,
isExpanded,
baseComment,
blockTracking=False):
""" Builds an VN reply from VNDB """
try:
vndb = VNDB()
try:
query = ('SELECT dbLinks'
' FROM synonyms'
' WHERE type = "VN"'
' AND lower(name) = ?')
sqlCur.execute(query, [searchText.lower()])
except sqlite3.Error as e:
print(e)
alternateLinks = sqlCur.fetchone()
if (alternateLinks):
synonym = json.loads(alternateLinks[0])
if synonym:
if 'vndb' in synonym and synonym['vndb']:
synonym = synonym['vndb']
if synonym:
result = vndb.getVisualNovelDetailsById(synonym)
else:
result = None
else:
result = vndb.getVisualNovelDetails(searchText)
vndb.close()
if result:
try:
titleToAdd = result['title']
subreddit = str(baseComment.subreddit).lower
ignored_subreddits = ('nihilate', 'roboragi')
if subreddit not in ignored_subreddits and not blockTracking:
DatabaseHandler.addRequest(
name=titleToAdd,
rType='VN',
requester=baseComment.author.name,
subreddit=baseComment.subreddit)
except Exception:
traceback.print_exc()
pass
return CommentBuilder.buildVisualNovelComment(isExpanded, result)
else:
print('No result found for ' + searchText)
return None
except Exception:
traceback.print_exc()
return None
def buildVisualNovelReply(searchText,
isExpanded,
baseComment,
blockTracking=False):
try:
vndb = VNDB()
try:
sqlCur.execute(
'SELECT dbLinks FROM synonyms WHERE type = "VN" and lower(name) = ?',
[searchText.lower()])
except sqlite3.Error as e:
print(e)
alternateLinks = sqlCur.fetchone()
if (alternateLinks):
synonym = json.loads(alternateLinks[0])
if synonym:
vndbsyn = None
if 'vndb' in synonym and synonym['vndb']:
synonym = synonym['vndb']
result = vndb.getVisualNovelDetailsById(
synonym) if synonym else None
else:
result = vndb.getVisualNovelDetails(searchText)
vndb.close()
if result:
try:
titleToAdd = result['title']
if (str(baseComment.subreddit).lower is not 'nihilate') and (
str(baseComment.subreddit).lower
is not 'roboragi') and not blockTracking:
DatabaseHandler.addRequest(titleToAdd, 'VN',
baseComment.author.name,
baseComment.subreddit)
except:
traceback.print_exc()
pass
return CommentBuilder.buildVisualNovelComment(isExpanded, result)
else:
print('No result found for ' + searchText)
return None
except Exception as e:
traceback.print_exc()
return None
