django

About django examples

The django example is the result of running xo against all the supported databases that Django and xo supports, with Django models similar to the xo booktest schema.

Setup

Install packages:

# install mysql, postgres, sqlite3 dependencies
$ sudo aptitude install libpq-dev libmysqlclient-dev libsqlite3-dev

# install sqlserver dependenices
# manually add the microsoft-prod ppa -- see: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15
$ sudo aptitude install unixodbc unixodbc-dev odbcinst msodbcsql18

# ensure odbcinst.ini has the relevant sqlserver entry
$ cat /etc/odbcinst.ini
[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.0.so.1.1
UsageCount=1

# install oracle dependencies
$ cd /path/to/usql/contrib/godror
$ sudo ./grab-instantclient.sh

# fix oob issue with oracle driver
$ cd /path/to/usql/contrib/godror
$ ./fix-oob-config.sh

# install pipenv
$ pip install --user pipenv

# install packages
$ pipenv install

# update packages
$ pipenv update