Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement basic structure of local database #8

Closed
redshiftzero opened this issue Jul 31, 2018 · 0 comments
Closed

Implement basic structure of local database #8

redshiftzero opened this issue Jul 31, 2018 · 0 comments
Assignees
Milestone

Comments

@redshiftzero
Copy link
Contributor

started in #1, eventually should have the following (ported from freedomofpress/securedrop-workstation#88 (comment)):

sources table

uuid
journalist_designation
is_flagged
last_updated
public_key
interaction_count
is_starred (not using separate table here as we do on the server, there is no reason to)

submissions table

uuid
is_read (the number of submissions that have this designation is basically going to generate the initial “read” icon locally)
filename -> path on the SVS where the doc is stored
is_downloaded (we could also expose this in the sources list in the UI)
size (expose in UI to give the user an idea of how long it will take to download)
source_id -> id in local database

replies table

source_id -> id in local database
journalist_id -> id in local database
filename

journalists table

username -> to begin with, this will just be the current user (when replies are surfaced in the API via freedomofpress/securedrop#3097 then we should store the usernames so it's clear who is talking to who)

@redshiftzero redshiftzero self-assigned this Jul 31, 2018
@eloquence eloquence changed the title implement basic structure of local db Implement basic structure of local database Aug 1, 2018
@eloquence eloquence added this to the 0.1alpha milestone Sep 11, 2018
legoktm pushed a commit that referenced this issue Dec 11, 2023
Adds initial scripts to use rsyslog for logging in workstation
legoktm pushed a commit that referenced this issue Dec 15, 2023
Adds setup.py and a MANIFEST.in file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants