#!/usr/bin/python
import wx
import subprocess
import os
import MySQLdb
import json

db = MySQLdb.connect(host="localhost", port=3306, user="root", passwd="*****", db="linuxdev")
cursor = db.cursor()

sql = ("SELECT * FROM users")
cursor.execute(sql)

row = cursor.fetchone()

data_string = 'id: {0}, username: {1}, password: {2}',format(*(1,'two', 'three))

# main frame class
class gunnp(wx.Frame):

    def __init__(self, parent, id):
        wx.Frame.__init__(self, parent, id, "GNOME SQL Entry by GunnDawg", size = (570,300))

        panel = wx.Panel(self)

        wx.StaticText(panel, -1, data_string, (45, 25), style=wx.ALIGN_CENTRE)


if __name__== "__main__":
    app = wx.PySimpleApp()
    frame = gunnp(parent = None, id = -1)
    frame.Show()
    app.MainLoop()