ReleaseEngineering:GraphServer: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 5: Line 5:
=== Schema ===
=== Schema ===


* The SQL for the Graph Server can be found in the [[http://hg.mozilla.org/graphs/file/1.0/sql/data.sql Graph repo's 1.0 branch]]
* The SQL for the Graph Server can be found in the [[http://hg.mozilla.org/graphs/file/default/sql/data.sql Graph repo's default branch]] (!! not the 1.0 branch any more !!)


Adjusting the schema is a multi-step process:  
Adjusting the schema is a multi-step process:  
# Get the SQL changes into the repo and reviewed
# Get the SQL changes reviewd and into the repo
# Convert the SQL into sql insert statements by removing any diff related cruft and only have new insert/update lines as plain text
# Convert the SQL into sql insert statements by removing any diff related cruft and only have new insert/update lines as plain text
# Adjust staging Graph server schema
# Adjust staging Graph server schema
# File IT bug to push to live server once tested clean
# File IT bug to push to live server once tested clean

Revision as of 11:21, 15 August 2012

Graph Server Notes

Note: Started as a page to contain various info nuggets about the Graph Server but it really needs to be filled out to a proper documentation page

Schema

Adjusting the schema is a multi-step process:

  1. Get the SQL changes reviewd and into the repo
  2. Convert the SQL into sql insert statements by removing any diff related cruft and only have new insert/update lines as plain text
  3. Adjust staging Graph server schema
  4. File IT bug to push to live server once tested clean