Jump to: navigation, search

Modeling Project Committer Database

Revision as of 14:57, 23 December 2009 by Nickboldt.gmail.com (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Steps to maintain the Modeling Project's Committer/Contributor Database:

1. ssh to build.eclipse.org

2. mysql modeling -u modeling_db -p -A

3. enter password when prompted (ask Nick Boldt if you don't know it)

4. perform tweaks to database; you can get details about the schema using these commands:

mysql> show tables;
mysql> describe developers;
mysql> describe teams;
mysql> describe groups;

5. note that every entry in the developers table must have at least one matching entry in the teams table.

mysql> INSERT INTO developers (committerid,name,email,role,company,location,website,photoURL) VALUES 
(, 'Jose Alfredo Serrano Gonzalez', 'alfredo@anyware-tech.com', 'EMF Searc Contributor', 
'Anyware Technologies', 'Toulouse, Haute-Garonne, France', , '/modeling/images/team/jgonzalez.jpg');
mysql> update developers set role = 'EMF Search Contributor' where email like 'alfredo%';
mysql> select * from developers where email like 'alfredo%';
mysql> insert into teams values ('emf-search',56,0);