697768 - Copy vouch data into mysql

Status: VERIFIED FIXED

(Participation Infrastructure :: Phonebook, defect)

Description

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

This is for metrics to get the profile data...

Anytime we do any vouch action, add that data to the DB as well.

The UserProfile should store two things:

is_vouched a boolean

and 

vouched_by an FK to the voucher (which could be null in the case of @mozilla.com users)

We'll also need a task to go through old profiles and update their vouch status from LDAP - not sure how to query this, maybe by email address.

We should be able to test both the tool, and the on-the-fly data replication.

Comment 1

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Marking as QA+.  I think we'll want to focus on any vouching that happens on the site:

- profile pages
  - vouch for unvouched
  - not vouched yet shows up
  - show who is vouched by whom on what page
- search
  - vouched users can't search
  - vouch data is shown accurately
- vouching
  - users can vouch for unvouched users
- auto-vouch
  - mozilla.com users are vouched automatically.

Comment 2

[[github robot]]

Commits pushed to https://github.com/mozilla/mozillians

https://github.com/mozilla/mozillians/commit/043466edfd90a8e400b26f1b288b4ac08129e51f
Remove |vouched helper, bug 697768

https://github.com/mozilla/mozillians/commit/49bc8e025f6c206920f657db39905e90c78b7894
Record vouch data for moz.com, bug 697768

https://github.com/mozilla/mozillians/commit/75a589682d1aec863bfad60254efaefbfa71114f
Remove is_vouched from request.user, bug 697768

https://github.com/mozilla/mozillians/commit/8d186ad52222a1979096120992bf53890926e7d6
Remove session based record_vouch's, bug 697768

https://github.com/mozilla/mozillians/commit/b1ddaae1b0b3d01bcfe5c699095f0d77dfe433d1
Removing ldap stuff from vouch form, bug 697768

Comment 3

[[github robot]]

Commits pushed to https://github.com/mozilla/mozillians

https://github.com/mozilla/mozillians/commit/5389f10c3fd583d07af129505c0c28a518f77068
Add vouch field data, bug 697768

https://github.com/mozilla/mozillians/commit/4b68a7b18383dcca4d3ab19e9757c9ece0a37c31
UserProfile->ldapPerson method, bug 697768

https://github.com/mozilla/mozillians/commit/043466edfd90a8e400b26f1b288b4ac08129e51f
Remove |vouched helper, bug 697768

https://github.com/mozilla/mozillians/commit/49bc8e025f6c206920f657db39905e90c78b7894
Record vouch data for moz.com, bug 697768

https://github.com/mozilla/mozillians/commit/75a589682d1aec863bfad60254efaefbfa71114f
Remove is_vouched from request.user, bug 697768

https://github.com/mozilla/mozillians/commit/8d186ad52222a1979096120992bf53890926e7d6
Remove session based record_vouch's, bug 697768

https://github.com/mozilla/mozillians/commit/b1ddaae1b0b3d01bcfe5c699095f0d77dfe433d1
Removing ldap stuff from vouch form, bug 697768

Comment 4

[Matt Brandt [:mbrandt]]

QA verified - this has been passed by time and has seen a couple of iterations since