ssk’s posterous

ssk’s posterous

ssk  //  http://twitter.com/notentact

Filed under

mysql

See all posts on posterous with this tag »
Oct 25 / 9:27pm

arbiter's dream place in Utah: Python and MySQL technique - Render JSON ouput based on MySQLdb to MySQL

by ssk
Here is the code.
import MySQLdb
import simplejson as json
db = MySQLdb.connect(host='xxx', user='xx', passwd='xx', db='xxx')
cursor = db.cursor()
def getSQLJSON(hostName,dbName,id,pw,sql):
global db,cursor
resultArray =[]
cursor.execute(sql)
tableDescription = cursor.description
result = cursor.fetchall()
for e in result:
resultRaw ={}
columnIndex =0
for ee in e:
vcoulumnName = tableDescription [columnIndex][0]
resultRaw[coulumnName]=ee
columnIndex +=1
resultArray.append(resultRaw)
jsonResult = json.dumps(resultArray, separators=(',',':'))
return jsonResult
via arbiterski.blogspot.com

mysql の出力を JSON 形式へ？

Filed under  //  json   mysql   python  

Comments (0)

Jun 9 / 7:53pm

mysql and apache2 settings memo

by ssk

先頭を pre で始めると p に置き換えられるな。

$ mysqladmin -uroot -p variables |grep char
Enter password:
| character_set_client            | ujis                        |
| character_set_connection        | ujis                        |
| character_set_database          | ujis                        |
| character_set_filesystem        | binary                      |
| character_set_results           | ujis                        |
| character_set_server            | ujis                        |
| character_set_system            | utf8                        |
| character_sets_dir              | /usr/share/mysql/charsets/  |
$ cat /etc/apache2/conf.d/charset
# AddDefaultCharset UTF-8
AddDefaultCharset EUC-JP
$ grep mbstring /etc/php5/apache2/php.ini       [mbstring]
mbstring.language = Japanese
mbstring.internal_encoding = EUC-JP
mbstring.http_input = pass
mbstring.http_output = pass
; mbstring.internal_encoding setting. Input chars are
mbstring.encoding_translation = On
;mbstring.detect_order = auto
;mbstring.substitute_character = none;
; overload(replace) single byte functions by mbstring functions.
;mbstring.func_overload = 0
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding

ujis で mysqldump してインポートしたので文字化けなし。

Filed under  //  apache   mysql  

Comments (0)