#! /usr/bin/env python
# -*- coding: utf-8 -*-

import sqlite3

stuff = [('MisterHatt!~hurf@eat.me.yuyu-sama.eat.me.good', 0),
         ('Piroko!Piroko@flying.lolis.ftw', 0),
         ('Bagels!Scu-@SENSEI..NINOMIYA-K.UN', 0),
         ('Disgaeaclassy!Disgaeamad@Am.I.Gonna.Have.To.Piledrive.A.Bitch', 0),
         ('tutturuu!~Sakura@Rizon-1DE4568B.retail.telecomitalia.it', 0),
         ('kViN!~M@ster.Spark', 1),
         ('Mattish!Mattish@tentaclenoises.jp', 1),
         ('MisterX!a-S@another.version.of.the.truth', 1),
         ('Ragyx!rgx@masked.host', 1),
         ('', 1)
        ]
        
con = sqlite3.connect('sec.sql')
for entry, perm in stuff:
    entry = entry.decode('utf-8')
    con.execute('insert into staff(hostname, permissions) values (?,?)', (entry, perm))
con.commit()
print('Changes commited')
con.close()