<commit_before>from typing import List, Dict

import sqlite3

from src.database.DatabaseAdapter import DatabaseAdapter


class DatabaseSqlite(DatabaseAdapter):
    def __init__(
            self,
            db_path: str):
        """
        :param db_path: Location where to Store DB
        """
        self.db = sqlite3.connect(db_path)
        self.db.execute("CREATE TABLE " + "track(" +
                        "title text, " +
                        "artist text, " +
                        "album text, " +
                        "location text primary key, " +
                        "imported bool, " +
                        "available bool, " +
                        "type text)")
        self.db.execute("CREATE TABLE" + "involved(" +
                        "location text, " +
                        "feature text)")
        self.db.execute("CREATE TABLE" + "genres(" +
                        "location text, " +
                        "genre text)")
        self._t_nfo = ["location", "subtitle text", "additional_artist1", "additional_artist2",
                       "additional_artist3", "composer", "lyricist", "publisher", "year", "track_number", "bpm", "key",
                       "mood", "length", "lyrics", "artist_url", "publisher_url", "file_type", "user_comment"]
        a = self._t_nfo
        self.db.execute("CREATE TABLE" + "trackTag(" +
                        a[0] + " text primary key, " +
                        a[1] + " text, " +<commit_msg>Add Typehint in Constructor<commit_after>from typing import List, Dict

import sqlite3

from src.database.DatabaseAdapter import DatabaseAdapter


class DatabaseSqlite(DatabaseAdapter):
    def __init__(
            self,
            db_path: str):
        """
        :param db_path: Location where to Store DB
        """
        self.db = sqlite3.connect(db_path)  # type: sqlite3.Connection
        self.db.execute("CREATE TABLE " + "track(" +
                        "title text, " +
                        "artist text, " +
                        "album text, " +
                        "location text primary key, " +
                        "imported bool, " +
                        "available bool, " +
                        "type text)")
        self.db.execute("CREATE TABLE" + "involved(" +
                        "location text, " +
                        "feature text)")
        self.db.execute("CREATE TABLE" + "genres(" +
                        "location text, " +
                        "genre text)")
        self._t_nfo = ["location", "subtitle text", "additional_artist1", "additional_artist2",
                       "additional_artist3", "composer", "lyricist", "publisher", "year", "track_number", "bpm", "key",
                       "mood", "length", "lyrics", "artist_url", "publisher_url", "file_type",
                       "user_comment"]  # type [str]
        a = self._t_nfo
        self.db.execute("CREATE TABLE" + "trackTag(" +
                        a[0] + " text primary key, " +
                        a[1] + " text, " +
{'fraction_non_alphanumeric': 0.12406137773424747, 'fraction_numerical': 0.004897159647404506, 'mean_word_length': 1.427892234548336, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6062411', 'n_tokens_mistral': 848, 'n_tokens_neox': 801, 'n_words': 191}