def by_volume(volume_number):
sql = "SELECT article_id FROM articles WHERE volume_number = {} ORDER BY full_number ASC".format(
volume_number)
c = executor.select(sql)
article_list = []
for item in c:
article_id = item[0]
sql = "SELECT needs_login FROM articles WHERE article_id = {}".format(
article_id)
d = executor.select(sql)
for it in d:
if (it[0] == 1 and var.isLogged) or it[0] == 0:
article_list.append(article_id)
return article_list
def by_article_id(article_id):
sql = "SELECT article_url FROM articles WHERE article_id = {}".format(
article_id)
c = executor.select(sql)
if len(c) > 0:
url = c[0][0]
webbrowser.open(url)
def by_article_id(article_id):
sql = "SELECT author_id FROM linker WHERE article_id = {}".format(
article_id)
c = executor.select(sql)
author_id_list = []
for lis in c:
author_id_list.append(lis[0])
return author_id_list
def volumes():
if var.isLogged:
sql = "SELECT volume_number FROM articles"
else:
sql = "SELECT volume_number FROM articles WHERE needs_login = 0"
c = executor.select(sql)
volume_list = []
for item in c:
if not item[0] in volume_list:
volume_list.append(item[0])
return volume_list
def all():
"""
Get all the titles
Returns:
titles (list): a list of all the titles in the table
"""
titles = []
sql = "SELECT article_title, full_number FROM articles"
c = executor.select(sql)
for x in c:
titles.append((x[0], x[1]))
return titles
def issues_in_volume(volume_number):
if var.isLogged:
sql = "SELECT issue_number FROM articles WHERE Volume_number = {}".format(
volume_number)
else:
sql = "SELECT issue_number FROM articles WHERE volume_number = {} AND needs_login = 0".format(
volume_number)
c = executor.select(sql)
issue_list = []
for item in c:
if not item[0] in issue_list:
issue_list.append(item[0])
return issue_list
def all():
"""
Get all the author names
Locations: rename.get_old_name()
Returns:
names (list): a list of all the author names
"""
names = []
sql = "SELECT author_name FROM authors"
c = executor.select(sql)
for x in c:
names.append(x[0])
return names
def by_article_id(article_id):
"""
Get the title based on article id
Locations: display.display_articles(), rename.rename()
Parameters:
article_id (int)
Returns:
title (string)
"""
sql = "SELECT article_title FROM articles WHERE article_id = {}".format(article_id)
c = executor.select(sql)
return c[0][0]
def full(article_id):
"""
Gets the full number based on article id
Current locations: display.display_articles()
Parameters:
article_id (int)
Returns:
full_number (string)
"""
sql = "SELECT full_number FROM articles WHERE article_id = {}".format(
article_id)
c = executor.select(sql)
return c[0][0]
def by_volume(volume_number):
"""
Gets article_id based on volume number
Locations: remove_article.by_article_id
Parameters:
volume_number (integer)
"""
sql = "SELECT article_id FROM articles WHERE volume_number = {}".format(
volume_number)
c = executor.select(sql)
article_id_list = []
for lis in c:
article_id_list.append(lis[0])
return article_id_list
def by_full_number(full_number):
"""
Gets article_id based on full_number
Locations: rename.rename(), downloader.download()
Parameters:
full_number (string) : Vol.issue.article (##.##.##)
"""
sql = "SELECT article_id FROM articles WHERE full_number = '{}'".format(
full_number)
c = executor.select(sql)
if len(c) == 0:
return False
else:
return c[0][0]
def by_name(author_name):
"""
Gets the author ID
Locations: rename.change()
Parameters:
author_name(string)
Returns:
c[0][0] (int): technically is the author_id
"""
sql = "SELECT author_id FROM authors WHERE author_name = '{}'".format(
author_name)
c = executor.select(sql)
return c[0][0]
def articles_table(full_number):
"""
Search the articles table for a specific article
Parameters:
full_number (string): if the full_number is in the table, gets information
Returns:
True : the article number was found, item in table
False : article number was not found, item not in table
"""
sql = "SELECT * FROM articles WHERE full_number = '{}'".format(full_number)
data = executor.select(sql)
if len(data) == 0:
return False
else:
return True
def author_table(author_name):
"""
Search the author table for a specific author
Parameters:
author_name (string): the author name to search
Returns:
True : the author was found, item in table
False : author was not found, item not in table
"""
sql = "SELECT * FROM authors WHERE author_name = '{}'".format(author_name)
data = executor.select(sql)
if len(data) == 0:
return False
else:
return True
def by_author(author_name):
"""
gets article_ids based on author name
Parameters:
author_name (string)
Returns:
article_id_list (list)
"""
author_id = get_author_id.by_name(author_name)
sql = "SELECT article_id FROM linker WHERE author_id = {}".format(
author_id)
c = executor.select(sql)
article_id_list = []
for lis in c:
article_id_list.append(lis[0])
return article_id_list
def year(volume_number):
sql = "SELECT year FROM volume WHERE volume_number = {}".format(
volume_number)
c = executor.select(sql)
for item in c:
return item[0]
def by_author_id(author_id):
sql = "SELECT author_name FROM authors WHERE author_id = {}".format(
author_id)
c = executor.select(sql)
return c[0][0]
