jakobwenzel

#!/usr/bin/python

#=======================================
# Configure Options here
#=======================================

username = "TU-ID hier"
password = "Passwort hier"

firstYear = 2012

jirutka

###############################################################################
# The MIT License
#
# Copyright 2012-2014 Jakub Jirutka <[email protected]>.
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is

cristianp6

/**
 * Creates a "logging" schema with an "history" table where are stored records in JSON format
 * 
 * Requires PostgreSQL >= 9.3 since data is stored in JSON format
 *
 * Credits: http://www.cybertec.at/2013/12/tracking-changes-in-postgresql/
 */

/* Create a schema dedicated to logs */
CREATE SCHEMA logging;

lnattrass

import sys
import pprint
import struct
import socket
import ssl
from time import sleep 

# Standard "HELLO" message for TDS
prelogin_msg = bytearray([      0x12, 0x01, 0x00, 0x2f, 0x00, 0x00, 0x01, 0x00, 0x00, 0x00, 0x1a, 0x00, 0x06, 0x01, 0x00, 0x20,
                                0x00, 0x01, 0x02, 0x00, 0x21, 0x00, 0x01, 0x03, 0x00, 0x22, 0x00, 0x04, 0x04, 0x00, 0x26, 0x00,