Category:Phabricator

[[category:phabricator]

Database list

 * 2017-02-26 Sunday:

[07:26]  there are 63 databases on a phabricator install [07:26]  Here are the first 5: [07:26]  | information_schema              | [07:26]  | bitnami_phabricator             | [07:26]  | bitnami_phabricator_almanac     | [07:26]  | bitnami_phabricator_audit       | [07:26]  | bitnami_phabricator_auth        | [07:26]  | bitnami_phabricator_badges      | [07:26]  | bitnami_phabricator_cache       | [07:28] <+Reception123> We don't have all of them. For example almanac is disabled. [07:28] <+Reception123> https://github.com/miraheze/puppet/blob/9bcc77cd23916747fe756f59df984cfae2deefbd/modules/phabricator/data/config.yaml#L91 [07:30]  I'm just looking for the one with the list of tickets [07:30] <+revi> we prefer to do query via API [07:30] <+revi> rather than DB directly [07:30] <+revi> and tickets should be something with maniphest_* [07:31]  thanks! [07:31] <+revi> :) [07:32]  ok, on Mirahezee phabricator how many rows does select * from maniphest_task; return? [07:55]  can I get the output of that query? [07:55] <+Reception123> Neither me or revi have access to db*, so you'd have to ask John, SPF or NDK for the exact output [07:58] <+revi> if you are asking for the number of the tasks, just use API [07:58] <+revi> most of the thing doable from API is also doable via API and we prefer that way [08:07]  I'm looking to create a report [08:08]  Reporting is done by creating queries, then running the query in a report engine.

mysql> show databases; +--+ +--+ +--+ 63 rows in set (0.00 sec)
 * Database                        |
 * information_schema              |
 * bitnami_phabricator             |
 * bitnami_phabricator_almanac     |
 * bitnami_phabricator_audit       |
 * bitnami_phabricator_auth        |
 * bitnami_phabricator_badges      |
 * bitnami_phabricator_cache       |
 * bitnami_phabricator_calendar    |
 * bitnami_phabricator_chatlog     |
 * bitnami_phabricator_conduit     |
 * bitnami_phabricator_config      |
 * bitnami_phabricator_conpherence |
 * bitnami_phabricator_countdown   |
 * bitnami_phabricator_daemon      |
 * bitnami_phabricator_dashboard   |
 * bitnami_phabricator_differential |
 * bitnami_phabricator_diviner     |
 * bitnami_phabricator_doorkeeper  |
 * bitnami_phabricator_draft       |
 * bitnami_phabricator_drydock     |
 * bitnami_phabricator_fact        |
 * bitnami_phabricator_feed        |
 * bitnami_phabricator_file        |
 * bitnami_phabricator_flag        |
 * bitnami_phabricator_fund        |
 * bitnami_phabricator_harbormaster |
 * bitnami_phabricator_herald      |
 * bitnami_phabricator_legalpad    |
 * bitnami_phabricator_maniphest   |
 * bitnami_phabricator_meta_data   |
 * bitnami_phabricator_metamta     |
 * bitnami_phabricator_multimeter  |
 * bitnami_phabricator_nuance      |
 * bitnami_phabricator_oauth_server |
 * bitnami_phabricator_owners      |
 * bitnami_phabricator_packages    |
 * bitnami_phabricator_passphrase  |
 * bitnami_phabricator_pastebin    |
 * bitnami_phabricator_phame       |
 * bitnami_phabricator_phlux       |
 * bitnami_phabricator_pholio      |
 * bitnami_phabricator_phortune    |
 * bitnami_phabricator_phragment   |
 * bitnami_phabricator_phrequent   |
 * bitnami_phabricator_phriction   |
 * bitnami_phabricator_phurl       |
 * bitnami_phabricator_policy      |
 * bitnami_phabricator_ponder      |
 * bitnami_phabricator_project     |
 * bitnami_phabricator_releeph     |
 * bitnami_phabricator_repository  |
 * bitnami_phabricator_search      |
 * bitnami_phabricator_slowvote    |
 * bitnami_phabricator_spaces      |
 * bitnami_phabricator_system      |
 * bitnami_phabricator_token       |
 * bitnami_phabricator_user        |
 * bitnami_phabricator_worker      |
 * bitnami_phabricator_xhpast      |
 * bitnami_phabricator_xhprof      |
 * mysql                           |
 * performance_schema              |
 * test                            |