Page MenuHomeSoftware Heritage

Refactor the person table
Closed, ResolvedPublic


It appears that the author specifications in some git commits are more free form than name <email>:

  • some omit the name and keep the space ( <email>)
  • some omit the name and the space (<email>)
  • some have trailing spaces (name <email> )

I believe our way out is adding a fullname field to the person table, and making the name and email field "secondary" fields that are filled if we were able to parse the fullname.

Related Objects

Event Timeline

olasd created this task.Apr 7 2016, 2:28 PM
zack added a comment.Apr 7 2016, 2:42 PM

after F2F discussion: ACK! /o\

  • id remains PRIMARY KEY
  • fullname is a new column, UNIQUE
  • name and email are NULLABLE, and filled only if we can parse them (note: empty string != NULL here, and both are meaningful)
olasd changed the visibility from "All Users" to "Public (No Login Required)".May 13 2016, 5:09 PM