def export_ledger():
    cnx = mariadb.connect(  user=cfg.db['user'],
                            password=cfg.db['pwd'],
                            database=cfg.db['baseteste']
                            )
    cursor = cnx.cursor()

    query = """
            SELECT ID, data, credito, debito, descricao, valor
            FROM ledger_teste
            ORDER BY data DESC
            """

    cursor.execute(query)
    rows = cursor.fetchall()
    desc = cursor.description
    cnx.close()

    ledger_completo = [dict(itertools.izip([col[0] for col in desc], row))
        for row in rows]

    return json.dumps(ledger_completo)

$('#exemplo').Tabledit({
    url: 'export_ledger.py',
    columns: {
        identifier: [0, 'id'],
        editable: [[1, 'Data'], [2, 'Credito'], [3, 'Debito'], [4, 'Descrição'], [5, 'Valor']]
    },
    onDraw: function() {
        console.log('onDraw()');
    },
    onSuccess: function(data, textStatus, jqXHR) {
        console.log('onSuccess(data, textStatus, jqXHR)');
        console.log(data);
        console.log(textStatus);
        console.log(jqXHR);
    },
    onFail: function(jqXHR, textStatus, errorThrown) {
        console.log('onFail(jqXHR, textStatus, errorThrown)');
        console.log(jqXHR);
        console.log(textStatus);
        console.log(errorThrown);
    },
    onAlways: function() {
        console.log('onAlways()');
    },
    onAjax: function(action, serialize) {
        console.log('onAjax(action, serialize)');
        console.log(action);
        console.log(serialize);
    }
});