#!/bin/sh
# Author: Athmane Madjoudj <athmanem@gmail.com>
# Author: Christoph Galuschka <tigalch@tigalch.org>
# 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
#starting with 5.10 we need to reflect mysql55
if [ $centos_ver = 5 ]
then
  t_InstallPackage mysql-server mysql55-mysql-server nc
  t_ServiceControl mysql55-mysqld stop
else
  t_InstallPackage mysql-server nc
fi
t_ServiceControl mysqld start >/dev/null 2>&1

#create a little DB to use
CREATE='/var/tmp/mysql-php-QA.sql'

cat >$CREATE <<EOF
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 <<EOF
<?php
\$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 <<EOF
<?php
\$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
mysql -u root -e 'drop database phptests' >/dev/null 2>&1