-
Notifications
You must be signed in to change notification settings - Fork 1
Home
Welcome to the com2pgsql wiki!
The com2pgsql tool developed by the Eggnet team in the S.E.G.A.L lab at the University of Victoria is a tool that will take a source of communication (Email, Bugzilla, or Jira) and import it into a generalized database format specified here Database Schema. The tool can also be used (if specified) to attempt to link items of communication to git commits from the scm2pgsql project database.
If you wish to create a new communication database you must use the -d flag. This flag takes one arguments which is to become the database name. If the database already exists, it will be deleted and reconstructed from the SQL script inside this project.
If you are importing from a Bugzilla database then you must use the -b flag. This flag takes three parameters. The first is the database name you have created with the -d flag. The second is the database name that was created from the scm2pgsql project. Third is the database name for Bugzilla.
If you are importing from a Jira then you must use the -j flag. This flag takes three parameters. The first is the database name you have created with the -d flag. The second is the database name that was created from the scm2pgsql project. Third is the host name of where the Jira is being stored.
As of now, the -e flag for email archives is unsupported.
The result of any of these flags will be a database that has reduced all of this communication information into a generalized format.
Eggnet has provided some communication specific regex inside of the code to be able to link commits to communication artifacts.
If you wish to link a project that uses Jira, you can supply the -l -j flags. After these two flags (order dependent) you must specify the database you created for this project, as well as the database created by the scm2pgsql project.
If you wish to link a project that uses Bugzilla, you can supply the -l -b flags. After these two flags (order dependent) you must specify the database you create for this project, ad well as the database created by the scm2pgsql project.
A more detailed approach as to how the linking is actually preformed can be found here.
The results of this project are links between communication artifacts and git repository commits. From these links, we can imply communication networks which become the final result of this project.
To imply a network, we simply take all communications artifacts inside a common thread that are linked to a commit and create a fully connected network where nodes are people who were apart of those artifacts.