# Importing the libraries and defining the connection

import mysql.connector as mysql
import pandas as pd
import numpy as np
pd.set_option('display.max_rows', 310)

# Defining cnx as our MySQL connection
# Make sure your vpn to datlinq is on!
cnx = mysql.connect(user='schilperoort', password='BMX741LOEFcgSnUw',
                              host='172.17.2.11',
                              database='outlet_public_global')

cnx1 = mysql.connect(user='schilperoort', password='BMX741LOEFcgSnUw',
                              host='172.17.2.11',
                              database='outlet_unilever_BNL')

# from IPython.display import HTML

# HTML('''<script>
# code_show=true;
# function code_toggle() {
#  if (code_show){
#  $('div.input').hide();
#  } else {
#  $('div.input').show();
#  }
#  code_show = !code_show
# }
# $( document ).ready(code_toggle);
# </script>
# <form action="javascript:code_toggle()"><input type="submit" value="Click here to toggle on/off the raw code."></form>''')