ModelTest.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490
  1. <?php declare(strict_types=1);
  2. use Identicon\Identicon;
  3. use PHPUnit\Framework\TestCase;
  4. use PrivateBin\Configuration;
  5. use PrivateBin\Data\Database;
  6. use PrivateBin\Model;
  7. use PrivateBin\Model\Comment;
  8. use PrivateBin\Model\Paste;
  9. use PrivateBin\Persistence\ServerSalt;
  10. use PrivateBin\Persistence\TrafficLimiter;
  11. use PrivateBin\Vizhash16x16;
  12. class ModelTest extends TestCase
  13. {
  14. private $_conf;
  15. private $_model;
  16. protected $_path;
  17. public function setUp(): void
  18. {
  19. /* Setup Routine */
  20. $this->_path = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'privatebin_data';
  21. if (!is_dir($this->_path)) {
  22. mkdir($this->_path);
  23. }
  24. $options = parse_ini_file(CONF_SAMPLE, true);
  25. $options['purge']['limit'] = 0;
  26. $options['model'] = array(
  27. 'class' => 'Database',
  28. );
  29. $options['model_options'] = array(
  30. 'dsn' => 'sqlite::memory:',
  31. 'usr' => null,
  32. 'pwd' => null,
  33. 'opt' => array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION),
  34. );
  35. Helper::confBackup();
  36. Helper::createIniFile(CONF, $options);
  37. ServerSalt::setStore(new Database($options['model_options']));
  38. $this->_conf = new Configuration;
  39. $this->_model = new Model($this->_conf);
  40. $_SERVER['REMOTE_ADDR'] = '::1';
  41. }
  42. public function tearDown(): void
  43. {
  44. /* Tear Down Routine */
  45. unlink(CONF);
  46. Helper::confRestore();
  47. Helper::rmDir($this->_path);
  48. }
  49. public function testBasicWorkflow()
  50. {
  51. // storing pastes
  52. $pasteData = Helper::getPastePost();
  53. unset($pasteData['meta']['created'], $pasteData['meta']['salt']);
  54. $this->_model->getPaste(Helper::getPasteId())->delete();
  55. $paste = $this->_model->getPaste(Helper::getPasteId());
  56. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  57. $paste = $this->_model->getPaste();
  58. $paste->setData($pasteData);
  59. $paste->store();
  60. $paste = $this->_model->getPaste(Helper::getPasteId());
  61. $this->assertTrue($paste->exists(), 'paste exists after storing it');
  62. $paste = $paste->get();
  63. unset(
  64. $pasteData['meta'],
  65. $paste['meta'],
  66. $paste['comments'],
  67. $paste['comment_count'],
  68. $paste['comment_offset'],
  69. $paste['@context']
  70. );
  71. $this->assertEquals($pasteData, $paste);
  72. // storing comments
  73. $commentData = Helper::getCommentPost();
  74. $paste = $this->_model->getPaste(Helper::getPasteId());
  75. $comment = $paste->getComment(Helper::getPasteId(), Helper::getCommentId());
  76. $this->assertFalse($comment->exists(), 'comment does not yet exist');
  77. $comment = $paste->getComment(Helper::getPasteId());
  78. $comment->setData($commentData);
  79. $comment->store();
  80. $comments = $this->_model->getPaste(Helper::getPasteId())->get()['comments'];
  81. $this->assertTrue(count($comments) === 1, 'comment exists after storing it');
  82. $commentData['id'] = Helper::getPasteId();
  83. $commentData['meta']['created'] = current($comments)['meta']['created'];
  84. $commentData['meta']['icon'] = current($comments)['meta']['icon'];
  85. $this->assertEquals($commentData, current($comments));
  86. // deleting pastes
  87. $this->_model->getPaste(Helper::getPasteId())->delete();
  88. $paste = $this->_model->getPaste(Helper::getPasteId());
  89. $this->assertFalse($paste->exists(), 'paste successfully deleted');
  90. $this->assertEquals(array(), $paste->getComments(), 'comment was deleted with paste');
  91. }
  92. public function testCommentDefaults()
  93. {
  94. $class = 'PrivateBin\\Data\\' . $this->_conf->getKey('class', 'model');
  95. $comment = new Comment(
  96. $this->_conf,
  97. new $class(
  98. $this->_conf->getSection('model_options')
  99. )
  100. );
  101. $paste = $this->_model->getPaste(Helper::getPasteId());
  102. $comment->setPaste($paste);
  103. $this->assertEquals(Helper::getPasteId(), $comment->getParentId(), 'comment parent ID gets initialized to paste ID');
  104. }
  105. public function testPasteDuplicate()
  106. {
  107. $pasteData = Helper::getPastePost();
  108. $this->_model->getPaste(Helper::getPasteId())->delete();
  109. $paste = $this->_model->getPaste();
  110. $paste->setData($pasteData);
  111. $paste->store();
  112. $paste = $this->_model->getPaste();
  113. $paste->setData($pasteData);
  114. $this->expectException(Exception::class);
  115. $this->expectExceptionCode(75);
  116. $paste->store();
  117. }
  118. public function testStoreFail()
  119. {
  120. $path = $this->_path . DIRECTORY_SEPARATOR . 'model-store-test.sq3';
  121. if (is_file($path)) {
  122. unlink($path);
  123. }
  124. $options = parse_ini_file(CONF_SAMPLE, true);
  125. $options['purge']['limit'] = 0;
  126. $options['model'] = array(
  127. 'class' => 'Database',
  128. );
  129. $options['model_options'] = array(
  130. 'dsn' => 'sqlite:' . $path,
  131. 'usr' => null,
  132. 'pwd' => null,
  133. 'opt' => array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION),
  134. );
  135. Helper::createIniFile(CONF, $options);
  136. $model = new Model(new Configuration);
  137. $pasteData = Helper::getPastePost();
  138. $model->getPaste(Helper::getPasteId())->delete();
  139. $model->getPaste(Helper::getPasteId())->exists();
  140. $db = new PDO(
  141. $options['model_options']['dsn'],
  142. $options['model_options']['usr'],
  143. $options['model_options']['pwd'],
  144. $options['model_options']['opt']
  145. );
  146. $statement = $db->prepare('DROP TABLE paste');
  147. $statement->execute();
  148. $statement->closeCursor();
  149. $paste = $model->getPaste();
  150. $paste->setData($pasteData);
  151. $this->expectException(Exception::class);
  152. $this->expectExceptionCode(76);
  153. $paste->store();
  154. }
  155. public function testCommentStoreFail()
  156. {
  157. $path = $this->_path . DIRECTORY_SEPARATOR . 'model-test.sq3';
  158. if (is_file($path)) {
  159. unlink($path);
  160. }
  161. $options = parse_ini_file(CONF_SAMPLE, true);
  162. $options['purge']['limit'] = 0;
  163. $options['model'] = array(
  164. 'class' => 'Database',
  165. );
  166. $options['model_options'] = array(
  167. 'dsn' => 'sqlite:' . $path,
  168. 'usr' => null,
  169. 'pwd' => null,
  170. 'opt' => array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION),
  171. );
  172. Helper::createIniFile(CONF, $options);
  173. $model = new Model(new Configuration);
  174. $pasteData = Helper::getPastePost();
  175. $commentData = Helper::getCommentPost();
  176. $model->getPaste(Helper::getPasteId())->delete();
  177. $paste = $model->getPaste();
  178. $paste->setData($pasteData);
  179. $paste->store();
  180. $this->assertTrue($paste->exists(), 'paste exists before creating comment');
  181. $comment = $paste->getComment(Helper::getPasteId());
  182. $comment->setData($commentData);
  183. $db = new PDO(
  184. $options['model_options']['dsn'],
  185. $options['model_options']['usr'],
  186. $options['model_options']['pwd'],
  187. $options['model_options']['opt']
  188. );
  189. $statement = $db->prepare('DROP TABLE comment');
  190. $statement->execute();
  191. $statement->closeCursor();
  192. $this->expectException(Exception::class);
  193. $this->expectExceptionCode(70);
  194. $comment->store();
  195. }
  196. public function testCommentDuplicate()
  197. {
  198. $pasteData = Helper::getPastePost();
  199. $commentData = Helper::getCommentPost();
  200. $this->_model->getPaste(Helper::getPasteId())->delete();
  201. $paste = $this->_model->getPaste();
  202. $paste->setData($pasteData);
  203. $paste->store();
  204. $comment = $paste->getComment(Helper::getPasteId());
  205. $comment->setData($commentData);
  206. $comment->store();
  207. $comment = $paste->getComment(Helper::getPasteId());
  208. $comment->setData($commentData);
  209. $this->expectException(Exception::class);
  210. $this->expectExceptionCode(69);
  211. $comment->store();
  212. }
  213. public function testImplicitDefaults()
  214. {
  215. $pasteData = Helper::getPastePost();
  216. $commentData = Helper::getCommentPost();
  217. $this->_model->getPaste(Helper::getPasteId())->delete();
  218. $paste = $this->_model->getPaste();
  219. $paste->setData($pasteData);
  220. $paste->store();
  221. $comment = $paste->getComment(Helper::getPasteId());
  222. $comment->setData($commentData);
  223. $comment->get();
  224. $comment->store();
  225. $identicon = new Identicon();
  226. $pngdata = $identicon->getImageDataUri(TrafficLimiter::getHash(), 16);
  227. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  228. $this->assertEquals($pngdata, $comment['meta']['icon'], 'icon gets set');
  229. }
  230. public function testPasteIdValidation()
  231. {
  232. $this->assertTrue(Paste::isValidId('a242ab7bdfb2581a'), 'valid paste id');
  233. $this->assertFalse(Paste::isValidId('foo'), 'invalid hex values & length');
  234. $this->assertFalse(Paste::isValidId('f00'), 'invalid length');
  235. $this->assertFalse(Paste::isValidId('foo bar baz quux'), 'invalid hex values');
  236. $this->assertFalse(Paste::isValidId("\n01234567feedcafe"), 'invalid line breaks');
  237. $this->assertFalse(Paste::isValidId("deadbeef01234567\n"), 'invalid line breaks');
  238. $this->assertFalse(Paste::isValidId('../bar/baz'), 'path attack');
  239. }
  240. public function testInvalidPaste()
  241. {
  242. $this->_model->getPaste(Helper::getPasteId())->delete();
  243. $paste = $this->_model->getPaste(Helper::getPasteId());
  244. $this->expectException(Exception::class);
  245. $this->expectExceptionCode(64);
  246. $paste->get();
  247. }
  248. public function testInvalidPasteFormat()
  249. {
  250. $pasteData = Helper::getPastePost();
  251. $pasteData['adata'][1] = 'format does not exist';
  252. $paste = $this->_model->getPaste();
  253. $this->expectException(Exception::class);
  254. $this->expectExceptionCode(75);
  255. $paste->setData($pasteData);
  256. }
  257. public function testInvalidPasteId()
  258. {
  259. $this->expectException(Exception::class);
  260. $this->expectExceptionCode(60);
  261. $this->_model->getPaste('');
  262. }
  263. public function testInvalidComment()
  264. {
  265. $paste = $this->_model->getPaste();
  266. $this->expectException(Exception::class);
  267. $this->expectExceptionCode(62);
  268. $paste->getComment(Helper::getPasteId());
  269. }
  270. public function testInvalidCommentDeletedPaste()
  271. {
  272. $pasteData = Helper::getPastePost();
  273. $paste = $this->_model->getPaste(Helper::getPasteId());
  274. $paste->setData($pasteData);
  275. $paste->store();
  276. $comment = $paste->getComment(Helper::getPasteId());
  277. $paste->delete();
  278. $this->expectException(Exception::class);
  279. $this->expectExceptionCode(67);
  280. $comment->store();
  281. }
  282. public function testInvalidCommentData()
  283. {
  284. $pasteData = Helper::getPastePost();
  285. $pasteData['adata'][2] = 0;
  286. $paste = $this->_model->getPaste(Helper::getPasteId());
  287. $paste->setData($pasteData);
  288. $paste->store();
  289. $comment = $paste->getComment(Helper::getPasteId());
  290. $this->expectException(Exception::class);
  291. $this->expectExceptionCode(68);
  292. $comment->store();
  293. }
  294. public function testInvalidCommentParent()
  295. {
  296. $paste = $this->_model->getPaste(Helper::getPasteId());
  297. $this->expectException(Exception::class);
  298. $this->expectExceptionCode(65);
  299. $paste->getComment('');
  300. }
  301. public function testExpiration()
  302. {
  303. $pasteData = Helper::getPastePost();
  304. $this->_model->getPaste(Helper::getPasteId())->delete();
  305. $paste = $this->_model->getPaste(Helper::getPasteId());
  306. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  307. $paste = $this->_model->getPaste();
  308. $paste->setData($pasteData);
  309. $paste->store();
  310. $paste = $paste->get();
  311. $this->assertEquals((float) 300, (float) $paste['meta']['time_to_live'], 'remaining time is set correctly', 1.0);
  312. }
  313. public function testCommentDeletion()
  314. {
  315. $pasteData = Helper::getPastePost();
  316. $this->_model->getPaste(Helper::getPasteId())->delete();
  317. $paste = $this->_model->getPaste();
  318. $paste->setData($pasteData);
  319. $paste->store();
  320. $this->expectException(Exception::class);
  321. $this->expectExceptionCode(64);
  322. $paste->getComment(Helper::getPasteId())->delete();
  323. }
  324. public function testPurge()
  325. {
  326. $conf = new Configuration;
  327. $store = new Database($conf->getSection('model_options'));
  328. $store->delete(Helper::getPasteId());
  329. $expired = Helper::getPaste(array('expire_date' => 1344803344));
  330. $paste = Helper::getPaste(array('expire_date' => time() + 3600));
  331. $keys = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'x', 'y', 'z');
  332. $ids = array();
  333. foreach ($keys as $key) {
  334. $ids[$key] = hash('fnv164', $key);
  335. $store->delete($ids[$key]);
  336. $this->assertFalse($store->exists($ids[$key]), "paste $key does not yet exist");
  337. if (in_array($key, array('x', 'y', 'z'))) {
  338. $this->assertTrue($store->create($ids[$key], $paste), "store $key paste");
  339. } else {
  340. $this->assertTrue($store->create($ids[$key], $expired), "store $key paste");
  341. }
  342. $this->assertTrue($store->exists($ids[$key]), "paste $key exists after storing it");
  343. }
  344. $this->_model->purge(10);
  345. foreach ($ids as $key => $id) {
  346. if (in_array($key, array('x', 'y', 'z'))) {
  347. $this->assertTrue($this->_model->getPaste($id)->exists(), "paste $key exists after purge");
  348. $this->_model->getPaste($id)->delete();
  349. } else {
  350. $this->assertFalse($this->_model->getPaste($id)->exists(), "paste $key was purged");
  351. }
  352. }
  353. }
  354. public function testCommentWithDisabledVizhash()
  355. {
  356. $options = parse_ini_file(CONF, true);
  357. $options['main']['discussiondatedisplay'] = 'false';
  358. $options['main']['icon'] = 'none';
  359. $options['model'] = array(
  360. 'class' => 'Database',
  361. );
  362. $options['model_options'] = array(
  363. 'dsn' => 'sqlite::memory:',
  364. 'usr' => null,
  365. 'pwd' => null,
  366. 'opt' => array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION),
  367. );
  368. Helper::createIniFile(CONF, $options);
  369. $model = new Model(new Configuration);
  370. $pasteData = Helper::getPastePost();
  371. $this->_model->getPaste(Helper::getPasteId())->delete();
  372. $paste = $model->getPaste(Helper::getPasteId());
  373. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  374. $paste = $model->getPaste();
  375. $paste->setData($pasteData);
  376. $paste->store();
  377. $paste = $model->getPaste(Helper::getPasteId());
  378. $this->assertTrue($paste->exists(), 'paste exists after storing it');
  379. // storing comments
  380. $commentData = Helper::getCommentPost();
  381. unset($commentData['meta']['icon']);
  382. $paste = $model->getPaste(Helper::getPasteId());
  383. $comment = $paste->getComment(Helper::getPasteId(), Helper::getPasteId());
  384. $this->assertFalse($comment->exists(), 'comment does not yet exist');
  385. $comment = $paste->getComment(Helper::getPasteId());
  386. $comment->setData($commentData);
  387. $comment->store();
  388. $comment = $paste->getComment(Helper::getPasteId(), Helper::getPasteId());
  389. $this->assertTrue($comment->exists(), 'comment exists after storing it');
  390. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  391. $this->assertFalse(array_key_exists('icon', $comment['meta']), 'icon was not generated');
  392. $this->assertTrue(array_key_exists('created', $comment['meta']), 'creation is set, when using default configuration');
  393. $comment = current($paste->get()['comments']);
  394. $this->assertFalse(array_key_exists('created', $comment['meta']), 'creation is not set, if using disabled configuration');
  395. }
  396. public function testCommentVizhash()
  397. {
  398. $options = parse_ini_file(CONF, true);
  399. $options['main']['icon'] = 'vizhash';
  400. $options['model'] = array(
  401. 'class' => 'Database',
  402. );
  403. $options['model_options'] = array(
  404. 'dsn' => 'sqlite::memory:',
  405. 'usr' => null,
  406. 'pwd' => null,
  407. 'opt' => array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION),
  408. );
  409. Helper::createIniFile(CONF, $options);
  410. $model = new Model(new Configuration);
  411. $pasteData = Helper::getPastePost();
  412. $commentData = Helper::getCommentPost();
  413. $model->getPaste(Helper::getPasteId())->delete();
  414. $paste = $model->getPaste();
  415. $paste->setData($pasteData);
  416. $paste->store();
  417. $comment = $paste->getComment(Helper::getPasteId());
  418. $comment->setData($commentData);
  419. $comment->store();
  420. $vz = new Vizhash16x16();
  421. $pngdata = 'data:image/png;base64,' . base64_encode($vz->generate(TrafficLimiter::getHash()));
  422. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  423. $this->assertEquals($pngdata, $comment['meta']['icon'], 'vizhash was generated');
  424. }
  425. }