AttributeError

[tcicit]

Hello, pysimplesql is exactly what I was looking for :-). A simple GUI for a small database.
Unfortunately I get the following error when running your sample program.

Traceback (most recent call last):
File "example2.py", line 25, in
db = ss.Database('example2.db', win) # <=== load the database and bind it to the window
File "/home/test-db/pysimplesql.py", line 694, in init
new_database = not os.path.isfile(sqlite3_database)
File "/usr/lib/python3.8/genericpath.py", line 30, in isfile
st = os.stat(path)
TypeError: stat: path should be string, bytes, os.PathLike or integer, not Window
Exception ignored in: <function Database.del at 0x7fd34ee2dca0>
Traceback (most recent call last):
File "/home/test-db/pysimplesql.py", line 725, in del
if self.path!=':memory:':
AttributeError: 'Database' object has no attribute 'path'

[Sprucelass]

Having this same issue.

[jrwhit1]

I've seen that error. This is the one I usually get.

Traceback (most recent call last):
File "C:\Users\Joe\Documents\PythonCode\PySimpleGui\MakeSQLiteDB.py", line 18, in
ss.record_actions('Item', False)
AttributeError: module 'pysimplesql' has no attribute 'record_actions'

[dani-91]

Hi, I'm also currently testing the library. I solved the issue changing following line in pysimplesql.py (line 694):
new_database = not os.path.isfile(sqlite3_database)
TO:
new_database = not os.path.isfile(db_path)

and in example2.py (line 25):
db = ss.Database('example2.db', win, sql_file='example2.sql')
TO:
db = ss.Database('example2.db', win=win, sql_file='example2.sql')

[jrwhit1]

Good job, dani-91. I hadn't given up hope that someone would come up with the solution.

[PySimpleSQL]

Sorry for the hiatus

Examples have been fixed!
Next step is getting this onto PyPi officially