DoliDBTest.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. <?php
  2. /* Copyright (C) 2010 Laurent Destailleur <eldy@users.sourceforge.net>
  3. * Copyright (C) 2023 Alexandre Janniaux <alexandre.janniaux@gmail.com>
  4. *
  5. * This program is free software; you can redistribute it and/or modify
  6. * it under the terms of the GNU General Public License as published by
  7. * the Free Software Foundation; either version 3 of the License, or
  8. * (at your option) any later version.
  9. *
  10. * This program is distributed in the hope that it will be useful,
  11. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13. * GNU General Public License for more details.
  14. *
  15. * You should have received a copy of the GNU General Public License
  16. * along with this program. If not, see <https://www.gnu.org/licenses/>.
  17. * or see https://www.gnu.org/
  18. */
  19. /**
  20. * \file test/phpunit/DoliDBTest.php
  21. * \ingroup test
  22. * \brief PHPUnit test
  23. * \remarks To run this script as CLI: phpunit filename.php
  24. */
  25. global $conf,$user,$langs,$db;
  26. //define('TEST_DB_FORCE_TYPE','mysql'); // This is to force using mysql driver
  27. //require_once 'PHPUnit/Autoload.php';
  28. require_once dirname(__FILE__).'/../../htdocs/master.inc.php';
  29. require_once dirname(__FILE__).'/../../htdocs/core/class/discount.class.php';
  30. if (empty($user->id)) {
  31. print "Load permissions for admin user nb 1\n";
  32. $user->fetch(1);
  33. $user->getrights();
  34. }
  35. $conf->global->MAIN_DISABLE_ALL_MAILS=1;
  36. /**
  37. * Class for PHPUnit tests
  38. *
  39. * @backupGlobals disabled
  40. * @backupStaticAttributes enabled
  41. * @remarks backupGlobals must be disabled to have db,conf,user and lang not erased.
  42. */
  43. class DoliDBTest extends PHPUnit\Framework\TestCase
  44. {
  45. protected $savconf;
  46. protected $savuser;
  47. protected $savlangs;
  48. protected $savdb;
  49. /**
  50. * Constructor
  51. * We save global variables into local variables
  52. *
  53. * @param string $name Name
  54. * @return DiscountTest
  55. */
  56. public function __construct($name = '')
  57. {
  58. parent::__construct($name);
  59. //$this->sharedFixture
  60. global $conf,$user,$langs,$db;
  61. $this->savconf=$conf;
  62. $this->savuser=$user;
  63. $this->savlangs=$langs;
  64. $this->savdb=$db;
  65. print __METHOD__." db->type=".$db->type." user->id=".$user->id;
  66. //print " - db ".$db->db;
  67. print "\n";
  68. }
  69. /**
  70. * setUpBeforeClass
  71. *
  72. * @return void
  73. */
  74. public static function setUpBeforeClass(): void
  75. {
  76. global $conf,$user,$langs,$db;
  77. $db->begin(); // This is to have all actions inside a transaction even if test launched without suite.
  78. print __METHOD__."\n";
  79. }
  80. /**
  81. * tearDownAfterClass
  82. *
  83. * @return void
  84. */
  85. public static function tearDownAfterClass(): void
  86. {
  87. global $conf,$user,$langs,$db;
  88. $db->rollback();
  89. print __METHOD__."\n";
  90. }
  91. /**
  92. * Init phpunit tests
  93. *
  94. * @return void
  95. */
  96. protected function setUp(): void
  97. {
  98. global $conf,$user,$langs,$db;
  99. $conf=$this->savconf;
  100. $user=$this->savuser;
  101. $langs=$this->savlangs;
  102. $db=$this->savdb;
  103. print __METHOD__."\n";
  104. //print $db->getVersion()."\n";
  105. }
  106. /**
  107. * End phpunit tests
  108. *
  109. * @return void
  110. */
  111. protected function tearDown(): void
  112. {
  113. print __METHOD__."\n";
  114. }
  115. /**
  116. * testDDLUpdateField
  117. *
  118. * @return int
  119. */
  120. public function testDDLUpdateField()
  121. {
  122. global $conf,$user,$langs,$db;
  123. $conf=$this->savconf;
  124. $user=$this->savuser;
  125. $langs=$this->savlangs;
  126. $db=$this->savdb;
  127. print __METHOD__.' db->type = '.$db->type."\n";
  128. $savtype = '';
  129. $savnull = '';
  130. $resql = $db->DDLDescTable($db->prefix().'c_paper_format', 'code');
  131. while ($obj = $db->fetch_object($resql)) {
  132. if ($obj->Field == 'code') {
  133. $savtype = $obj->Type;
  134. $savnull = $obj->Null;
  135. }
  136. }
  137. // Set new field
  138. $field_desc = array('type'=>'varchar', 'value'=>'17', 'null'=>'NOT NULL');
  139. $result = $db->DDLUpdateField($db->prefix().'c_paper_format', 'code', $field_desc);
  140. $this->assertEquals(1, $result);
  141. print __METHOD__." result=".$result."\n";
  142. // TODO Use $savtype and $savnull instead of hard coded
  143. $field_desc = array('type'=>'varchar', 'value'=>'16', 'null'=>'NOT NULL', 'default'=>'aaaabbbbccccdddd');
  144. $result = $db->DDLUpdateField($db->prefix().'c_paper_format', 'code', $field_desc);
  145. $this->assertEquals(1, $result);
  146. print __METHOD__." result=".$result."\n";
  147. return $result;
  148. }
  149. }