Skip to content

Non able to create output, starting from a simple html page #87

@aborruso

Description

@aborruso

Describe the bug

Hi, when I run

sqlitebiter url "https://gist.githubusercontent.com/aborruso/01db63cb74f0646e6bf0cb2b21b02951/raw/220c167e2fd8106f8cfea89d87239a3e8c1d9d6e/page.html"

I have this error

Traceback (most recent call last):
  File "cli.py", line 14, in <module>
  File "click/core.py", line 1137, in __call__
  File "click/core.py", line 1062, in main
  File "click/core.py", line 1668, in invoke
  File "click/core.py", line 1404, in invoke
  File "click/core.py", line 763, in invoke
  File "click/decorators.py", line 26, in new_func
  File "sqlitebiter/__main__.py", line 433, in url
  File "sqlitebiter/converter/_url.py", line 121, in convert
  File "sqlitebiter/converter/_table_creator.py", line 48, in create
  File "simplesqlite/core.py", line 1378, in create_table_from_tabledata
  File "simplesqlite/core.py", line 1727, in __create_table_from_tabledata
  File "simplesqlite/core.py", line 647, in insert_many
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 2, and there are 1 supplied.
[14985] Failed to execute script cli

Expected behavior

To have my sqlite db

To Reproduce

Steps to reproduce the behavior:

Simply run sqlitebiter url "https://gist.githubusercontent.com/aborruso/01db63cb74f0646e6bf0cb2b21b02951/raw/220c167e2fd8106f8cfea89d87239a3e8c1d9d6e/page.html"

Environments

Please complete the following information:

- uname: Linux
- Python version: CPython 3.8.10
- sqlitebiter version: 0.35.2
- SimpleSQLite version: not installed
- pytablereader version: not installed
  • Installation Method: deb package

Additional context

Add any other context (logs, error output, etc.) about the problem here.
(If it’s long, please paste to https://ghostbin.co/ and insert the link here.)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions