Postgresql has referential integrety checking.
[htsworkflow.git] / htsworkflow / frontend / samples / fixtures / test_samples.json
index dba08b6626de4185298f4826a8834b6a9a3cac9d..41824e065a149215bfaf5d656cc2f23ae9576f94 100644 (file)
@@ -1,5 +1,5 @@
 [
-  {"pk": 5, "model": "auth.user", 
+  {"pk": 5, "model": "auth.user",
    "fields": {
        "username": "test",
        "first_name": "",
        "is_active": true,
        "is_superuser": false,
        "is_staff": false,
-       "last_login": "2009-01-01 00:00:01",
+       "last_login": "2009-01-01T00:00:01-0800",
        "groups": [],
        "user_permissions": [],
        "password": "sha1$foo$5e4eefec1144a04becfb7da79244f07c487fc345",
        "email": "",
-       "date_joined": "2009-01-01 00:01:01"
+       "date_joined": "2009-01-01T00:01:01-0800"
        }
    },
-  {"pk": 10984, "model": "samples.library", 
+   {"pk": 1, "model": "samples.affiliation",
+    "fields": {
+        "users": [5],
+        "name": "Alice",
+        "contact": "Lab Boss",
+        "email": "alice@some.where.else."
+        }
+    },
+    {"pk": 2, "model": "samples.affiliation",
+     "fields": { "name": "Bob",
+                 "contact": "Other Lab Boss",
+                 "email": "bob@some.where.else"
+               }
+    },
+    {"pk": 3, "model": "samples.affiliation",
+     "fields": {
+         "users": [],
+         "contact": "group 3",
+         "name": "affiliation 3",
+         "email": "pk3@example.com"
+         }
+     },
+    {"pk": 4, "model": "samples.affiliation",
+     "fields": {
+         "users": [],
+         "contact": "group 4",
+         "name": "affiliation 4",
+         "email": "pk1@example.com"
+         }
+     },
+    {"pk": 5, "model": "samples.affiliation",
+     "fields": {
+         "users": [],
+         "contact": "group 5",
+         "name": "affiliation 5",
+         "email": "pk5@example.com"
+         }
+     },
+ {"pk": 153, "model": "experiments.flowcell",
+  "fields": {
+      "paired_end": true,
+      "run_date": "2009-09-11T22:12:13-0800",
+      "read_length": 75,
+      "notes": "",
+      "advanced_run": false,
+      "control_lane": 2,
+      "cluster_station": 3,
+      "sequencer": 2,
+      "flowcell_id": "303TUAAXX"
+      }
+  },
+  {"pk": 1193, "model": "experiments.lane",
+   "fields": {
+       "comment": "No change in cluster numbers, despite slight increase in pM",
+       "library": "10981",
+       "cluster_estimate": 129000,
+       "flowcell": 153,
+       "lane_number": 1,
+       "pM": "8"
+       }
+   },
+  {"pk": 1197, "model": "experiments.lane",
+   "fields": {
+       "comment": "stuff",
+       "library": "11016",
+       "cluster_estimate": 140000,
+       "flowcell": 153,
+       "lane_number": 5,
+       "pM": "7",
+       "status": 2
+       }
+   },
+  {"pk": "10981", "model": "samples.library",
         "fields": {
-            "library_id": "10981", 
-            "ten_nM_dilution": false, 
-            "avg_lib_size": 400, 
-            "library_name": "Paired End Multiplexed Sp-BAC", 
-            "creation_date": "2009-07-21", 
-            "cell_line": 1, 
-            "library_species": 2, 
-            "library_type": null, 
-            "made_by": "Igor", 
+            "ten_nM_dilution": false,
+            "gel_cut_size": 400,
+            "library_name": "Paired End Multiplexed Sp-BAC",
+            "creation_date": "2009-07-21",
+            "cell_line": 1,
+            "library_species": 2,
+            "library_type": null,
+            "made_by": "Igor",
             "affiliations": [
-                40
-            ], 
-            "replicate": 1, 
-            "condition": 1, 
-            "hidden": false, 
-            "stopping_point": "Done", 
-            "tags": [], 
-            "made_for": "Andy Cameron", 
-            "amplified_from_sample": null, 
-            "notes": "Combined 10957-10968", 
-            "undiluted_concentration": "5.1", 
-            "successful_pM": null, 
-            "experiment_type": 10, 
+                2
+            ],
+            "replicate": 1,
+            "condition": 1,
+            "hidden": false,
+            "stopping_point": "Done",
+            "tags": [],
+            "made_for": "Andy Cameron",
+            "amplified_from_sample": null,
+            "notes": "Combined 10957-10968",
+            "undiluted_concentration": "5.1",
+            "successful_pM": null,
+            "experiment_type": 10,
             "antibody": null
         }
-    }, 
+    },
+    {
+        "pk": "11016",
+        "model": "samples.library",
+        "fields": {
+            "ten_nM_dilution": false,
+            "gel_cut_size": 325,
+            "library_name": "Paired End Pfl #3 MP 7/24/9 a",
+            "creation_date": "2009-08-06",
+            "cell_line": 1,
+            "library_species": 9,
+            "library_type": 2,
+            "made_by": "Lorian",
+            "affiliations": [
+                3
+            ],
+            "replicate": 1,
+            "condition": 1,
+            "hidden": false,
+            "stopping_point": "1Aa",
+            "tags": [],
+            "made_for": "",
+            "amplified_from_sample": "11003",
+            "notes": "7/31/2009 16:08:22\tColor: Blue",
+            "undiluted_concentration": "35.5",
+            "successful_pM": null,
+            "experiment_type": 8,
+            "antibody": null
+        }
+    },
     {
-        "pk": 11019, 
-        "model": "samples.library", 
+        "pk": "11039",
+        "model": "samples.library",
         "fields": {
-            "library_id": "11016", 
-            "ten_nM_dilution": false, 
-            "avg_lib_size": 325, 
-            "library_name": "Paired End Pfl #3 MP 7/24/9 a", 
-            "creation_date": "2009-08-06", 
-            "cell_line": 1, 
-            "library_species": 1, 
-            "library_type": 2, 
-            "made_by": "Lorian", 
+            "ten_nM_dilution": false,
+            "gel_cut_size": 300,
+            "library_name": "Paired ends 99 GM12892",
+            "creation_date": "2009-08-25",
+            "cell_line": 1,
+            "library_species": 8,
+            "library_type": 2,
+            "made_by": "Brian Williams",
             "affiliations": [
-                41
-            ], 
-            "replicate": 1, 
-            "condition": 1, 
-            "hidden": false, 
-            "stopping_point": "1Aa", 
-            "tags": [], 
-            "made_for": "", 
-            "amplified_from_sample": 11006, 
-            "notes": "7/31/2009 16:08:22\tColor: Blue", 
-            "undiluted_concentration": "35.5", 
-            "successful_pM": null, 
-            "experiment_type": 8, 
+                1,
+                2,
+                4
+            ],
+            "replicate": 1,
+            "condition": 1,
+            "hidden": false,
+            "stopping_point": "1Aa",
+            "tags": [],
+            "made_for": "Brian Williams",
+            "amplified_from_sample": null,
+            "notes": "fragment size = 300 bp, Amicon filtered\r\nnanodrop: 56.3",
+            "undiluted_concentration": "28.7",
+            "successful_pM": null,
+            "experiment_type": 4,
             "antibody": null
         }
-    }, 
+    },
     {
-        "pk": 11042, 
-        "model": "samples.library", 
+        "pk": "11003",
+        "model": "samples.library",
         "fields": {
-            "library_id": "11039", 
-            "ten_nM_dilution": false, 
-            "avg_lib_size": 300, 
-            "library_name": "Paired ends 99 GM12892", 
-            "creation_date": "2009-08-25", 
-            "cell_line": 1, 
-            "library_species": 8, 
-            "library_type": 2, 
-            "made_by": "Brian Williams", 
+            "ten_nM_dilution": false,
+            "gel_cut_size": 325,
+            "library_name": "Paired End Pfl #3 MP 7/24/9",
+            "creation_date": "2009-08-05",
+            "cell_line": 1,
+            "library_species": 8,
+            "library_type": 2,
+            "made_by": "Lorian",
             "affiliations": [
-                4, 
-                8, 
-                12
-            ], 
-            "replicate": 1, 
-            "condition": 1, 
-            "hidden": false, 
-            "stopping_point": "1Aa", 
-            "tags": [], 
-            "made_for": "Brian Williams", 
-            "amplified_from_sample": null, 
-            "notes": "fragment size = 300 bp, Amicon filtered\r\nnanodrop: 56.3", 
-            "undiluted_concentration": "28.7", 
-            "successful_pM": null, 
-            "experiment_type": 4, 
+                4
+            ],
+            "replicate": 1,
+            "condition": 1,
+            "hidden": true,
+            "stopping_point": "1A",
+            "tags": [],
+            "made_for": "",
+            "amplified_from_sample": null,
+            "notes": "7/31/2009 16:08:22\tColor: Blue",
+            "undiluted_concentration": null,
+            "successful_pM": null,
+            "experiment_type": 8,
             "antibody": null
         }
     },
     {
-        "pk": 11006, 
-        "model": "samples.library", 
+        "pk": "11005",
+        "model": "samples.library",
         "fields": {
-            "library_id": "11003", 
-            "ten_nM_dilution": false, 
-            "avg_lib_size": 325, 
-            "library_name": "Paired End Pfl #3 MP 7/24/9", 
-            "creation_date": "2009-08-05", 
-            "cell_line": 1, 
-            "library_species": 1, 
-            "library_type": 2, 
-            "made_by": "Lorian", 
+            "ten_nM_dilution": false,
+            "gel_cut_size": 325,
+            "library_name": "null cell line",
+            "creation_date": "2009-08-05",
+            "cell_line": null,
+            "library_species": 8,
+            "library_type": 2,
+            "made_by": "Lorian",
             "affiliations": [
-                41
-            ], 
-            "replicate": 1, 
-            "condition": 1, 
-            "hidden": true, 
-            "stopping_point": "1A", 
-            "tags": [], 
-            "made_for": "", 
-            "amplified_from_sample": null, 
-            "notes": "7/31/2009 16:08:22\tColor: Blue", 
-            "undiluted_concentration": null, 
-            "successful_pM": null, 
-            "experiment_type": 8, 
+                4
+            ],
+            "replicate": 1,
+            "condition": 1,
+            "hidden": true,
+            "stopping_point": "1A",
+            "tags": [],
+            "made_for": "",
+            "amplified_from_sample": null,
+            "notes": "7/31/2009 16:08:22\tColor: Blue",
+            "undiluted_concentration": null,
+            "successful_pM": null,
+            "experiment_type": 8,
             "antibody": null
         }
     }