#!/usr/bin/env python
# -*- encoding: utf-8 -*-
# author: xu3352
# desc: mysql db access test

import pymysql
pymysql.install_as_MySQLdb()
import MySQLdb

# Open database connection
host="IP"
username="***"
passwd="***"
dbname="wordpress"
db = MySQLdb.connect(host, username, passwd, dbname)

# prepare a cursor object using cursor() method
cursor = db.cursor()

# Prepare SQL query to INSERT a record into the database.
# sql = "show tables"
sql = "select * from tbl_a where id > %d" % (0)
print( sql )

try:
   # Execute the SQL command
   cursor.execute(sql)
   # Fetch all the rows in a list of lists.
   results = cursor.fetchall()
   print ("id\t\tname\tage")
   for row in results:
      id = row[0]
      name = row[1]
      age = row[2]
      # Now print fetched result
      # print ("name = %s, age = %s" % (name, age))
      print("%s\t%s\t%s" % (id, name, age))
except:
   print ("Error: unable to fetch data")

## disconnect from server
db.close()