Skip to content

Instantly share code, notes, and snippets.

@fredyrx
fredyrx / 00. tutorial.md
Created February 7, 2018 18:01 — forked from maxivak/00. tutorial.md
Importing/Indexing database (MySQL or SQL Server) in Solr using Data Import Handler
@fredyrx
fredyrx / README.md
Created February 2, 2016 13:18 — forked from rduplain/README.md
Connect to MSSQL using FreeTDS / ODBC in Python.

Goal: Connect to MSSQL using FreeTDS / ODBC in Python.

Host: Ubuntu 11.10 x86_64

Install:

sudo apt-get install freetds-dev freetds-bin unixodbc-dev tdsodbc
pip install pyodbc sqlalchemy

In /etc/odbcinst.ini:

@fredyrx
fredyrx / python.sh
Created April 18, 2015 14:29
run manage python out the virtualenv and log commands exetuted
#!/bin/bash
# CONFIG
USER="myuser"
PROJECT="projectname"
VIRTUALENV_RELATIVE_PATH="virtualenvpath"
DATE_FORMAT="%d/%m/%Y %T"
# AUTO SET
HOME="/home/$USER"
PYTHON="$HOME/$VIRTUALENV_RELATIVE_PATH/bin/python"
MANAGE="$HOME/$VIRTUALENV_RELATIVE_PATH/$PROJECT/manage.py"