psa_tests/psa_init.php at master · bmauser/psa_tests · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php

$TCFG['use_db'] = 'mysql';
//$TCFG['use_db'] = 'pgsql'; // Uncoment to use pgsql database. Also change connection settings in psa/config_override.php

$TCFG['psa_dir'] = 'W:/WEBROOT/psa1/skeleton_application/app/psa';

// for mysql
$TCFG['mysql']['sql_file']['main'] = 'W:/WEBROOT/psa1/install/db_mysql.sql';
$TCFG['mysql']['sql_file']['test1'] = 'W:/WEBROOT/psa1/tests/test1_mysql.sql';
$TCFG['mysql']['sql_file']['test2'] = 'W:/WEBROOT/psa1/tests/test2_mysql.sql';
$TCFG['mysql']['cli_command'] = 'W:/APP/xampp-portable/mysql/bin/mysql -u <USERNAME> -p<PASSWORD> -h localhost <DATABASE_NAME> < <SQL_FILE>';

// for pgsql
$TCFG['pgsql']['sql_file']['main'] = 'W:/WEBROOT/psa1/install/db_pgsql.sql';
$TCFG['pgsql']['sql_file']['test1'] = 'W:/WEBROOT/psa1/tests/test1_pgsql.sql';
$TCFG['pgsql']['sql_file']['test2'] = 'W:/WEBROOT/psa1/tests/test2_pgsql.sql';
$TCFG['pgsql']['cli_command'] = '"C:/Program Files/PostgreSQL/9.3/bin/psql.exe" -U <USERNAME> -d <DATABASE_NAME> -h localhost -f <SQL_FILE>';

// NOTE: check also database connection settings in psa/config_override.php
// ------------------------------------------------------------------------


// PSA main dir
define('PSA_BASE_DIR', $TCFG['psa_dir']);


// include required files
include PSA_BASE_DIR . '/config.php';
include PSA_BASE_DIR . '/lib/Psa_Singleton.php';
include PSA_BASE_DIR . '/lib/Psa_Logger.php';
include PSA_BASE_DIR . '/lib/Psa_Files.php';
include PSA_BASE_DIR . '/lib/Psa_Registry.php';
include PSA_BASE_DIR . '/lib/functions.php';


// register psa_autoload() function as __autoload() implementation
spl_autoload_register('psa_autoload');


// put PSA config array to registry
Psa_Registry::get_instance()->PSA_CFG = $PSA_CFG;
// database connection wrapper object
Psa_Registry::get_instance()->psa_database = new Psa_PDO();


// test hooks
Psa_Registry::get_instance()->PSA_CFG['folders']['hook_autoload'][] = '../../../tests/test_hooks';
Psa_Registry::get_instance()->PSA_CFG['folders']['hook_def'][] = '../../../tests/test_hooks/def';


// register and save files for autoloader
$files_data = Psa_Files::get_instance()->register();
Psa_Files::get_instance()->save($files_data);


// flag that this is test mode
if(!defined('PSA_TEST'))
	define('PSA_TEST', 1);


echo "\nPSA tests with {$TCFG['use_db']} database.\n\n";


/**
 * Executes SQL file.
 */
function run_sql_file($sql_file = null){

	global $PSA_CFG, $TCFG;

	if(!$sql_file)
		$sql_file = $TCFG[$TCFG['use_db']]['sql_file']['main'];
	else
		$sql_file = $TCFG[$TCFG['use_db']]['sql_file'][$sql_file];

	$command = $TCFG[$TCFG['use_db']]['cli_command'];

	$command = str_replace('<USERNAME>', $PSA_CFG['pdo']['username'], $command);
	$command = str_replace('<PASSWORD>', $PSA_CFG['pdo']['password'], $command);
	$command = str_replace('<DATABASE_NAME>', $PSA_CFG['pdo']['database'], $command);
	$command = str_replace('<SQL_FILE>', $sql_file, $command);

	shell_exec($command);
}