tmaxtw/django-polls

django tutorial application for testing django-tibero backend engine

Sample application based on django tutorial

https://docs.djangoproject.com/en/3.2/intro/

Configuration

• Install django-tibero from github repository

  pip3 install git+https://github.com/cpyang/django-tibero.git  

• Modify mysite/settings.py with Tibero as default database
  Using django-tibero module

    DATABASES = {
        'default': {
            'ENGINE': "django_tibero",
            'HOST': "127.0.0.1,8629",
            'USER': "tibero",
            'PASSWORD': "tmax",
            'NAME': "tibero",
            'OPTIONS': {
                'dsn': "tibero",
                'unicode_results': True,
                'connection_timeout': 0,
                'dbshell': "tbsql",
            },
        }
    }

  Using django-pyodbc module

    DATABASES = {  
        'default': {  
            'ENGINE': "django_pyodbc",  
            'HOST': "127.0.0.1,8629",  
            'USER': "tibero",  
            'PASSWORD': "tmax",  
            'NAME': "tibero",  
            'OPTIONS': {  
                'dsn': "tibero",
                'host_is_server': True,  
                'driver': "Tibero",  
                'dbms_type': 'tibero',  
            },  
        }  
    }  

• Setup Environment Variables

  . ./setenv.sh

• Initialise django database

  python3 manage.py migrate

• After made change to models

  python3 manage.py makemigrations polls  
  python3 manage.py sqlmigrate polls 0001   

• Create site admin user

  python3 manage.py createsuperuser

• Start django web service

  python3 manage.py runserver

• Access web application
  Admin: http://localhost:8000/admin
  Polls: http://localhost:8000/polls

Runing this demo application with docker

• Using docker-compose Modify database connection informat in docker-compose.yml

  cd docker
  docker-compose build
  docker-compose up

• Using docker Put database connection information in build arguments

  docker build -t polls --build-arg DB_NAME=tibero --build-arg DB_HOST=localhost --build-arg DB_PORT=8629 .
  docker run --name polls -p 8000:8000 polls