Skip to content

Instantly share code, notes, and snippets.

@Adarnof
Adarnof / conv.py
Last active April 20, 2018 20:24
Convert sqlite3 to mysql
#!/usr/bin/python3
# https://stackoverflow.com/a/13365275
# Usage: sqlite3 database_name.sqlite3 .dump | python3 conv.py > database_name.sql
import re
import fileinput
def this_line_is_useless(line):
useless_es = [
@Adarnof
Adarnof / allianceauth-v2-ubuntu16.sh
Last active November 17, 2017 22:07
allianceauth-v2-ubuntu16
apt-get update && apt-get install -y python3 python3-dev python3-venv python3-setuptools python3-pip redis-server libssl-dev libbz2-dev libffi-dev supervisor nginx
adduser --disabled-login allianceserver
python3 -m venv /home/allianceserver/env
source /home/allianceserver/env/bin/activate
pip install git+https://github.com/allianceauth/allianceauth@v2-dev-master-merge
pip install gunicorn
allianceauth start auth /home/allianceserver/auth
ln /home/allianceserver/auth/supervisor.conf /etc/supervisor/conf.d/auth.conf
echo "DEBUG = True" >> /home/allianceserver/auth/auth/settings/local.py
python /home/allianceserver/auth/manage.py migrate