PHP Classes

File: docker/ubuntu16/run.sh

Recommend this page to a friend!
  Classes of Punto Waskito   PHP CRUD API   docker/ubuntu16/run.sh   Download  
File: docker/ubuntu16/run.sh
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP CRUD API
Provide API to manipulate database table records
Author: By
Last change:
Date: 3 years ago
Size: 2,358 bytes
 

Contents

Class file image Download
#!/bin/bash echo "================================================" echo " Ubuntu 16.04 (PHP 7.0)" echo "================================================" echo -n "[1/4] Starting MariaDB 10.0 ..... " # make sure mysql can create socket and lock mkdir /var/run/mysqld && chmod 777 /var/run/mysqld # run mysql server nohup mysqld > /root/mysql.log 2>&1 & # wait for mysql to become available while ! mysqladmin ping -hlocalhost >/dev/null 2>&1; do sleep 1 done # create database and user on mysql mysql -u root >/dev/null << 'EOF' CREATE DATABASE `php-crud-api` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE USER 'php-crud-api'@'localhost' IDENTIFIED BY 'php-crud-api'; GRANT ALL PRIVILEGES ON `php-crud-api`.* TO 'php-crud-api'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; EOF echo "done" echo -n "[2/4] Starting PostgreSQL 9.5 ... " # run postgres server nohup su - -c "/usr/lib/postgresql/9.5/bin/postgres -D /etc/postgresql/9.5/main" postgres > /root/postgres.log 2>&1 & # wait for postgres to become available until su - -c "psql -U postgres -c '\q'" postgres >/dev/null 2>&1; do sleep 1; done # create database and user on postgres su - -c "psql -U postgres >/dev/null" postgres << 'EOF' CREATE USER "php-crud-api" WITH PASSWORD 'php-crud-api'; CREATE DATABASE "php-crud-api"; GRANT ALL PRIVILEGES ON DATABASE "php-crud-api" to "php-crud-api"; \c "php-crud-api"; CREATE EXTENSION IF NOT EXISTS postgis; \q EOF echo "done" echo -n "[3/4] Starting SQLServer 2017 ... " # run sqlserver server nohup /opt/mssql/bin/sqlservr --accept-eula > /root/mssql.log 2>&1 & # create database and user on postgres /opt/mssql-tools/bin/sqlcmd -l 30 -S localhost -U SA -P sapwd123! >/dev/null << 'EOF' CREATE DATABASE [php-crud-api] GO CREATE LOGIN [php-crud-api] WITH PASSWORD=N'php-crud-api', DEFAULT_DATABASE=[php-crud-api], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE [php-crud-api] GO CREATE USER [php-crud-api] FOR LOGIN [php-crud-api] WITH DEFAULT_SCHEMA=[dbo] exec sp_addrolemember 'db_owner', 'php-crud-api'; GO exit EOF echo "done" echo -n "[4/4] Cloning PHP-CRUD-API v2 ... " # install software if [ -d /php-crud-api ]; then echo "skipped" else git clone --quiet https://github.com/mevdschee/php-crud-api.git echo "done" fi echo "------------------------------------------------" # run the tests cd php-crud-api php test.php