llmware-ai / llmware-ai/llmware
unable to open sqlite database
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 14.8k
- Forks
- 2.9k
- PR merge metrics
- No merged PRs in 30d
Description
Hi,
my system is windows 11 with 32GB RAM , using python 3.12 , i am trying to fiddle with llmware nlp to sql using a csv file, after installing the llmware i copy pasted "examples/Structured_Tables/loading_csv_into_custom_table-2a.py" this code, the python environment is already installed with sqlite. but when i run i encounter this error
> > File "C:\python312\Lib\site-packages\llmware\resources.py", line 3917, in insert_rows
> if self.build_table():
> ^^^^^^^^^^^^^^^^^^
> File "C:\python312\Lib\site-packages\llmware\resources.py", line 3273, in build_table
> conn = self.get_connection(table_name=self.table_name, type="write")
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> File "C:\python312\Lib\site-packages\llmware\resources.py", line 3356, in get_connection
> self.db_connection = CollectionWriter(self.table_name, account_name=self.account_name,
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> File "C:\python312\Lib\site-packages\llmware\resources.py", line 228, in __init__
> self._writer = SQLiteWriter(self.library_name, account_name=self.account_name, custom_table=custom_table,
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> File "C:\python312\Lib\site-packages\llmware\resources.py", line 2564, in __init__
> self.conn = _SQLiteConnect().connect(library_name)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> File "C:\python312\Lib\site-packages\llmware\resources.py", line 3083, in connect
> self.conn = sqlite3.connect(db_file)
> ^^^^^^^^^^^^^^^^^^^^^^^^
> sqlite3.OperationalError: unable to open database file
>
the folder is having full rights and i am able to create and manipulate sqlite db from a simple python program with out any issues.
struck with this for past 2 days any help ?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the failure with examples/Structured_Tables/loading_csv_into_custom_table-2a.py on Windows, then trace the database path from llmware/resources.py at lines 3083, 2564, and 3356. Done means identifying why sqlite3.connect cannot open the generated path and resolving or clearly documenting the cause so the CSV example runs successfully.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100