FROM python:3.10.9-slim-buster

EXPOSE 8888/tcp
EXPOSE 8812/tcp
EXPOSE 9000/tcp
EXPOSE 9009/tcp

ENV ARCHITECTURE=x64
ENV PYTHONUNBUFFERED 1
ENV JAVA_HOME=/usr/lib/jvm/java-17-amazon-corretto
ENV PATH="$JAVA_HOME/bin:${PATH}"

# Update system
RUN apt-get -y update
RUN apt-get -y upgrade
RUN apt-get -y --no-install-recommends install syslog-ng ca-certificates git curl wget vim procps gnupg2 lsb-release software-properties-common unzip less tar gzip iputils-ping

# Install JDK
RUN wget -O- https://apt.corretto.aws/corretto.key | gpg --dearmor | tee /etc/apt/trusted.gpg.d/winehq.gpg >/dev/null && \
    add-apt-repository 'deb https://apt.corretto.aws stable main' && \
    apt-get update && \
    apt-get install -y java-17-amazon-corretto-jdk=1:17.0.3.6-1

# Clean after packages installation
RUN apt-get clean
RUN rm -rf /var/lib/apt/lists/*

# Aliases
RUN echo "alias l='ls -l'" >> ~/.bashrc
RUN echo "alias ll='ls -la'" >> ~/.bashrc
RUN echo "alias rm='rm -i'" >> ~/.bashrc

WORKDIR /opt

# Install QuestDB
COPY questdb-6.7.1-SNAPSHOT-no-jre-bin.tar.gz questdb.tar.gz
RUN tar xvfz questdb.tar.gz
RUN rm questdb.tar.gz
RUN mv questdb-6.7.1-SNAPSHOT-no-jre-bin questdb

# Configure QuestDB
RUN ulimit -S unlimited
RUN ulimit -H unlimited
RUN mkdir csv
RUN mkdir tmp
RUN mkdir backups
RUN mkdir volume0
RUN mkdir volume1
RUN mkdir questdb/db
RUN mkdir questdb/conf
RUN echo "config.validation.strict=true" > questdb/conf/server.conf
RUN echo "query.timeout.sec=120" >> questdb/conf/server.conf
RUN echo "cairo.volumes=volume0->/opt/volume0, volume1->/opt/volume1" >> questdb/conf/server.conf
RUN echo "cairo.sql.copy.root=/opt/csv" >> questdb/conf/server.conf
RUN echo "cairo.sql.copy.work.root=/opt/tmp" >> questdb/conf/server.conf
RUN echo "cairo.sql.backup.root=/opt/backups" >> questdb/conf/server.conf

# Install requirements.txt
COPY requirements.txt .
RUN pip install --upgrade pip
RUN pip install --no-compile --only-binary :all: -r requirements.txt
RUN jupyter-lab --generate-config && sed -i -e "s|# c.ServerApp.allow_remote_access = False|# c.ServerApp.allow_remote_access = True|g" /root/.jupyter/jupyter_lab_config.py

# Create run.sh script
RUN echo "#!/bin/bash" > run.sh
RUN echo "/opt/questdb/questdb.sh start -d /opt/questdb" >> run.sh
RUN echo "jupyter-lab --allow-root --ip 0.0.0.0 --port 8888 --no-browser --notebook-dir /opt/notebooks /opt/notebooks/play.ipynb" >> run.sh
RUN chmod 700 run.sh

COPY notebooks notebooks
CMD ["/bin/bash", "-c", "/opt/run.sh"]