llmware-ai / llmware-ai/llmware

unable to open sqlite database

Open
#906 6 comments 0 reactions 0 assignees View on GitHub

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.