Python:
import sqlite3 as sql
import datetime
class sql_user:
def __init__(self,database_loc):
self.database_loc = database_loc
try:
self.conn = sql.connect(str(database_loc))
except:
print("cant connect to database")
self.created = datetime.datetime.now()
self.conn.execute(''' CREATE TABLE IF NOT EXISTS Users( ID INT PRIMARY KEY NOT NULL, USERNAME TEXT NOT NULL, NAME TEXT NOT NULL, SURNAME TEXT NOT NULL, EMAIL TEXT NOT NULL,
BIRTHDATE TEXT NOT NULL, PHONE INT NOT NULL, PWD TEXT NOT NULL)''')
def read(self):
data = self.conn.execute("SELECT * FROM Users")
return data
def write(self,data):
#try:
self.conn.execute("INSERT INTO Users(ID,USERNAME,NAME,SURNAME,EMAIL,BIRTHDATE,PHONE,PWD)\
VALUES({},{},{},{},{},{},{},{})".format(data[0],data[1],data[2],data[3],data[4],data[5],data[6],data[7]))
#except:
#print("something happend cant insert data")
self.conn.commit()
class sql_page:
def __init__(self,database_loc):
try:
self.conn = sql.connect(str(database_loc))
except:
print("cant connect to database")
self.conn.execute('''CREATE TABLE IF NOT EXISTS Page(ID INT PRIMARY KEY NOT NULL,PAGE_HEADER TEXT NOT NULL, PAGE_FILE TEXT NOT NULL, PAGE_LINK TEXT NOT NULL)''')
def read(self):
data = self.conn.execute("SELECT * FROM Page")
return data
user_obj = sql_user("database\\user.user.db")
data = [1,'veri1',"ASDADSA","ASDADAS","ADASDASASD","ASDASDAS",45353453,"ASDASDASDAS"] # ceri gidiyor ama column bulamiyor
user_obj.write(data)Hata:
Kod:
self.conn.execute("INSERT INTO Users(ID,USERNAME,NAME,SURNAME,EMAIL,BIRTHDATE,PHONE,PWD)\
sqlite3.OperationalError: no such column: veri1
