How can I add some data from file.txt to db.sqlite3 ?

[Mike Ru]

I have just resolved it like that

def add():
    db = sqlite3.connect('../project/db.sqlite3')
    cursor = db.cursor()
    
    f = open('subject.txt')
    line = f.readline()
    while line:
        cursor.execute('''insert into subject(name, slug)
        values(:name, :slug)''',
        {'name': line.replace('&', ' and ').lower(), 'slug': formatSlug(line)})
        db.commit()
        line = f.readline()
        print(line)
    f.close() 

def formatSlug(a):
    filter = '!@%#$?\/^*(&'
    for x in filter:
        a = a.replace(x, '').replace(' ', '-')
        
    return a.lower()

add()

I think that it is not bad resolve.