Baloo/Schema: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
m (Ppapadeas moved page Wormhole/Schema to Baloo/Schema: new project name)
No edit summary
Line 1: Line 1:
The Blackhole database contains two tables: the contributions, and the entrypoints.
The [[Baloo]] system requires a unified schema for contribution activity description


== Contributions ==
== Contributions ==
Line 86: Line 86:
<li><code>url</code>: canonical URL for the activity (string)</li></ul>
<li><code>url</code>: canonical URL for the activity (string)</li></ul>


<!--
== Entrypoints ==
== Entrypoints ==
Data representing first contact points for potential contributors. These may not actually be first contact, but the are places where first contact often occurs.
Data representing first contact points for potential contributors. These may not actually be first contact, but the are places where first contact often occurs.
Line 112: Line 114:
<li><code>category</code>: name of category (string)</li>
<li><code>category</code>: name of category (string)</li>
</ul>
</ul>
-->

Revision as of 10:05, 15 March 2014

The Baloo system requires a unified schema for contribution activity description

Contributions

All contribution data follows this schema:

  • guid: Globally Unique Identifier of the contribution (string)
  • email: email address of contributor (string)
  • datetime: date and time of contribution (datetime)
  • canonical: permanent URL to contribution (string)
  • volunteer: boolean value indicating paid employee status (boolean)
  • type: a codified string that describes the contribution (string)
  • source: source of contribution, one of the following: (string)
    • bugzilla
    • hg
    • sumo
  • extra: per-contribution data, following a source-dependent schema (dictionary)

extra - Bugzilla

  • fields: fields modified (list of string)
  • values: values of modified fields, where available. Keys correspond to names of modified fields. (dictionary)
  • id: bug id (integer)
  • product: product (string)
  • component: component (string)
  • new: new bug creation (boolean, optional)
  • firstpatch: first patch flag (boolean, optional [likely doesn't work])
  • comment: associated comment ID (integer, optional)
  • review: review flag was modified (set, cleared, changed, etc) (boolean, optional)
  • feedback: feedback flag was modified (set, cleared, changed, etc) (boolean, optional)
  • needinfo: needinfo flag was modified (set, cleared, changed, etc) (boolean, optional)

extra - hg

  • tree: tree name (eg. mozilla-central) (string)
  • sha: revision hash (string, doesn't exist yet)

extra - sumo

  • type: type of SUMO contribution, one of: (string)
    • answer
    • post
    • discuss
    • revision
  • locale: locale of contribution (string)

extra - sumo - answer

  • question: id of answered question (integer)
  • id: id of answer (integer)
  • product: associated product slug (string)
  • topic: associated topic slug (string)

extra - sumo - post

  • thread: id of associated forum thread (integer)
  • id: id of post (integer)
  • slug: associated forum slug (string)

extra - sumo - discuss

  • article: id of associated article (integer)
  • thread: id of associated discussion thread (integer)
  • id: id of post (integer)
  • new: new post, or edit of existing (boolean)
  • slug: associated article slug (string)

extra - sumo - revision

  • article: id of associated article (integer)
  • revision: id of revision (integer)

extra - reps (planned)

  • report-date: when the contribution was reported (datetime)
  • report-type: type of report (string)
  • campaign: campaign that the contribution supports (string)
  • contribution-areas: contribution areas that are supported by this contribution (string)
  • location: location (latitude, longitude?)
  • extra: additional text about the contribution (string)
  • url: canonical URL for the activity (string)