# https://discuss.huggingface.co/t/how-to-install-a-specific-version-of-gradio-in-spaces/13552
import os

def p(command):
    print("EXEC: " + command)
    os.system(command)

p("mkdir _gradio")
p("mv gradio.zip _gradio")
os.chdir("_gradio")

from zipfile import ZipFile

z = ZipFile("gradio.zip")
z.extractall()
p("pip uninstall gradio")
p("pip install -e .")
print(os.getcwd())
import sys
sys.path.append(os.getcwd())
os.chdir("..")

"""
p("wget -qO- https://get.pnpm.io/install.sh | sh -")
p("git clone https://github.com/yiyuezhuo/gradio --branch cmo_pinned")
os.chdir("gradio")
p("pnpm i --frozen-lockfile")
p("pnpm build")
p("pip uninstall -y gradio")
p("pip install -e .")
os.chdir("..")
"""

# os.system("pip uninstall -y gradio")
# os.system("pip install git+https://github.com/yiyuezhuo/gradio@cmo_pinned")

import gradio as gr
import pandas as pd
import plotly
import sqlalchemy

print(f"gr.__version__={gr.__version__}, pd.__version__={pd.__version__}, ployly.__version__={plotly.__version__}, sqlalchemy.__version__={sqlalchemy.__version__}")
print(dir(gr))

from cmo_db_inspector import App
from pathlib import Path

cmo_db_root = Path("DB")

app = App(cmo_db_root).create()
app.demo.launch()