Python open_connection_with_dict_factory示例

示例#1

文件： maxsqlite3_json.py 项目： maxneo4/SAPMedia

def get_json_data(database, query):
    try:
        connection = open_connection_with_dict_factory(database)
        cursor = connection.cursor()
        cursor.execute(query)
        data = cursor.fetchall()
        connection.close()
        return json.dumps(data)
    except:
        print "Unexpected error:", sys.exc_info()[0]
        raise

示例#2

文件： maxsqlite3_json.py 项目： maxneo4/SAPMedia

def insert_json_data(database, insert_query, insert_data):
    try:
        connection = open_connection_with_dict_factory(database)
        cursor = connection.cursor()
        cursor.execute(insert_query, insert_data)
        connection.commit()
        connection.close()
        return maxrest.build_json_response({'success':True}, 200)
    except:
        print "Unexpected error:", sys.exc_info()[0]
        return maxrest.build_json_response({'success':False}, 500)
        raise