csv to sqlite db

csv2db.py

import csv
import sqlite3

filename = r"""C:\Users\Vineet\Documents\test_records.csv"""
dbname = r"""C:\Users\Vineet\test.db"""

rows = []


def main():
    print("hello")
    conn = sqlite3.connect(dbname)
    
    with open(filename, 'r') as csvfile:
        csvreader = csv.reader(csvfile)
        
        for row in csvreader:
            print(row)
            rows.append(row)

        for row in rows:
            message = row[0]
            date = row[1]
            insert(conn, message, date)
            
    conn.close()

def insert(conn, message, date):
    query = "INSERT INTO records (name, date) values ('{}', '{}')".format(message, date)
    conn.execute(query)
    conn.commit()


if __name__ == '__main__':
    main()