From 1bb3590ba78cd0efe7fad0f5a112cf33b2014f75 Mon Sep 17 00:00:00 2001 From: Diane Trout Date: Thu, 21 May 2015 16:13:15 -0700 Subject: [PATCH] load in our encode3 accession numbers seperately from the migration system --- docs/load_accessions.py | 386 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 386 insertions(+) create mode 100644 docs/load_accessions.py diff --git a/docs/load_accessions.py b/docs/load_accessions.py new file mode 100644 index 0000000..601d9a1 --- /dev/null +++ b/docs/load_accessions.py @@ -0,0 +1,386 @@ +"""We have many accessions for our libraries, + +our data isn't really part of the htsworkflow project +so it seemed unnecessary to put it in the normal migrations +""" +from datetime import datetime +import os +import socket + +from samples.models import ( + AccessionAgency, + Library, + LibraryAccession +) + + +def load_encode3_accessions(): + data = [ + ('15499', 'ENCLB217DSV', '2015-03-27T22:01:46.051760+0000'), + ('15500', 'ENCLB159SLV', '2015-03-27T22:01:46.609807+0000'), + ('15497', 'ENCLB169SNA', '2015-03-27T22:01:44.903888+0000'), + ('15498', 'ENCLB459OYG', '2015-03-27T22:01:45.457150+0000'), + ('15496', 'ENCLB817LXB', '2015-03-27T22:01:44.356874+0000'), + ('15495', 'ENCLB260QNG', '2015-03-27T22:01:43.823840+0000'), + ('15491', 'ENCLB847UDV', '2015-03-27T22:01:41.366532+0000'), + ('15492', 'ENCLB704CYQ', '2015-03-27T22:01:41.934480+0000'), + ('15488', 'ENCLB544VIE', '2015-03-27T22:01:39.534590+0000'), + ('15487', 'ENCLB810TRL', '2015-03-27T22:01:38.910449+0000'), + ('15486', 'ENCLB741KQB', '2015-03-27T22:01:38.396352+0000'), + ('15485', 'ENCLB658ICO', '2015-03-27T22:01:37.835601+0000'), + ('15484', 'ENCLB415KPR', '2015-03-27T22:01:37.266549+0000'), + ('15483', 'ENCLB074REG', '2015-03-27T22:01:36.679913+0000'), + ('15481', 'ENCLB790ZKD', '2015-03-27T22:01:35.693423+0000'), + ('15482', 'ENCLB319NLX', '2015-03-27T22:01:36.114223+0000'), + ('15479', 'ENCLB274VUA', '2015-03-27T22:01:34.760956+0000'), + ('15480', 'ENCLB441AFS', '2015-03-27T22:01:35.242213+0000'), + ('15477', 'ENCLB080NNG', '2015-03-27T22:01:33.809928+0000'), + ('15478', 'ENCLB180OTB', '2015-03-27T22:01:34.281900+0000'), + ('15476', 'ENCLB055JUC', '2015-03-27T22:01:33.316038+0000'), + ('15475', 'ENCLB266LCY', '2015-03-27T22:01:32.864613+0000'), + ('15293', 'ENCLB950QWJ', '2014-12-16T01:15:58.109787+0000'), + ('15288', 'ENCLB435TVJ', '2014-12-16T01:15:53.184310+0000'), + ('15297', 'ENCLB384GBY', '2014-12-16T01:16:00.929045+0000'), + ('15298', 'ENCLB030QYZ', '2014-12-16T01:16:01.373251+0000'), + ('15301', 'ENCLB807MQE', '2014-12-16T01:16:02.132204+0000'), + ('15302', 'ENCLB462UWC', '2014-12-16T01:16:03.048372+0000'), + ('15289', 'ENCLB337IRK', '2014-12-16T01:15:54.829508+0000'), + ('15294', 'ENCLB219UWV', '2014-12-16T01:15:58.782565+0000'), + ('15299', 'ENCLB721WMG', '2014-12-16T01:16:01.597127+0000'), + ('15303', 'ENCLB296VEF', '2014-12-16T01:16:03.815641+0000'), + ('15292', 'ENCLB577KCS', '2014-12-16T01:15:57.362521+0000'), + ('15296', 'ENCLB430RUN', '2014-12-16T01:16:00.122073+0000'), + ('15290', 'ENCLB863GTU', '2014-12-16T01:15:56.220924+0000'), + ('15291', 'ENCLB033OYZ', '2014-12-16T01:15:56.821935+0000'), + ('15300', 'ENCLB359XUW', '2014-12-16T01:16:01.825260+0000'), + ('15295', 'ENCLB196QXY', '2014-12-16T01:15:59.455275+0000'), + ('15271', 'ENCLB518MNF', '2014-12-16T01:15:51.255098+0000'), + ('15270', 'ENCLB108LLJ', '2014-12-16T01:15:50.793306+0000'), + ('15269', 'ENCLB284YTS', '2014-12-16T01:15:50.317441+0000'), + ('15268', 'ENCLB678FAD', '2014-12-16T01:15:49.637634+0000'), + ('15267', 'ENCLB708TZF', '2014-12-16T01:15:48.518860+0000'), + ('15266', 'ENCLB640QPM', '2014-12-16T01:15:48.094692+0000'), + ('15265', 'ENCLB663WPK', '2014-12-16T01:15:47.823408+0000'), + ('15264', 'ENCLB035MJZ', '2014-12-16T01:15:47.581360+0000'), + ('15263', 'ENCLB417MEI', '2014-12-16T01:15:47.354094+0000'), + ('15262', 'ENCLB112DAD', '2014-12-16T01:15:47.111994+0000'), + ('15261', 'ENCLB809LQF', '2014-12-16T01:15:46.336850+0000'), + ('15260', 'ENCLB183ZSO', '2014-12-16T01:15:46.051548+0000'), + ('15259', 'ENCLB587ZYP', '2014-12-16T01:15:45.407813+0000'), + ('15258', 'ENCLB891HIS', '2014-12-16T01:15:44.686534+0000'), + ('15257', 'ENCLB857GUO', '2014-12-16T01:15:43.062548+0000'), + ('15256', 'ENCLB253LOZ', '2014-12-16T01:15:42.800855+0000'), + ('15248', 'ENCLB700NFV', '2014-12-16T01:03:14.123376+0000'), + ('15247', 'ENCLB229LFR', '2014-12-16T01:03:13.888442+0000'), + ('15246', 'ENCLB730HDZ', '2014-12-16T01:03:13.532201+0000'), + ('15245', 'ENCLB893OOW', '2014-12-16T01:03:12.851385+0000'), + ('15243', 'ENCLB521CXU', '2014-12-16T01:03:12.409916+0000'), + ('15244', 'ENCLB969JPS', '2014-12-16T01:03:12.638218+0000'), + ('15241', 'ENCLB604HVJ', '2014-12-15T23:31:51.819207+0000'), + ('15242', 'ENCLB357UPR', '2014-12-16T01:03:11.301778+0000'), + ('13429', 'ENCLB243CVS', '2014-12-16T00:45:21.329370+0000'), + ('13439', 'ENCLB318YQB', '2014-12-16T00:45:27.109024+0000'), + ('13430', 'ENCLB204EWE', '2014-12-16T00:45:22.235057+0000'), + ('13437', 'ENCLB461BIJ', '2014-12-16T00:45:25.696471+0000'), + ('13440', 'ENCLB407NSA', '2014-12-16T00:45:27.519366+0000'), + ('13438', 'ENCLB580JUS', '2014-12-16T00:45:26.678862+0000'), + ('13428', 'ENCLB714KUY', '2014-12-16T00:45:20.848934+0000'), + ('13432', 'ENCLB729FQY', '2014-12-16T00:45:23.458123+0000'), + ('13433', 'ENCLB988OPM', '2014-12-16T00:45:23.707750+0000'), + ('13431', 'ENCLB751POF', '2014-12-16T00:45:23.092374+0000'), + ('13435', 'ENCLB981WTU', '2014-12-16T00:45:24.273572+0000'), + ('13436', 'ENCLB364NZB', '2014-12-16T00:45:25.243385+0000'), + ('13427', 'ENCLB442ZCO', '2014-12-16T00:45:20.402307+0000'), + ('13426', 'ENCLB507MOC', '2014-12-16T00:45:19.791431+0000'), + ('13425', 'ENCLB042QFS', '2014-12-16T00:45:18.620202+0000'), + ('13424', 'ENCLB641AYP', '2014-12-16T00:45:18.075095+0000'), + ('13423', 'ENCLB036AMX', '2014-12-16T00:45:17.587710+0000'), + ('13422', 'ENCLB711HMD', '2014-12-16T00:45:17.306141+0000'), + ('13421', 'ENCLB541QCS', '2014-12-16T00:45:17.049659+0000'), + ('13420', 'ENCLB133ICO', '2014-12-16T00:45:16.784349+0000'), + ('13419', 'ENCLB921XPI', '2014-12-16T00:45:16.561156+0000'), + ('13418', 'ENCLB322YDP', '2014-12-16T00:45:15.320136+0000'), + ('13417', 'ENCLB578MIX', '2014-12-16T00:45:14.860425+0000'), + ('13416', 'ENCLB193ILA', '2014-12-16T00:45:14.431853+0000'), + ('13415', 'ENCLB569DAO', '2014-12-16T00:45:14.213313+0000'), + ('13414', 'ENCLB414SJG', '2014-12-16T00:45:13.800356+0000'), + ('13413', 'ENCLB510UJB', '2014-12-16T00:45:13.360830+0000'), + ('15018', 'ENCLB357KYA', '2014-10-23T21:25:38.564710+0000'), + ('15017', 'ENCLB055KYV', '2014-10-23T21:25:37.604795+0000'), + ('15007', 'ENCLB835LVO', '2014-10-23T21:25:29.431984+0000'), + ('15008', 'ENCLB471QMM', '2014-10-23T21:25:30.115849+0000'), + ('15494', 'ENCLB590UZK', '2015-03-27T22:01:43.220918+0000'), + ('15493', 'ENCLB318WHF', '2015-03-27T22:01:42.583021+0000'), + ('15504', 'ENCLB803HJK', '2015-03-27T22:01:48.918921+0000'), + ('15503', 'ENCLB556YSG', '2015-03-27T22:01:48.360245+0000'), + ('15089', 'ENCLB595PNG', '2014-12-10T23:00:24.554339+0000'), + ('15088', 'ENCLB409LKR', '2014-12-10T23:00:24.173237+0000'), + ('15082', 'ENCLB819PZM', '2014-12-10T23:00:21.265192+0000'), + ('15083', 'ENCLB220DVX', '2014-12-10T23:00:21.537679+0000'), + ('15094', 'ENCLB813BQB', '2014-12-10T23:00:29.029220+0000'), + ('15095', 'ENCLB949WIO', '2014-12-10T23:00:29.343030+0000'), + ('15090', 'ENCLB156EMG', '2014-12-10T23:00:25.382334+0000'), + ('15091', 'ENCLB030NEC', '2014-12-10T23:00:26.743561+0000'), + ('15080', 'ENCLB200EFP', '2014-12-10T23:00:20.013418+0000'), + ('15081', 'ENCLB278MMD', '2014-12-10T23:00:20.516203+0000'), + ('15086', 'ENCLB584VFZ', '2014-12-10T23:00:23.080355+0000'), + ('15087', 'ENCLB931ORG', '2014-12-10T23:00:23.626841+0000'), + ('15079', 'ENCLB015WCJ', '2014-12-10T23:00:19.713321+0000'), + ('15078', 'ENCLB254AMJ', '2014-12-10T23:00:19.420436+0000'), + ('15085', 'ENCLB949YQN', '2014-12-10T23:00:22.369090+0000'), + ('15084', 'ENCLB906TKN', '2014-12-10T23:00:21.824807+0000'), + ('15093', 'ENCLB214UZM', '2014-12-10T23:00:28.526626+0000'), + ('15092', 'ENCLB377PCX', '2014-12-10T23:00:28.034636+0000'), + ('15077', 'ENCLB567WFL', '2014-12-10T23:00:19.145366+0000'), + ('15076', 'ENCLB989QNS', '2014-12-10T23:00:18.850689+0000'), + ('15074', 'ENCLB000EUQ', '2014-12-10T23:00:17.847597+0000'), + ('15075', 'ENCLB597GRF', '2014-12-10T23:00:18.331925+0000'), + ('15073', 'ENCLB964APA', '2014-12-10T23:00:17.550508+0000'), + ('15072', 'ENCLB336GOL', '2014-12-10T23:00:17.177956+0000'), + ('15015', 'ENCLB601XLL', '2014-10-23T21:25:35.898934+0000'), + ('15016', 'ENCLB347FRI', '2014-10-23T21:25:36.765768+0000'), + ('15013', 'ENCLB331VAA', '2014-10-23T21:25:33.732239+0000'), + ('15014', 'ENCLB761PCA', '2014-10-23T21:25:34.879860+0000'), + ('15019', 'ENCLB495FUZ', '2014-10-23T21:25:39.571864+0000'), + ('15020', 'ENCLB979DZW', '2014-10-23T21:25:40.266492+0000'), + ('15022', 'ENCLB627LDZ', '2014-10-23T21:25:42.094283+0000'), + ('15021', 'ENCLB162EJJ', '2014-10-23T21:25:41.173920+0000'), + ('15011', 'ENCLB454ZUS', '2014-10-23T21:25:32.065385+0000'), + ('15012', 'ENCLB061TDP', '2014-10-23T21:25:32.733245+0000'), + ('15010', 'ENCLB426JKF', '2014-10-23T21:25:31.349525+0000'), + ('15009', 'ENCLB659UFY', '2014-10-23T21:25:30.756915+0000'), + ('15502', 'ENCLB416HZP', '2015-03-27T22:01:47.742894+0000'), + ('15501', 'ENCLB022VFG', '2015-03-27T22:01:47.188586+0000'), + ('15489', 'ENCLB370ZFK', '2015-03-27T22:01:40.115768+0000'), + ('15490', 'ENCLB273BPC', '2015-03-27T22:01:40.746450+0000'), + ('14636', 'ENCLB185MNU', '2014-07-30T22:13:44.242558+0000'), + ('14635', 'ENCLB005HHX', '2014-07-30T22:13:43.673544+0000'), + ('14632', 'ENCLB348BMH', '2014-07-30T22:13:41.597441+0000'), + ('14628', 'ENCLB652HKH', '2014-07-30T22:13:39.079002+0000'), + ('14627', 'ENCLB238LIR', '2014-07-30T22:13:38.488612+0000'), + ('14631', 'ENCLB765HDK', '2014-07-30T22:13:41.017277+0000'), + ('14629', 'ENCLB181TCJ', '2014-07-30T22:13:39.612566+0000'), + ('14626', 'ENCLB766UOB', '2014-07-30T22:13:37.751613+0000'), + ('14501', 'ENCLB304LFK', '2014-07-30T22:13:36.682522+0000'), + ('14634', 'ENCLB096HAH', '2014-07-30T22:13:42.871555+0000'), + ('14499', 'ENCLB356IIP', '2014-07-30T22:13:35.356726+0000'), + ('14633', 'ENCLB791CRT', '2014-07-30T22:13:42.145408+0000'), + ('14495', 'ENCLB719BQO', '2014-07-30T22:13:34.234738+0000'), + ('14630', 'ENCLB669AEL', '2014-07-30T22:13:40.373455+0000'), + ('14488', 'ENCLB171NYD', '2014-07-30T22:13:32.876751+0000'), + ('14487', 'ENCLB237OAE', '2014-07-30T22:13:32.006665+0000'), + ('14486', 'ENCLB941VYE', '2014-07-30T22:13:30.865419+0000'), + ('14485', 'ENCLB463KOX', '2014-07-30T22:13:29.658606+0000'), + ('14655', 'ENCLB449LBZ', '2014-07-22T21:17:23.464962+0000'), + ('14656', 'ENCLB905LVV', '2014-07-22T21:18:02.970100+0000'), + ('14653', 'ENCLB917PKP', '2014-07-22T21:16:09.466969+0000'), + ('14654', 'ENCLB026BHP', '2014-07-22T21:16:36.206892+0000'), + ('13291', 'ENCLB402YMB', '2014-04-17T22:46:58.456242+0000'), + ('13290', 'ENCLB476CZO', '2014-04-17T22:46:58.374543+0000'), + ('13289', 'ENCLB206JYT', '2014-04-17T22:46:58.292642+0000'), + ('13644', 'ENCLB632SOL', '2014-04-17T22:46:54.617599+0000'), + ('13643', 'ENCLB509KSM', '2014-04-17T22:46:54.529638+0000'), + ('13642', 'ENCLB552DLJ', '2014-04-17T22:46:54.430325+0000'), + ('13641', 'ENCLB876ZIU', '2014-04-17T22:46:54.340786+0000'), + ('13640', 'ENCLB617JJG', '2014-04-17T22:46:54.244908+0000'), + ('13639', 'ENCLB218HBM', '2014-04-17T22:46:54.155566+0000'), + ('13638', 'ENCLB257OVB', '2014-04-17T22:46:54.073274+0000'), + ('13637', 'ENCLB350NUB', '2014-04-17T22:46:53.980565+0000'), + ('13636', 'ENCLB619TYA', '2014-04-17T22:46:53.884920+0000'), + ('13635', 'ENCLB222MSP', '2014-04-17T22:46:53.715943+0000'), + ('13634', 'ENCLB211OUD', '2014-04-17T22:46:53.615476+0000'), + ('13633', 'ENCLB710XHU', '2014-04-17T22:46:53.538836+0000'), + ('13632', 'ENCLB747ZHK', '2014-04-17T22:46:53.457184+0000'), + ('13631', 'ENCLB087SVF', '2014-04-17T22:46:53.371845+0000'), + ('13630', 'ENCLB804XKW', '2014-04-17T22:46:53.273136+0000'), + ('13629', 'ENCLB403JBC', '2014-04-17T22:46:53.192762+0000'), + ('13628', 'ENCLB641KNK', '2014-04-17T22:46:53.114120+0000'), + ('13627', 'ENCLB228BIT', '2014-04-17T22:46:53.033480+0000'), + ('13626', 'ENCLB327MTR', '2014-04-17T22:46:52.954204+0000'), + ('13625', 'ENCLB331AUZ', '2014-04-17T22:46:52.874393+0000'), + ('13280', 'ENCLB187EEQ', '2014-04-17T22:46:56.606142+0000'), + ('13292', 'ENCLB211FCW', '2014-04-17T22:46:56.889940+0000'), + ('13297', 'ENCLB882HPA', '2014-04-17T22:46:57.428995+0000'), + ('13299', 'ENCLB242XIT', '2014-04-17T22:46:57.604855+0000'), + ('13281', 'ENCLB146LAW', '2014-04-17T22:46:56.763676+0000'), + ('13296', 'ENCLB108EAP', '2014-04-17T22:46:57.341596+0000'), + ('13298', 'ENCLB804XTY', '2014-04-17T22:46:57.507323+0000'), + ('13295', 'ENCLB720ZUM', '2014-04-17T22:46:57.198472+0000'), + ('13294', 'ENCLB283IJI', '2014-04-17T22:46:57.082795+0000'), + ('13645', 'ENCLB678KFT', '2014-04-17T22:46:54.699948+0000'), + ('13658', 'ENCLB147KNI', '2014-04-17T22:46:55.786033+0000'), + ('13660', 'ENCLB857XKO', '2014-04-17T22:46:55.967510+0000'), + ('13663', 'ENCLB229ENW', '2014-04-17T22:46:56.202064+0000'), + ('13652', 'ENCLB294BYK', '2014-04-17T22:46:55.262903+0000'), + ('13654', 'ENCLB614VPZ', '2014-04-17T22:46:55.416400+0000'), + ('13656', 'ENCLB462FVS', '2014-04-17T22:46:55.622867+0000'), + ('13659', 'ENCLB904FTO', '2014-04-17T22:46:55.881860+0000'), + ('13662', 'ENCLB632CVX', '2014-04-17T22:46:56.126475+0000'), + ('13664', 'ENCLB912XSU', '2014-04-17T22:46:56.461112+0000'), + ('13646', 'ENCLB432EQY', '2014-04-17T22:46:54.778444+0000'), + ('13648', 'ENCLB151CUN', '2014-04-17T22:46:54.937278+0000'), + ('13661', 'ENCLB720FXC', '2014-04-17T22:46:56.045285+0000'), + ('13647', 'ENCLB546SWD', '2014-04-17T22:46:54.858448+0000'), + ('13649', 'ENCLB340FFP', '2014-04-17T22:46:55.022324+0000'), + ('13651', 'ENCLB452IVF', '2014-04-17T22:46:55.184097+0000'), + ('13650', 'ENCLB205HHN', '2014-04-17T22:46:55.098461+0000'), + ('13653', 'ENCLB078UJF', '2014-04-17T22:46:55.341750+0000'), + ('13655', 'ENCLB611KGC', '2014-04-17T22:46:55.540595+0000'), + ('13657', 'ENCLB562SNL', '2014-04-17T22:46:55.701402+0000'), + ('13347', 'ENCLB928LID', '2014-04-17T22:46:52.162858+0000'), + ('13349', 'ENCLB532KHK', '2014-04-17T22:46:52.248810+0000'), + ('13262', 'ENCLB164LQL', '2014-04-17T22:46:51.996269+0000'), + ('13263', 'ENCLB621DLJ', '2014-04-17T22:46:52.081511+0000'), + ('13025', 'ENCLB976CMA', '2014-04-17T22:46:51.909420+0000'), + ('13024', 'ENCLB386HBI', '2014-04-17T22:46:51.828778+0000'), + ('13665', 'ENCLB915IHV', '2014-04-17T22:46:51.664093+0000'), + ('13666', 'ENCLB204VYG', '2014-04-17T22:46:51.747073+0000'), + ('13623', 'ENCLB036TZY', '2014-04-17T22:46:51.581073+0000'), + ('13620', 'ENCLB392ZIG', '2014-04-17T22:46:51.468689+0000'), + ('13619', 'ENCLB901PGF', '2014-04-17T22:46:51.257931+0000'), + ('13622', 'ENCLB426EUN', '2014-04-17T22:46:51.379932+0000'), + ('11204', 'ENCLB625YJM', '2014-02-11T04:54:55.290109+0000'), + ('11007', 'ENCLB866SQE', '2014-02-11T04:54:52.164787+0000'), + ('11008', 'ENCLB424IFK', '2014-02-11T04:54:51.864439+0000'), + ('11206', 'ENCLB043WCL', '2014-02-11T04:54:53.934271+0000'), + ('11209', 'ENCLB334AQY', '2014-02-11T04:54:54.659774+0000'), + ('11210', 'ENCLB267HUY', '2014-02-11T04:54:54.901232+0000'), + ('11207', 'ENCLB540GQH', '2014-02-11T04:54:54.151840+0000'), + ('11208', 'ENCLB267LXR', '2014-02-11T04:54:54.367250+0000'), + ('10876', 'ENCLB827ADT', '2014-02-11T04:54:56.056039+0000'), + ('11009', 'ENCLB205QXO', '2015-01-15T19:40:15.525219+0000'), + ('10947', 'ENCLB184USD', '2014-02-11T04:54:52.964669+0000'), + ('10516', 'ENCLB858EYY', '2014-02-11T04:54:55.778298+0000'), + ('11011', 'ENCLB732DFW', '2014-02-11T04:54:51.042384+0000'), + ('11010', 'ENCLB529ELW', '2014-02-11T04:54:51.647823+0000'), + ('12097', 'ENCLB308ZDI', '2013-12-31T01:24:30.117992+0000'), + ('12096', 'ENCLB330KCB', '2013-12-31T01:24:29.929490+0000'), + ('10881', 'ENCLB928ZOL', '2013-12-31T01:24:31.988425+0000'), + ('10882', 'ENCLB070EUV', '2013-12-31T01:24:32.157600+0000'), + ('11286', 'ENCLB227WEO', '2013-12-31T00:56:50.365755+0000'), + ('11289', 'ENCLB221REA', '2013-12-31T00:56:50.771930+0000'), + ('10874', 'ENCLB211VHB', '2013-12-31T00:56:50.185938+0000'), + ('11288', 'ENCLB764TBI', '2013-12-31T00:56:50.539923+0000'), + ('11582', 'ENCLB445LWQ', '2013-12-31T01:24:30.715684+0000'), + ('11581', 'ENCLB794RXE', '2013-12-31T01:24:31.159562+0000'), + ('12098', 'ENCLB849ZXB', '2013-12-31T01:24:30.951897+0000'), + ('11621', 'ENCLB282WJS', '2013-12-31T00:56:49.527454+0000'), + ('11622', 'ENCLB379BUZ', '2013-12-31T00:56:49.274381+0000'), + ('10986', 'ENCLB356ZZZ', '2013-09-13T13:31:02.556929-0800'), + ('11612', 'ENCLB370ZZZ', '2013-09-13T13:31:03.835164-0800'), + ('11956', 'ENCLB323ZZZ', '2013-09-13T13:31:05.229141-0800'), + ('10599', 'ENCLB329ZZZ', '2013-09-13T13:31:01.589610-0800'), + ('10506', 'ENCLB354ZZZ', '2013-09-13T13:31:01.402055-0800'), + ('10703', 'ENCLB347ZZZ', '2013-09-13T13:31:01.634288-0800'), + ('11719', 'ENCLB330ZZZ', '2013-09-13T13:31:04.755910-0800'), + ('11719', 'ENCLB373ZZZ', '2013-09-13T13:31:03.237846-0800'), + ('11905', 'ENCLB320ZZZ', '2013-09-13T13:31:04.885807-0800'), + ('10296', 'ENCLB326ZZZ', '2013-09-13T13:31:01.050362-0800'), + ('10502', 'ENCLB322ZZZ', '2013-09-13T13:31:01.357314-0800'), + ('10409', 'ENCLB335ZZZ', '2013-09-13T13:31:01.268879-0800'), + ('10409', 'ENCLB373ZZZ', '2013-09-13T13:31:03.237846-0800'), + ('10158', 'ENCLB349ZZZ', '2013-09-13T13:31:00.888358-0800'), + ('10704', 'ENCLB353ZZZ', '2013-09-13T13:31:01.678096-0800'), + ('11923', 'ENCLB346ZZZ', '2013-09-13T13:31:05.014078-0800'), + ('11644', 'ENCLB341ZZZ', '2013-09-13T13:31:04.092318-0800'), + ('10481', 'ENCLB328ZZZ', '2013-09-13T13:31:01.312917-0800'), + ('11653', 'ENCLB344ZZZ', '2013-09-13T13:31:04.212140-0800'), + ('11847', 'ENCLB345ZZZ', '2013-09-13T13:31:04.842142-0800'), + ('11924', 'ENCLB343ZZZ', '2013-09-13T13:31:05.057237-0800'), + ('11669', 'ENCLB321ZZZ', '2013-09-13T13:31:04.327003-0800'), + ('10135', 'ENCLB371ZZZ', '2013-09-13T13:31:00.800862-0800'), + ('11957', 'ENCLB319ZZZ', '2013-09-13T13:31:05.271096-0800'), + ('11155', 'ENCLB357ZZZ', '2013-09-13T13:31:02.954320-0800'), + ('10333', 'ENCLB348ZZZ', '2013-09-13T13:31:01.182426-0800'), + ('10331', 'ENCLB312ZZZ', '2013-09-13T13:31:01.138188-0800'), + ('11942', 'ENCLB340ZZZ', '2013-09-13T13:31:05.185199-0800'), + ('11942', 'ENCLB374ZZZ', '2013-09-13T13:31:00.932762-0800'), + ('11832', 'ENCLB318ZZZ', '2013-09-13T13:31:04.798657-0800'), + ('11927', 'ENCLB351ZZZ', '2013-09-13T13:31:05.142104-0800'), + ('10150', 'ENCLB375ZZZ', '2013-09-13T13:31:00.845686-0800'), + ('10335', 'ENCLB325ZZZ', '2013-09-13T13:31:01.226356-0800'), + ('10330', 'ENCLB316ZZZ', '2013-09-13T13:31:01.094821-0800'), + ('11906', 'ENCLB315ZZZ', '2013-09-13T13:31:04.927936-0800'), + ('11154', 'ENCLB358ZZZ', '2013-09-13T13:31:02.792781-0800'), + ('10007', 'ENCLB372ZZZ', '2013-09-13T13:31:00.667863-0800'), + ('11926', 'ENCLB342ZZZ', '2013-09-13T13:31:05.098878-0800'), + ('11682', 'ENCLB331ZZZ', '2013-09-13T13:31:04.445816-0800'), + ('10985', 'ENCLB359ZZZ', '2013-09-13T13:31:02.337847-0800'), + ('10536', 'ENCLB317ZZZ', '2013-09-13T13:31:01.484966-0800'), + ('10065', 'ENCLB350ZZZ', '2013-09-13T13:31:00.711427-0800'), + ('11612', 'ENCLB370ZZZ', '2013-09-13T13:31:03.835164-0800'), + ('11638', 'ENCLB507FSU', '2015-03-12T23:49:04.901543+0000'), + ('11670', 'ENCLB715BMJ', '2015-03-12T23:18:09.561375+0000'), + ('11565', 'ENCLB332ZZZ', '2013-09-13T13:31:03.112170-0800'), + ('11907', 'ENCLB313ZZZ', '2013-09-13T13:31:04.970793-0800'), + ('11697', 'ENCLB314ZZZ', '2013-09-13T13:31:04.621147-0800'), + ('11718', 'ENCLB327ZZZ', '2013-09-13T13:31:04.713973-0800'), + ('13712', 'ENCLB044ZZZ', '2013-09-13T13:31:21.995955-0800'), + ('13711', 'ENCLB043ZZZ', '2013-09-13T13:31:21.704089-0800'), + ('13714', 'ENCLB046ZZZ', '2013-09-13T13:31:19.986238-0800'), + ('13713', 'ENCLB045ZZZ', '2013-09-13T13:31:21.121478-0800'), + ('13717', 'ENCLB063ZZZ', '2013-09-13T13:31:22.543146-0800'), + ('13718', 'ENCLB064ZZZ', '2013-09-13T13:31:26.615177-0800'), + ('13715', 'ENCLB061ZZZ', '2013-09-13T13:31:26.233894-0800'), + ('13716', 'ENCLB062ZZZ', '2013-09-13T13:31:21.394322-0800'), + ('10885', 'ENCLB369MMK', '2013-12-31T00:56:51.214725+0000'), + ('10883', 'ENCLB553XIA', '2013-12-31T00:56:50.961345+0000'), + ('SL2970', 'ENCLB871LCB', '2013-12-31T01:24:29.617351+0000'), + ('02973', 'ENCLB661EBH', '2013-12-31T01:24:29.450163+0000'), + ('11039', 'ENCLB637FKG', '2013-12-31T01:24:29.779715+0000'), + ('11584', 'ENCLB866FVU', '2013-12-31T01:24:30.539689+0000'), + ('11585', 'ENCLB415HFJ', '2013-12-31T01:24:30.323719+0000'), + ('SL2971', 'ENCLB503AOQ', '2013-12-31T01:24:29.290708+0000'), + ('11038', 'ENCLB857ING', '2013-12-31T01:24:29.125690+0000'), + ('11587', 'ENCLB271DFX', '2013-12-31T00:56:49.784310+0000'), + ('11588', 'ENCLB224GWZ', '2013-12-31T00:56:50.002023+0000'), + ('11586', 'ENCLB170HBR', '2013-12-31T01:24:32.842478+0000'), + ('10884', 'ENCLB439WFS', '2013-12-31T01:24:32.695166+0000'), + ('10565', 'ENCLB700LMU', '2013-12-31T01:24:31.490950+0000'), + ('10515', 'ENCLB150CGC', '2013-12-31T01:24:31.329052+0000'), + ('10878', 'ENCLB596OCH', '2013-12-31T01:24:32.312287+0000'), + ('10879', 'ENCLB285RFV', '2013-12-31T01:24:32.481428+0000'), + ('10567', 'ENCLB912OTZ', '2013-12-31T01:24:31.813954+0000'), + ('10517', 'ENCLB296STQ', '2013-12-31T01:24:31.650260+0000'), + ('13284', 'ENCLB319PGU', '2014-04-17T22:46:57.859868+0000'), + ('13300', 'ENCLB550GYC', '2014-04-17T22:46:52.512366+0000'), + ('13301', 'ENCLB576ZGP', '2014-04-17T22:46:52.601612+0000'), + ('13287', 'ENCLB868NQU', '2014-04-17T22:46:58.123540+0000'), + ('13282', 'ENCLB267CXI', '2014-04-17T22:46:57.686887+0000'), + ('13274', 'ENCLB036MBQ', '2014-04-17T22:46:52.331729+0000'), + ('13275', 'ENCLB284CYK', '2014-04-17T22:46:52.424102+0000'), + ('13286', 'ENCLB714NCU', '2014-04-17T22:46:58.029639+0000'), + ('13288', 'ENCLB264YKE', '2014-04-17T22:46:58.206637+0000'), + ('13283', 'ENCLB198OUV', '2014-04-17T22:46:57.765163+0000'), + ('12517', 'ENCLB482LEX', '2014-04-17T22:46:52.690510+0000'), + ('12518', 'ENCLB898RJN', '2014-04-17T22:46:52.789971+0000'), + ('13285', 'ENCLB391GZT', '2014-04-17T22:46:57.942156+0000'), + ] + encode = AccessionAgency.objects.get(name="ENCODE3") + for jumpgate_id, accession, created in data: + jumpgate_id = { + 'SL2970': '02970', + 'SL2971': '02971', + 'SL2972': '02972', + }.get(jumpgate_id, jumpgate_id) + jumpgate = Library.objects.get(pk=jumpgate_id) + date_created = datetime.strptime(created, '%Y-%m-%dT%H:%M:%S.%f%z') + o = LibraryAccession(agency=encode, + library=jumpgate, + accession=accession, + created=date_created,) + o.save() + + +def main(): + print('loading encode3 accessions') + load_encode3_accessions() + +if __name__ == '__main__': + import socket + os.environ.setdefault( + "DJANGO_SETTINGS_MODULE", + "htsworkflow.settings.{}".format(socket.gethostname())) + import django + django.setup() + main() -- 2.30.2