Welcome, guest | Sign In | My Account | Store | Cart

ExecSql.cgi returning JSON for SQL (Python recipe) by Martchenko
ActiveState Code (http://code.activestate.com/recipes/576971/)

CGI script getting JSON for SQL request

Python, 40 lines
Download
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
#!c:/python25/python.exe -u
# -*- coding: utf-8 -*-

import sys,os
import cgi
import cgitb; cgitb.enable()
#
print """Content-Type: text/html;charset=UTF-8
"""
cgiform= cgi.FieldStorage()
if os.environ.has_key('QUERY_STRING'):
  query= cgi.urllib.unquote(os.environ['QUERY_STRING'])
else:
  query= """select * from dx order by code limit 10;"""


import MySQLdb, MySQLdb.cursors
mycon= MySQLdb.connect(host='localhost',port=3306, \
  db='airs', user='airs', passwd='airs', cursorclass=MySQLdb.cursors.DictCursor)
mycon.set_character_set('utf8')
mycur = mycon.cursor()
mycur.execute('SET NAMES utf8;')
# ===================================================
if len(sys.argv)>1:
  query= sys.argv[1]
mycur.execute(query);
print "["
for x1 in mycur._rows:
  print "{",
  nn= 0
  for x2 in x1:
    x3= x1[x2]
    if nn>0: print ",",
    nn= 1
    if type(x3).__name__=='str':
      print "'%s':" % x2, "'%s'" % x3.replace("'","\\'"),
    else:
      print "'%s':" % x2, x3,
  print "},"
print "]"
Tags: cgi, json, sql