On 2020-09-15 19:41, SS wrote:
I'm trying to create an table in html from a Maria DB table, from a python
script. I'm getting some unexpected results.
The environment is Centos 7, I'm using Python3 with apache.
Here is copy of the script I'm using:
******* SCRIPT START *********
import mysql.connector
import cgitb
cgitb.enable()
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="somepassword",
database="somedb"
)
mycursor = mydb.cursor()
mycursor.execute("select name, provisioned_space, used_space, memory_size, cpus,
ip_address, host_cpu, host_mem from projecttable where name like '%newproject%'")
myresult = mycursor.fetchall()
print "Content-type: text/plain:charset=utf-8"
print
for x in myresult:
print(x)
******* SCRIPT STOPS *********
It works. But I get alot of extraneous data I don't need or want. Here is an
example of the output:
********* OUTPUT STARTS ***********
Content-type: text/plain:charset=utf-8
(u'host1.mydomain.com', u'106.11 GB', u'32.72 GB', u'1 GB', u'1',
u'172.18.33.62', u'Running', u'16 MHz')
(u'hopst2.mydomain.com', u'106.08 GB', u'56.87 GB', u'1 GB', u'1',
u'172.17.4.82', u'Running', u'0 Hz')
********* OUTPUT STOPS ***********
Is this typical of Python? Do I need create another script to clean up the
output? Or is there a better way to extract data from a MariaDB instance, and
put it in an HTML table? Any advise would be appreciated.
That's not Python 3, that's Python 2.
The u'host1.mydomain.com' is a Unicode string. If you're going to print
it in Python 2, you'll need to encode it to bytes, UTF-8 in this case.
--
https://mail.python.org/mailman/listinfo/python-list
