def initialize_database():
''' Delete and initialize tables for app to work properly
'''
connection = get_database_connection()
drop_tables(connection)
create_tables(connection)
def test_find_all_replace_data_entries_works(self):
program_service.create_replace_data(self._filename,
self._user_input_data,
self._placeholder)
program_service.create_replace_data(self._filename2,
self._user_input_data2,
self._placeholder2)
program_service.create_replace_data(self._filename,
self._user_input_data2,
self._placeholder2)
replace_data_entries = program_service.find_all_replace_data_entries()
self.assertEqual(self._filename2, replace_data_entries[0].filename)
self.assertEqual(self._user_input_data2,
replace_data_entries[0].user_input_data)
self.assertEqual(self._placeholder2,
replace_data_entries[0].placeholder)
self.assertEqual(self._filename, replace_data_entries[1].filename)
self.assertEqual(self._user_input_data,
replace_data_entries[1].user_input_data)
self.assertEqual(self._placeholder,
replace_data_entries[1].placeholder)
self.assertEqual(self._filename, replace_data_entries[2].filename)
self.assertEqual(self._user_input_data2,
replace_data_entries[2].user_input_data)
self.assertEqual(self._placeholder2,
replace_data_entries[2].placeholder)
drop_tables(get_database_connection())
def initialise_database():
# Create a database connection
print("Creating database connection")
connection = get_database_connection()
# Create tables
create_tables(connection)
def test_create_replace_data_works(self):
replace_data = program_service.create_replace_data(
self._filename, self._user_input_data, self._placeholder)
self.assertEqual(self._filename, replace_data.filename)
self.assertEqual(self._user_input_data, replace_data.user_input_data)
self.assertEqual(self._placeholder, replace_data.placeholder)
drop_tables(get_database_connection())
def recycle_list_all(self):
'''getting the amount of items recycled by all users'''
connection = get_database_connection()
get_recycle_all = connection.execute(
'select sum(bottles_cans), sum(cardboard), sum(electronics), sum(glass), sum(metal), sum(plastic), sum(paper), sum(batteries), sum(clothes) from recycle'
).fetchone()
return get_recycle_all
def initialize_database():
"""Funktio, joka suorittaa tietokannan alustuksen
"""
connection = get_database_connection()
drop_tables(connection)
create_tables(connection)
def initialize_database():
connection = get_database_connection()
drop_tables(connection)
tracker_service.delete_courses()
tracker_service.delete_notes()
create_tables(connection)
def initialize_database():
connection = get_database_connection()
drop_tables(connection)
create_tables(connection)
connection.close()
def initialize_database():
"""Luo tietokantayhteyden sekä poistaa siellä mahdollisesti olevat taulut ja luo uudet.
"""
connection = get_database_connection()
drop_tables(connection)
create_tables(connection)
def initialize_database():
"""Alustaa tietokantataulut.
"""
connection = get_database_connection()
drop_tables(connection)
create_tables(connection)
def test_document_exists_works(self):
program_service.create_replace_data(self._filename,
self._user_input_data,
self._placeholder)
self.assertEqual(program_service.document_exists(self._filename2),
True)
self.assertEqual(program_service.document_exists("kana"), False)
drop_tables(get_database_connection())
def initialize_database():
"""Initializes the database by establishing a connection
to SQL-database, and then creating new data tables.
"""
connection = get_database_connection()
drop_tables(connection)
create_tables(connection)
def setUp(self):
drop_tables(get_database_connection())
initialize_database()
self._filename = "viranhaltijapäätös_määräalan_myynti_pohja"
self._filename2 = "Testipohja"
self._user_input_data = "Kiinteistötunnus"
self._user_input_data2 = "Ostaja"
self._placeholder = "[kiinteistötunnus]"
self._placeholder2 = "[ostaja]"
def initialize_database(self):
"""Tuhoaa nykyiset taulut tietokannasta,
jonka jälkeen luo ne uudelleen ja lisää testikäyttäjän.
"""
connection = get_database_connection()
connection.isolation_level = None
self.drop_tables(connection)
self.create_tables(connection)
self.insert_test_user(connection)
def main():
"""Function for running the application"""
config = Config(CONFIG_PATH)
screen = Screen(config.window_width, config.window_height,
config.font_size)
event_handler = EventHandler()
database_connection = get_database_connection(config.database_path)
main_menu = create_main_menu(screen, event_handler, config,
database_connection)
main_menu.run()
def recycle_list(self):
'''getting the amount of items recycled from the database matching with the current user'''
connection = get_database_connection()
username = self._user.username
username_id = connection.execute(
'select id from users where username = ?',
(username, )).fetchone()[0]
get_recycle = connection.execute(
'select bottles_cans, cardboard, electronics, glass, metal, plastic, paper, batteries, clothes from recycle where username_id = ?',
(username_id, )).fetchone()
return get_recycle
def init_database(database_path):
"""Initializes a database at `database_path`.
Arguments:
`database_path`: Path
Should be either an existing file or a non-existing
file in an existing directory
"""
connection = get_database_connection(database_path)
drop_tables(connection)
create_tables(connection)
def trigger(user_id, friend_id):
connection, cursor = database_connection.get_database_connection()
cursor.execute("LISTEN status_changed;")
while True:
select.select([connection], [], [])
connection.poll()
while connection.notifies:
cursor.execute("SELECT state FROM users WHERE id = " +
str(user_id))
return {"state": cursor.fetchall()[0][0]}
def recycle_list_update(self, amount, what_to_update):
'''update amount of material recycled'''
connection = get_database_connection()
username = self._user.username
username_id = connection.execute(
'select id from users where username = ?',
(username, )).fetchone()[0]
connection.execute(
'update recycle set {} = ({}+?) where username_id = ?'.format(
what_to_update, what_to_update), (
amount,
username_id,
))
connection.commit()
def test_find_all_document_names_works(self):
program_service.create_replace_data(self._filename,
self._user_input_data,
self._placeholder)
program_service.create_replace_data(self._filename2,
self._user_input_data2,
self._placeholder2)
program_service.create_replace_data(self._filename,
self._user_input_data2,
self._placeholder2)
document_names = program_service.find_all_document_names()
self.assertEqual(self._filename, document_names[0])
self.assertEqual(self._filename2, document_names[1])
drop_tables(get_database_connection())
def test_placeholder_duplicate_exists_works(self):
program_service.create_replace_data(self._filename,
self._user_input_data,
self._placeholder)
self.assertEqual(
program_service.placeholder_duplicate_exists(
self._filename, self._placeholder), True)
self.assertEqual(
program_service.placeholder_duplicate_exists(
"Nikko", self._placeholder), False)
self.assertEqual(
program_service.placeholder_duplicate_exists(
self._filename, "Auto"), False)
self.assertEqual(
program_service.placeholder_duplicate_exists("Nikko", "Auto"),
False)
drop_tables(get_database_connection())
def __init__(self, username):
"""Luokan konstruktori. Luo päävalikon valinnat
Args:
username: kirjautuneen käyttäjän nimi
"""
self._actions = {
"x": "x Lopeta",
"1": "1 Uusi kurssi",
"2": "2 Hae kurssit",
"3": "3 Poista kurssi",
"4": "4 Muuta tietoja",
"5": "5 Syötä tenttipäivämäärä",
"6": "6 Ilmoittaudu kurssille",
"7": "7 Tulevat tenttini"
}
self._headers = ["Kurssi", "Opintopisteet"]
self._ui = UI()
self._repository = CourseRepository(get_database_connection())
self._username = username
def __init__(self, display: Display, letters: list, status: int,
event_queue, word, level):
"""Luokan konstruktori, joka luo uuden pelin
Args:
display (Display): Display-olio, joka kuvaa pelialuetta
letters (list): Kirjainten sijannit peliruudulla [x, y, letter, used (True/False)]
status (int): Tämänhetkinen pelitilanne, kuinka monta kertaa käyttäjä arvannut väärin
event_queue (EventQueue): EventQueue-olio, joka kuvaa pelin tapahtumia
word (str): Arvattava sana
level: Vaikeustaso
"""
self.display = display
self.letters = letters
self.status = status
self.guessed = []
self.event_queue = event_queue
self.word = word
self.clock = Clock()
self.level = level
self.highscore = Highscore(get_database_connection())
def initialize_database():
'''do everything needed for using the app'''
connection = get_database_connection()
drop_tables(connection)
adminpass = input("Give a password for the admin account: ")
create_tables(connection, adminpass)
"""
cursor = self._connection.cursor()
cursor.execute(
"DELETE FROM Replace_data WHERE document_name = ? AND placeholder = ?",
(
filename,
placeholder,
))
self._connection.commit()
cursor.execute(
"""
SELECT document_name, placeholder
FROM Replace_data
WHERE document_name = ? AND placeholder = ?
""", (
filename,
placeholder,
))
result = cursor.fetchone()
if result is None:
return True
return False
database_handler = DatabaseHandler(get_database_connection())
def setUp(self):
initialize_database()
self._user = UserRepository(get_database_connection())
configure()
'''
cursor = self._connection.cursor()
cursor.execute('SELECT * FROM Scores ORDER BY score DESC LIMIT 10')
high_scores = cursor.fetchall()
return high_scores
def delete_all(self):
'''Poistaa tiedot tietokannasta
'''
cursor = self._connection.cursor()
cursor.execute('DELETE FROM Scores')
self._connection.commit()
def add_new_score(self, name, score):
'''Kirjaa uuden pelituloksen ja pelaajanimen tietokantaan
'''
cursor = self._connection.cursor()
cursor.execute(
'INSERT INTO Scores (name, score) VALUES (?, ?)', (name, score))
self._connection.commit()
score_repository = ScoreRepository(get_database_connection())
cursor.execute(
'select * from users where username = ?',
(username,)
)
row = cursor.fetchone()
return get_user_by_row(row)
def create(self, user):
cursor = self.connection.cursor()
cursor.execute(
'insert into users (username, password) values (?, ?)',
(user.username, user.password)
)
self.connection.commit()
return user
def delete_all(self):
cursor = self.connection.cursor()
cursor.execute('delete from users')
self.connection.commit()
user_repository = UserRepository(get_database_connection())
def __init__(self):
"""Konstruktori, alustaa tietokanta-yhteyden ja käytetyn cursor-objektin."""
self.connection = get_database_connection()
self.cursor = self.connection.cursor()
self._connection.commit()
def find_all(self):
""" Select all cubes from the cubes table.
Return:
rows: [List Tuple] List of tuples including the cubes.
"""
cursor = self._connection.cursor()
cursor.execute('SELECT * FROM cubes')
rows = cursor.fetchall()
return rows
def find_by_user(self, username):
""" Select cubes from the cubes table that belong to the given username.
Args:
username: [String] The username of a user.
Return:
rows: [List Tuple] List of tuples including the cubes.
"""
user_sql = (username, )
sql = """ SELECT * FROM cubes WHERE users = ?; """
cursor = self._connection.cursor()
cursor.execute(sql, user_sql)
rows = cursor.fetchall()
return rows
cube_repository = CubeRepository(get_database_connection())
