ETTLIMS

ETTLIMS is a Single Cell Genomics Lab Information Management System developed for the Ettema Lab by BILS.

The database implements the workflow of the Ettema Lab:

If your lab has a similar workflow you might be able to use the ETTLIMS as is. Otherwise an amout of tweaking might be required in which case we would recommend forking the repository and only using certain elements.

• Documentation: http://ettlims.rtfd.org
• Demo: http://bit.ly/ettlims-heroku (for admin user/pass inodb)
• Presentation: http://bit.ly/limstalk
• GitHub: https://github.com/BILS/ETTLIMS/
• Free software: GPLv3 License

Requirements

• Python 2.7+
• Django 1.6.1
• Local: https://github.com/BILS/ETTLIMS/blob/master/lims_project/requirements/local.txt
• Development: https://github.com/BILS/ETTLIMS/blob/master/lims_project/requirements/development.txt

Installation

Clone the repository to your computer:

git clone https://github.com/BILS/ETTLIMS

Local installation:

pip install -r lims_project/requirements/local.txt

Running ETTLIMS

Locally with SQLite

Without example data:

cd lims_project
python manage.py syncdb --settings=lims_project.settings.local && \
python manage.py runserver 127.0.0.1:8000 --settings=lims_project.settings.local

With all example data:

cd lims_project
python manage.py syncdb --settings=lims_project.settings.local && \
python manage.py loaddata example barcode_example --settings=lims_project.settings.local && \
python manage.py runserver 127.0.0.1:8000 --settings=lims_project.settings.local

Remove example from the loaddata command if you only want the barcode_example data and vice versa.

Empty the database:

cd lims_project
rm lims_project/lims_project.sqlite

Development with PostgreSQL database

First you need to set up PostgreSQL. You'll have to create a database django and user django, see the development settings. Then the commands are similar to running it locally, but you change lims_project.settings.local to lims_project.settings.development e.g.:

cd lims_project
python manage.py syncdb --settings=lims_project.settings.development && \
python manage.py loaddata example barcode_example --settings=lims_project.settings.development && \
python manage.py runserver 127.0.0.1:8000 --settings=lims_project.settings.development

To empty the PostgreSQL database you can run:

python manage.py sqlclear sessions admin lims auth contenttypes \
    --settings=lims_project.settings.development | \
grep -v parent_id | \
python manage.py dbshell --settings=lims_project.settings.development

The grep -v parent_id is necessary to remove a non-existing constraint from the generated sql statements by django. This is a known django bug.

Contribute

Contributions are greatly appreciated, please read the contribution instructions.