Postingan lainnya
Insert Data "Gagal" menggunakan peewee di python
Jadi saya kemarin ngikutin tutorial di kelas belajar peewee di python
mau create data baru di sqlite
user.py
from peewee import *
sqlite_db = SqliteDatabase('user.db')
class User(Model):
name = CharField()
email = CharField()
class Meta:
database = sqlite_db
sqlite_db.connect()
sqlite_db.create_tables([User], safe = True)
#insert Data
User.create(name = 'test', email = 'hehe@test')
nah saat saya jalanin kodenya pakai perintah
python user.py
muncul eror seperti ini
Traceback (most recent call last):
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 3160, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: table user has no column named name
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "F:\BELAJAR\oop_python\databases\user.py", line 17, in <module>
User.create(name = 'test', email = 'hehe@test')
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 6393, in create
inst.save(force_insert=True)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 6603, in save
pk = self.insert(**field_dict).execute()
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 1911, in inner
return method(self, database, *args, **kwargs)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 1982, in execute
return self._execute(database)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 2761, in _execute
return super(Insert, self)._execute(database)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 2479, in _execute
cursor = database.execute(self)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 3173, in execute
return self.execute_sql(sql, params, commit=commit)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 3157, in execute_sql
with __exception_wrapper__:
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 2933, in __exit__
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 191, in reraise
raise value.with_traceback(tb)
File "C:\Users\ErPrasetyo\AppData\Local\Programs\Python\Python310\lib\site-packages\peewee.py", line 3160, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: table user has no column named name
saya udah cek sesuai demonya bang hilman ramadan, tapi masih error
terima kasih, mohon pencerahannya
0
Tanggapan
Pertanyaan kamu tidak jelas, coba dijelaskan lebih baik
1 Jawaban:
<div>setelah saya ulik kembali ternyata masalahnya adalah disini saya sudah membuat file user.db itu karena ada ketimpangan data di file user.db<br><br>solusinya saya hapus isi file yang ada di user.db , <br>lalu saya jalanin<br><br></div><pre>python user.py</pre><div><br></div><div>erornya pun hilang</div>
0