def find_by_title(title):
result = None
mapped_names = {}
mapped_images = {}
with SQLite() as db:
result = db.execute("SELECT * FROM anime WHERE title = ?", title)
anime = result.fetchone()
if anime is None:
raise ApplicationError("Anime not found", 404)
with SQLite() as db:
characters = db.execute(
"SELECT characters.name, characters.image FROM anime JOIN characters ON anime.title = characters.anime WHERE title = ?",
title).fetchall()
# characters = db.execute("SELECT characters.name, characters.image FROM characters WHERE anime = ?", title).fetchall()
VAs = db.execute(
"SELECT VAs.name, VAs.image FROM anime JOIN characters ON anime.title = characters.anime JOIN VAs ON VAs.name = characters.VA WHERE title = ?",
title).fetchall()
f = 0
for i, j in zip(characters, VAs):
for i1, j1 in zip(i, j):
if f == 1:
mapped_images[i1] = j1
break
mapped_names[i1] = j1
f = 1
return Anime(*anime, mapped_names, mapped_images)
def find_by_name(name):
result = None
mapped_names = {}
mapped_images = {}
with SQLite() as db:
result = db.execute("SELECT * FROM VAs WHERE name = ?", name)
va = result.fetchone()
if va is None:
raise ApplicationError("No character found", 404)
with SQLite() as db:
characters = db.execute(
"SELECT characters.name, characters.image FROM VAs JOIN characters ON VAs.name = characters.VA WHERE VAs.name = ?",
name).fetchall()
anime = db.execute(
"SELECT anime.title, anime.image FROM VAs JOIN characters ON VAs.name = characters.VA JOIN anime ON anime.title = characters.anime WHERE VAs.name = ?",
name).fetchall()
f = 0
for i, j in zip(characters, anime):
for i1, j1 in zip(i, j):
if f == 1:
mapped_images[i1] = j1
break
mapped_names[i1] = j1
f = 1
filename = ''.join(name)
path = "./images/" + filename + ".jpg"
return VA(*va, mapped_names, mapped_images, path)
def export_dataset(self) -> None:
WRITE = 'w'
l_column_names: list = SQLite.get_table_column_names(
'discovered_services')
l_ds_records: list = SQLite.get_discovered_service_records(
self.type_of_data_to_export)
with open(self.export_output_file, WRITE) as l_file:
l_csv_writer = csv.writer(l_file, csv.excel)
l_csv_writer.writerow(l_column_names)
l_csv_writer.writerows(l_ds_records)
def get_ads():
query = 'SELECT title, description, price, creation_date, is_active, user_id, buyer_id, id FROM advert'
with SQLite() as db:
ads = db.execute(query).fetchall()
return [Advert(*ad) for ad in ads]
def get_status_message(matches: list, db: SQLite) -> discord.Embed:
em = discord.Embed()
em.color = EMBED_COLOR
em.title = 'Server Status'
em.description = '**{}** / **{}** players are online.'.format(
matches[0], matches[1])
player_list = []
name_map = dict((v, k) for k, v in db.get_whitelist().items())
if len(matches) >= 3 and matches[2]:
player_names = matches[2].split(',')
for name in player_names:
name = name.strip().lower()
dc_id = name_map.get(name)
d_name = '`{}`'.format(name)
if dc_id:
d_name += ' (<@{}>)'.format(dc_id)
player_list.append(d_name)
else:
player_list = ['*no players online*']
em.add_field(name='Online Players',
value='\n'.join(player_list),
inline=False)
return em
def all_questions():
#fetching all questions from the database
with SQLite() as db:
result = db.execute(
"SELECT content, answer, user, category FROM question"
).fetchall()
return [' | '.join(name) for name in result]
def find_by_user(user):
result = None
with SQLite() as db:
result = db.execute(
"SELECT content, answer FROM question WHERE user = ?",
(user, )).fetchall()
return [' | '.join(name) for name in result]
def private_check(name):
with SQLite() as db:
result = db.execute(
"SELECT is_private FROM rooms WHERE name = ?",
(name,))
room = result.fetchone()
return room[0] == 1
def get_users():
query = 'SELECT email, username, password, address, phone, id FROM user'
with SQLite() as db:
users = db.execute(query).fetchall()
return [User(*row) for row in users]
def update_match(match, name):
result = None
with SQLite() as db:
result = db.execute("UPDATE user SET match = ? WHERE name = ?",
(match, name))
if result.rowcount == 0:
raise ApplicationError("No user present", 404)
def get_company(company_id):
result = None
with SQLite() as db:
result = db.execute("SELECT * FROM companies WHERE id = ?",
(company_id, ))
company = result.fetchone()
return Company(*company)
def save(self):
query = "{} INTO anime {} VALUES {}"
if self.anime_id == None:
query = query.format("INSERT",
"(title, image, studio, episodes, seasons)",
"(?, ?, ?, ?, ?)")
args = (self.title, self.convertToBinaryData(self.image),
self.studio, self.episodes, self.seasons)
else:
query = query.format(
"REPLACE",
"(anime_id, title, image, studio, episodes, seasons)",
"(?, ?, ?, ?, ?, ?)")
args = (self.anime_id, self.title,
self.convertToBinaryData(self.image), self.studio,
self.episodes, self.seasons)
path = "./templates/images" + self.title + ".jpg"
self.writeTofile(self.convertToBinaryData(self.image), path)
with SQLite() as db:
cursor = db.execute(query, args)
self.anime_id = cursor.lastrowid
return self
def delete(question_tag_id):
result = None
with SQLite() as db:
result = db.execute("DELETE FROM question_tag WHERE id = ?",
(question_tag_id, ))
if result.rowcount == 0:
raise ApplicationError("No value present", 404)
def get_all():
result = None
with SQLite() as db:
result = db.execute(
"SELECT id, email, password, name, address, phone_number FROM user"
).fetchall()
return [User(*row) for row in result]
def __study_file_record_is_new(
self, p_study_file_record: StudyFileRecord) -> bool:
l_newer_record_already_in_database: bool = bool(
SQLite.get_newer_study_file_records(
p_study_file_record.port, p_study_file_record.protocol,
p_study_file_record.timestamp).__len__())
return not l_newer_record_already_in_database
def update_rating_by_name(rating, name):
result = None
with SQLite() as db:
result = db.execute("UPDATE user SET rating = ? WHERE name = ?",
(rating, name))
if result.rowcount == 0:
raise ApplicationError("No user present", 404)
def create_user(user, password, email, address, phone_number):
result = None
with SQLite() as db:
result = db.execute("INSERT INTO user (username, password, email, address, phone_number) VALUES (?, ?, ?, ?, ?)",
(user, password, email, address, phone_number,))
if result.rowcount == 0:
raise ApplicationError("No value present", 404)
def update_rating(self, rating):
result = None
with SQLite() as db:
result = db.execute("UPDATE user SET rating = ? WHERE id = ?",
(rating, self.id))
if result.rowcount == 0:
raise ApplicationError("No user present", 404)
def update_choice(self, choice):
result = None
with SQLite() as db:
result = db.execute("UPDATE user SET choice = ? WHERE id = ?",
(choice, self.id))
if result.rowcount == 0:
raise ApplicationError("No user present", 404)
def registerVisitor(name, password, email):
result = None
query = "INSERT INTO users {} VALUES {}"
args = (name, password, "visitor", email)
query = query.format("(name, password, role, email)", args)
print(query)
with SQLite() as db:
result = db.execute(query)
def find_most_recent_by_user(user):
result = None
with SQLite() as db:
result = db.execute(
"SELECT content, answer, user, category, id FROM question WHERE user = ? ORDER BY id DESC LIMIT 1",
(user, ))
question = result.fetchone()
return Question(*question)
def make_payment(company_id, event_id):
result = None
query = "INSERT INTO payments {} VALUES {}"
args = (event_id, company_id)
query = query.format("(event_id, company_id)", args)
print(query)
with SQLite() as db:
result = db.execute(query)
def send_message(content, sender_id, company_id):
result = None
query = "INSERT INTO messages {} VALUES {}"
args = (content, sender_id, company_id)
query = query.format("(content, sender_id, company_id)", args)
print(query)
with SQLite() as db:
result = db.execute(query)
def registerParticipant(name, password, email, event, c_id):
result = None
query = "INSERT INTO users {} VALUES {}"
args = (name, password, "participant", email, event, c_id)
query = query.format("(name, password, role, email, event_id, company_id)", args)
print(query)
with SQLite() as db:
result = db.execute(query)
def update_answer_by_content(answer, content):
result = None
with SQLite() as db:
result = db.execute(
"UPDATE question SET answer = ? WHERE content = ?",
(answer, content))
if result.rowcount == 0:
raise ApplicationError("No question present", 404)
def send_invite(event_id, user_email):
result = None
query = "INSERT INTO invites {} VALUES {}"
args = (event_id, user_email)
query = query.format("(event_id, user_email)", args)
print(query)
with SQLite() as db:
result = db.execute(query)
def register(name, password, image_link, event_id):
result = None
query = "INSERT INTO companies {} VALUES {}"
args = (name, password, image_link, event_id)
query = query.format("(name, password, image_link, event_id)", args)
print(query)
with SQLite() as db:
result = db.execute(query)
def find_by_name(name):
result = None
with SQLite() as db:
result = db.execute("SELECT * FROM characters WHERE name = ?",
name)
character = result.fetchone()
if character is None:
raise ApplicationError("No character found", 404)
return Character(*character)
def find_id(name, password, event_id):
result = None
with SQLite() as db:
result = db.execute(
"SELECT id FROM companies WHERE name = ? AND password = ? AND event_id = ?",
(name, password, event_id)).fetchone()
if result is None:
raise ApplicationError("False company credentials", 404)
return result[0]
def get_last_registered():
result = None
with SQLite() as db:
result = db.execute(
"SELECT * FROM user ORDER BY id DESC LIMIT 1", )
user = result.fetchone()
if user is None:
return None
return User(*user)