Python Transbase Client
Project description
transbase-python
Python database driver for Transbase
based on Transbase/TCI (Transase C/C++ call interface )
implementing Python database api v2.0 (PEP-249)
Python | 3.9 |
Transbase | 8.x |
Install
Transbase is available in PyPi
pip install transbase
Example
from transbase import transbase
# connect to transbase database
connection = transbase.connect("//develop.transaction.de:8324/test", "test", "test")
cursor = connection.cursor()
cursor.execute("select no, text, date from test")
# use native python data types in fetch result set (bool, int, float, bytes,...)
# otherwise all values will be fetched as plain "str"
cursor.type_cast = True
row = cursor.fetchone()
print(row)
cursor.close()
connection.close()
DML statements (insert, update, delete) are executed similar.
The number of affected rows can be obtained by .rowcount
cursor.execute("insert into test ( text ) values ( '... kind regards' )");
print(cursor.rowcount) # -> 1
Query parameters can be passed as second argument
# pass parameters as object matching named parameters
cursor.execute(
"select no, text, date from test where no >= :no and text like :text",
{ "no": 1, "text": "Hello%" }
)
# or as an array for positional parameters
cursor.execute(
"select no, text, date from test where no >= ? and text like insensitive ?",
[ 2, "%kind%" ]
)
Troubleshooting
TCI SDK not found
If no prebuild binary wheel could be found on PyPi for your operating system or Python version
you can simply download it after installation by running the python script
(added with installation of this package)
install_tci
Contribution
VS-Code Editor with python extension is recommended.
Development
- install python 3.9 (TODO: -> 3.11)
- it is recommended to install and use virtualenv
py -m pip install --user virtualenv
- install required dependencies
py -m pip install flake8 coverage requests
- download tci lib
py setup.py get_lib
Test
py -m unittest
or use vs-code test explorer
Build
Source distribution and wheel including tci sdk
py setup.py sdist [bdist_wheel]
Manual Release
Linux wheels need to be renamed matching PEP-600
To publish manually to pypi (or testP) run
twine upload [--repository testpypi] dist/*
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for transbase-0.0.6-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 51265b3093d6f30ff96557eed40103806f74366064a40da6ea0e9f76ca316af5 |
|
MD5 | c1e3fe6ea0bfd64a8f668a2ec4c5acbe |
|
BLAKE2b-256 | c66abd78791888d092a4e09e975e58297fcbba48d978dcd7e6f3b93f3c92ca5f |
Hashes for transbase-0.0.6-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0c50c7be5cd96930d3b4a3b4637c78e4700829cfcd5b38a7d506b99e13425661 |
|
MD5 | 49c05a63ad6df258a30d09e7735141f9 |
|
BLAKE2b-256 | 3e6ebae1f9fb23c5e000a483878328dcc4c4377d21c27fd58c2f1586491e0559 |
Hashes for transbase-0.0.6-cp39-cp39-macosx_11_0_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | aab72d857b6a88b9dae5609cdf2cbcaf1f4dccc1034dc6c811011e601bbc24df |
|
MD5 | 49ff48f0a70f7ab86ce7d0c709fe4ae3 |
|
BLAKE2b-256 | 8b14f11f1f40a1688d7ed167726d1f3fad488d939c5108cc1c8e94dadadbc18e |