Integrate with Google Apps

[khannotations]

Integrate our app with Google Apps so it can create groups and calendars on behalf of the domain, preferably with displaying OAuth info to the user.

IMPORTANT NAMING CONVENTION: A "group" is a Google Group that may represent an Organization (YaleGo's logical unit for a student-run org) or a Category (a category of events, such as "tech-related", "free food", etc)

As discussed on 6/22, this should:

• For each organization, create a subscribers group called yalego.subscribers.<organization-slug>@elilists.yale.edu. Make sure the description and name follows conventions here, as well:
  • name: Subscribers (i.e. TEDxYale Subscribers)
  • description: YaleGo group for all
• Also create a calendar, and share it with "certain people", most importantly including the above group.
• In our backend, create / update the organization with the corresponding Google Group ID and Calendar ID
  • note that our backend's description and name will be different than the Google Group's
• For each category, do the same thing.
  • name of group TBD: yalego.subscribers.<category-slug>@elilists.yale.edu? And make subscribeable-slug unique across all subscribeables.

Whenever an event is created by an organization, the appropriate event is added to the organization's calendar. Also copied to all the desired category calendars.

When a user follows an organization or category, just add them to the group. To get a user's events, get all their groups, then get a flat list of events (making sure to account for duplicates from category calendars).

Also make sure the right preferences are added in the preferences panel.

[khannotations]

Our plan from 6 / 23 / 2013:

YG = YaleGo GG = Google

When a user visits:

• Ask YG database for all groups and categories the user is associated with.
• For each organization:
  • Query GG calendar for all events in
  • Add returned events to global events list (in order), if they don't exist
  • Mark each event's organization as this one
• For each category:
  • Query GG calendar for all events in
  • Add returned events to global events list (in order), if they don't exist
  • Append to each event's list of categories, if this category isn't in that list
• Render event list and calendar

Backend:

• Organization (implements subscribeable):
  • has_many subscribers, as subscribeable
  • YG Id
  • GG Group Id
  • GG Cal Id
  • Color
• Category (implements subscribeable):
  • YG Id
  • GG Group Id
  • GG Cal Id
• User:
  • has_many subscriptions
  • has_many subscribeables, through: subscriptions
  • followed_orgs = subscibeables where type = org
  • followed_cat = subscibeables where type = cat
  • admin_orgs = followed_orgs where subscriptions.access == admin
  • member_orgs = ""
• Event:
  • GG event Id
  • location ID:
  • name (synced from google)
  • description (for search)
  • EVENTUALLY: user plans to attend : status Users attendned user ratings
  • PRESTATUS: 0: NOT_ATTENDING 1: ATTENDING 2: UNKNOWN
  • POSTSTATUS 0: DID_NOT_ATTEND 1: DID_ATTEND 2: UNKNOWN (event in past, unmarked)
• Subscription:
  • belongs_ user
  • belongs_to subscribeable
• Location:
  • For autocomplete
• LocationAliases:
  • Also for autocomplete
• PG_search:
• Paul's got it hehe

[pfletcherhill]

https://github.com/pfletch1023/Gandalf/pull/74

[khannotations]

So something is wrong here because you have 250+ commits starting in December 2012. I think when I did a fresh clone of the repo to try and solve the rails issue, things got all messed up. i think we should merge the paul and rafi branches, then rename that master.

On Tue, Jul 9, 2013 at 9:03 PM, Paul Fletcher-Hill <notifications@github.com

wrote:

74 https://github.com/pfletch1023/Gandalf/issues/74

— Reply to this email directly or view it on GitHubhttps://github.com/pfletch1023/Gandalf/issues/59#issuecomment-20720493 .

[khannotations]

sorry, never mind...paul is the same as master. google_apps, events_page and rafi are part of one branch, and paul and master a part of another (they seem to have diverged about 6 monhts ago...). i say let's pick rafi as the new master? and then merge google_apps and events_page into it?

On Wed, Jul 10, 2013 at 1:38 AM, Rafi Khan rafi.fa.khan@gmail.com wrote:

So something is wrong here because you have 250+ commits starting in December 2012. I think when I did a fresh clone of the repo to try and solve the rails issue, things got all messed up. i think we should merge the paul and rafi branches, then rename that master.

On Tue, Jul 9, 2013 at 9:03 PM, Paul Fletcher-Hill < notifications@github.com> wrote:

74 https://github.com/pfletch1023/Gandalf/issues/74

— Reply to this email directly or view it on GitHubhttps://github.com/pfletch1023/Gandalf/issues/59#issuecomment-20720493 .

[pfletcherhill]

So I pulled events_page into google_apps before submitting a PR, so yeah let's remove master and paul, rename rafi as master, and merge google_apps into the new master. Wanna do that, or should I?

[khannotations]

are you comfortable doing it? I'm at like 50%. if you're more comfortable than that, go for it. otherwise lemme know Sent in motion

On Wed, Jul 10, 2013 at 12:32 PM, Paul Fletcher-Hill notifications@github.com wrote:

So I pulled events_page into google_apps before submitting a PR, so yeah let's remove master and paul, rename rafi as master, and merge google_apps into the new master. Wanna do that, or should I?

Reply to this email directly or view it on GitHub: https://github.com/pfletch1023/Gandalf/issues/59#issuecomment-20766975

[pfletcherhill]

Check your gchat when you can. We have sort of a problem where rafi is no better than master or paul.