from os import environ as env
from keystoneauth1 import loading
from keystoneauth1 import session
from neutronclient.v2_0 import client
import pymysql

loader = loading.get_plugin_loader('password')
auth = loader.load_from_options(auth_url=env['OS_AUTH_URL'],username=env['OS_USERNAME'],password=env['OS_PASSWORD'], project_id= '646ce0dee0944242aaae26df0bfb3b6f', user_domain_name=env['OS_USER_DOMAIN_NAME'])
sess = session.Session(auth=auth)
neutron = client.Client( session=sess)

#########Database Connection##########################

connection = pymysql.connect(host='localhost', user='root', password='Ro3118086', db='billing', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor)








routers=neutron.list_routers(retrieve_all=True)
#print(neutron.list_networks())
#print(neutron.list_routers(retrieve_all=True))
print(neutron.list_floatingips(retrieve_all=True))
#print(neutron.list_flavors(retrieve_all=True))