11. Additional notes

• 11.1. Testing
• 11.2. Technical notes
  • 11.2.1. Resolved bugs elsewhere, previously affecting CRATE
  • 11.2.2. Cross-platform hosting
  • 11.2.3. Converting to SQLAlchemy
  • 11.2.4. Installing Python 3.4 on Ubuntu 16.04
  • 11.2.5. Transaction count always >0 for SQL Server, prohibiting CREATE FULLTEXT INDEX
  • 11.2.6. Celery: test_email_rdbm_task() missing 1 required positional argument: ‘self’
  • 11.2.7. SQL comments
  • 11.2.8. webnotes.txt
  • 11.2.9. notes_on_database_schemas.txt
  • 11.2.10. old notes.txt
  • 11.2.11. Old pipeline notes
• 11.3. Common relevant TCP/IP ports
• 11.4. External dependencies
  • 11.4.1. Python packages
  • 11.4.2. Versions of software etc. used by CRATE
• 11.5. Calling Python from SQL Server
  • 11.5.1. Prerequisites
  • 11.5.2. Basic communication with Python
  • 11.5.3. Install some external Python code
  • 11.5.4. See what packages are installed locally
  • 11.5.5. Structured data flow
  • 11.5.6. Example to find two antidepressants “episodes”
• 11.6. Using SemEHR
  • 11.6.1. Background on Docker
  • 11.6.2. SemEHR tutorial via Docker on Ubuntu
  • 11.6.3. Notes on Docker
  • 11.6.4. Notes on the SemEHR Docker setup
  • 11.6.5. Troubleshooting SemEHR