You can use this diagram as a template to create your own git branching diagrams. Here's how:
https://gist.githubusercontent.com/bryanbraun/8c93e154a93a08794291df1fcdce6918/raw/bf563eb36c3623bb9e7e1faae349c5da802f9fed/template-data.xml
| BEGIN; | |
| UPDATE nd_experiment | |
| SET nd_geolocation_id = 119 | |
| WHERE nd_geolocation_id = 52; | |
| UPDATE projectprop | |
| SET value = '119' | |
| WHERE value = '52' | |
| AND type_id = ( |
| # Retrieve NCSU crosses that are missing female_parent stock_relationship | |
| SELECT stock.stock_id, stock.uniquename FROM stock | |
| LEFT JOIN stock_relationship sr ON( | |
| stock.stock_id = sr.object_id | |
| AND sr.type_id = (SELECT cvterm_id FROM cvterm WHERE name = 'female_parent') | |
| ) | |
| JOIN nd_experiment_stock s ON(stock.stock_id = s.stock_id) | |
| JOIN nd_experiment_project p ON(s.nd_experiment_id = p.nd_experiment_id) | |
| JOIN project t ON(p.project_id = t.project_id) | |
| JOIN project_relationship pr ON( |
| # skips first sp_person_id to exclude admin account | |
| psql -U postgres -h breedbase_db <db_name> -c "\copy (SELECT * FROM sgn_people.sp_person where sp_person_id > 1) TO STDOUT" > people.tsv | |
| psql -U postgres -h breedbase_db <db_name> -c "COPY sgn_people.sp_person FROM STDIN" < people.tsv | |
| # Grant usage on all schemas to web_usr | |
| DO $do$ | |
| DECLARE | |
| sch text; | |
| BEGIN | |
| FOR sch IN SELECT nspname FROM pg_namespace |
| license: gpl-3.0 |
Notes about confirmation email troubleshooting.
Confirmation emails sent with the local hostname go to spam, and Mail::Sendmail does seem to support SMTP auth very well. I could not get Mail::Sendmail to work with smtp.gmail.com. I also had no luck with Email::Sender::Transport::SMTP which is already a dependency, or Email::Sender::Transport::SMTPS
The best soultion I've found is Email::Send::SMTP::Gmail which works well and has bonus features like support for file attachments. To use it, install it (cpanm Email::Send::SMTP::Gmail) and make sure the gmail account being used for login has the 'allow access for less secure apps' setting turned on.
Here's a test script for proof of concept:
| # Add to beginning of cgi: | |
| import logging | |
| import pprint | |
| import config | |
| pp = pprint.PrettyPrinter(indent=4) | |
| logging.basicConfig(filename=config.ROOT_PATH+"/rtt.log", level=logging.DEBUG) | |
| # Add debugging print statements like this |
| Install Rstudio | |
| Install Peek | |
| Install VirtualBox | |
| Install Android Studio | |
| sudo apt install docker.io | |
| sudo apt install htop | |
| Setup .bash_aliases |
| dbhost breedbase-db | |
| dbname breedbase | |
| dbuser postgres | |
| dbpass postgres | |
| rootpath /home/production/cxgn | |
| basepath /home/production/cxgn/sgn | |
| composable_cvs trait,toy | |
| composable_cvs_allowed_combinations Time Series|trait+toy |
| #breedbase | |
| alias log='tail -f -n 100 /var/log/sgn/error.log' | |
| #docker commands | |
| alias drm='docker stop $(docker ps -qa) && docker rm $(docker ps -qa) && docker image rm $(docker images) && docker volume rm $(docker volume ls)' # && docker ps -a && docker images && docker volume ls' | |
| alias dps='docker ps --format "table {{.Names}}\t{{.Status}}\t{{.Image}}"' | |
| alias dpsa='docker ps -a' | |
| alias dstart='docker start $(docker ps -qa)' | |
| alias dstop='docker stop $(docker ps -qa)' |