ModelTest.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484
  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::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([], $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 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. 'hash' => TrafficLimiter::getHash(),
  227. 'size' => 16,
  228. 'style' => [
  229. 'backgroundColor' => '#fff0', // fully transparent, for dark mode
  230. 'padding' => 0,
  231. ],
  232. ]);
  233. $pngdata = $identicon->getImageDataUri('png');
  234. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  235. $this->assertEquals($pngdata, $comment['meta']['icon'], 'icon gets set');
  236. }
  237. public function testPasteIdValidation()
  238. {
  239. $this->assertTrue(Paste::isValidId('a242ab7bdfb2581a'), 'valid paste id');
  240. $this->assertFalse(Paste::isValidId('foo'), 'invalid hex values & length');
  241. $this->assertFalse(Paste::isValidId('f00'), 'invalid length');
  242. $this->assertFalse(Paste::isValidId('foo bar baz quux'), 'invalid hex values');
  243. $this->assertFalse(Paste::isValidId("\n01234567feedcafe"), 'invalid line breaks');
  244. $this->assertFalse(Paste::isValidId("deadbeef01234567\n"), 'invalid line breaks');
  245. $this->assertFalse(Paste::isValidId('../bar/baz'), 'path attack');
  246. }
  247. public function testInvalidPaste()
  248. {
  249. $this->_model->getPaste(Helper::getPasteId())->delete();
  250. $paste = $this->_model->getPaste(Helper::getPasteId());
  251. $this->expectException(Exception::class);
  252. $this->expectExceptionCode(64);
  253. $paste->get();
  254. }
  255. public function testInvalidPasteFormat()
  256. {
  257. $pasteData = Helper::getPastePost();
  258. $pasteData['adata'][1] = 'format does not exist';
  259. $paste = $this->_model->getPaste();
  260. $this->expectException(Exception::class);
  261. $this->expectExceptionCode(75);
  262. $paste->setData($pasteData);
  263. }
  264. public function testInvalidPasteId()
  265. {
  266. $this->expectException(Exception::class);
  267. $this->expectExceptionCode(60);
  268. $this->_model->getPaste('');
  269. }
  270. public function testInvalidComment()
  271. {
  272. $paste = $this->_model->getPaste();
  273. $this->expectException(Exception::class);
  274. $this->expectExceptionCode(62);
  275. $paste->getComment(Helper::getPasteId());
  276. }
  277. public function testInvalidCommentDeletedPaste()
  278. {
  279. $pasteData = Helper::getPastePost();
  280. $paste = $this->_model->getPaste(Helper::getPasteId());
  281. $paste->setData($pasteData);
  282. $paste->store();
  283. $comment = $paste->getComment(Helper::getPasteId());
  284. $paste->delete();
  285. $this->expectException(Exception::class);
  286. $this->expectExceptionCode(67);
  287. $comment->store();
  288. }
  289. public function testInvalidCommentData()
  290. {
  291. $pasteData = Helper::getPastePost();
  292. $pasteData['adata'][2] = 0;
  293. $paste = $this->_model->getPaste(Helper::getPasteId());
  294. $paste->setData($pasteData);
  295. $paste->store();
  296. $comment = $paste->getComment(Helper::getPasteId());
  297. $this->expectException(Exception::class);
  298. $this->expectExceptionCode(68);
  299. $comment->store();
  300. }
  301. public function testInvalidCommentParent()
  302. {
  303. $paste = $this->_model->getPaste(Helper::getPasteId());
  304. $this->expectException(Exception::class);
  305. $this->expectExceptionCode(65);
  306. $paste->getComment('');
  307. }
  308. public function testExpiration()
  309. {
  310. $pasteData = Helper::getPastePost();
  311. $this->_model->getPaste(Helper::getPasteId())->delete();
  312. $paste = $this->_model->getPaste(Helper::getPasteId());
  313. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  314. $paste = $this->_model->getPaste();
  315. $paste->setData($pasteData);
  316. $paste->store();
  317. $paste = $paste->get();
  318. $this->assertEquals((float) 300, (float) $paste['meta']['time_to_live'], 'remaining time is set correctly', 1.0);
  319. }
  320. public function testPurge()
  321. {
  322. $conf = new Configuration;
  323. $store = new Database($conf->getSection('model_options'));
  324. $store->delete(Helper::getPasteId());
  325. $expired = Helper::getPaste(['expire_date' => 1344803344]);
  326. $paste = Helper::getPaste(['expire_date' => time() + 3600]);
  327. $keys = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'x', 'y', 'z'];
  328. $ids = [];
  329. foreach ($keys as $key) {
  330. $ids[$key] = hash('fnv164', $key);
  331. $store->delete($ids[$key]);
  332. $this->assertFalse($store->exists($ids[$key]), "paste $key does not yet exist");
  333. if (in_array($key, ['x', 'y', 'z'])) {
  334. $this->assertTrue($store->create($ids[$key], $paste), "store $key paste");
  335. } else {
  336. $this->assertTrue($store->create($ids[$key], $expired), "store $key paste");
  337. }
  338. $this->assertTrue($store->exists($ids[$key]), "paste $key exists after storing it");
  339. }
  340. $this->_model->purge(10);
  341. foreach ($ids as $key => $id) {
  342. if (in_array($key, ['x', 'y', 'z'])) {
  343. $this->assertTrue($this->_model->getPaste($id)->exists(), "paste $key exists after purge");
  344. $this->_model->getPaste($id)->delete();
  345. } else {
  346. $this->assertFalse($this->_model->getPaste($id)->exists(), "paste $key was purged");
  347. }
  348. }
  349. }
  350. public function testCommentWithDisabledVizhash()
  351. {
  352. $options = parse_ini_file(CONF, true);
  353. $options['main']['discussiondatedisplay'] = 'false';
  354. $options['main']['icon'] = 'none';
  355. $options['model'] = [
  356. 'class' => 'Database',
  357. ];
  358. $options['model_options'] = [
  359. 'dsn' => 'sqlite::memory:',
  360. 'usr' => null,
  361. 'pwd' => null,
  362. 'opt' => [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION],
  363. ];
  364. Helper::createIniFile(CONF, $options);
  365. $model = new Model(new Configuration);
  366. $pasteData = Helper::getPastePost();
  367. $this->_model->getPaste(Helper::getPasteId())->delete();
  368. $paste = $model->getPaste(Helper::getPasteId());
  369. $this->assertFalse($paste->exists(), 'paste does not yet exist');
  370. $paste = $model->getPaste();
  371. $paste->setData($pasteData);
  372. $paste->store();
  373. $paste = $model->getPaste(Helper::getPasteId());
  374. $this->assertTrue($paste->exists(), 'paste exists after storing it');
  375. // storing comments
  376. $commentData = Helper::getCommentPost();
  377. unset($commentData['meta']['icon']);
  378. $paste = $model->getPaste(Helper::getPasteId());
  379. $comment = $paste->getComment(Helper::getPasteId(), Helper::getPasteId());
  380. $this->assertFalse($comment->exists(), 'comment does not yet exist');
  381. $comment = $paste->getComment(Helper::getPasteId());
  382. $comment->setData($commentData);
  383. $comment->store();
  384. $comment = $paste->getComment(Helper::getPasteId(), Helper::getPasteId());
  385. $this->assertTrue($comment->exists(), 'comment exists after storing it');
  386. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  387. $this->assertFalse(array_key_exists('icon', $comment['meta']), 'icon was not generated');
  388. $this->assertTrue(array_key_exists('created', $comment['meta']), 'creation is set, when using default configuration');
  389. $comment = current($paste->get()['comments']);
  390. $this->assertFalse(array_key_exists('created', $comment['meta']), 'creation is not set, if using disabled configuration');
  391. }
  392. public function testCommentVizhash()
  393. {
  394. $options = parse_ini_file(CONF, true);
  395. $options['main']['icon'] = 'vizhash';
  396. $options['model'] = [
  397. 'class' => 'Database',
  398. ];
  399. $options['model_options'] = [
  400. 'dsn' => 'sqlite::memory:',
  401. 'usr' => null,
  402. 'pwd' => null,
  403. 'opt' => [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION],
  404. ];
  405. Helper::createIniFile(CONF, $options);
  406. $model = new Model(new Configuration);
  407. $pasteData = Helper::getPastePost();
  408. $commentData = Helper::getCommentPost();
  409. $model->getPaste(Helper::getPasteId())->delete();
  410. $paste = $model->getPaste();
  411. $paste->setData($pasteData);
  412. $paste->store();
  413. $comment = $paste->getComment(Helper::getPasteId());
  414. $comment->setData($commentData);
  415. $comment->store();
  416. $vz = new Vizhash16x16();
  417. $pngdata = 'data:image/png;base64,' . base64_encode($vz->generate(TrafficLimiter::getHash()));
  418. $comment = current($this->_model->getPaste(Helper::getPasteId())->get()['comments']);
  419. $this->assertEquals($pngdata, $comment['meta']['icon'], 'vizhash was generated');
  420. }
  421. }