from sqlalchemy import create_engine,MetaData
def connect_to_database_core():
# create an engine to point to my database 'Mainframe'
engine = create_engine('mysql+pymysql://root:123456@192.152.156.134:3306/ANNEDBSE')
# create a connection to connect to database
connection = engine.connect()
# create a metadata instance, we will use this instance to persistent tables
metadata = MetaData()
# return connection and metadata
return connection, metadata, engine