<commit_before>import sqlite3

class database_connection:
    __init__(self):
        self.connection = sqlite3.connect()

    def insert_new_user(self, username):
        self.connection.execute("INSERT INTO Users VALUES(?)", (username))

    def insert_new_message(self, username, roomName, sendTime):
        if not sendTime:
            self.connection.execute("INSERT INTO Messages VALUES(username = ?, roomName = ?)",(username, roomName))
        else:
            self.connection.execute("INSERT INTO Messages VALUES(username = ? roomName = ? sendTime = ?)",(username, roomName, sendTime))<commit_msg>updated to python conventions and minor fixes<commit_after>import sqlite3

class Conn(object):
    def __init__(self):
        self.connection = sqlite3.connect()

    def insert_new_user(self, username):
        c = self.connection.cursor()
	c.execute("INSERT INTO Users VALUES(?)", (username,))

    def insert_new_message(self, username, room_name, send_time):

	c = self.connnection.cursor()
        if not send_time:
            c.execute("INSERT INTO Messages VALUES(username = ?, room_name = ?)",(username, room_name))
        else:
            c.execute("INSERT INTO Messages VALUES(username = ? room_name = ? send_time = ?)",(username, room_name, send_time))
{'fraction_non_alphanumeric': 0.1207843137254902, 'fraction_numerical': 0.003137254901960784, 'mean_word_length': 3.6911764705882355, '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': '874970', 'n_tokens_mistral': 380, 'n_tokens_neox': 355, 'n_words': 90}