mozilla-services / mozilla-services/syncstorage-rs
Store account "last seen" datetime with token server
Nobody has claimed this yet.
- Dominant language
- Rust
- Stars
- 1.8k
- Forks
- 86
- Avg merge
- 2d 17h
- Merged PRs (30d)
- 21
Description
In order to determine the active status of an account in Sync we need to know when the account was last seen in Sync Storge. The Oauth access token verification and exchange is a fairly good proxy for this purpose.
We’ll need:
- a new BigQuery dataset
- a table in the new dataset where we upsert the account uid, the client id from the access token, and a timestamp
In Token Server, we’ll periodically batch upsert into the new BQ table. For the upsert, the composite key is (uid, client_id).
┆Issue is synchronized with this Jira Task
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the Token Server's OAuth access-token verification and exchange paths, along with any existing BigQuery integration. Define the new dataset and table for (uid, client_id, timestamp), then determine how periodic batch upserts fit the service; done means verified account last-seen records are written to BigQuery.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- rust
- Domain
- backend, cloud, data-engineering, database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100