...
- File-paths-given-issue.sql
- 05-01_authors_registration.sql
- file-paths-given-issue.sql
- get-author-id-by-email.sql
- get-authors-and-submissions.sql
- get-authors-email-family_name-given_name.sql
- get-submissions-date-range.sql
- get-urls_submission-id.sql
- 05-01_authors_registration.sql
Scripts Documentation
...
--We have published .
Issue 2023
where setting_name = 'issueID' and setting_value = 13
Issue 2022
where setting_name = 'issueID' and setting_value = 8
On the making
Scripts we have not yet managed to finish.
get-authors-and-submissions.sql
Given a list of emails, returns a table with all the submissions by those authors, the user_id, givenName, familyName, email, university, publication_id, submission_id, title (of the abstract), abstract, last_modified (date), and a quick access URL to the public view and the dashboard view of that submission.
get-authors-email-family_name-given_name.sql
Smaller script: Returns the email, family name and given name of an author, which are values found at different tables of the database (email in users and names in user_settings).
get-author-id-by-email.sql
Smaller script: Returns the author_id, given name, family name, email, university, publication_id, submission_id and country, given an email address.
get-urls_submission-id.sql
Smaller script: Generates the URLs for quick access of a given submission both in the public face of the website (or its preview) and the admin dashboard.
get-submissions-date-range.sql
Gets submissions within a date range and their data.
This is important as a constrain because until the submissions have been reviewed and approved, we cannot filter them by issue (merely because they have not yet been assigned to an issue, which is a manual process done one by one).
On the making
Scripts we have not yet managed to finish, if any.
- 05-01_authors_registration.sql
- We would like it to track: Author, email address, submission ID (& link), submission title, if the submission abstract text field is filled, and if they actually pressed the button to submit)
- .
Quick useful queries
-- Given submission_id, provide the backend and frontend links of its submission. Change 368 for your n.
...