phenobarbital/asyncdb

Collection of Asynchronous (Asyncio-based) generic Database connectors

Coding Habits:

Latest Tweets:

asyncdb's Issues

Windows build failing

Hello,

is this one supported on Windows by any chance? Build is failing.

python -m pip install asyncdb
Collecting asyncdb
  Using cached asyncdb-2.1.40.tar.gz (228 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... error
  error: subprocess-exited-with-error

  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
  ╰─> [21 lines of output]
      Traceback (most recent call last):
        File "C:\Users\user\Desktop\Programs\Python\Python310\lib\site-packages\pip\_vendor\pep517\in_process\_in_process.py", line 351, in <module>
          main()
        File "C:\Users\user\Desktop\Programs\Python\Python310\lib\site-packages\pip\_vendor\pep517\in_process\_in_process.py", line 333, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
        File "C:\Users\user\Desktop\Programs\Python\Python310\lib\site-packages\pip\_vendor\pep517\in_process\_in_process.py", line 118, in get_requires_for_build_wheel
          return hook(config_settings)
        File "C:\Users\user\AppData\Local\Temp\pip-build-env-ik_estk3\overlay\Lib\site-packages\setuptools\build_meta.py", line 338, in get_requires_for_build_wheel
          return self._get_build_requires(config_settings, requirements=['wheel'])
        File "C:\Users\user\AppData\Local\Temp\pip-build-env-ik_estk3\overlay\Lib\site-packages\setuptools\build_meta.py", line 320, in _get_build_requires
          self.run_setup()
        File "C:\Users\user\AppData\Local\Temp\pip-build-env-ik_estk3\overlay\Lib\site-packages\setuptools\build_meta.py", line 335, in run_setup
          exec(code, locals())
        File "<string>", line 270, in <module>
        File "C:\Users\user\AppData\Local\Temp\pip-build-env-ik_estk3\overlay\Lib\site-packages\Cython\Build\Dependencies.py", line 970, in cythonize
          module_list, module_metadata = create_extension_list(
        File "C:\Users\user\AppData\Local\Temp\pip-build-env-ik_estk3\overlay\Lib\site-packages\Cython\Build\Dependencies.py", line 816, in create_extension_list
          for file in nonempty(sorted(extended_iglob(filepattern)), "'%s' doesn't match any files" % filepattern):
        File "C:\Users\user\AppData\Local\Temp\pip-build-env-ik_estk3\overlay\Lib\site-packages\Cython\Build\Dependencies.py", line 114, in nonempty
          raise ValueError(error_msg)
      ValueError: 'asyncdb/exceptions/exceptions.pyx' doesn't match any files
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error

× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.

It's a Windows 10 with Python 3.10

attribute "model" on Model Connections make clash with a column called "model"

in model methods, this block of code:
result = await self.Meta.connection.model_get( model=self, fields=self.columns(), **kwargs )

The attribute called "model" will clash with a database field called "model", please, rename that attribute.

Linting errors detected with "make lint"

After running make lint I detected the following linting errors:

pylint: Command line or configuration file:1: UserWarning: 'BaseException' is not a proper value for the 'overgeneral-exceptions' option. Use fully qualified name (maybe 'builtins.BaseException' ?) instead. This will cease to be checked at runtime in 3.1.0.
pylint: Command line or configuration file:1: UserWarning: 'Exception' is not a proper value for the 'overgeneral-exceptions' option. Use fully qualified name (maybe 'builtins.Exception' ?) instead. This will cease to be checked at runtime in 3.1.0.
************* Module asyncdb.interfaces
asyncdb/interfaces.py:625:11: R6103: Use 'if (row := await self._cursor.fetchone()) is not None:' instead (consider-using-assignment-expr)
asyncdb/interfaces.py:636:11: R6103: Use 'if (row := self._cursor.fetchone()) is not None:' instead (consider-using-assignment-expr)
asyncdb/interfaces.py:722:11: R6103: Use 'if (data := await self._cursor.fetchrow()) is not None:' instead (consider-using-assignment-expr)
asyncdb/interfaces.py:872:21: R1714: Consider merging these comparisons with 'in' by using 'value in ('!null', '!NULL')'. Use a set instead if elements are hashable. (consider-using-in)
asyncdb/interfaces.py:888:24: W0141: Used builtin function 'map'. Using a list comprehension can be clearer. (bad-builtin)
asyncdb/interfaces.py:894:24: W0141: Used builtin function 'map'. Using a list comprehension can be clearer. (bad-builtin)
asyncdb/interfaces.py:855:4: R0912: Too many branches (14/12) (too-many-branches)
asyncdb/interfaces.py:886:49: W6001: 'typing.List' is deprecated, use 'list' instead (deprecated-typing-alias)

support asyncio-based cassandra driver

Now, cassandra driver uses asyncore, its implementation is too old. And I want to use cassandra in pure asynchronous (asyncio-based) code in Python3.11. I want to know whether it will be soon in the next release.

Occured 'row count' error in JDBC driver

AttributeError: 'jdbc' object has no attribute 'rowcount'

When use execute in jdbc query, I got upper error.
The query was upsert query.
Can u fix it?