In [ ]:

    

import sqlite3 as sql
import os


    

In [ ]:

    

test_connect = sql.connect('test.db')


    

In [ ]:

    

cursor = test_connect.cursor()

cursor.execute('''
  CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT,
                     phone TEXT, email TEXT unique, password TEXT)
''')
test_connect.commit()


    

In [ ]:

    

users = [('name1','phone1', 'email1', 'password1'),
         ('name2','phone2', 'email2', 'password2'),
         ('name3','phone3', 'email3', 'password3')]
cursor.executemany(''' INSERT INTO users(name, phone, email, password) VALUES(?,?,?,?)''', users)
test_connect.commit()


    

In [ ]:

    

cursor = test_connect.execute('''
  SELECT * FROM users;
''')


    

In [ ]:

    

all_rows = cursor.fetchall()
for row in all_rows:
    # row[0] returns the first column in the query (name), row[1] returns email column.
    print('{0} : {1}, {2}'.format(row[0], row[1], row[2]))


    

In [ ]:

    

test_connect.close()
os.unlink('test.db')


    

In [ ]: