FROM cubejs/cube:latest

# Copy the configuration files
COPY . /cube/conf

# Set environment variables
ENV CUBEJS_DB_HOST=34.150.22.222 \
    CUBEJS_DB_PORT=3306 \
    CUBEJS_DB_NAME=pchub_app \
    CUBEJS_DB_USER=pchubapp \
    CUBEJS_DB_PASS=7CRJbnVis_Ls \
    CUBEJS_DB_TYPE=mysql \
    CUBEJS_API_SECRET=c0387de6905e6d124c2d2d6410b7627b \
    CUBEJS_EXTERNAL_DEFAULT=true \
    CUBEJS_SCHEDULED_REFRESH_DEFAULT=true \
    CUBEJS_DEV_MODE=false \
    CUBEJS_SCHEMA_PATH=model \
    CUBEJS_CUBESTORE_HOST=cubestore-router \
    CUBEJS_CUBESTORE_PORT=3030

# Set ports for both HTTP API and PostgreSQL interfaces
ENV PORT=4000 \
    CUBEJS_PG_PORT=15432

# Expose both ports
EXPOSE ${PORT} ${CUBEJS_PG_PORT}

# Start Cube.js
CMD ["cubejs", "server"]