- postgres db to run the postgres project
- oracle db to run the oracle project
- Rabbitmq to run the data generator and loaders project.
- linux vm to run oracle docker image
- Deploy an oracle db using docker
Option 1:
docker run -d -p 1521:1521 -e ORACLE_PASSWORD=XXXXX -v oracle-volume:/opt/oracle/oradata gvenzl/oracle-xe
Option 2:
https://github.com/oracle/python-oracledb/tree/main/samples/sample_container
- rename the db_config_sample.py to db_config.py and update your connection parameters to Oracledb and RabbitMQ
- Run the python oracle Project on local
python3 panda-company-ora.py
- Postgres running locally or k8s
- Rename the files db_config_sample.py to db_config.py and update your configuration for Postgress and RabbitMQ
- Run the python postgres project on local
python3 panda-company-postgres.py
- Provides data generator that genrates random data for various jobs
- Provides data loaders that can load the data to postgres db
- Update the config values for Postgres, RabbitMQ and OLLAMA
- Run the python postgres freature project on local
python3 panda-company-postgres-feature.py
Data generator comes with various jobs that can produce random data and send a json payload to RabbitMQ queue_declare
Data loaders are equipped to read the json payload from RabbitMQ queue and save the data to PostgresDB or OracleDB
Currently the python buildpack does not support some of libraries used in the project. However we can build a docker image and run this application to demo a COTS application on TPCF
- Build a docker image using the Dockerfile-feature-TPCF
- cf push panda-company-tpcf
CF_DOCKER_PASSWORD="$(cat key.json)" cf push panda-company-feature --docker-image --docker-username _json_key -k 2G
- cf bind-service postgresdb panda-company-tpcf
- cf bind-service rabbitmq panda-company-tpcf