{"action":"created","comment":{"url":"https://api.github.com/repos/phpbb/phpbb/pulls/comments/39479980","id":39479980,"diff_hunk":"@@ -0,0 +1,69 @@\n+<?php\n+/**\n+*\n+* This file is part of the phpBB Forum Software package.\n+*\n+* @copyright (c) phpBB Limited <https://www.phpbb.com>\n+* @license GNU General Public License, version 2 (GPL-2.0)\n+*\n+* For full copyright and license information, please see\n+* the docs/CREDITS.txt file.\n+*\n+*/\n+namespace phpbb\\console\\command\\db;\n+\n+use Symfony\\Component\\Console\\Input\\InputInterface;\n+use Symfony\\Component\\Console\\Input\\InputOption;\n+use Symfony\\Component\\Console\\Output\\OutputInterface;\n+\n+class list_command extends \\phpbb\\console\\command\\db\\migration_command\n+{\n+\tprotected function configure()\n+\t{\n+\t\t$this\n+\t\t\t->setName('db:list')\n+\t\t\t->setDescription($this->user->lang('CLI_DESCRIPTION_DB_LIST'))\n+\t\t\t->addOption(\n+\t\t\t\t'uninstalled',\n+\t\t\t\t'u',\n+\t\t\t\tInputOption::VALUE_NONE,\n+\t\t\t\t$this->user->lang('CLI_MIGRATION_ONLY_UNINSTALLED')\n+\t\t\t)\n+\t\t;\n+\t}\n+\n+\tprotected function execute(InputInterface $input, OutputInterface $output)\n+\t{\n+\t\t$show_installed = !$input->getOption('uninstalled');\n+\t\t$installed = $uninstalled = array();\n+\n+\t\tforeach ($this->load_migrations() as $name)\n+\t\t{\n+\t\t\tif ($this->migrator->migration_state($name) !== false)\n+\t\t\t{\n+\t\t\t\t$installed[] = $name;\n+\t\t\t}\n+\t\t\telse\n+\t\t\t{\n+\t\t\t\t$uninstalled[] = $name;\n+\t\t\t}\n+\t\t}\n+\n+\t\tif (!empty($installed) && $show_installed)\n+\t\t{\n+\t\t\t$output->writeln('<info>' . $this->user->lang('CLI_MIGRATION_INSTALLED') . $this->user->lang('COLON') . '</info>');\n+\t\t\t$output->writeln($installed);\n+\t\t}\n+\n+\t\tif (!empty($installed) && $show_installed && !empty($uninstalled))\n+\t\t{\n+\t\t\t$output->writeln('');\n+\t\t}\n+\n+\t\tif (!empty($uninstalled))\n+\t\t{\n+\t\t\t$output->writeln('<info>' . $this->user->lang('CLI_MIGRATION_UNINSTALLED') . $this->user->lang('COLON') . '</info>');","path":"phpBB/phpbb/console/command/db/list_command.php","position":65,"original_position":65,"commit_id":"7debc290a8d59d9c0c7a8fa7636bca178f4fd36a","original_commit_id":"7debc290a8d59d9c0c7a8fa7636bca178f4fd36a","user":{"login":"Nicofuma","id":591456,"avatar_url":"https://avatars.githubusercontent.com/u/591456?v=3","gravatar_id":"","url":"https://api.github.com/users/Nicofuma","html_url":"https://github.com/Nicofuma","followers_url":"https://api.github.com/users/Nicofuma/followers","following_url":"https://api.github.com/users/Nicofuma/following{/other_user}","gists_url":"https://api.github.com/users/Nicofuma/gists{/gist_id}","starred_url":"https://api.github.com/users/Nicofuma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nicofuma/subscriptions","organizations_url":"https://api.github.com/users/Nicofuma/orgs","repos_url":"https://api.github.com/users/Nicofuma/repos","events_url":"https://api.github.com/users/Nicofuma/events{/privacy}","received_events_url":"https://api.github.com/users/Nicofuma/received_events","type":"User","site_admin":false},"body":"I don't think uninstall is a good name here: thes migrations can be both uninstalled and not installed. I'd prefer the more generic `not installed`or `available` here","created_at":"2015-09-15T07:05:58Z","updated_at":"2015-09-15T07:05:58Z","html_url":"https://github.com/phpbb/phpbb/pull/3904#discussion_r39479980","pull_request_url":"https://api.github.com/repos/phpbb/phpbb/pulls/3904","_links":{"self":{"href":"https://api.github.com/repos/phpbb/phpbb/pulls/comments/39479980"},"html":{"href":"https://github.com/phpbb/phpbb/pull/3904#discussion_r39479980"},"pull_request":{"href":"https://api.github.com/repos/phpbb/phpbb/pulls/3904"}}},"pull_request":{"url":"https://api.github.com/repos/phpbb/phpbb/pulls/3904","id":44875281,"html_url":"https://github.com/phpbb/phpbb/pull/3904","diff_url":"https://github.com/phpbb/phpbb/pull/3904.diff","patch_url":"https://github.com/phpbb/phpbb/pull/3904.patch","issue_url":"https://api.github.com/repos/phpbb/phpbb/issues/3904","number":3904,"state":"open","locked":false,"title":"[ticket/14162] Add CLI commands to manage migrations","user":{"login":"Zoddo","id":5215545,"avatar_url":"https://avatars.githubusercontent.com/u/5215545?v=3","gravatar_id":"","url":"https://api.github.com/users/Zoddo","html_url":"https://github.com/Zoddo","followers_url":"https://api.github.com/users/Zoddo/followers","following_url":"https://api.github.com/users/Zoddo/following{/other_user}","gists_url":"https://api.github.com/users/Zoddo/gists{/gist_id}","starred_url":"https://api.github.com/users/Zoddo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Zoddo/subscriptions","organizations_url":"https://api.github.com/users/Zoddo/orgs","repos_url":"https://api.github.com/users/Zoddo/repos","events_url":"https://api.github.com/users/Zoddo/events{/privacy}","received_events_url":"https://api.github.com/users/Zoddo/received_events","type":"User","site_admin":false},"body":"| Command | Description |\r\n| ------------- | -------------- |\r\n| db:list | List all installed and not installed migrations. |\r\n| db:revert | Revert a migration. |\r\n\r\nNote: For `db:list`, the class is named `list_command`, because `list` is a reserved word and can't be used as class name in PHP.\r\n\r\n[PHPBB3-14162](https://tracker.phpbb.com/browse/PHPBB3-14162)","created_at":"2015-09-13T16:02:13Z","updated_at":"2015-09-15T07:05:58Z","closed_at":null,"merged_at":null,"merge_commit_sha":"3e158022e75419e2a28af1ab1e74ca38528d42b1","assignee":null,"milestone":{"url":"https://api.github.com/repos/phpbb/phpbb/milestones/2","html_url":"https://github.com/phpbb/phpbb/milestones/3.2.0-a1","labels_url":"https://api.github.com/repos/phpbb/phpbb/milestones/2/labels","id":835770,"number":2,"title":"3.2.0-a1","description":"/!\\ Feature freeze for the 3.2 release","creator":{"login":"nickvergessen","id":213943,"avatar_url":"https://avatars.githubusercontent.com/u/213943?v=3","gravatar_id":"","url":"https://api.github.com/users/nickvergessen","html_url":"https://github.com/nickvergessen","followers_url":"https://api.github.com/users/nickvergessen/followers","following_url":"https://api.github.com/users/nickvergessen/following{/other_user}","gists_url":"https://api.github.com/users/nickvergessen/gists{/gist_id}","starred_url":"https://api.github.com/users/nickvergessen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nickvergessen/subscriptions","organizations_url":"https://api.github.com/users/nickvergessen/orgs","repos_url":"https://api.github.com/users/nickvergessen/repos","events_url":"https://api.github.com/users/nickvergessen/events{/privacy}","received_events_url":"https://api.github.com/users/nickvergessen/received_events","type":"User","site_admin":false},"open_issues":36,"closed_issues":173,"state":"open","created_at":"2014-10-22T10:41:02Z","updated_at":"2015-09-15T06:59:26Z","due_on":"2015-09-19T22:00:00Z","closed_at":null},"commits_url":"https://api.github.com/repos/phpbb/phpbb/pulls/3904/commits","review_comments_url":"https://api.github.com/repos/phpbb/phpbb/pulls/3904/comments","review_comment_url":"https://api.github.com/repos/phpbb/phpbb/pulls/comments{/number}","comments_url":"https://api.github.com/repos/phpbb/phpbb/issues/3904/comments","statuses_url":"https://api.github.com/repos/phpbb/phpbb/statuses/7debc290a8d59d9c0c7a8fa7636bca178f4fd36a","head":{"label":"Zoddo:ticket/14162","ref":"ticket/14162","sha":"7debc290a8d59d9c0c7a8fa7636bca178f4fd36a","user":{"login":"Zoddo","id":5215545,"avatar_url":"https://avatars.githubusercontent.com/u/5215545?v=3","gravatar_id":"","url":"https://api.github.com/users/Zoddo","html_url":"https://github.com/Zoddo","followers_url":"https://api.github.com/users/Zoddo/followers","following_url":"https://api.github.com/users/Zoddo/following{/other_user}","gists_url":"https://api.github.com/users/Zoddo/gists{/gist_id}","starred_url":"https://api.github.com/users/Zoddo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Zoddo/subscriptions","organizations_url":"https://api.github.com/users/Zoddo/orgs","repos_url":"https://api.github.com/users/Zoddo/repos","events_url":"https://api.github.com/users/Zoddo/events{/privacy}","received_events_url":"https://api.github.com/users/Zoddo/received_events","type":"User","site_admin":false},"repo":{"id":16558781,"name":"phpbb","full_name":"Zoddo/phpbb","owner":{"login":"Zoddo","id":5215545,"avatar_url":"https://avatars.githubusercontent.com/u/5215545?v=3","gravatar_id":"","url":"https://api.github.com/users/Zoddo","html_url":"https://github.com/Zoddo","followers_url":"https://api.github.com/users/Zoddo/followers","following_url":"https://api.github.com/users/Zoddo/following{/other_user}","gists_url":"https://api.github.com/users/Zoddo/gists{/gist_id}","starred_url":"https://api.github.com/users/Zoddo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Zoddo/subscriptions","organizations_url":"https://api.github.com/users/Zoddo/orgs","repos_url":"https://api.github.com/users/Zoddo/repos","events_url":"https://api.github.com/users/Zoddo/events{/privacy}","received_events_url":"https://api.github.com/users/Zoddo/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/Zoddo/phpbb","description":" phpBB 3 Development: phpBB is a popular open-source bulletin board written in PHP. This repository also contains the history of version 2.","fork":true,"url":"https://api.github.com/repos/Zoddo/phpbb","forks_url":"https://api.github.com/repos/Zoddo/phpbb/forks","keys_url":"https://api.github.com/repos/Zoddo/phpbb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Zoddo/phpbb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Zoddo/phpbb/teams","hooks_url":"https://api.github.com/repos/Zoddo/phpbb/hooks","issue_events_url":"https://api.github.com/repos/Zoddo/phpbb/issues/events{/number}","events_url":"https://api.github.com/repos/Zoddo/phpbb/events","assignees_url":"https://api.github.com/repos/Zoddo/phpbb/assignees{/user}","branches_url":"https://api.github.com/repos/Zoddo/phpbb/branches{/branch}","tags_url":"https://api.github.com/repos/Zoddo/phpbb/tags","blobs_url":"https://api.github.com/repos/Zoddo/phpbb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Zoddo/phpbb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Zoddo/phpbb/git/refs{/sha}","trees_url":"https://api.github.com/repos/Zoddo/phpbb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Zoddo/phpbb/statuses/{sha}","languages_url":"https://api.github.com/repos/Zoddo/phpbb/languages","stargazers_url":"https://api.github.com/repos/Zoddo/phpbb/stargazers","contributors_url":"https://api.github.com/repos/Zoddo/phpbb/contributors","subscribers_url":"https://api.github.com/repos/Zoddo/phpbb/subscribers","subscription_url":"https://api.github.com/repos/Zoddo/phpbb/subscription","commits_url":"https://api.github.com/repos/Zoddo/phpbb/commits{/sha}","git_commits_url":"https://api.github.com/repos/Zoddo/phpbb/git/commits{/sha}","comments_url":"https://api.github.com/repos/Zoddo/phpbb/comments{/number}","issue_comment_url":"https://api.github.com/repos/Zoddo/phpbb/issues/comments{/number}","contents_url":"https://api.github.com/repos/Zoddo/phpbb/contents/{+path}","compare_url":"https://api.github.com/repos/Zoddo/phpbb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Zoddo/phpbb/merges","archive_url":"https://api.github.com/repos/Zoddo/phpbb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Zoddo/phpbb/downloads","issues_url":"https://api.github.com/repos/Zoddo/phpbb/issues{/number}","pulls_url":"https://api.github.com/repos/Zoddo/phpbb/pulls{/number}","milestones_url":"https://api.github.com/repos/Zoddo/phpbb/milestones{/number}","notifications_url":"https://api.github.com/repos/Zoddo/phpbb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Zoddo/phpbb/labels{/name}","releases_url":"https://api.github.com/repos/Zoddo/phpbb/releases{/id}","created_at":"2014-02-05T21:21:01Z","updated_at":"2014-05-24T12:33:34Z","pushed_at":"2015-09-13T20:27:03Z","git_url":"git://github.com/Zoddo/phpbb.git","ssh_url":"git@github.com:Zoddo/phpbb.git","clone_url":"https://github.com/Zoddo/phpbb.git","svn_url":"https://github.com/Zoddo/phpbb","homepage":"http://www.phpbb.com","size":57369,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":0,"forks":1,"open_issues":0,"watchers":0,"default_branch":"develop"}},"base":{"label":"phpbb:master","ref":"master","sha":"797e70380b2ec058b657419f099fa529713c4ab2","user":{"login":"phpbb","id":176697,"avatar_url":"https://avatars.githubusercontent.com/u/176697?v=3","gravatar_id":"","url":"https://api.github.com/users/phpbb","html_url":"https://github.com/phpbb","followers_url":"https://api.github.com/users/phpbb/followers","following_url":"https://api.github.com/users/phpbb/following{/other_user}","gists_url":"https://api.github.com/users/phpbb/gists{/gist_id}","starred_url":"https://api.github.com/users/phpbb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpbb/subscriptions","organizations_url":"https://api.github.com/users/phpbb/orgs","repos_url":"https://api.github.com/users/phpbb/repos","events_url":"https://api.github.com/users/phpbb/events{/privacy}","received_events_url":"https://api.github.com/users/phpbb/received_events","type":"Organization","site_admin":false},"repo":{"id":541983,"name":"phpbb","full_name":"phpbb/phpbb","owner":{"login":"phpbb","id":176697,"avatar_url":"https://avatars.githubusercontent.com/u/176697?v=3","gravatar_id":"","url":"https://api.github.com/users/phpbb","html_url":"https://github.com/phpbb","followers_url":"https://api.github.com/users/phpbb/followers","following_url":"https://api.github.com/users/phpbb/following{/other_user}","gists_url":"https://api.github.com/users/phpbb/gists{/gist_id}","starred_url":"https://api.github.com/users/phpbb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpbb/subscriptions","organizations_url":"https://api.github.com/users/phpbb/orgs","repos_url":"https://api.github.com/users/phpbb/repos","events_url":"https://api.github.com/users/phpbb/events{/privacy}","received_events_url":"https://api.github.com/users/phpbb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/phpbb/phpbb","description":" phpBB 3 Development: phpBB is a popular open-source bulletin board written in PHP. This repository also contains the history of version 2.","fork":false,"url":"https://api.github.com/repos/phpbb/phpbb","forks_url":"https://api.github.com/repos/phpbb/phpbb/forks","keys_url":"https://api.github.com/repos/phpbb/phpbb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/phpbb/phpbb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/phpbb/phpbb/teams","hooks_url":"https://api.github.com/repos/phpbb/phpbb/hooks","issue_events_url":"https://api.github.com/repos/phpbb/phpbb/issues/events{/number}","events_url":"https://api.github.com/repos/phpbb/phpbb/events","assignees_url":"https://api.github.com/repos/phpbb/phpbb/assignees{/user}","branches_url":"https://api.github.com/repos/phpbb/phpbb/branches{/branch}","tags_url":"https://api.github.com/repos/phpbb/phpbb/tags","blobs_url":"https://api.github.com/repos/phpbb/phpbb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/phpbb/phpbb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/phpbb/phpbb/git/refs{/sha}","trees_url":"https://api.github.com/repos/phpbb/phpbb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/phpbb/phpbb/statuses/{sha}","languages_url":"https://api.github.com/repos/phpbb/phpbb/languages","stargazers_url":"https://api.github.com/repos/phpbb/phpbb/stargazers","contributors_url":"https://api.github.com/repos/phpbb/phpbb/contributors","subscribers_url":"https://api.github.com/repos/phpbb/phpbb/subscribers","subscription_url":"https://api.github.com/repos/phpbb/phpbb/subscription","commits_url":"https://api.github.com/repos/phpbb/phpbb/commits{/sha}","git_commits_url":"https://api.github.com/repos/phpbb/phpbb/git/commits{/sha}","comments_url":"https://api.github.com/repos/phpbb/phpbb/comments{/number}","issue_comment_url":"https://api.github.com/repos/phpbb/phpbb/issues/comments{/number}","contents_url":"https://api.github.com/repos/phpbb/phpbb/contents/{+path}","compare_url":"https://api.github.com/repos/phpbb/phpbb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/phpbb/phpbb/merges","archive_url":"https://api.github.com/repos/phpbb/phpbb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/phpbb/phpbb/downloads","issues_url":"https://api.github.com/repos/phpbb/phpbb/issues{/number}","pulls_url":"https://api.github.com/repos/phpbb/phpbb/pulls{/number}","milestones_url":"https://api.github.com/repos/phpbb/phpbb/milestones{/number}","notifications_url":"https://api.github.com/repos/phpbb/phpbb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/phpbb/phpbb/labels{/name}","releases_url":"https://api.github.com/repos/phpbb/phpbb/releases{/id}","created_at":"2010-03-01T22:33:17Z","updated_at":"2015-09-13T23:21:34Z","pushed_at":"2015-09-15T03:36:42Z","git_url":"git://github.com/phpbb/phpbb.git","ssh_url":"git@github.com:phpbb/phpbb.git","clone_url":"https://github.com/phpbb/phpbb.git","svn_url":"https://github.com/phpbb/phpbb","homepage":"http://www.phpbb.com","size":198292,"stargazers_count":770,"watchers_count":770,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":488,"mirror_url":null,"open_issues_count":90,"forks":488,"open_issues":90,"watchers":770,"default_branch":"3.1.x"}},"_links":{"self":{"href":"https://api.github.com/repos/phpbb/phpbb/pulls/3904"},"html":{"href":"https://github.com/phpbb/phpbb/pull/3904"},"issue":{"href":"https://api.github.com/repos/phpbb/phpbb/issues/3904"},"comments":{"href":"https://api.github.com/repos/phpbb/phpbb/issues/3904/comments"},"review_comments":{"href":"https://api.github.com/repos/phpbb/phpbb/pulls/3904/comments"},"review_comment":{"href":"https://api.github.com/repos/phpbb/phpbb/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/phpbb/phpbb/pulls/3904/commits"},"statuses":{"href":"https://api.github.com/repos/phpbb/phpbb/statuses/7debc290a8d59d9c0c7a8fa7636bca178f4fd36a"}}}}