Getting started with IBM DB Django adapter

IBM iSeries Db2 (pyodbc/iaccess driver) support for the Django application Framework

forked from python-ibmdb-django

Prerequisites for Django for iSeries

• Python 3.6+
• Django Framework 2.2.x or above.
• iAccess Client ODBC Driver

Installation

1. Install Django

Install Django as per instructions from the Django [http://docs.djangoproject.com/en/dev/topics/install/#installing-an-official-release website].

2. Install pyodbc and the DB2 Django adapter (django-pyodbc-iseries)

$ pip install django-pyodbc-iseries  

Tested Operating Systems

• Ubuntu Linux 18
• Win64/Win32 bit
• Mac OS

Supported Databases

• IBM Db2 for iSeries

Usage

• Create a new Django project by executing django-admin.py startproject myproj.

• Navigate to your newly created project directory (myproj, and edit the settings.py file

  DATABASES = {
    'default': {
       'ENGINE'     : 'iseries',
       'NAME'       : 'mydb',
       'USER'       : '<username>',
       'PASSWORD'   : '<pass>',
       'HOST'       : 'host/ipaddress',
    }
  }
  
  USE_TZ = False

• RUN python manage.py migrate

• In the tuple INSTALLED_APPS in settings.py add the following lines:

  [ ...,
    'django.contrib.flatpages',
    'django.contrib.redirects',
    'django.contrib.comments',
    'django.contrib.admin',
    ...,
  ]

• Next step is to run a simple test suite. To do this just execute following command in the project we created earlier:

  $ python manage.py test #for Django-1.5.x or older
  $ Python manage.py test django.contrib.auth #For Django-1.6.x onwards, since test discovery behavior have changed
  

Database Transactions

• Django by default executes without transactions i.e. in auto-commit mode. This default is generally not what you want in web-applications. Remember to turn on transaction support in Django