import os
import time
import pymysql
#import threading
import logging
logging.basicConfig(filename = ('server_listing.log'),
                    level= logging.INFO ,
                    format= '%(asctime)s:%(message)s:', )


conn= pymysql.connect(host="mysql.server", user= "root", password='root', db="autoorder")

a = conn.cursor()
sql = 'SELECT * FROM "listings";'
a.execute(sql)
countrow = a.execute(sql)
print ("List checked:"+time,)
data = a.fetchall()
print(data)

logging.info('List checked at:'+time, '/n',
             +data)