FROM python:latest
WORKDIR /code
COPY ./requirements.txt /code/requirements.txt

RUN apt-get -y update
RUN apt-get -y install git
RUN git clone https://github.com/dbt-labs/jaffle_shop.git
RUN pip install --no-cache-dir --upgrade -r /code/requirements.txt

RUN useradd -m -u 1000 user
USER user
ENV HOME=/home/user
ENV PATH=/home/user/.local/bin:$PATH
 
FROM postgres:latest
WORKDIR $HOME/app
# COPY --chown=user . $HOME/app

RUN ls /code

#COPY /code/jaffle_shop .
#COPY profiles.yml .

#ENV POSTGRES_HOST_AUTH_METHOD=trust
#ENV DBT_PROFILES_DIR=/jaffle_shop

#RUN ls
# RUN dbt debug

# RUN dbt seed
# RUN dbt run