Integration Tests Using PHPUnit to Ensure Your Website is Workin

  • 时间：2020-09-12 10:17:13
  • 分类：网络文摘
  • 阅读：134 次

You must want to make sure your website is configured properly to work with the static contents (e.g. html, js, css) and the dynamic contents (PHP, MySQL) – either you are using Apache2 or Ngnix servers.

We can write some integration tests using PHPUnit that write contents to the website public folder, and test the contents via HTTP or HTTPS url. That way, we make sure the website is configured correctly to serve static files, dynamic contents (even with MySQL databases).

You could put this in a BASH script, then schedule the script in the Crontab that runs e.g. hourly. If the tests fail, send an email notification so you are notified in time.

1
2
3
4
5
6
7

#!/bin/bash
 
phpunit tests.php
if [[ $? -ne 0 ]]; then
   echo "Tests Failed"
   echo "Sending email..."
fi
#!/bin/bash

phpunit tests.php
if [[ $? -ne 0 ]]; then
   echo "Tests Failed"
   echo "Sending email..."
fi

Test the Static Contents

You could repeat this test by replacing the file extension with HTML, and it should still work.

1
2
3
4
5
6
7
8
9

  public function test_a_text_file() {
    define('API_ROOT_FOLDER', '/var/www/your_website');
    $domain = "helloacm.com";
    $file = API_ROOT_FOLDER . '/test.txt';
    $data = "This is a text file " . date("Y-m-d h:i:s");
    file_put_contents($file, $data);
    $data = trim(shell_exec("curl -s \"https://$domain/test.txt\""));
    $this->assertEquals($data, $data);
  }
  public function test_a_text_file() {
    define('API_ROOT_FOLDER', '/var/www/your_website');
    $domain = "helloacm.com";
    $file = API_ROOT_FOLDER . '/test.txt';
    $data = "This is a text file " . date("Y-m-d h:i:s");
    file_put_contents($file, $data);
    $data = trim(shell_exec("curl -s \"https://$domain/test.txt\""));
    $this->assertEquals($data, $data);
  }

Test the Dynamic Contents

The PHP or other dynamic contents should be interpreted at the server side before sending the content to the client. In the integration tests, we can write a PHP script, and curl it to expect the content.

1
2
3
4
5
6
7
8
9

  public function test_a_php_file() {
    define('API_ROOT_FOLDER', '/var/www/your_website');
    $domain = "helloacm.com";
    $file = API_ROOT_FOLDER . '/test.php';
    $data = "<?php \n echo 'This is a PHP file " . date("Y-m-d h:i:s"). "';";
    file_put_contents($file, $data);
    $data = trim(shell_exec("curl -s \"https://$domain/test.php\""));
    $this->assertEquals($data, 'This is a PHP file '. date("Y-m-d h:i:s"));
  }
  public function test_a_php_file() {
    define('API_ROOT_FOLDER', '/var/www/your_website');
    $domain = "helloacm.com";
    $file = API_ROOT_FOLDER . '/test.php';
    $data = "<?php \n echo 'This is a PHP file " . date("Y-m-d h:i:s"). "';";
    file_put_contents($file, $data);
    $data = trim(shell_exec("curl -s \"https://$domain/test.php\""));
    $this->assertEquals($data, 'This is a PHP file '. date("Y-m-d h:i:s"));
  }

Test the Dynamic Contents with MySQL database access

Let’s push this a step further by integration the test the connection to Database (MySQL). 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

  public function test_a_php_file_with_mysql_access() {
    define('API_ROOT_FOLDER', '/var/www/your_website');
    $domain = "helloacm.com";
    $file = API_ROOT_FOLDER . '/test.php';
    $DB_HOST = "localhost";
    $DB_USER = "root";
    $DB_PASSWORD = "password";
    $data = "<?php
    \$conn = mysqli_connect('$DB_HOST', '$DB_USER', '$DB_PASSWORD', \"mysql\");
    \$query = \"select * from user where User='root'\";
    \$result = mysqli_query(\$conn, \$query) or die(mysqli_error(\$conn));
    \$array = mysqli_fetch_assoc(\$result);
    echo \$array['User'] . date(\"Y-m-d h:i:s\");        
    ";
    file_put_contents($file, $data);
    $data = trim(shell_exec("curl -s \"https://$domain/test.php\""));
    $this->assertEquals($data, 'root'. date("Y-m-d h:i:s"));
  }
  public function test_a_php_file_with_mysql_access() {
    define('API_ROOT_FOLDER', '/var/www/your_website');
    $domain = "helloacm.com";
    $file = API_ROOT_FOLDER . '/test.php';
    $DB_HOST = "localhost";
    $DB_USER = "root";
    $DB_PASSWORD = "password";
    $data = "<?php
    \$conn = mysqli_connect('$DB_HOST', '$DB_USER', '$DB_PASSWORD', \"mysql\");
    \$query = \"select * from user where User='root'\";
    \$result = mysqli_query(\$conn, \$query) or die(mysqli_error(\$conn));
    \$array = mysqli_fetch_assoc(\$result);
    echo \$array['User'] . date(\"Y-m-d h:i:s\");        
    ";
    file_put_contents($file, $data);
    $data = trim(shell_exec("curl -s \"https://$domain/test.php\""));
    $this->assertEquals($data, 'root'. date("Y-m-d h:i:s"));
  }

–EOF (The Ultimate Computing & Technology Blog) —

推荐阅读：
How to Compute the N-th Tribonacci Number using Iterative Dynami　 How to Find the Largest Unique Number in Array (C++)?　 How to Find the K-diff Pairs in an Array with Two Pointer or Has　 String Algorithm: Reverse the first k characters for every 2k ch　 How to Generate Parentheses using Bruteforce or Depth First Sear　 Algorithm to Construct Binary Tree from Preorder and Inorder Tra　 The 24 Game Algorithm using Depth First Search　 How to Count the Path Sum from a Binary Tree using Depth First S　 How to Multiply Two Matrices in C++?　 How to Compute the Number of Equivalent Domino Pairs?　
评论列表
添加评论