Postgresql has referential integrety checking.
[htsworkflow.git] / htsworkflow / frontend / inventory / fixtures / test_harddisks.json
1 [
2  {"pk": 1,
3   "model": "bcmagic.printer",
4   "fields": {"name": "ZM400 1.25x1",
5              "label_height": 1.0,
6              "notes": "Everyday use labels",
7              "label_width": 1.25,
8              "label_shape": "Square",
9              "model": "Zebra ZM400",
10              "ip_address": "131.215.34.116"}},
11  {"pk": 2,
12   "model": "bcmagic.printer",
13   "fields": {"name": "ZM400 3x3",
14              "label_height": 3.0,
15              "notes": "Larger everyday use labels",
16              "label_width": 3.0,
17              "label_shape": "Square",
18              "model": "Zebra ZM400",
19              "ip_address": "131.215.34.117"}},
20   { "model": "experiments.Sequencer",
21     "pk": 7,
22     "fields": {
23       "name": "First sequencer",
24       "instrument_name": "USI-EAS99",
25       "serial_number": "",
26       "model": "Illumina Genome Analyzer I",
27       "active": false,
28       "isdefault": false,
29       "comment": "my first sequencer"
30     }
31   },
32   { "model": "experiments.ClusterStation",
33     "pk": 1,
34     "fields": {
35       "name": "Station",
36       "isdefault": true
37     }
38   },
39   {
40     "pk": 1,
41     "model": "inventory.vendor",
42     "fields": {
43       "url": "http://www.newegg.com/",
44       "name": "newegg.com"
45     }
46   },
47   {
48     "pk": 1,
49     "model": "inventory.location",
50     "fields": {
51       "uuid": "e344a4a2522211de99b00015172ce556",
52       "notes": "",
53       "location_description": "Office 1",
54       "name": "Dev Office"
55     }
56   },
57   {
58     "pk": 1,
59     "model": "inventory.iteminfo",
60     "fields": {
61       "model_id": "WD10EADS-00L5B1",
62       "vendor": 1,
63       "lot_number": "",
64       "url": "http://www.newegg.com/Product/Product.aspx?Item=N82E16822136317&Tpk=WD10EADS",
65       "warranty_months": 24,
66       "notes": "",
67       "part_number": "",
68       "purchase_date": "2009-05-19",
69       "qty_purchased": 17
70     }
71   },
72   {
73     "pk": 1,
74     "model": "inventory.itemtype",
75     "fields": {
76       "name": "Hard Drive",
77       "description": null
78     }
79   },
80   {
81     "pk": 1,
82     "model": "inventory.itemstatus",
83     "fields": {
84       "notes": "",
85       "name": "Used"
86     }
87   },
88   {
89     "pk": 2,
90     "model": "inventory.itemstatus",
91     "fields": {
92       "notes": "",
93       "name": "Unused"
94     }
95   },
96   {
97     "pk": 1,
98     "model": "inventory.item",
99     "fields": {
100       "status": null,
101       "modified_date": "2009-08-10T16:58:44-0800",
102       "uuid": "8a90b6ce522311de99b00015172ce556",
103       "barcode_id": "WCAU49183397",
104       "notes": "",
105       "item_info": 1,
106       "force_use_uuid": false,
107       "item_type": 1,
108       "location": 1,
109       "creation_date": "2009-06-05T15:52:26-0800"
110     }
111   },
112   {
113     "pk": 2,
114     "model": "inventory.item",
115     "fields": {
116       "status": null,
117       "modified_date": "2009-06-16T11:38:24-0800",
118       "uuid": "b0792d425aa411de99b00015172ce556",
119       "barcode_id": "WCAU49042470",
120       "notes": "",
121       "item_info": 1,
122       "force_use_uuid": false,
123       "item_type": 1,
124       "location": 1,
125       "creation_date": "2009-06-16T11:37:04-0800"
126     }
127   },
128   {
129     "pk": 1,
130     "model": "inventory.printertemplate",
131     "fields": {
132       "default": false,
133       "item_type": 1,
134       "printer": 2,
135       "template": "^FX=========================\r\n^FX 3\"x3\" Label\r\n^FX=========================\r\n^XA\r\n\r\n\r\n^FX======== Left Side ===========\r\n\r\n^FX------------\r\n^FX ^LH changes the 0,0 point of all subsequent location references\r\n^FX------------\r\n\r\n^LH0,50\r\n\r\n^FX ---Header---\r\n\r\n^FO25,0\r\n^CF0,50\r\n^FB250,2,,C\r\n^FD{{ item.barcode_id }}^FS\r\n\r\n^FX ---Column 1: Flowcells---\r\n\r\n^FX-----------------\r\n^FX FB command for automatic text formatting:\r\n^FX ^FB[dot width of area], [max # of lines], [change line spacing], [justification: L, C, R, J], [hanging indent]\r\n^FX-----------------\r\n\r\n^CF0,30,30\r\n^FO75,125\r\n^FB275,19,,L\r\n^FD{% for flowcell in flowcell_id_list %}{{ flowcell }}{% if not forloop.last %}\\&{% endif %}{% endfor %}^FS\r\n^FX ---Date---\r\n\r\n^FO0,725\r\n^CF0,35\r\n^FB300,2,,C\r\n^FD{{ oldest_rundate|date:\"YMd\" }} - {{ latest_rundate|date:\"YMd\" }}^FS\r\n\r\n^FX ---Barcode---\r\n\r\n^FO135,795\r\n^BXN,3,200^FDinvb|{{ item.barcode_id }}^FS\r\n\r\n^FX======== Right Side ===========\r\n\r\n^LH300,60\r\n\r\n^FX ---Header---\r\n\r\n^FO0,0\r\n^CF0,50\r\n^FB600,2,,C\r\n^FD{{ barcode_id }}^FS\r\n\r\n^FX ---Dividing line---\r\n\r\n^FX---------------\r\n^FX GB command:\r\n^FX ^GB[box width], [box height], [border thickness], [color: B, W], [corner rounding: 0-8]^FS\r\n^FX---------------\r\n\r\n^FO0,100\r\n^GB0,600,10^FS\r\n\r\n^FX ---Column 2: Libraries 1-20---\r\n\r\n^CF0,30,30\r\n^FO75,100\r\n^FB100,20,,L\r\n^FD{% for lib_id in library_id_list_1_to_20 %}{{ lib_id }}{% if not forloop.last %}\\&{% endif %}{% endfor %}^FS\r\n\r\n^FX ---Column 3: Libraries 21-40---\r\n\r\n^CF0,30,30\r\n^FO200,100\r\n^FB100,20,,L\r\n^FD{% for lib_id in library_id_list_21_to_40 %}{{ lib_id }}{% if not forloop.last %}\\&{% endif %}{% endfor %}^FS\r\n\r\n^FX ---Column 4: Libraries 41-60---\r\n\r\n^CF0,30,30\r\n^FO325,100\r\n^FB100,20,,L\r\n^FD{% for lib_id in library_id_list_41_to_60 %}{{ lib_id }}{% if not forloop.last %}\\&{% endif %}{% endfor %}^FS\r\n\r\n^FX ---Column 5: Libraries 61-80---\r\n\r\n^CF0,30,30\r\n^FO450,100\r\n^FB100,20,,L\r\n^FD{% for lib_id in library_id_list_61_to_80 %}{{ lib_id }}{% if not forloop.last %}\\&{% endif %}{% endfor %}^FS\r\n\r\n^FX ---Date---\r\n\r\n^FO0,715\r\n^CF0,35\r\n^FB600,2,,C\r\n^FDRun Dates: {{ oldest_rundate|date:\"YMd\" }}-{{ latest_rundate|date:\"YMd\" }}^FS\r\n\r\n^FX ---Barcode---\r\n\r\n^FO255,785\r\n^BXN,3,200^FDinvb|{{ item.barcode_id }}^FS\r\n\r\n^LH0,0\r\n^FX ---End---\r\n^XZ\r\n"
136     }
137   },
138   {
139     "pk": 2,
140     "model": "inventory.printertemplate",
141     "fields": {
142       "default": true,
143       "item_type": 2,
144       "printer": 1,
145       "template": "^FX=========================\r\n^FX Harddrive Location Tracking Label\r\n^FX 300x375 dots\r\n^FX=========================\r\n\r\n^XA\r\n^LH 0,25\r\n\r\n^FO0,0\r\n^CF0,35\r\n^FB375,1,,C\r\n^FD{{ item.item_type.name }}:^FS\r\n\r\n^FX -------Text contains HD serial #-------------\r\n^FO15,75\r\n^CF0,42\r\n^FB325,3,,C\r\n^FD{% if use_uuid %}{{ item.uuid }}{% else %}{{ item.barcode_id }}{% endif %}^FS\r\n\r\n^FX -------Barcode contains HD serial #-----------\r\n^FO150,200\r\n^BXN,3,200\r\n^FD{% if use_uuid %}invu|{{ item.uuid }}{% else %}invb|{{ item.barcode_id }}{% endif %}^FS\r\n\r\n^XZ\r\n"
146     }
147   },
148   {
149     "pk": 3,
150     "model": "inventory.printertemplate",
151     "fields": {
152       "default": false,
153       "item_type": 6,
154       "printer": 1,
155       "template": "^XA\r\n\r\n^FX ---SIDE LABEL---\r\n^LH 190,40\r\n^CF 0,30\r\n\r\n^FX------Sideways ID------\r\n^FO 0,25\r\n^TB R,100,40\r\n^FD{{ library.id }}^FS\r\n^FX------Sideways Line------\r\n^FO 50,0\r\n^GB 5,200,5^FS\r\n\r\n^FX-------Name----------\r\n^FO 65,20\r\n^FB 325,4\r\n^FD{{ library.library_name }}^FS\r\n\r\n^FX ---TOP LABEL---\r\n^LH 12,28\r\n^CF 0,30\r\n\r\n^FX----ID #----\r\n^FO 5,25\r\n^FB 145,1,,C\r\n^FD{{ library.id }}^FS\r\n\r\n^FX----Name----\r\n^CF 0,16\r\n^FO 13,47\r\n^TB N,130,30\r\n^FD{{ library.library_name }}^FS\r\n\r\n^FX--------Barcode--------\r\n^FO 50,80\r\n^BXN ,3,200\r\n^FDl|0000000{{ library.id }}|woldlab^FS\r\n\r\n{% if not library.hidden %}\r\n^FX-----Border-------\r\n^FO 0,0\r\n^GC 150,10\r\n^FX ---End---\r\n{% endif %}\r\n^XZ\r\n"
156     }
157   },
158   {
159     "pk": 1,
160     "model": "inventory.longtermstorage",
161     "fields": {
162       "libraries": [
163         "10001",
164         "10002",
165         "10003"
166       ],
167       "modified_date": "2009-06-01T00:00:00-0800",
168       "storage_devices": [
169         1
170       ],
171       "flowcell": 1,
172       "creation_date": "2009-06-01T00:00:00-0800"
173     }
174   },
175   {
176     "pk": 2,
177     "model": "inventory.longtermstorage",
178     "fields": {
179       "libraries": [
180         "10001",
181         "10002",
182         "10003"
183       ],
184       "modified_date": "2009-06-01T00:00:00-0800",
185       "storage_devices": [
186         1
187       ],
188       "flowcell": 2,
189       "creation_date": "2009-06-01T00:00:00-0800"
190     }
191   },
192  {"pk": 1, "model": "experiments.flowcell",
193   "fields": {
194       "paired_end": true,
195       "run_date": "2009-09-11T22:12:13-0800",
196       "read_length": 75,
197       "notes": "",
198       "advanced_run": false,
199       "control_lane": 2,
200       "flowcell_id": "11ONEAAXX"
201       }
202   },
203   {"pk": 2, "model": "experiments.flowcell",
204   "fields": {
205       "paired_end": false,
206       "run_date": "2010-09-11T22:12:13-0800",
207       "read_length": 75,
208       "notes": "",
209       "advanced_run": false,
210       "control_lane": 2,
211       "flowcell_id": "22TWOAAXX"
212       }
213   },
214   {"pk": 3, "model": "experiments.flowcell",
215   "fields": {
216       "paired_end": false,
217       "run_date": "2010-09-11T22:12:13-0800",
218       "read_length": 75,
219       "notes": "",
220       "advanced_run": false,
221       "control_lane": 2,
222       "flowcell_id": "33THRAAXX (failed)"
223       }
224   },
225   {"pk": "10001", "model": "samples.library",
226         "fields": {
227             "ten_nM_dilution": false,
228             "gel_cut_size": 400,
229             "library_name": "10001",
230             "creation_date": "2009-07-21",
231             "cell_line": 1,
232             "library_species": 2,
233             "library_type": null,
234             "made_by": "Igor",
235             "affiliations": [
236                 1
237             ],
238             "replicate": 1,
239             "condition": 1,
240             "hidden": false,
241             "stopping_point": "Done",
242             "tags": [],
243             "made_for": "Test",
244             "amplified_from_sample": null,
245             "notes": "",
246             "undiluted_concentration": "1",
247             "successful_pM": null,
248             "experiment_type": 10,
249             "antibody": null
250         }
251     },
252   {"pk": "10002", "model": "samples.library",
253         "fields": {
254             "ten_nM_dilution": false,
255             "gel_cut_size": 400,
256             "library_name": "10002",
257             "creation_date": "2009-07-21",
258             "cell_line": 1,
259             "library_species": 2,
260             "library_type": null,
261             "made_by": "Igor",
262             "affiliations": [
263                 1
264             ],
265             "replicate": 1,
266             "condition": 1,
267             "hidden": false,
268             "stopping_point": "Done",
269             "tags": [],
270             "made_for": "Test",
271             "amplified_from_sample": null,
272             "notes": "",
273             "undiluted_concentration": "1",
274             "successful_pM": null,
275             "experiment_type": 10,
276             "antibody": null
277         }
278     },
279   {"pk": "10003", "model": "samples.library",
280         "fields": {
281             "ten_nM_dilution": false,
282             "gel_cut_size": 400,
283             "library_name": "10003",
284             "creation_date": "2009-07-21",
285             "cell_line": 1,
286             "library_species": 2,
287             "library_type": null,
288             "made_by": "Igor",
289             "affiliations": [
290                 1
291             ],
292             "replicate": 1,
293             "condition": 1,
294             "hidden": false,
295             "stopping_point": "Done",
296             "tags": [],
297             "made_for": "Test",
298             "amplified_from_sample": null,
299             "notes": "",
300             "undiluted_concentration": "1",
301             "successful_pM": null,
302             "experiment_type": 10,
303             "antibody": null
304         }
305     },
306   {"pk": 1, "model": "experiments.lane",
307    "fields": {
308        "comment": "10001 lane 1",
309        "library": "10001",
310        "cluster_estimate": 100000,
311        "flowcell": 1,
312        "lane_number": 1,
313        "pM": "8"
314        }
315    },
316   {"pk": 2, "model": "experiments.lane",
317    "fields": {
318        "comment": "10002 lane 2",
319        "library": "10002",
320        "cluster_estimate": 100000,
321        "flowcell": 1,
322        "lane_number": 2,
323        "pM": "8"
324        }
325    },
326   {"pk": 3, "model": "experiments.lane",
327    "fields": {
328        "comment": "10003 lane 3",
329        "library": "10003",
330        "cluster_estimate": 100000,
331        "flowcell": 1,
332        "lane_number": 3,
333        "pM": "8"
334        }
335    },
336   {"pk": 4, "model": "experiments.lane",
337    "fields": {
338        "comment": "10004 lane 4",
339        "library": "10001",
340        "cluster_estimate": 100000,
341        "flowcell": 2,
342        "lane_number": 4,
343        "pM": "8"
344        }
345    },
346   {"pk": 5, "model": "experiments.lane",
347    "fields": {
348        "comment": "10001 lane 1",
349        "library": "10001",
350        "cluster_estimate": 100000,
351        "flowcell": 2,
352        "lane_number": 1,
353        "pM": "8"
354        }
355    },
356   {"pk": 6, "model": "experiments.lane",
357    "fields": {
358        "comment": "10001 lane 1",
359        "library": "10003",
360        "cluster_estimate": 100000,
361        "flowcell": 2,
362        "lane_number": 2,
363        "pM": "8"
364        }
365    },
366   {"pk": 7, "model": "experiments.lane",
367    "fields": {
368        "comment": "10003 lane 8",
369        "library": "10003",
370        "cluster_estimate": 100000,
371        "flowcell": 2,
372        "lane_number": 8,
373        "pM": "8"
374        }
375    },
376   {"pk": 8, "model": "experiments.lane",
377    "fields": {
378        "comment": "10002 lane 8",
379        "library": "10001",
380        "cluster_estimate": 100000,
381        "flowcell": 2,
382        "lane_number": 8,
383        "pM": "8"
384        }
385    },
386   {"pk": 9, "model": "experiments.lane",
387    "fields": {
388        "comment": "10004 lane 4",
389        "library": "10001",
390        "cluster_estimate": 100000,
391        "flowcell": 3,
392        "lane_number": 4,
393        "pM": "8"
394        }
395    },
396   {"pk": 10, "model": "experiments.lane",
397    "fields": {
398        "comment": "10001 lane 1",
399        "library": "10001",
400        "cluster_estimate": 100000,
401        "flowcell": 3,
402        "lane_number": 1,
403        "pM": "8"
404        }
405    },
406   {"pk": 11, "model": "experiments.lane",
407    "fields": {
408        "comment": "10001 lane 1",
409        "library": "10003",
410        "cluster_estimate": 100000,
411        "flowcell": 3,
412        "lane_number": 2,
413        "pM": "8"
414        }
415    },
416   {"pk": 12, "model": "experiments.lane",
417    "fields": {
418        "comment": "10003 lane 8",
419        "library": "10003",
420        "cluster_estimate": 100000,
421        "flowcell": 3,
422        "lane_number": 8,
423        "pM": "8"
424        }
425    },
426   {"pk": 13, "model": "experiments.lane",
427    "fields": {
428        "comment": "10002 lane 8",
429        "library": "10001",
430        "cluster_estimate": 100000,
431        "flowcell": 3,
432        "lane_number": 8,
433        "pM": "8"
434        }
435    }
436 ]