JoeyHendricks / python-benchmark-harness

A micro/macro benchmark framework for the Python programming language that helps with optimizing your software.
MIT License
155 stars 13 forks source link

problems when using sqlite3 with large profiled samples and deprecation warning #11

Closed JoeyHendricks closed 2 years ago

JoeyHendricks commented 2 years ago

Got the following error in one of my project will fix this and update QuickPotato.

C:\Program Files\Python38\lib\copyreg.py:91: SADeprecationWarning: Calling URL() directly is deprecated and will be disabled in a future release.  The public constructor for URL is now the URL.create() method.
  return cls.__new__(cls, *args)

Ran 1 test in 1.273s

FAILED (errors=1)

Error
Traceback (most recent call last):
  File "C:\Users\user\OneDrive\My Documents\PycharmProject\venster\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _execute_context
    self.dialect.do_execute(
  File "C:\Users\user\OneDrive \My Documents\PycharmProject\venster\venv\lib\site-packages\sqlalchemy\engine\default.py", line 719, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: too many SQL variables

The above exception was the direct cause of the following exception:
JoeyHendricks commented 2 years ago

problem is with amount of variables it is still sending to many variables, I am working on a work around for this.