1
0

ModelTest.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553
  1. <?php declare(strict_types=1);
  2. use Jdenticon\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'] = [
  27. 'class' => 'Database',
  28. ];
  29. $options['model_options'] = [
  30. 'dsn' => 'sqlite::memory:',
  31. 'usr' => null,
  32. 'pwd' => null,
  33. 'opt' => [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::getCommentId();
  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([], $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'] = [
  127. 'class' => 'Database',
  128. ];
  129. $options['model_options'] = [
  130. 'dsn' => 'sqlite:' . $path,
  131. 'usr' => null,
  132. 'pwd' => null,
  133. 'opt' => [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'] = [
  164. 'class' => 'Database',
  165. ];
  166. $options['model_options'] = [
  167. 'dsn' => 'sqlite:' . $path,
  168. 'usr' => null,
  169. 'pwd' => null,
  170. 'opt' => [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 testCommentDuplicateOtherParent()
  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->store();
  224. $firstCommentId = $comment->getId();
  225. // reply to the first comment, using a different ciphertext
  226. $replyData = $commentData;
  227. $replyData['ct'] = base64_encode('reply ciphertext');
  228. $replyData['parentid'] = $firstCommentId;
  229. $reply = $paste->getComment($firstCommentId);
  230. $reply->setData($replyData);
  231. $reply->store();
  232. $this->assertTrue($reply->exists(), 'reply to existing comment can be stored');
  233. // replay of the first comment under the reply as parent
  234. $commentData['parentid'] = $reply->getId();
  235. $comment = $paste->getComment($reply->getId());
  236. $comment->setData($commentData);
  237. $this->expectException(Exception::class);
  238. $this->expectExceptionCode(69);
  239. $comment->store();
  240. }
  241. public function testCommentNonexistentParent()
  242. {
  243. $pasteData = Helper::getPastePost();
  244. $commentData = Helper::getCommentPost();
  245. $commentData['parentid'] = '1111111111111111';
  246. $this->_model->getPaste(Helper::getPasteId())->delete();
  247. $paste = $this->_model->getPaste();
  248. $paste->setData($pasteData);
  249. $paste->store();
  250. $comment = $paste->getComment('1111111111111111');
  251. $comment->setData($commentData);
  252. $this->expectException(Exception::class);
  253. $this->expectExceptionCode(71);
  254. $comment->store();
  255. }
  256. public function testCommentEqualsPaste()
  257. {
  258. $pasteData = Helper::getPastePost();
  259. $commentData = Helper::getCommentPost();
  260. $commentData['ct'] = $pasteData['ct'];
  261. $this->_model->getPaste(Helper::getPasteId())->delete();
  262. $paste = $this->_model->getPaste();
  263. $paste->setData($pasteData);
  264. $paste->store();
  265. $comment = $paste->getComment(Helper::getPasteId());
  266. $comment->setData($commentData);
  267. $this->expectException(Exception::class);
  268. $this->expectExceptionCode(72);
  269. $comment->store();
  270. }
  271. public function testImplicitDefaults()
  272. {
  273. $pasteData = Helper::getPastePost();
  274. $commentData = Helper::getCommentPost();
  275. $this->_model->getPaste(Helper::getPasteId())->delete();
  276. $paste = $this->_model->getPaste();
  277. $paste->setData($pasteData);
  278. $paste->store();
  279. $comment = $paste->getComment(Helper::getPasteId());
  280. $comment->setData($commentData);
  281. $comment->get();
  282. $comment->store();
  283. $identicon = new Identicon([
  284. 'hash' => TrafficLimiter::getHash(),
  285. 'size' => 16,
  286. 'style' => [
  287. 'backgroundColor' => '#fff0', // fully transparent, for dark mode
  288. 'padding' => 0,
  289. ],
  290. ]);
  291. $pngdata = $identicon->getImageDataUri('png');
  292. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  293. $this->assertEquals($pngdata, $comment['meta']['icon'], 'icon gets set');
  294. }
  295. public function testPasteIdValidation()
  296. {
  297. $this->assertTrue(Paste::isValidId('a242ab7bdfb2581a'), 'valid paste id');
  298. $this->assertFalse(Paste::isValidId('foo'), 'invalid hex values & length');
  299. $this->assertFalse(Paste::isValidId('f00'), 'invalid length');
  300. $this->assertFalse(Paste::isValidId('foo bar baz quux'), 'invalid hex values');
  301. $this->assertFalse(Paste::isValidId("\n01234567feedcafe"), 'invalid line breaks');
  302. $this->assertFalse(Paste::isValidId("deadbeef01234567\n"), 'invalid line breaks');
  303. $this->assertFalse(Paste::isValidId('../bar/baz'), 'path attack');
  304. }
  305. public function testInvalidPaste()
  306. {
  307. $this->_model->getPaste(Helper::getPasteId())->delete();
  308. $paste = $this->_model->getPaste(Helper::getPasteId());
  309. $this->expectException(Exception::class);
  310. $this->expectExceptionCode(64);
  311. $paste->get();
  312. }
  313. public function testInvalidPasteFormat()
  314. {
  315. $pasteData = Helper::getPastePost();
  316. $pasteData['adata'][1] = 'format does not exist';
  317. $paste = $this->_model->getPaste();
  318. $this->expectException(Exception::class);
  319. $this->expectExceptionCode(75);
  320. $paste->setData($pasteData);
  321. }
  322. public function testInvalidPasteId()
  323. {
  324. $this->expectException(Exception::class);
  325. $this->expectExceptionCode(60);
  326. $this->_model->getPaste('');
  327. }
  328. public function testInvalidComment()
  329. {
  330. $paste = $this->_model->getPaste();
  331. $this->expectException(Exception::class);
  332. $this->expectExceptionCode(62);
  333. $paste->getComment(Helper::getPasteId());
  334. }
  335. public function testInvalidCommentDeletedPaste()
  336. {
  337. $pasteData = Helper::getPastePost();
  338. $paste = $this->_model->getPaste(Helper::getPasteId());
  339. $paste->setData($pasteData);
  340. $paste->store();
  341. $comment = $paste->getComment(Helper::getPasteId());
  342. $paste->delete();
  343. $this->expectException(Exception::class);
  344. $this->expectExceptionCode(67);
  345. $comment->store();
  346. }
  347. public function testInvalidCommentData()
  348. {
  349. $pasteData = Helper::getPastePost();
  350. $pasteData['adata'][2] = 0;
  351. $paste = $this->_model->getPaste(Helper::getPasteId());
  352. $paste->setData($pasteData);
  353. $paste->store();
  354. $comment = $paste->getComment(Helper::getPasteId());
  355. $this->expectException(Exception::class);
  356. $this->expectExceptionCode(68);
  357. $comment->store();
  358. }
  359. public function testInvalidCommentParent()
  360. {
  361. $paste = $this->_model->getPaste(Helper::getPasteId());
  362. $this->expectException(Exception::class);
  363. $this->expectExceptionCode(65);
  364. $paste->getComment('');
  365. }
  366. public function testExpiration()
  367. {
  368. $pasteData = Helper::getPastePost();
  369. $this->_model->getPaste(Helper::getPasteId())->delete();
  370. $paste = $this->_model->getPaste(Helper::getPasteId());
  371. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  372. $paste = $this->_model->getPaste();
  373. $paste->setData($pasteData);
  374. $paste->store();
  375. $paste = $paste->get();
  376. $this->assertEquals((float) 300, (float) $paste['meta']['time_to_live'], 'remaining time is set correctly', 1.0);
  377. }
  378. public function testPurge()
  379. {
  380. $conf = new Configuration;
  381. $store = new Database($conf->getSection('model_options'));
  382. $store->delete(Helper::getPasteId());
  383. $expired = Helper::getPaste(['expire_date' => 1344803344]);
  384. $paste = Helper::getPaste(['expire_date' => time() + 3600]);
  385. $keys = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'x', 'y', 'z'];
  386. $ids = [];
  387. foreach ($keys as $key) {
  388. $ids[$key] = hash('fnv164', $key);
  389. $store->delete($ids[$key]);
  390. $this->assertFalse($store->exists($ids[$key]), "paste $key does not yet exist");
  391. if (in_array($key, ['x', 'y', 'z'])) {
  392. $this->assertTrue($store->create($ids[$key], $paste), "store $key paste");
  393. } else {
  394. $this->assertTrue($store->create($ids[$key], $expired), "store $key paste");
  395. }
  396. $this->assertTrue($store->exists($ids[$key]), "paste $key exists after storing it");
  397. }
  398. $this->_model->purge(10);
  399. foreach ($ids as $key => $id) {
  400. if (in_array($key, ['x', 'y', 'z'])) {
  401. $this->assertTrue($this->_model->getPaste($id)->exists(), "paste $key exists after purge");
  402. $this->_model->getPaste($id)->delete();
  403. } else {
  404. $this->assertFalse($this->_model->getPaste($id)->exists(), "paste $key was purged");
  405. }
  406. }
  407. }
  408. public function testCommentWithDisabledVizhash()
  409. {
  410. $options = parse_ini_file(CONF, true);
  411. $options['main']['discussiondatedisplay'] = 'false';
  412. $options['main']['icon'] = 'none';
  413. $options['model'] = [
  414. 'class' => 'Database',
  415. ];
  416. $options['model_options'] = [
  417. 'dsn' => 'sqlite::memory:',
  418. 'usr' => null,
  419. 'pwd' => null,
  420. 'opt' => [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION],
  421. ];
  422. Helper::createIniFile(CONF, $options);
  423. $model = new Model(new Configuration);
  424. $pasteData = Helper::getPastePost();
  425. $this->_model->getPaste(Helper::getPasteId())->delete();
  426. $paste = $model->getPaste(Helper::getPasteId());
  427. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  428. $paste = $model->getPaste();
  429. $paste->setData($pasteData);
  430. $paste->store();
  431. $paste = $model->getPaste(Helper::getPasteId());
  432. $this->assertTrue($paste->exists(), 'paste exists after storing it');
  433. // storing comments
  434. $commentData = Helper::getCommentPost();
  435. unset($commentData['meta']['icon']);
  436. $paste = $model->getPaste(Helper::getPasteId());
  437. $comment = $paste->getComment(Helper::getPasteId(), Helper::getCommentId());
  438. $this->assertFalse($comment->exists(), 'comment does not yet exist');
  439. $comment = $paste->getComment(Helper::getPasteId());
  440. $comment->setData($commentData);
  441. $comment->store();
  442. $comment = $paste->getComment(Helper::getPasteId(), Helper::getCommentId());
  443. $this->assertTrue($comment->exists(), 'comment exists after storing it');
  444. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  445. $this->assertFalse(array_key_exists('icon', $comment['meta']), 'icon was not generated');
  446. $this->assertTrue(array_key_exists('created', $comment['meta']), 'creation is set, when using default configuration');
  447. $comment = current($paste->get()['comments']);
  448. $this->assertFalse(array_key_exists('created', $comment['meta']), 'creation is not set, if using disabled configuration');
  449. }
  450. public function testCommentVizhash()
  451. {
  452. $options = parse_ini_file(CONF, true);
  453. $options['main']['icon'] = 'vizhash';
  454. $options['model'] = [
  455. 'class' => 'Database',
  456. ];
  457. $options['model_options'] = [
  458. 'dsn' => 'sqlite::memory:',
  459. 'usr' => null,
  460. 'pwd' => null,
  461. 'opt' => [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION],
  462. ];
  463. Helper::createIniFile(CONF, $options);
  464. $model = new Model(new Configuration);
  465. $pasteData = Helper::getPastePost();
  466. $commentData = Helper::getCommentPost();
  467. $model->getPaste(Helper::getPasteId())->delete();
  468. $paste = $model->getPaste();
  469. $paste->setData($pasteData);
  470. $paste->store();
  471. $comment = $paste->getComment(Helper::getPasteId());
  472. $comment->setData($commentData);
  473. $comment->store();
  474. $vz = new Vizhash16x16();
  475. $pngdata = 'data:image/png;base64,' . base64_encode($vz->generate(TrafficLimiter::getHash()));
  476. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  477. $this->assertEquals($pngdata, $comment['meta']['icon'], 'vizhash was generated');
  478. }
  479. }