PageRenderTime 54ms CodeModel.GetById 30ms RepoModel.GetById 1ms app.codeStats 0ms

/Demo/gb_test.php

https://bitbucket.org/gbouthenot/gbphpdb
PHP | 186 lines | 128 code | 44 blank | 14 comment | 0 complexity | 026f1c6c932dc2e95141fd2905e84458 MD5 | raw file
    

  1. <?php
    2. 

  2. //require_once("Zend/Exception.php");
    3. 

  3. require_once("Zend/Loader.php");
    4. 

  4. require_once("../Gb/Util.php");
    5. 

  5. 

  6. Gb_Util::$debug=1;
    7. 

  7. Gb_Response::$noFooterEscape=1;
    8. 

  8. 

  9. Gb_Log::$loglevel_showuser=Gb_Log::LOG_ALL;
    10. 

  10. Gb_Log::$loglevel_file=Gb_Log::LOG_NOTICE;
    11. 

  11. Gb_Log::$loglevel_footer=Gb_Log::LOG_ALL;
    12. 

  12. Gb_Log::$logFilename="demo.log";
    13. 

  13. 

  14. Gb_Util::startup();
    15. 

  15. 

  16. function main()
    17. 

  17. {
    18. 

  18. 	Gb_Response::$head["author"]=array("name", "Gilles Bouthenot");
    19. 

  19. 	Gb_Response::send_headers(1);
    20. 

  20. 

  21. 	echo "this is main\n";
    22. 

  22. 

  23. 	echo "url is: ".$_SERVER['PHP_SELF'].Gb_Util::url_debug("&")."\n";
    24. 

  24. 

  25. 	Gb_Log::log(Gb_Log::LOG_DEBUG, "*** FOOTER ***:");
    26. 

  26. 

  27.     echo "Connexion avec Gb_Db --> Pdo_Mysql\n";
    28. 

  28.     $dbProt=new Gb_Db(array("type"=>"Pdo_Mysql",    "host"=>"pollux3" , "name"=>"test",      "user"=>"test", "pass"=>"testneon"));
    29. 

  29.     $date=$dbProt->retrieve_one("SELECT NOW()");
    30. 

  30.     print_r($date);
    31. 

  31.     //print_r($dbProt->getTablesName());
    32. 

  32.     echo "Fin de connexion\n";
    33. 

  33. 

  34.     echo "Connexion avec Gb_Db --> Pdo_Oci\n";
    35. 

  35.     $dbProt=new Gb_Db(array("type"=>"Pdo_Oci",    "host"=>"", "name"=>"PROTHEE99",      "user"=>"gbouthenot", "pass"=>"angel"));
    36. 

  36.     $date=$dbProt->retrieve_one("SELECT SYSDATE FROM DUAL");
    37. 

  37.     print_r($date);
    38. 

  38.     print_r($dbProt->getTables());
    39. 

  39.     echo "Fin de connexion\n";
    40. 

  40. 

  41. 	$c=array(0=>"a", "b"=>array(0=>"c", "d"=>"e"));
    42. 

  42. 	$d=array("a", "b", "c", 3=>"d", 5=>"e");
    43. 

  43. 

  44. 	//demo de dump:
    45. 

  45. 	Gb_Log::log(Gb_Log::LOG_DEBUG, "début des tests : dump");
    46. 

  46. 	$ret=Gb_Log::dump($d);	                                  echo ($ret=="array('a', 'b', 'c', 'd', 5=>'e')"  ?"OK":"ERROR")." dump array: $ret\n";
    47. 

  47. 	$ret=Gb_Log::dump($c);                                    echo ($ret=="array('a', b=>array('c', d=>'e'))"  ?"OK":"ERROR")." dump array of array: $ret\n";
    48. 

  48. 	$ret=Gb_Log::dump("toto");                                echo ($ret=="'toto'"                             ?"OK":"ERROR")." dump string: $ret\n";
    49. 

  49. 

  50. 	//demo de call
    51. 

  51. 	Gb_Log::log(Gb_Log::LOG_DEBUG, "début des tests : call");
    52. 

  52. 	$ret=Gb_Log::log_function(Gb_Log::LOG_DEBUG, "", array("Gb_Log","dump"), array($d));	     echo ($ret=="array('a', 'b', 'c', 'd', 5=>'e')"  ?"OK":"ERROR")." call of static function: $ret\n";
    53. 

  53. 

  54. 	$b="myB"; $c=array(5=>'my5', 'toto'=>'myToto');
    55. 

  55. 	$ret=Gb_Log::log_function(Gb_Log::LOG_DEBUG, "", "testfunction", array("myA", $b, &$c)); echo ($ret=="a=myA b=myB c[5]=my5 c[toto]=myToto"?"OK":"ERROR")." call: $ret\n";
    56. 

  56. 	                                                         echo ($b=='myB'&&$c[5]=="new5"                   ?"OK":"ERROR")." args passed by reference: b=$b c[5]=".$c[5]."\n";
    57. 

  57. 

  58. 	$catched=0;
    59. 

  59. 	try
    60. 

  60. 	{
    61. 

  61. 		$c=array(5=>'my5', 'toto'=>'myToto');
    62. 

  62. 		Gb_Log::log_function(Gb_Log::LOG_DEBUG, "", "testfunction3", array("myA", "myB", &$c));
    63. 

  63. 		echo "b=$b c[5]=".$c[5]."\n";
    64. 

  64. 	}catch (Gb_Exception $e)
    65. 

  65. 	{ $catched=1;
    66. 

  66. 	}
    67. 

  67. 	                                                         echo ($catched==1                                ?"OK":"ERROR")." exception thrown\n";
    68. 

  68. 

  69. 	//demo de Gb_Timer
    70. 

  70. 	Gb_Log::log(Gb_Log::LOG_DEBUG, "début des tests : Gb_Timer");
    71. 

  71. 	$t1=new Gb_Timer("Timer A");
    72. 

  72. 	$t2=new Gb_Timer();
    73. 

  73. 	$t3=new Gb_Timer();
    74. 

  74. 

  75. 

  76. 	$ret1=$t1->get();$ret2=$t2->get();$ret3=$t3->get(null);  echo ($ret1>0&&$ret1<1&&$ret2>0&&$ret2<1&&$ret3>0&&$ret3<1?"OK":"ERROR")." t1: $ret1 t2: $t2 t3: $t3\n";
    77. 

  77. 	$t1->logTimer();
    78. 

  78. 	$t3->pause();
    79. 

  79. 	sleep(1);
    80. 

  80. 	$ret1=$t1->get();$ret2=$t2->get();$ret3=$t3->get(null);  echo ($ret1>1&&$ret1<2&&$ret2>1&&$ret2<2&&$ret3>0&&$ret3<1?"OK":"ERROR")." t3->pause t1: $t1 t2: $t2 t3: $ret3\n";
    81. 

  81. 	$t2->logTimer();
    82. 

  82. 	$t2->reset();
    83. 

  83. 	$t3->resume();
    84. 

  84. 	$ret1=$t1->get();$ret2=$t2->get();$ret3=$t3->get(null);  echo ($ret1>1&&$ret1<2&&$ret2>0&&$ret2<1&&$ret3>0&&$ret3<1?"OK":"ERROR")." t2->reset, t3->resume t1: $ret1 t2: $ret2 t3: $t3\n";
    85. 

  85. 

  86. 	//démo de Gb_Util::roundCeil
    87. 

  87. 	Gb_Log::log(Gb_Log::LOG_DEBUG, "début des tests : roundCeil");
    88. 

  88. 	$ret=Gb_Util::roundCeil(120000  ,2);   echo ("$ret"==="120000"  ?"OK":"ERROR")." $ret\n";
    89. 

  89. 	$ret=Gb_Util::roundCeil(120000.1,2);   echo ("$ret"==="130000"  ?"OK":"ERROR")." $ret\n";
    90. 

  90. 	$ret=Gb_Util::roundCeil(129999.9,2);   echo ("$ret"==="130000"  ?"OK":"ERROR")." $ret\n";
    91. 

  91. 	$ret=Gb_Util::roundCeil(120000  ,3);   echo ("$ret"==="120000"  ?"OK":"ERROR")." $ret\n";
    92. 

  92. 	$ret=Gb_Util::roundCeil(120000.1,3);   echo ("$ret"==="121000"  ?"OK":"ERROR")." $ret\n";
    93. 

  93. 	$ret=Gb_Util::roundCeil(129999.9,3);   echo ("$ret"==="130000"  ?"OK":"ERROR")." $ret\n";
    94. 

  94. 

  95. 	$ret=Gb_Util::roundCeil(1400,2);       echo ("$ret"==="1400"    ?"OK":"ERROR")." $ret\n";
    96. 

  96. 	$ret=Gb_Util::roundCeil(1400.01,2);    echo ("$ret"==="1500"    ?"OK":"ERROR")." $ret\n";
    97. 

  97. 	$ret=Gb_Util::roundCeil(1400,3);       echo ("$ret"==="1400"    ?"OK":"ERROR")." $ret\n";
    98. 

  98. 	$ret=Gb_Util::roundCeil(1400.01,3);    echo ("$ret"==="1410"    ?"OK":"ERROR")." $ret\n";
    99. 

  99. 

  100. 	$ret=Gb_Util::roundCeil(140,2);        echo ("$ret"==="140"     ?"OK":"ERROR")." $ret\n";
    101. 

  101. 	$ret=Gb_Util::roundCeil(140.01,2);     echo ("$ret"==="150"     ?"OK":"ERROR")." $ret\n";
    102. 

  102. 	$ret=Gb_Util::roundCeil(140,3);        echo ("$ret"==="140"     ?"OK":"ERROR")." $ret\n";
    103. 

  103. 	$ret=Gb_Util::roundCeil(140.01,3);     echo ("$ret"==="141"     ?"OK":"ERROR")." $ret\n";
    104. 

  104. 

  105. 	$ret=Gb_Util::roundCeil(14,2);         echo ("$ret"==="14"      ?"OK":"ERROR")." $ret\n";
    106. 

  106. 	$ret=Gb_Util::roundCeil(14.01,2);      echo ("$ret"==="15"      ?"OK":"ERROR")." $ret\n";
    107. 

  107. 	$ret=Gb_Util::roundCeil(14,3);         echo ("$ret"==="14"      ?"OK":"ERROR")." $ret\n";
    108. 

  108. 	$ret=Gb_Util::roundCeil(14.01,3);      echo ("$ret"==="14.1"    ?"OK":"ERROR")." $ret\n";
    109. 

  109. 

  110. 	$ret=Gb_Util::roundCeil(1.4,2);        echo ("$ret"==="1.4"     ?"OK":"ERROR")." $ret\n";
    111. 

  111. 	$ret=Gb_Util::roundCeil(1.401,2);      echo ("$ret"==="1.5"     ?"OK":"ERROR")." $ret\n";
    112. 

  112. 	$ret=Gb_Util::roundCeil(1.4,3);        echo ("$ret"==="1.4"     ?"OK":"ERROR")." $ret\n";
    113. 

  113. 	$ret=Gb_Util::roundCeil(1.401,3);      echo ("$ret"==="1.41"    ?"OK":"ERROR")." $ret\n";
    114. 

  114. 

  115. 	$ret=Gb_Util::roundCeil(.14,2);        echo ("$ret"==="0.14"    ?"OK":"ERROR")." $ret\n";
    116. 

  116. 	$ret=Gb_Util::roundCeil(.1401,2);      echo ("$ret"==="0.15"    ?"OK":"ERROR")." $ret\n";
    117. 

  117. 	$ret=Gb_Util::roundCeil(.14,3);        echo ("$ret"==="0.14"    ?"OK":"ERROR")." $ret\n";
    118. 

  118. 	$ret=Gb_Util::roundCeil(.1401,3);      echo ("$ret"==="0.141"   ?"OK":"ERROR")." $ret\n";
    119. 

  119. 

  120. 	$ret=Gb_Util::roundCeil(.014,2);       echo ("$ret"==="0.014"   ?"OK":"ERROR")." $ret\n";
    121. 

  121. 	$ret=Gb_Util::roundCeil(.01401,2);     echo ("$ret"==="0.015"   ?"OK":"ERROR")." $ret\n";
    122. 

  122. 	$ret=Gb_Util::roundCeil(.014,3);       echo ("$ret"==="0.014"   ?"OK":"ERROR")." $ret\n";
    123. 

  123. 	$ret=Gb_Util::roundCeil(.01401,3);     echo ("$ret"==="0.0141"  ?"OK":"ERROR")." $ret\n";
    124. 

  124. 

  125. 	$ret=Gb_Util::roundCeil(.0014,2);      echo ("$ret"==="0.0014"  ?"OK":"ERROR")." $ret\n";
    126. 

  126. 	$ret=Gb_Util::roundCeil(.001401,2);    echo ("$ret"==="0.0015"  ?"OK":"ERROR")." $ret\n";
    127. 

  127. 	$ret=Gb_Util::roundCeil(.0014,3);      echo ("$ret"==="0.0014"  ?"OK":"ERROR")." $ret\n";
    128. 

  128. 	$ret=Gb_Util::roundCeil(.001401,3);    echo ("$ret"==="0.00141" ?"OK":"ERROR")." $ret\n";
    129. 

  129. 

  130. 	$ret=Gb_Util::roundCeil(.00014,2);     echo ("$ret"==="0.00014" ?"OK":"ERROR")." $ret\n";
    131. 

  131. 	$ret=Gb_Util::roundCeil(.0001401,2);   echo ("$ret"==="0.00015" ?"OK":"ERROR")." $ret\n";
    132. 

  132. 	$ret=Gb_Util::roundCeil(.00014,3);     echo ("$ret"==="0.00014" ?"OK":"ERROR")." $ret\n";
    133. 

  133. 	$ret=Gb_Util::roundCeil(.0001401,3);   echo ("$ret"==="0.000141"?"OK":"ERROR")." $ret\n";
    134. 

  134. 

  135. 

  136. 	$t3->reset();
    137. 

  137. 	$t3->logTimer(Gb_Log::LOG_DEBUG, "reset");
    138. 

  138. 

  139. 

  140. 	Gb_Log::log(Gb_Log::LOG_DEBUG, "début des tests : Gb_Db");
    141. 

  141. 	$dbGE=new Gb_Db(array("driver"=>"Pdo_Mysql", "host"=>"5.157.252.127", "user"=>"test", "pass"=>"testneon", "name"=>"horde"));
    142. 

  142. 	$t3->logTimer(Gb_Log::LOG_DEBUG, "new Gb_Db");
    143. 

  143. 

  144. 	$dbGE->beginTransaction();
    145. 

  145. //	$dbGE->delete("horde_prefs", array());
    146. 

  146. //	$dbGE->insert("horde_prefs", array("pref_uid"=>"root", "pref_scope"=>"scope1", "pref_name"=>"name1", "pref_value"=>"value1"));
    147. 

  147. //	$dbGE->update("horde_prefs", array("pref_value"=>"toto"), array());
    148. 

  148. //todo:escape
    149. 

  149. // $dbGE->update("horde_prefs", array("pref_value"=>"toto"), array("pref_name=".$dbGE->quote("last_login));
    150. 

  150. 

  151. //	Doit générer une exception si on n'a pas fait delete:
    152. 

  152. //	$dbGE->replace("horde_prefs", array("pref_value"=>"toto"), array($dbGE->quoteInto("pref_name=?","last_login")));
    153. 

  153. 

  154. //	$dbGE->replace("horde_prefs", array("pref_value"=>"toto", "pref_scope"=>"scope2"), array("pref_uid='root'", "pref_name='last_login'"));
    155. 

  155. 

  156. 	$sql="select * FROM horde_prefs WHERE pref_uid=?";
    157. 

  157. 	$sqlparam=array('root');
    158. 

  158. 

  159. 	$dbGE->retrieve_all($sql, $sqlparam);
    160. 

  160. 	$t3->logTimer(Gb_Log::LOG_DEBUG, "retrieve_all");
    161. 

  161. 

  162. 	$r=Gb_Log::log_function(Gb_Log::LOG_DEBUG, "", array($dbGE, "retrieve_all"), array($sql, $sqlparam));
    163. 

  163. 	echo "<pre>".print_r($r, true)."</pre>";
    164. 

  164. 

  165. 	$r=Gb_Log::log_function(Gb_Log::LOG_DEBUG, "", array($dbGE, "retrieve_all"), array($sql, $sqlparam, "pref_name"));
    166. 

  166. 	echo "<pre>".print_r($r, true)."</pre>";
    167. 

  167. 

  168. 	$r=Gb_Log::log_function(Gb_Log::LOG_DEBUG, "", array($dbGE, "retrieve_all"), array($sql, $sqlparam, "pref_name", "pref_value"));
    169. 

  169. 	echo "<pre>".print_r($r, true)."</pre>";
    170. 

  170. 

  171. 	$dbGE->rollBack();
    172. 

  172. 

  173. 

  174. 	return "OK";
    175. 

  175. }
    176. 

  176. 

  177. echo "Toujours là !";
    178. 

  178. 

  179. 

  180. function testfunction($a='', $b='', &$c='')
    181. 

  181. {
    182. 

  182. 	$ret="a=$a b=$b c[5]=".$c[5]." c[toto]=".$c['toto'];
    183. 

  183. 	$b="newB";
    184. 

  184. 	$c[5]="new5";
    185. 

  185. 	return $ret;
    186. 

  186. }
    187. 

  187.