django-dbmaker ============= ## django-dbmaker support for DBMaker

django-dbmaker is a Django DBMaker DB backend powered by the pyodbc library. pyodbc is a mature, viable way to access DBMaker from Python in multiple platforms and is actively maintained.

This is a fork of the original django-pyodbc, hosted on Google Code and last updated in 2017.

• [x] support for Django 2.X via https://github.com/dbmaker-go/django-dbmaker/
• [x] support for Django 3.X via https://github.com/dbmaker-go/django-dbmaker/tree/django3/
• [x] support for Django 4.X via https://github.com/dbmaker-go/django-dbmaker/tree/django4/
• [x] Support for DBMaker
• [x] Passes most of the tests of the Django test suite.
• [x] support for Python 3

1. Install django-dbmaker.

   git clone https://github.com/dbmaker-go/django-dbmaker
   cd django-dbmaker
   python setup.py install

2. Now you can now add a database to your settings using standard ODBC parameters. Note: you need to create utf-8 database first before add it to your settings.

   DATABASES = {
      'default': {
         'ENGINE':'django_dbmaker',
         'NAME':'DBName',
         'HOST': 'HostIp:Port',
         'USER':'UserName',
         'PASSWORD':'',
         'TEST_CREATE':False,
         'USE_TZ':False,
         'OPTIONS':{
             'driver':'DBMaker 5.4 Driver',
         },
      }
   }

3. That's it! You're done.*

   * You may need to configure your machine and drivers to do an ODBC connection to your database server, if you haven't already. For Linux this involves installing and configuring Unix ODBC and FreeTDS . Iterate on the command line to test your pyodbc connection like:

   python -c 'import pyodbc; print(pyodbc.connect("DSN=DBSAMPLE5;UID=SYSADM;PWD=").cursor().execute("select 1"))'

The following settings control the behavior of the backend:

NAME String. Database name. Required.

HOST String. instance in server\instance or ip,port format.

USER String. Database user name. If not given then MS Integrated Security

will be used.

PASSWORD String. Database user password.

TEST_CREATE Boolean. Indicates if test need to create test db or keep db.

OPTIONS Dictionary. Current available keys:

• driver

  String. ODBC Driver to use. Default is "DBMaker 5.4 Driver".

• SELTMPBB

  Boolean. Default False will set isolation committed, this may cause more lock timeout error if concurrent select/update on same record very frequently. Set True will set isolation level uncommited for select does not held lock, this may reduce lock timeout for concurrent select/update on same record. It will also cast blob to temp blob for select query as a snapshot of the blob for select statement to prevent incorrect access for blob.

From the original project README.

• All the Django core developers, especially Malcolm Tredinnick. For being an example of technical excellence and for building such an impressive community.
• The Oracle Django team (Matt Boersma, Ian Kelly) for some excellent ideas when it comes to implement a custom Django DB backend.