From: Diane Trout Date: Fri, 17 Jan 2014 23:45:24 +0000 (-0800) Subject: Initial conversion of HTSWorkflow to use south migrations. X-Git-Url: http://woldlab.caltech.edu/gitweb/?p=htsworkflow.git;a=commitdiff_plain;h=32883c0c4a767258ffbbb635c5543902bdd46b8c Initial conversion of HTSWorkflow to use south migrations. --- diff --git a/htsworkflow/frontend/bcmagic/migrations/0001_initial.py b/htsworkflow/frontend/bcmagic/migrations/0001_initial.py new file mode 100644 index 0000000..8d04e36 --- /dev/null +++ b/htsworkflow/frontend/bcmagic/migrations/0001_initial.py @@ -0,0 +1,63 @@ +# -*- coding: utf-8 -*- +from south.utils import datetime_utils as datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + + +class Migration(SchemaMigration): + + def forwards(self, orm): + # Adding model 'KeywordMap' + db.create_table(u'bcmagic_keywordmap', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('keyword', self.gf('django.db.models.fields.CharField')(max_length=64)), + ('regex', self.gf('django.db.models.fields.CharField')(max_length=1024)), + ('url_template', self.gf('django.db.models.fields.TextField')()), + )) + db.send_create_signal(u'bcmagic', ['KeywordMap']) + + # Adding model 'Printer' + db.create_table(u'bcmagic_printer', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=256)), + ('model', self.gf('django.db.models.fields.CharField')(max_length=64)), + ('ip_address', self.gf('django.db.models.fields.IPAddressField')(max_length=15)), + ('label_shape', self.gf('django.db.models.fields.CharField')(max_length=32)), + ('label_width', self.gf('django.db.models.fields.FloatField')()), + ('label_height', self.gf('django.db.models.fields.FloatField')()), + ('notes', self.gf('django.db.models.fields.TextField')()), + )) + db.send_create_signal(u'bcmagic', ['Printer']) + + + def backwards(self, orm): + # Deleting model 'KeywordMap' + db.delete_table(u'bcmagic_keywordmap') + + # Deleting model 'Printer' + db.delete_table(u'bcmagic_printer') + + + models = { + u'bcmagic.keywordmap': { + 'Meta': {'object_name': 'KeywordMap'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'keyword': ('django.db.models.fields.CharField', [], {'max_length': '64'}), + 'regex': ('django.db.models.fields.CharField', [], {'max_length': '1024'}), + 'url_template': ('django.db.models.fields.TextField', [], {}) + }, + u'bcmagic.printer': { + 'Meta': {'object_name': 'Printer'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'ip_address': ('django.db.models.fields.IPAddressField', [], {'max_length': '15'}), + 'label_height': ('django.db.models.fields.FloatField', [], {}), + 'label_shape': ('django.db.models.fields.CharField', [], {'max_length': '32'}), + 'label_width': ('django.db.models.fields.FloatField', [], {}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '64'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256'}), + 'notes': ('django.db.models.fields.TextField', [], {}) + } + } + + complete_apps = ['bcmagic'] \ No newline at end of file diff --git a/htsworkflow/frontend/bcmagic/migrations/__init__.py b/htsworkflow/frontend/bcmagic/migrations/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/htsworkflow/frontend/experiments/migrations/0001_initial.py b/htsworkflow/frontend/experiments/migrations/0001_initial.py new file mode 100644 index 0000000..971489d --- /dev/null +++ b/htsworkflow/frontend/experiments/migrations/0001_initial.py @@ -0,0 +1,332 @@ +# -*- coding: utf-8 -*- +from south.utils import datetime_utils as datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + + +class Migration(SchemaMigration): + + def forwards(self, orm): + # Adding model 'ClusterStation' + db.create_table(u'experiments_clusterstation', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=50)), + ('isdefault', self.gf('django.db.models.fields.BooleanField')(default=False)), + )) + db.send_create_signal(u'experiments', ['ClusterStation']) + + # Adding model 'Sequencer' + db.create_table(u'experiments_sequencer', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=50, db_index=True)), + ('instrument_name', self.gf('django.db.models.fields.CharField')(max_length=50, db_index=True)), + ('serial_number', self.gf('django.db.models.fields.CharField')(max_length=50, db_index=True)), + ('model', self.gf('django.db.models.fields.CharField')(max_length=255)), + ('active', self.gf('django.db.models.fields.BooleanField')(default=True)), + ('isdefault', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('comment', self.gf('django.db.models.fields.CharField')(max_length=255)), + )) + db.send_create_signal(u'experiments', ['Sequencer']) + + # Adding model 'FlowCell' + db.create_table(u'experiments_flowcell', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('flowcell_id', self.gf('django.db.models.fields.CharField')(unique=True, max_length=20, db_index=True)), + ('run_date', self.gf('django.db.models.fields.DateTimeField')()), + ('advanced_run', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('paired_end', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('read_length', self.gf('django.db.models.fields.IntegerField')(default=32)), + ('control_lane', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('cluster_station', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.ClusterStation'])), + ('sequencer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.Sequencer'])), + ('notes', self.gf('django.db.models.fields.TextField')(blank=True)), + )) + db.send_create_signal(u'experiments', ['FlowCell']) + + # Adding model 'Lane' + db.create_table(u'experiments_lane', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('flowcell', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.FlowCell'])), + ('lane_number', self.gf('django.db.models.fields.IntegerField')()), + ('library', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Library'])), + ('pM', self.gf('django.db.models.fields.DecimalField')(default=5, max_digits=5, decimal_places=2)), + ('cluster_estimate', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('status', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'experiments', ['Lane']) + + # Adding model 'DataRun' + db.create_table(u'experiments_datarun', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('flowcell', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.FlowCell'])), + ('runfolder_name', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('result_dir', self.gf('django.db.models.fields.CharField')(max_length=255)), + ('last_update_time', self.gf('django.db.models.fields.DateTimeField')()), + ('run_start_time', self.gf('django.db.models.fields.DateTimeField')()), + ('cycle_start', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('cycle_stop', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('run_status', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('image_software', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('image_version', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('basecall_software', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('basecall_version', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('alignment_software', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('alignment_version', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('comment', self.gf('django.db.models.fields.TextField')(blank=True)), + )) + db.send_create_signal(u'experiments', ['DataRun']) + + # Adding model 'FileType' + db.create_table(u'experiments_filetype', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=50)), + ('mimetype', self.gf('django.db.models.fields.CharField')(max_length=50, null=True, blank=True)), + ('regex', self.gf('django.db.models.fields.CharField')(max_length=50, null=True, blank=True)), + )) + db.send_create_signal(u'experiments', ['FileType']) + + # Adding model 'DataFile' + db.create_table(u'experiments_datafile', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('random_key', self.gf('django.db.models.fields.CharField')(default='9ce3c20e-7fcc-11e3-9794-f0def16fbea3', max_length=64, db_index=True)), + ('data_run', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.DataRun'])), + ('library', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Library'], null=True, blank=True)), + ('file_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.FileType'])), + ('relative_pathname', self.gf('django.db.models.fields.CharField')(max_length=255, db_index=True)), + )) + db.send_create_signal(u'experiments', ['DataFile']) + + + def backwards(self, orm): + # Deleting model 'ClusterStation' + db.delete_table(u'experiments_clusterstation') + + # Deleting model 'Sequencer' + db.delete_table(u'experiments_sequencer') + + # Deleting model 'FlowCell' + db.delete_table(u'experiments_flowcell') + + # Deleting model 'Lane' + db.delete_table(u'experiments_lane') + + # Deleting model 'DataRun' + db.delete_table(u'experiments_datarun') + + # Deleting model 'FileType' + db.delete_table(u'experiments_filetype') + + # Deleting model 'DataFile' + db.delete_table(u'experiments_datafile') + + + models = { + u'auth.group': { + 'Meta': {'object_name': 'Group'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}), + 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}) + }, + u'auth.permission': { + 'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'}, + 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) + }, + u'auth.user': { + 'Meta': {'object_name': 'User'}, + 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Group']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}), + 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Permission']"}), + 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) + }, + u'contenttypes.contenttype': { + 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"}, + 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}) + }, + u'experiments.clusterstation': { + 'Meta': {'ordering': "['-isdefault', 'name']", 'object_name': 'ClusterStation'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'isdefault': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '50'}) + }, + u'experiments.datafile': { + 'Meta': {'object_name': 'DataFile'}, + 'data_run': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.DataRun']"}), + 'file_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.FileType']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'library': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Library']", 'null': 'True', 'blank': 'True'}), + 'random_key': ('django.db.models.fields.CharField', [], {'default': "'9ce8579c-7fcc-11e3-9794-f0def16fbea3'", 'max_length': '64', 'db_index': 'True'}), + 'relative_pathname': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'}) + }, + u'experiments.datarun': { + 'Meta': {'object_name': 'DataRun'}, + 'alignment_software': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'alignment_version': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'basecall_software': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'basecall_version': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'comment': ('django.db.models.fields.TextField', [], {'blank': 'True'}), + 'cycle_start': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'cycle_stop': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'flowcell': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.FlowCell']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'image_software': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'image_version': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'last_update_time': ('django.db.models.fields.DateTimeField', [], {}), + 'result_dir': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'run_start_time': ('django.db.models.fields.DateTimeField', [], {}), + 'run_status': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'runfolder_name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) + }, + u'experiments.filetype': { + 'Meta': {'object_name': 'FileType'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'mimetype': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}), + 'regex': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}) + }, + u'experiments.flowcell': { + 'Meta': {'ordering': "['-run_date']", 'object_name': 'FlowCell'}, + 'advanced_run': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'cluster_station': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.ClusterStation']"}), + 'control_lane': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'flowcell_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '20', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}), + 'paired_end': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'read_length': ('django.db.models.fields.IntegerField', [], {'default': '32'}), + 'run_date': ('django.db.models.fields.DateTimeField', [], {}), + 'sequencer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.Sequencer']"}) + }, + u'experiments.lane': { + 'Meta': {'object_name': 'Lane'}, + 'cluster_estimate': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'flowcell': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.FlowCell']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'lane_number': ('django.db.models.fields.IntegerField', [], {}), + 'library': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Library']"}), + 'pM': ('django.db.models.fields.DecimalField', [], {'default': '5', 'max_digits': '5', 'decimal_places': '2'}), + 'status': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}) + }, + u'experiments.sequencer': { + 'Meta': {'ordering': "['-isdefault', '-active', 'name']", 'object_name': 'Sequencer'}, + 'active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'comment': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'instrument_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'db_index': 'True'}), + 'isdefault': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'db_index': 'True'}), + 'serial_number': ('django.db.models.fields.CharField', [], {'max_length': '50', 'db_index': 'True'}) + }, + u'samples.affiliation': { + 'Meta': {'ordering': "['name', 'contact']", 'unique_together': "(('name', 'contact'),)", 'object_name': 'Affiliation'}, + 'contact': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}), + 'users': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': u"orm['samples.HTSUser']", 'null': 'True', 'blank': 'True'}) + }, + u'samples.antibody': { + 'Meta': {'ordering': "['antigene']", 'object_name': 'Antibody'}, + 'antibodies': ('django.db.models.fields.CharField', [], {'max_length': '500', 'db_index': 'True'}), + 'antigene': ('django.db.models.fields.CharField', [], {'max_length': '500', 'db_index': 'True'}), + 'biology': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'catalog': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'source': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '500', 'null': 'True', 'blank': 'True'}) + }, + u'samples.cellline': { + 'Meta': {'ordering': "['cellline_name']", 'object_name': 'Cellline'}, + 'cellline_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}) + }, + u'samples.condition': { + 'Meta': {'ordering': "['condition_name']", 'object_name': 'Condition'}, + 'condition_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2000', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}) + }, + u'samples.experimenttype': { + 'Meta': {'object_name': 'ExperimentType'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '50'}) + }, + u'samples.htsuser': { + 'Meta': {'ordering': "['first_name', 'last_name', 'username']", 'object_name': 'HTSUser', '_ormbases': [u'auth.User']}, + u'user_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': u"orm['auth.User']", 'unique': 'True', 'primary_key': 'True'}) + }, + u'samples.library': { + 'Meta': {'ordering': "['-id']", 'object_name': 'Library'}, + 'account_number': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), + 'affiliations': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'library_affiliations'", 'null': 'True', 'to': u"orm['samples.Affiliation']"}), + 'amplified_from_sample': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'amplified_into_sample'", 'null': 'True', 'to': u"orm['samples.Library']"}), + 'antibody': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Antibody']", 'null': 'True', 'blank': 'True'}), + 'bioanalyzer_concentration': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '5', 'decimal_places': '2', 'blank': 'True'}), + 'bioanalyzer_image_url': ('django.db.models.fields.URLField', [], {'default': "''", 'max_length': '200', 'blank': 'True'}), + 'bioanalyzer_summary': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}), + 'cell_line': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Cellline']", 'null': 'True', 'blank': 'True'}), + 'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Condition']", 'null': 'True', 'blank': 'True'}), + 'creation_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'experiment_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.ExperimentType']"}), + 'gel_cut_size': ('django.db.models.fields.IntegerField', [], {'default': '225', 'null': 'True', 'blank': 'True'}), + 'hidden': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'id': ('django.db.models.fields.CharField', [], {'max_length': '10', 'primary_key': 'True'}), + 'insert_size': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'library_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}), + 'library_species': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Species']"}), + 'library_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.LibraryType']", 'null': 'True', 'blank': 'True'}), + 'made_by': ('django.db.models.fields.CharField', [], {'default': "'Lorian'", 'max_length': '50', 'blank': 'True'}), + 'made_for': ('django.db.models.fields.CharField', [], {'max_length': '50', 'blank': 'True'}), + 'multiplex_id': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}), + 'replicate': ('django.db.models.fields.PositiveSmallIntegerField', [], {'null': 'True', 'blank': 'True'}), + 'stopping_point': ('django.db.models.fields.CharField', [], {'default': "'Done'", 'max_length': '25'}), + 'successful_pM': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '9', 'decimal_places': '1', 'blank': 'True'}), + 'tags': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'library_tags'", 'null': 'True', 'symmetrical': 'False', 'to': u"orm['samples.Tag']"}), + 'ten_nM_dilution': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'undiluted_concentration': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '5', 'decimal_places': '2', 'blank': 'True'}) + }, + u'samples.librarytype': { + 'Meta': {'ordering': "['-id']", 'object_name': 'LibraryType'}, + 'can_multiplex': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_paired_end': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}) + }, + u'samples.species': { + 'Meta': {'ordering': "['scientific_name']", 'object_name': 'Species'}, + 'common_name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'scientific_name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}) + }, + u'samples.tag': { + 'Meta': {'ordering': "['context', 'tag_name']", 'object_name': 'Tag'}, + 'context': ('django.db.models.fields.CharField', [], {'default': "'Library'", 'max_length': '50'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'tag_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'db_index': 'True'}) + } + } + + complete_apps = ['experiments'] \ No newline at end of file diff --git a/htsworkflow/frontend/experiments/migrations/__init__.py b/htsworkflow/frontend/experiments/migrations/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/htsworkflow/frontend/inventory/migrations/0001_initial.py b/htsworkflow/frontend/inventory/migrations/0001_initial.py new file mode 100644 index 0000000..ad0114d --- /dev/null +++ b/htsworkflow/frontend/inventory/migrations/0001_initial.py @@ -0,0 +1,452 @@ +# -*- coding: utf-8 -*- +from south.utils import datetime_utils as datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + + +class Migration(SchemaMigration): + + def forwards(self, orm): + # Adding model 'Vendor' + db.create_table(u'inventory_vendor', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=256)), + ('url', self.gf('django.db.models.fields.URLField')(max_length=200, null=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['Vendor']) + + # Adding model 'Location' + db.create_table(u'inventory_location', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=256)), + ('location_description', self.gf('django.db.models.fields.TextField')()), + ('uuid', self.gf('django.db.models.fields.CharField')(max_length=32, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['Location']) + + # Adding model 'ItemInfo' + db.create_table(u'inventory_iteminfo', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('model_id', self.gf('django.db.models.fields.CharField')(max_length=256, null=True, blank=True)), + ('part_number', self.gf('django.db.models.fields.CharField')(max_length=256, null=True, blank=True)), + ('lot_number', self.gf('django.db.models.fields.CharField')(max_length=256, null=True, blank=True)), + ('url', self.gf('django.db.models.fields.URLField')(max_length=200, null=True, blank=True)), + ('qty_purchased', self.gf('django.db.models.fields.IntegerField')(default=1)), + ('vendor', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['inventory.Vendor'])), + ('purchase_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), + ('warranty_months', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['ItemInfo']) + + # Adding model 'ItemType' + db.create_table(u'inventory_itemtype', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=64)), + ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['ItemType']) + + # Adding model 'ItemStatus' + db.create_table(u'inventory_itemstatus', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=64)), + ('notes', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['ItemStatus']) + + # Adding model 'Item' + db.create_table(u'inventory_item', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('item_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['inventory.ItemType'])), + ('uuid', self.gf('django.db.models.fields.CharField')(unique=True, max_length=32, blank=True)), + ('barcode_id', self.gf('django.db.models.fields.CharField')(max_length=256, null=True, blank=True)), + ('force_use_uuid', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('item_info', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['inventory.ItemInfo'])), + ('location', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['inventory.Location'])), + ('status', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['inventory.ItemStatus'], null=True, blank=True)), + ('creation_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + ('modified_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['Item']) + + # Adding model 'PrinterTemplate' + db.create_table(u'inventory_printertemplate', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('item_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['inventory.ItemType'])), + ('printer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['bcmagic.Printer'])), + ('default', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('template', self.gf('django.db.models.fields.TextField')()), + )) + db.send_create_signal(u'inventory', ['PrinterTemplate']) + + # Adding model 'LongTermStorage' + db.create_table(u'inventory_longtermstorage', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('flowcell', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.FlowCell'])), + ('creation_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + ('modified_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), + )) + db.send_create_signal(u'inventory', ['LongTermStorage']) + + # Adding M2M table for field libraries on 'LongTermStorage' + m2m_table_name = db.shorten_name(u'inventory_longtermstorage_libraries') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('longtermstorage', models.ForeignKey(orm[u'inventory.longtermstorage'], null=False)), + ('library', models.ForeignKey(orm[u'samples.library'], null=False)) + )) + db.create_unique(m2m_table_name, ['longtermstorage_id', 'library_id']) + + # Adding M2M table for field storage_devices on 'LongTermStorage' + m2m_table_name = db.shorten_name(u'inventory_longtermstorage_storage_devices') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('longtermstorage', models.ForeignKey(orm[u'inventory.longtermstorage'], null=False)), + ('item', models.ForeignKey(orm[u'inventory.item'], null=False)) + )) + db.create_unique(m2m_table_name, ['longtermstorage_id', 'item_id']) + + # Adding model 'ReagentFlowcell' + db.create_table(u'inventory_reagentflowcell', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('creation_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + ('modified_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), + ('flowcell', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['experiments.FlowCell'])), + )) + db.send_create_signal(u'inventory', ['ReagentFlowcell']) + + # Adding M2M table for field reagent on 'ReagentFlowcell' + m2m_table_name = db.shorten_name(u'inventory_reagentflowcell_reagent') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('reagentflowcell', models.ForeignKey(orm[u'inventory.reagentflowcell'], null=False)), + ('item', models.ForeignKey(orm[u'inventory.item'], null=False)) + )) + db.create_unique(m2m_table_name, ['reagentflowcell_id', 'item_id']) + + # Adding model 'ReagentLibrary' + db.create_table(u'inventory_reagentlibrary', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('creation_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + ('modified_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), + ('library', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Library'])), + )) + db.send_create_signal(u'inventory', ['ReagentLibrary']) + + # Adding M2M table for field reagent on 'ReagentLibrary' + m2m_table_name = db.shorten_name(u'inventory_reagentlibrary_reagent') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('reagentlibrary', models.ForeignKey(orm[u'inventory.reagentlibrary'], null=False)), + ('item', models.ForeignKey(orm[u'inventory.item'], null=False)) + )) + db.create_unique(m2m_table_name, ['reagentlibrary_id', 'item_id']) + + + def backwards(self, orm): + # Deleting model 'Vendor' + db.delete_table(u'inventory_vendor') + + # Deleting model 'Location' + db.delete_table(u'inventory_location') + + # Deleting model 'ItemInfo' + db.delete_table(u'inventory_iteminfo') + + # Deleting model 'ItemType' + db.delete_table(u'inventory_itemtype') + + # Deleting model 'ItemStatus' + db.delete_table(u'inventory_itemstatus') + + # Deleting model 'Item' + db.delete_table(u'inventory_item') + + # Deleting model 'PrinterTemplate' + db.delete_table(u'inventory_printertemplate') + + # Deleting model 'LongTermStorage' + db.delete_table(u'inventory_longtermstorage') + + # Removing M2M table for field libraries on 'LongTermStorage' + db.delete_table(db.shorten_name(u'inventory_longtermstorage_libraries')) + + # Removing M2M table for field storage_devices on 'LongTermStorage' + db.delete_table(db.shorten_name(u'inventory_longtermstorage_storage_devices')) + + # Deleting model 'ReagentFlowcell' + db.delete_table(u'inventory_reagentflowcell') + + # Removing M2M table for field reagent on 'ReagentFlowcell' + db.delete_table(db.shorten_name(u'inventory_reagentflowcell_reagent')) + + # Deleting model 'ReagentLibrary' + db.delete_table(u'inventory_reagentlibrary') + + # Removing M2M table for field reagent on 'ReagentLibrary' + db.delete_table(db.shorten_name(u'inventory_reagentlibrary_reagent')) + + + models = { + u'auth.group': { + 'Meta': {'object_name': 'Group'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}), + 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}) + }, + u'auth.permission': { + 'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'}, + 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) + }, + u'auth.user': { + 'Meta': {'object_name': 'User'}, + 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Group']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}), + 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Permission']"}), + 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) + }, + u'bcmagic.printer': { + 'Meta': {'object_name': 'Printer'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'ip_address': ('django.db.models.fields.IPAddressField', [], {'max_length': '15'}), + 'label_height': ('django.db.models.fields.FloatField', [], {}), + 'label_shape': ('django.db.models.fields.CharField', [], {'max_length': '32'}), + 'label_width': ('django.db.models.fields.FloatField', [], {}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '64'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256'}), + 'notes': ('django.db.models.fields.TextField', [], {}) + }, + u'contenttypes.contenttype': { + 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"}, + 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}) + }, + u'experiments.clusterstation': { + 'Meta': {'ordering': "['-isdefault', 'name']", 'object_name': 'ClusterStation'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'isdefault': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '50'}) + }, + u'experiments.flowcell': { + 'Meta': {'ordering': "['-run_date']", 'object_name': 'FlowCell'}, + 'advanced_run': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'cluster_station': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.ClusterStation']"}), + 'control_lane': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'flowcell_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '20', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}), + 'paired_end': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'read_length': ('django.db.models.fields.IntegerField', [], {'default': '32'}), + 'run_date': ('django.db.models.fields.DateTimeField', [], {}), + 'sequencer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.Sequencer']"}) + }, + u'experiments.sequencer': { + 'Meta': {'ordering': "['-isdefault', '-active', 'name']", 'object_name': 'Sequencer'}, + 'active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'comment': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'instrument_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'db_index': 'True'}), + 'isdefault': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'db_index': 'True'}), + 'serial_number': ('django.db.models.fields.CharField', [], {'max_length': '50', 'db_index': 'True'}) + }, + u'inventory.item': { + 'Meta': {'object_name': 'Item'}, + 'barcode_id': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'creation_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'force_use_uuid': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'item_info': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['inventory.ItemInfo']"}), + 'item_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['inventory.ItemType']"}), + 'location': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['inventory.Location']"}), + 'modified_date': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'status': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['inventory.ItemStatus']", 'null': 'True', 'blank': 'True'}), + 'uuid': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '32', 'blank': 'True'}) + }, + u'inventory.iteminfo': { + 'Meta': {'object_name': 'ItemInfo'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'lot_number': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'model_id': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'part_number': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'purchase_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'qty_purchased': ('django.db.models.fields.IntegerField', [], {'default': '1'}), + 'url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), + 'vendor': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['inventory.Vendor']"}), + 'warranty_months': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}) + }, + u'inventory.itemstatus': { + 'Meta': {'object_name': 'ItemStatus'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '64'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}) + }, + u'inventory.itemtype': { + 'Meta': {'object_name': 'ItemType'}, + 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '64'}) + }, + u'inventory.location': { + 'Meta': {'object_name': 'Location'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'location_description': ('django.db.models.fields.TextField', [], {}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '256'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'uuid': ('django.db.models.fields.CharField', [], {'max_length': '32', 'blank': 'True'}) + }, + u'inventory.longtermstorage': { + 'Meta': {'object_name': 'LongTermStorage'}, + 'creation_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'flowcell': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.FlowCell']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'libraries': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['samples.Library']", 'symmetrical': 'False'}), + 'modified_date': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}), + 'storage_devices': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['inventory.Item']", 'symmetrical': 'False'}) + }, + u'inventory.printertemplate': { + 'Meta': {'object_name': 'PrinterTemplate'}, + 'default': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'item_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['inventory.ItemType']"}), + 'printer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['bcmagic.Printer']"}), + 'template': ('django.db.models.fields.TextField', [], {}) + }, + u'inventory.reagentflowcell': { + 'Meta': {'object_name': 'ReagentFlowcell'}, + 'creation_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'flowcell': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['experiments.FlowCell']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'modified_date': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}), + 'reagent': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['inventory.Item']", 'symmetrical': 'False'}) + }, + u'inventory.reagentlibrary': { + 'Meta': {'object_name': 'ReagentLibrary'}, + 'creation_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'library': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Library']"}), + 'modified_date': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}), + 'reagent': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['inventory.Item']", 'symmetrical': 'False'}) + }, + u'inventory.vendor': { + 'Meta': {'object_name': 'Vendor'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256'}), + 'url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}) + }, + u'samples.affiliation': { + 'Meta': {'ordering': "['name', 'contact']", 'unique_together': "(('name', 'contact'),)", 'object_name': 'Affiliation'}, + 'contact': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}), + 'users': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': u"orm['samples.HTSUser']", 'null': 'True', 'blank': 'True'}) + }, + u'samples.antibody': { + 'Meta': {'ordering': "['antigene']", 'object_name': 'Antibody'}, + 'antibodies': ('django.db.models.fields.CharField', [], {'max_length': '500', 'db_index': 'True'}), + 'antigene': ('django.db.models.fields.CharField', [], {'max_length': '500', 'db_index': 'True'}), + 'biology': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'catalog': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'source': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '500', 'null': 'True', 'blank': 'True'}) + }, + u'samples.cellline': { + 'Meta': {'ordering': "['cellline_name']", 'object_name': 'Cellline'}, + 'cellline_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}) + }, + u'samples.condition': { + 'Meta': {'ordering': "['condition_name']", 'object_name': 'Condition'}, + 'condition_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2000', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}) + }, + u'samples.experimenttype': { + 'Meta': {'object_name': 'ExperimentType'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '50'}) + }, + u'samples.htsuser': { + 'Meta': {'ordering': "['first_name', 'last_name', 'username']", 'object_name': 'HTSUser', '_ormbases': [u'auth.User']}, + u'user_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': u"orm['auth.User']", 'unique': 'True', 'primary_key': 'True'}) + }, + u'samples.library': { + 'Meta': {'ordering': "['-id']", 'object_name': 'Library'}, + 'account_number': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), + 'affiliations': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'library_affiliations'", 'null': 'True', 'to': u"orm['samples.Affiliation']"}), + 'amplified_from_sample': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'amplified_into_sample'", 'null': 'True', 'to': u"orm['samples.Library']"}), + 'antibody': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Antibody']", 'null': 'True', 'blank': 'True'}), + 'bioanalyzer_concentration': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '5', 'decimal_places': '2', 'blank': 'True'}), + 'bioanalyzer_image_url': ('django.db.models.fields.URLField', [], {'default': "''", 'max_length': '200', 'blank': 'True'}), + 'bioanalyzer_summary': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}), + 'cell_line': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Cellline']", 'null': 'True', 'blank': 'True'}), + 'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Condition']", 'null': 'True', 'blank': 'True'}), + 'creation_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'experiment_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.ExperimentType']"}), + 'gel_cut_size': ('django.db.models.fields.IntegerField', [], {'default': '225', 'null': 'True', 'blank': 'True'}), + 'hidden': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'id': ('django.db.models.fields.CharField', [], {'max_length': '10', 'primary_key': 'True'}), + 'insert_size': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'library_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}), + 'library_species': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Species']"}), + 'library_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.LibraryType']", 'null': 'True', 'blank': 'True'}), + 'made_by': ('django.db.models.fields.CharField', [], {'default': "'Lorian'", 'max_length': '50', 'blank': 'True'}), + 'made_for': ('django.db.models.fields.CharField', [], {'max_length': '50', 'blank': 'True'}), + 'multiplex_id': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}), + 'replicate': ('django.db.models.fields.PositiveSmallIntegerField', [], {'null': 'True', 'blank': 'True'}), + 'stopping_point': ('django.db.models.fields.CharField', [], {'default': "'Done'", 'max_length': '25'}), + 'successful_pM': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '9', 'decimal_places': '1', 'blank': 'True'}), + 'tags': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'library_tags'", 'null': 'True', 'symmetrical': 'False', 'to': u"orm['samples.Tag']"}), + 'ten_nM_dilution': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'undiluted_concentration': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '5', 'decimal_places': '2', 'blank': 'True'}) + }, + u'samples.librarytype': { + 'Meta': {'ordering': "['-id']", 'object_name': 'LibraryType'}, + 'can_multiplex': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_paired_end': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}) + }, + u'samples.species': { + 'Meta': {'ordering': "['scientific_name']", 'object_name': 'Species'}, + 'common_name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'scientific_name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}) + }, + u'samples.tag': { + 'Meta': {'ordering': "['context', 'tag_name']", 'object_name': 'Tag'}, + 'context': ('django.db.models.fields.CharField', [], {'default': "'Library'", 'max_length': '50'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'tag_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'db_index': 'True'}) + } + } + + complete_apps = ['inventory'] \ No newline at end of file diff --git a/htsworkflow/frontend/inventory/migrations/__init__.py b/htsworkflow/frontend/inventory/migrations/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/htsworkflow/frontend/labels/migrations/0001_initial.py b/htsworkflow/frontend/labels/migrations/0001_initial.py new file mode 100644 index 0000000..238b966 --- /dev/null +++ b/htsworkflow/frontend/labels/migrations/0001_initial.py @@ -0,0 +1,86 @@ +# -*- coding: utf-8 -*- +from south.utils import datetime_utils as datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + + +class Migration(SchemaMigration): + + def forwards(self, orm): + # Adding model 'LabelPrinter' + db.create_table(u'labels_labelprinter', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=256)), + ('model', self.gf('django.db.models.fields.CharField')(default='ZM400', max_length=64)), + ('ip_address', self.gf('django.db.models.fields.IPAddressField')(max_length=15)), + ('labels', self.gf('django.db.models.fields.CharField')(max_length=200)), + ('notes', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'labels', ['LabelPrinter']) + + # Adding model 'LabelTemplate' + db.create_table(u'labels_labeltemplate', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=200)), + ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + ('printer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['labels.LabelPrinter'])), + ('ZPL_code', self.gf('django.db.models.fields.TextField')()), + )) + db.send_create_signal(u'labels', ['LabelTemplate']) + + # Adding model 'LabelContent' + db.create_table(u'labels_labelcontent', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('title', self.gf('django.db.models.fields.CharField')(max_length=200, null=True, blank=True)), + ('subtitle', self.gf('django.db.models.fields.CharField')(max_length=200, null=True, blank=True)), + ('text', self.gf('django.db.models.fields.CharField')(max_length=200, null=True, blank=True)), + ('barcode', self.gf('django.db.models.fields.CharField')(max_length=200, null=True, blank=True)), + ('template', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['labels.LabelTemplate'])), + ('creator', self.gf('django.db.models.fields.CharField')(max_length=200)), + )) + db.send_create_signal(u'labels', ['LabelContent']) + + + def backwards(self, orm): + # Deleting model 'LabelPrinter' + db.delete_table(u'labels_labelprinter') + + # Deleting model 'LabelTemplate' + db.delete_table(u'labels_labeltemplate') + + # Deleting model 'LabelContent' + db.delete_table(u'labels_labelcontent') + + + models = { + u'labels.labelcontent': { + 'Meta': {'object_name': 'LabelContent'}, + 'barcode': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), + 'creator': ('django.db.models.fields.CharField', [], {'max_length': '200'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'subtitle': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), + 'template': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['labels.LabelTemplate']"}), + 'text': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), + 'title': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}) + }, + u'labels.labelprinter': { + 'Meta': {'object_name': 'LabelPrinter'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'ip_address': ('django.db.models.fields.IPAddressField', [], {'max_length': '15'}), + 'labels': ('django.db.models.fields.CharField', [], {'max_length': '200'}), + 'model': ('django.db.models.fields.CharField', [], {'default': "'ZM400'", 'max_length': '64'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}) + }, + u'labels.labeltemplate': { + 'Meta': {'object_name': 'LabelTemplate'}, + 'ZPL_code': ('django.db.models.fields.TextField', [], {}), + 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '200'}), + 'printer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['labels.LabelPrinter']"}) + } + } + + complete_apps = ['labels'] \ No newline at end of file diff --git a/htsworkflow/frontend/labels/migrations/__init__.py b/htsworkflow/frontend/labels/migrations/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/htsworkflow/frontend/samples/migrations/0001_initial.py b/htsworkflow/frontend/samples/migrations/0001_initial.py new file mode 100644 index 0000000..8678e3e --- /dev/null +++ b/htsworkflow/frontend/samples/migrations/0001_initial.py @@ -0,0 +1,351 @@ +# -*- coding: utf-8 -*- +from south.utils import datetime_utils as datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + + +class Migration(SchemaMigration): + + def forwards(self, orm): + # Adding model 'Antibody' + db.create_table(u'samples_antibody', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('antigene', self.gf('django.db.models.fields.CharField')(max_length=500, db_index=True)), + ('nickname', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=20, null=True, blank=True)), + ('catalog', self.gf('django.db.models.fields.CharField')(max_length=50, null=True, blank=True)), + ('antibodies', self.gf('django.db.models.fields.CharField')(max_length=500, db_index=True)), + ('source', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=500, null=True, blank=True)), + ('biology', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), + )) + db.send_create_signal(u'samples', ['Antibody']) + + # Adding model 'Cellline' + db.create_table(u'samples_cellline', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('cellline_name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100, db_index=True)), + ('nickname', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=20, null=True, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(blank=True)), + )) + db.send_create_signal(u'samples', ['Cellline']) + + # Adding model 'Condition' + db.create_table(u'samples_condition', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('condition_name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=2000, db_index=True)), + ('nickname', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=20, null=True, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(blank=True)), + )) + db.send_create_signal(u'samples', ['Condition']) + + # Adding model 'ExperimentType' + db.create_table(u'samples_experimenttype', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=50)), + )) + db.send_create_signal(u'samples', ['ExperimentType']) + + # Adding model 'Tag' + db.create_table(u'samples_tag', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('tag_name', self.gf('django.db.models.fields.CharField')(max_length=100, db_index=True)), + ('context', self.gf('django.db.models.fields.CharField')(default='Library', max_length=50)), + )) + db.send_create_signal(u'samples', ['Tag']) + + # Adding model 'Species' + db.create_table(u'samples_species', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('scientific_name', self.gf('django.db.models.fields.CharField')(max_length=256, db_index=True)), + ('common_name', self.gf('django.db.models.fields.CharField')(max_length=256, blank=True)), + )) + db.send_create_signal(u'samples', ['Species']) + + # Adding model 'Affiliation' + db.create_table(u'samples_affiliation', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(max_length=256, db_index=True)), + ('contact', self.gf('django.db.models.fields.CharField')(max_length=256, null=True, blank=True)), + ('email', self.gf('django.db.models.fields.EmailField')(max_length=75, null=True, blank=True)), + )) + db.send_create_signal(u'samples', ['Affiliation']) + + # Adding unique constraint on 'Affiliation', fields ['name', 'contact'] + db.create_unique(u'samples_affiliation', ['name', 'contact']) + + # Adding M2M table for field users on 'Affiliation' + m2m_table_name = db.shorten_name(u'samples_affiliation_users') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('affiliation', models.ForeignKey(orm[u'samples.affiliation'], null=False)), + ('htsuser', models.ForeignKey(orm[u'samples.htsuser'], null=False)) + )) + db.create_unique(m2m_table_name, ['affiliation_id', 'htsuser_id']) + + # Adding model 'LibraryType' + db.create_table(u'samples_librarytype', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255)), + ('is_paired_end', self.gf('django.db.models.fields.BooleanField')(default=True)), + ('can_multiplex', self.gf('django.db.models.fields.BooleanField')(default=True)), + )) + db.send_create_signal(u'samples', ['LibraryType']) + + # Adding model 'MultiplexIndex' + db.create_table(u'samples_multiplexindex', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('adapter_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.LibraryType'])), + ('multiplex_id', self.gf('django.db.models.fields.CharField')(max_length=6)), + ('sequence', self.gf('django.db.models.fields.CharField')(max_length=12, null=True, blank=True)), + )) + db.send_create_signal(u'samples', ['MultiplexIndex']) + + # Adding unique constraint on 'MultiplexIndex', fields ['adapter_type', 'multiplex_id'] + db.create_unique(u'samples_multiplexindex', ['adapter_type_id', 'multiplex_id']) + + # Adding model 'Library' + db.create_table(u'samples_library', ( + ('id', self.gf('django.db.models.fields.CharField')(max_length=10, primary_key=True)), + ('library_name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)), + ('library_species', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Species'])), + ('hidden', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('account_number', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), + ('cell_line', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Cellline'], null=True, blank=True)), + ('condition', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Condition'], null=True, blank=True)), + ('antibody', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.Antibody'], null=True, blank=True)), + ('replicate', self.gf('django.db.models.fields.PositiveSmallIntegerField')(null=True, blank=True)), + ('experiment_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.ExperimentType'])), + ('library_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['samples.LibraryType'], null=True, blank=True)), + ('multiplex_id', self.gf('django.db.models.fields.CharField')(max_length=128, null=True, blank=True)), + ('creation_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), + ('made_for', self.gf('django.db.models.fields.CharField')(max_length=50, blank=True)), + ('made_by', self.gf('django.db.models.fields.CharField')(default='Lorian', max_length=50, blank=True)), + ('stopping_point', self.gf('django.db.models.fields.CharField')(default='Done', max_length=25)), + ('amplified_from_sample', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='amplified_into_sample', null=True, to=orm['samples.Library'])), + ('undiluted_concentration', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=5, decimal_places=2, blank=True)), + ('successful_pM', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=9, decimal_places=1, blank=True)), + ('ten_nM_dilution', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('gel_cut_size', self.gf('django.db.models.fields.IntegerField')(default=225, null=True, blank=True)), + ('insert_size', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), + ('notes', self.gf('django.db.models.fields.TextField')(blank=True)), + ('bioanalyzer_summary', self.gf('django.db.models.fields.TextField')(default='', blank=True)), + ('bioanalyzer_concentration', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=5, decimal_places=2, blank=True)), + ('bioanalyzer_image_url', self.gf('django.db.models.fields.URLField')(default='', max_length=200, blank=True)), + )) + db.send_create_signal(u'samples', ['Library']) + + # Adding M2M table for field affiliations on 'Library' + m2m_table_name = db.shorten_name(u'samples_library_affiliations') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('library', models.ForeignKey(orm[u'samples.library'], null=False)), + ('affiliation', models.ForeignKey(orm[u'samples.affiliation'], null=False)) + )) + db.create_unique(m2m_table_name, ['library_id', 'affiliation_id']) + + # Adding M2M table for field tags on 'Library' + m2m_table_name = db.shorten_name(u'samples_library_tags') + db.create_table(m2m_table_name, ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('library', models.ForeignKey(orm[u'samples.library'], null=False)), + ('tag', models.ForeignKey(orm[u'samples.tag'], null=False)) + )) + db.create_unique(m2m_table_name, ['library_id', 'tag_id']) + + # Adding model 'HTSUser' + db.create_table(u'samples_htsuser', ( + (u'user_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['auth.User'], unique=True, primary_key=True)), + )) + db.send_create_signal(u'samples', ['HTSUser']) + + + def backwards(self, orm): + # Removing unique constraint on 'MultiplexIndex', fields ['adapter_type', 'multiplex_id'] + db.delete_unique(u'samples_multiplexindex', ['adapter_type_id', 'multiplex_id']) + + # Removing unique constraint on 'Affiliation', fields ['name', 'contact'] + db.delete_unique(u'samples_affiliation', ['name', 'contact']) + + # Deleting model 'Antibody' + db.delete_table(u'samples_antibody') + + # Deleting model 'Cellline' + db.delete_table(u'samples_cellline') + + # Deleting model 'Condition' + db.delete_table(u'samples_condition') + + # Deleting model 'ExperimentType' + db.delete_table(u'samples_experimenttype') + + # Deleting model 'Tag' + db.delete_table(u'samples_tag') + + # Deleting model 'Species' + db.delete_table(u'samples_species') + + # Deleting model 'Affiliation' + db.delete_table(u'samples_affiliation') + + # Removing M2M table for field users on 'Affiliation' + db.delete_table(db.shorten_name(u'samples_affiliation_users')) + + # Deleting model 'LibraryType' + db.delete_table(u'samples_librarytype') + + # Deleting model 'MultiplexIndex' + db.delete_table(u'samples_multiplexindex') + + # Deleting model 'Library' + db.delete_table(u'samples_library') + + # Removing M2M table for field affiliations on 'Library' + db.delete_table(db.shorten_name(u'samples_library_affiliations')) + + # Removing M2M table for field tags on 'Library' + db.delete_table(db.shorten_name(u'samples_library_tags')) + + # Deleting model 'HTSUser' + db.delete_table(u'samples_htsuser') + + + models = { + u'auth.group': { + 'Meta': {'object_name': 'Group'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}), + 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}) + }, + u'auth.permission': { + 'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'}, + 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) + }, + u'auth.user': { + 'Meta': {'object_name': 'User'}, + 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Group']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}), + 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Permission']"}), + 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) + }, + u'contenttypes.contenttype': { + 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"}, + 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}) + }, + u'samples.affiliation': { + 'Meta': {'ordering': "['name', 'contact']", 'unique_together': "(('name', 'contact'),)", 'object_name': 'Affiliation'}, + 'contact': ('django.db.models.fields.CharField', [], {'max_length': '256', 'null': 'True', 'blank': 'True'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}), + 'users': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': u"orm['samples.HTSUser']", 'null': 'True', 'blank': 'True'}) + }, + u'samples.antibody': { + 'Meta': {'ordering': "['antigene']", 'object_name': 'Antibody'}, + 'antibodies': ('django.db.models.fields.CharField', [], {'max_length': '500', 'db_index': 'True'}), + 'antigene': ('django.db.models.fields.CharField', [], {'max_length': '500', 'db_index': 'True'}), + 'biology': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'catalog': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'source': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '500', 'null': 'True', 'blank': 'True'}) + }, + u'samples.cellline': { + 'Meta': {'ordering': "['cellline_name']", 'object_name': 'Cellline'}, + 'cellline_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}) + }, + u'samples.condition': { + 'Meta': {'ordering': "['condition_name']", 'object_name': 'Condition'}, + 'condition_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2000', 'db_index': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nickname': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}) + }, + u'samples.experimenttype': { + 'Meta': {'object_name': 'ExperimentType'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '50'}) + }, + u'samples.htsuser': { + 'Meta': {'ordering': "['first_name', 'last_name', 'username']", 'object_name': 'HTSUser', '_ormbases': [u'auth.User']}, + u'user_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': u"orm['auth.User']", 'unique': 'True', 'primary_key': 'True'}) + }, + u'samples.library': { + 'Meta': {'ordering': "['-id']", 'object_name': 'Library'}, + 'account_number': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), + 'affiliations': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'library_affiliations'", 'null': 'True', 'to': u"orm['samples.Affiliation']"}), + 'amplified_from_sample': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'amplified_into_sample'", 'null': 'True', 'to': u"orm['samples.Library']"}), + 'antibody': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Antibody']", 'null': 'True', 'blank': 'True'}), + 'bioanalyzer_concentration': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '5', 'decimal_places': '2', 'blank': 'True'}), + 'bioanalyzer_image_url': ('django.db.models.fields.URLField', [], {'default': "''", 'max_length': '200', 'blank': 'True'}), + 'bioanalyzer_summary': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}), + 'cell_line': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Cellline']", 'null': 'True', 'blank': 'True'}), + 'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Condition']", 'null': 'True', 'blank': 'True'}), + 'creation_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'experiment_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.ExperimentType']"}), + 'gel_cut_size': ('django.db.models.fields.IntegerField', [], {'default': '225', 'null': 'True', 'blank': 'True'}), + 'hidden': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'id': ('django.db.models.fields.CharField', [], {'max_length': '10', 'primary_key': 'True'}), + 'insert_size': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'library_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}), + 'library_species': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.Species']"}), + 'library_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.LibraryType']", 'null': 'True', 'blank': 'True'}), + 'made_by': ('django.db.models.fields.CharField', [], {'default': "'Lorian'", 'max_length': '50', 'blank': 'True'}), + 'made_for': ('django.db.models.fields.CharField', [], {'max_length': '50', 'blank': 'True'}), + 'multiplex_id': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}), + 'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}), + 'replicate': ('django.db.models.fields.PositiveSmallIntegerField', [], {'null': 'True', 'blank': 'True'}), + 'stopping_point': ('django.db.models.fields.CharField', [], {'default': "'Done'", 'max_length': '25'}), + 'successful_pM': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '9', 'decimal_places': '1', 'blank': 'True'}), + 'tags': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'library_tags'", 'null': 'True', 'symmetrical': 'False', 'to': u"orm['samples.Tag']"}), + 'ten_nM_dilution': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'undiluted_concentration': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '5', 'decimal_places': '2', 'blank': 'True'}) + }, + u'samples.librarytype': { + 'Meta': {'ordering': "['-id']", 'object_name': 'LibraryType'}, + 'can_multiplex': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_paired_end': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}) + }, + u'samples.multiplexindex': { + 'Meta': {'unique_together': "(('adapter_type', 'multiplex_id'),)", 'object_name': 'MultiplexIndex'}, + 'adapter_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['samples.LibraryType']"}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'multiplex_id': ('django.db.models.fields.CharField', [], {'max_length': '6'}), + 'sequence': ('django.db.models.fields.CharField', [], {'max_length': '12', 'null': 'True', 'blank': 'True'}) + }, + u'samples.species': { + 'Meta': {'ordering': "['scientific_name']", 'object_name': 'Species'}, + 'common_name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'scientific_name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}) + }, + u'samples.tag': { + 'Meta': {'ordering': "['context', 'tag_name']", 'object_name': 'Tag'}, + 'context': ('django.db.models.fields.CharField', [], {'default': "'Library'", 'max_length': '50'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'tag_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'db_index': 'True'}) + } + } + + complete_apps = ['samples'] \ No newline at end of file diff --git a/htsworkflow/frontend/samples/migrations/__init__.py b/htsworkflow/frontend/samples/migrations/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/htsworkflow/settings.py b/htsworkflow/settings.py index dce3d90..34f830d 100644 --- a/htsworkflow/settings.py +++ b/htsworkflow/settings.py @@ -42,6 +42,7 @@ INSTALLED_APPS = ( 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', + 'south', 'htsworkflow.frontend.eland_config', 'htsworkflow.frontend.samples',