Integration Tests Using PHPUnit to Ensure Your Website is Workin

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

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) —

推荐阅读：
几种含多不饱和脂肪酸的食物　 维生素B2(核黄素)的食物来源　 维生素B1(硫胺素)的食物来源　 SAE数据库导入、导出和备份方法　 保健食品：不以治疗疾病为目的！　 专家称转基因食品违背生态平衡的天道　 海虾与河虾口感差别大　 到底怎么分辨食物的“寒热”　 番石榴可用于辅助治疗糖尿病　 哪些食物是不适合生吃的？　
评论列表
添加评论