Skip to content

Scripts that helped Agile Medicine research data management between MySQL and MongoDB for genome data.

License

Notifications You must be signed in to change notification settings

AgileMedicine/GenomeDataManagementResearch

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

39 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Genome Data Management Research

Script to load SNP and locus data from tab-delimited files into MySQL and MongoDB for performance comparisons.

Prerequistites:

  • Python
  • MySQL
    • mysql.connector
  • MongoDB
    • pymongo
  • Tab-delimited data files
  usage: loader.py [-h] [--dev] [--path PATH] [--method METHOD] [--db DB]
                 [--yhost YHOST] [--username USERNAME] [--password PASSWORD]
                 [--ohost OHOST] [--coll COLL]

  Load SNP and locus data

  optional arguments:
    -h, --help           show this help message and exit
    --dev                Only load chromosome 21 for development testing
    --path PATH          Path to chromosome data
    --method METHOD      Load type: M(y)SQL, M(o)ngoDB, or (b)oth
    --db DB              MySQL and MongoDB database name
    --yhost YHOST        MySQL host
    --username USERNAME  MySQL username
    --password PASSWORD  MySQL password
    --ohost OHOST        MongoDB host
    --coll COLL          MongoDB collection

About

Scripts that helped Agile Medicine research data management between MySQL and MongoDB for genome data.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages