z9C6abZG

1import sqlite3
2
3conn = sqlite3.connect('data.db')  
4c = conn.cursor()
5
6
7def create_table():
8    c.execute(' CREATE TABLE IF NOT EXISTS test_table('
9          ' first_name TEXT NOT NULL,'
10          ' second_name TEXT NOT NULL,'
11          ' date TEXT NOT NULL)')
12
13date = raw_input("Enter date: ")
14
15
16def enter():
17   while True:
18
19    f = raw_input("Enter name: ")
20    e = raw_input("Enter second name: ")
21
22    if len(f) == 0:
23        break
24    elif len(e) == 0:
25        break
26    else:
27
28        def first_name():
29            a = f
30            return a
31
32        def second_name():
33            y = e
34            return y
35
36        f_name = first_name()
37        s_name  = second_name()
38
39        c.execute("INSERT INTO test_table(first_name, "
40                  "second_name, date)VALUES(?, ?, ?)",
41                  (f_name, s_name, date))
42
43        conn.commit() 
44
45
46create_table()
47enter()
48conn.close()