/automatic_database_testing

Robotic process automation of postgresql database with robot framework

Primary LanguageHTML

automatic_database_testing

** ADMIRATION FOR THE UNKNOW **

web testing with robot automatic tests: many cases

Before, Keep your motivation and excitement level high!

Robotic process automation of database postgresql with robot framework

Make running?

Requirements

  • Docker
  • Python
  • Postgres
  • PGAdmin4 (optional)
  • psycopg
  • robot framework
  • robotframework-databaselibrary
  • robotframework-postgresqldb

Method 1

Docker container to postgres database server

# docker pull postgres 
# docker run 
#   --name cael-psql 
#   -p 5455:5432 
#   -e POSTGRES_USER=postgresUser 
#   -e POSTGRES_PASSWORD=postgresPW 
#   -e POSTGRES_DB=postgresDB 
#   -d 
#   postgres

Docker conainer to pgadmin4

# docker pull dpage/pgadmin4 
# docker run -p 80:80 \
# -e "PGADMIN_DEFAULT_EMAIL=admin@admin.com" \
# -e "PGADMIN_DEFAULT_PASSWORD=1234" \
# -d dpage/pgadmin4

Method 2: Docker conainer to pgadmin4 and postgres

# cd server_compose
# docker-compose up

Docker container for robot framework

# cd robot-container
# docker build -f ./Dockerfile -t robot .
# chmod +x scripts/run_suite.sh
# docker-compose up

PASSION FOR DISCOVERY