import dash_html_components as html
import json
import pandas as pd
import plotly.express as px
import plotly.graph_objs as go
from connect import Connect
external_stylesheets = ['https://codepen.io/chriddyp/pen/bWLwgP.css']
app = dash.Dash(__name__, external_stylesheets=external_stylesheets)
server = app.server
NO_DATA_GRAPH = {'data': [], 'layout': go.Layout()}
connection = Connect.get_connection()
print("Databases:", connection.list_database_names())
# creating or accessing a new database
db = connection["imdb_database"]
category_dict = OrderedDict({
'top_movies': 'Top Movies',
'top_tvshows': 'Top TV Shows',
'top_budgets': 'Top Movie Budgets',
'top_revenues': 'Top Movie Revenues',
'top_budgets_revenues': 'Top Movie Budgets and their Revenues',
'top_revenues_budgets': 'Top Movie Revenues and their Budgets',
'movies_count': 'Number of Movies per Year',
'tvshows_count': 'Number of TV Shows per Year',
'budgets_max': 'Highest Movie Budget per Year',
# table_name here is the schema_name.table_name (e.g. etltest.campaign)
add_col = """ALTER TABLE {table_name}
ADD {col_name} {data_type} NULL;"""
insert_query = """ INSERT INTO {table_name}({attributes}) VALUES ({values}); """
createTable_query = """CREATE TABLE {schema_name}.{table_name} ( _id VARCHAR(100) ); """
schema_name = "etltest"
try:
conn = establishConnection() #Redshift
client = Connect.get_connection() #MongoDb
db = client['test']
## Add any other mongo collections here // Rename existing collections
# collections = ['organization', 'campaign', 'user', 'checkout', 'tickets']
collections = ['organization']
# Initialize Tables
for ele in collections:
sql = createTable_query.format(schema_name=schema_name, table_name=ele)
print("Creating Table - " + ele)
print(sql)
updateQuery(sql)
commitChanges()
for ele in collections: