Attachment 875844 Details for Bug 1077591 – mysql_factory.py

mysql_factory.py

mysql_factory.py (text/x-python), 1.07 KB, created by Zhe Wang on 2014-03-18 09:46:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Zhe Wang

Created: 2014-03-18 09:46:43 UTC

Size: 1.07 KB

patch

obsolete

>#!/usr/bin/env python
>import os
>from cgi import escape
>import MySQLdb
>
>def response(params):
>    con = MySQLdb.connect(host=os.environ['OPENSHIFT_MYSQL_DB_HOST'], user=os.environ['OPENSHIFT_MYSQL_DB_USERNAME'], passwd=os.environ['OPENSHIFT_MYSQL_DB_PASSWORD'], db=os.environ['OPENSHIFT_APP_NAME'], port=int(os.environ['OPENSHIFT_MYSQL_DB_PORT']))
>    cursor = con.cursor()
>    cursor.execute('CREATE TABLE IF NOT EXISTS factory(id INT UNSIGNED NOT NULL, data TEXT, PRIMARY KEY(id));')
>    cursor.execute('COMMIT;')
>    cursor.execute('SELECT COUNT(*) FROM factory;')
>    try:
>        count = int(cursor.fetchone()[0])
>    except:
>        count = 0
>    if count == 0:
>        cursor.execute("INSERT INTO factory VALUES(1, '1');")
>    if 'version' in params:
>        cursor.execute("UPDATE factory SET data='%s' WHERE id=1;" % (escape(params['version'][0])))
>        response_body = "The mysql factory is modified"
>    else:
>        cursor.execute('SELECT * FROM factory;')
>        response_body = "version %s" % (cursor.fetchone()[1])
>    cursor.close()
>    con.close()
>    return response_body

Actions: View

Attachments on bug 1077591: 875843 | 875844