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.
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