maj_population_2017_bilan.py

#!./venv37/bin/python
# -*- coding: utf-8 -*-

import cgi
import cgitb
import os.path
import sys
import json

import db

def get_data(data_type):
	with open(os.path.join(os.path.dirname(os.path.abspath(__file__)),'sql/{:s}.sql'.format(data_type)),'r') as fq:
		with db.bano_cache.cursor() as cur:
			cur.execute(fq.read())

			return cur.fetchall()

data = get_data('avancement_par_departement')

print("Content-Type: application/json\n")

print(json.JSONEncoder().encode(data))