<commit_before># encoding: utf-8

import MySQLdb

def main():
    username = raw_input('input username:')
    password = raw_input('input password:')

    db = MySQLdb.connect("localhost", username, password, 'nova')

    cursor = db.cursor()
 #   cursor.execute('drop table if exists tfilter')
    tfilter_sql = '''create table tfilter(
                                        id int not null primary key auto_increment,
                                        created_at datetime default null,
                                        updated_at datetime default null,
                                        deleted_at datetime default null,
                                        deleted varchar(36),
                                        classid varchar(10),
                                        handle int,
                                        ip varchar(25),
                                        flowid varchar(10),
                                        prio int )'''
    
    cursor.execute(tfilter_sql)
    
 #   cursor.execute('drop table if exists tqdisc')
    
    tqdisc_sql = '''create table tqdisc(
                                          id int not null primary key auto_increment,
                                          created_at datetime default null,
                                          updated_at datetime default null,
                                          deleted_at datetime default null,
                                          deleted varchar(36),
                                          instanceid varchar(50),
                                          classid varchar(20),
                                          ip varchar(25),
                                          host varchar(20),
                                          band varchar(15),
                                          prio int)'''
    
    cursor.execute(tqdisc_sql)
    
    db.commit()

    db.close()


if __name__ == '__main__':
    main()<commit_msg>change tab<commit_after># encoding: utf-8

import MySQLdb

def main():
    username = raw_input('input username:')
    password = raw_input('input password:')

    db = MySQLdb.connect("localhost", username, password, 'nova')

    cursor = db.cursor()
 #   cursor.execute('drop table if exists tfilter')
    tfilter_sql = '''create table tfilter(
                                        id int not null primary key auto_increment,
                                        created_at datetime default null,
                                        updated_at datetime default null,
                                        deleted_at datetime default null,
                                        deleted varchar(36),
                                        classid varchar(10),
                                        handle int,
                                        ip varchar(25),
                                        flowid varchar(10),
                                        prio int )'''
    
    cursor.execute(tfilter_sql)
    
 #   cursor.execute('drop table if exists tqdisc')
    
    tqdisc_sql = '''create table tqdisc(
                                          id int not null primary key auto_increment,
                                          created_at datetime default null,
                                          updated_at datetime default null,
                                          deleted_at datetime default null,
                                          deleted varchar(36),
                                          instanceid varchar(50),
                                          classid varchar(20),
                                          ip varchar(25),
                                          host varchar(100),
                                          band varchar(15),
                                          prio int)'''
    
    cursor.execute(tqdisc_sql)
    
    db.commit()

    db.close()


if __name__ == '__main__':
    main()
{'fraction_non_alphanumeric': 0.06084396467124632, 'fraction_numerical': 0.010549558390578999, 'mean_word_length': 0.8168449197860963, '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': 70, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1277645', 'n_tokens_mistral': 789, 'n_tokens_neox': 691, 'n_words': 220}