https://github.com/amp-scz/db-query-collection
A centralized collection of SQL queries used across AMP SCZ project.
Science Score: 26.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
○CITATION.cff file
-
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (8.6%) to scientific vocabulary
Repository
A centralized collection of SQL queries used across AMP SCZ project.
Basic Info
- Host: GitHub
- Owner: AMP-SCZ
- Language: Python
- Default Branch: master
- Size: 140 KB
Statistics
- Stars: 0
- Watchers: 3
- Forks: 0
- Open Issues: 0
- Releases: 0
Metadata Files
README.md
db-query-collection
A centralized collection of SQL queries utilized across the AMP SCZ project.
Contents
- mriteamcount
- Github action
mriteamcount
This directory contains the SQL query used to create the materialized view mri_team_count in the mri schema.
The materialized view provides two rows for each recruited subject, representing baseline and month 2 MRI data, along with various characteristics and status for each timepoint. AMP-SCZ members counting MRI data should use this materialized view for deriving harmonized counts from the database.
The DNA007 server is configured to clone this repository every hour and update the materialized view. This ensures that everyone counting MR-related data has access to the same number of subjects. Please ensure to follow the PR process when any updates to the query for the materialized view are needed.
You can access the mri_team_count table (materialized view) using the following SQL query:
sql
SELECT * FROM mri.mri_team_count;
The materialized view is directly accessible from the database as well as through DBeaver. It is also saved in the following path:
/data/predict1/home/kcho/software/db-query-collection/mri_team_count.csv
Github action
See .github/workflows/auto-pr.yml for github action to automatically merge mri_team_count branch to master branch. test, test, test
Owner
- Name: AMP SCZ
- Login: AMP-SCZ
- Kind: organization
- Repositories: 17
- Profile: https://github.com/AMP-SCZ
Accelerating Medicines Partnership - Schizophrenia
GitHub Events
Total
- Issues event: 1
- Delete event: 5
- Member event: 1
- Issue comment event: 3
- Push event: 41
- Pull request review comment event: 7
- Pull request review event: 17
- Pull request event: 30
- Create event: 11
Last Year
- Issues event: 1
- Delete event: 5
- Member event: 1
- Issue comment event: 3
- Push event: 41
- Pull request review comment event: 7
- Pull request review event: 17
- Pull request event: 30
- Create event: 11
Issues and Pull Requests
Last synced: 10 months ago
All Time
- Total issues: 1
- Total pull requests: 22
- Average time to close issues: 2 days
- Average time to close pull requests: about 12 hours
- Total issue authors: 1
- Total pull request authors: 3
- Average comments per issue: 5.0
- Average comments per pull request: 0.05
- Merged pull requests: 12
- Bot issues: 0
- Bot pull requests: 10
Past Year
- Issues: 1
- Pull requests: 22
- Average time to close issues: 2 days
- Average time to close pull requests: about 12 hours
- Issue authors: 1
- Pull request authors: 3
- Average comments per issue: 5.0
- Average comments per pull request: 0.05
- Merged pull requests: 12
- Bot issues: 0
- Bot pull requests: 10
Top Authors
Issue Authors
- mbabbage742 (1)
Pull Request Authors
- github-actions[bot] (9)
- abawesome-li (6)
- kcho (4)
Top Labels
Issue Labels
Pull Request Labels
Dependencies
- actions/checkout v3 composite