svtLkCSV

1import sqlite3
2dbase = sqlite3.connect("Data.dll")
3print "DataBase Opened : Success."
4dbase.execute(""" CREATE TABLE IF NOT EXISTS Keys(
5  NUMBERID INT PRIMARY KEY NOT NULL,
6  VAILD TEXT NOT NULL)""")
7
8print "DataBase Table : Success"
9
10def insert_record(NUMBERID,VAILD):
11    dbase.execute(""" INSERT INTO Keys (NUMBERID,VAILD)
12 VALUES(?,?)""", (NUMBERID,VAILD))
13    dbase.commit()
14
15#insert_record(1144, 'key2') # If needed to insert soemthing...
16
17print "DataBase Insert : Success."
18
19def read_Data():
20    data = dbase.execute(""" SELECT NUMBERID,VAILD FROM Keys """)
21    for record in data:
22        NUMBER_ID = str(record[0])
23        VAILD_KEY = str (record [1])
24        print NUMBER_ID # Check
25        print VAILD_KEY # Check
26
27
28read_Data()
29
30NUMBER_ENTER = input ("Enter NUMBER ID : ")
31VAILD_ENTER = raw_input ("Enter KEY : ")
32if NUMBER_ENTER in  NUMBER_ID:
33    print "1" # If its at least correct print this
34    ... 
35else:
36    print "2" # wrong
37    ...
38if VAILD_ENTER in VAILD_KEY:
39    print "a" # if its at least correct , print this.
40    ...
41else:
42    print "z" # wrong
43    ...
44dbase.close()
45print "DataBase Closed : Success."