#!/bin/sh

# Author: Athmane Madjoudj <athmanem@gmail.com>

# Author: Christoph Galuschka <christoph.galuschka@chello.at>

# reusing the script from LAMP-Tests

t_Log "Running $0 - php-cli basic interaction with mysql test."

# Install php-mysql-module

t_InstallPackage php-mysql

# we need a working and running mysql server

t_InstallPackage mysql-server

t_ServiceControl mysqld start >/dev/null 2>&1

#create a little DB to use

CREATE='/var/tmp/mysql-php-QA.sql'

cat >$CREATE <

drop database if exists phptests;

create database phptests;

use phptests;

create table tests (name varchar(20)) ;

grant all on phptests.* to 'centos'@'localhost' identified by 'qa';

flush privileges;

EOF

mysql <$CREATE

# create PHP Script and write something into DB

INSERT='/var/tmp/test.php'

cat >$INSERT <

\$dbconnect = mysql_connect("localhost","centos","qa");

if (!\$dbconnect)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("phptests", \$dbconnect);

mysql_query("INSERT INTO tests (name)

VALUES ('phpsqltest')");

mysql_close(\$dbconnect);

?> 

EOF

php $INSERT

if [ $? -ne 0 ]

  then

  t_Log "Inserting into DB failed"

  exit 1

fi

# create PHP script to read from DB

READ='/var/tmp/read.php'

cat >$READ <

\$dbconnect = mysql_connect("localhost","centos","qa");

if (!\$dbconnect)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("phptests", \$dbconnect);

\$array = mysql_query("SELECT count(*) as success FROM tests WHERE name = 'phpsqltest'");

mysql_close(\$dbconnect);

\$line = mysql_fetch_array(\$array, MYSQL_ASSOC);

print \$line['success'];

?>

EOF

# If we execute the script and get '1' it works (1 entry should be in the DB)

php $READ | grep -q '1'

t_CheckExitStatus $?

#cleaning up

/bin/rm $READ $CREATE $INSERT