Page MenuHomeSoftware Heritage

Refactor the person table
Closed, ResolvedPublic

Description

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

StatusAssignedTask
Work in Progressvlorentz
Openolasd
OpenNone
OpenNone
Work in ProgressNone
Work in Progressvlorentz
Resolvedvlorentz
Resolvedvlorentz
Resolvedardumont
Resolvedardumont
Resolvedvlorentz
Resolvedvlorentz
Resolvedardumont
Resolvedardumont
Resolvedvlorentz
Work in Progressvlorentz
Work in Progressvlorentz
Work in Progressvlorentz
Resolvedolasd
Resolvedvlorentz
Resolvedvlorentz

Event Timeline

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