Skip to content

Latest commit

 

History

History
82 lines (56 loc) · 2.54 KB

README.md

File metadata and controls

82 lines (56 loc) · 2.54 KB
Raw

gomssql-python

This library binds go-mssqldb for use in Python3 using gopy .

Versions

All versions 1.0.0 and up support Python 3 only! If you need Python 2 support, check out the following:

Concept

In the early days gopy was fairly limited in it's ability to track object allocation across the border of Go and Python.

As a result, our implementation is fairly naive- we only pass primitive types from Go to Python (nothing that comes by reference).

Session are managed entirely on the Go side and identified with an integer- here are a few function signatures to demonstrate:

  • NewRPCSession(dataSourceName string) uint64
  • RPCConnect(sessionID uint64) error
  • RPCQuery(sessionID uint64, query string) (uint64, error)
  • RPCFetchAll(sessionID, rowsID uint64) (string, error)
  • RPCExecute(sessionID uint64, query string) (uint64, error)
  • RPCGetRowsAffected(sessionID, resultID uint64) (int64, error)
  • RPCClose(sessionID uint64) error

The functions that return complex data do so in a special JSON-based format- at this point gopy does it's magic and those functions are made available to Python.

We then have RPCSession abstraction on the Python side that pulls things together in a class for convenience (saving you need the to keep track of the identifiers and handling deserialisation).

Weird gotchas

We're building for Python3 and we use a python-config script for Python3 however we're using a python.pc file from Python2.

I dunno why this has to be this way, but it's the only way I can get the C Python API GIL lock/unlock calls to be available to Go (C.PyEval_SaveThread() and C.PyEval_RestoreThread(tState)).

So if you're wondering why Python2 still comes into it here and there- that's why. Doesn't seem to cause any problems.

Prerequisites

  • MacOS
  • CPython3.8+
  • virtualenv
    • pip install virtualenv
  • pkgconfig
    • brew install pkg-config
  • Docker

Install (from PyPI)

python -m pip install gomssql-python

Setup

virtualenv -p $(which python3) venv
source venv/bin/activate
./fix_venv.sh
pip install -r requirements-dev.txt

Build

source venv/bin/activate
./native_build.sh

If you're deep in the grind and want to iterate faster, you can invoke:

./native_build.sh fast

This skips the setup (assuming you've already done that).