rtirrell

>> cor = Cor.first
 ~ (0.003168) SELECT `id`, `type`, `meth`, `cor`, `pval`, `pval_adj`, `perm_pval`, `len` FROM `cors` ORDER BY `id`, `type`, `meth` LIMIT 1
=> #<Cor @id="1059" @type=:cid @cor=-0.0339791 @pval=1.82219e-05 @pval_adj=nil @perm_pval=0.001 @meth=:pearson @len=15901>
>> cor.update :pval_adj => 0.001
DataMapper::ImmutableError: Immutable resource cannot be modified
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/resource/state/immutable.rb:16:in `set'
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/model/property.rb:269:in `pval_adj='
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/resource.rb:345:in `__send__'
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/resource.rb:345:in `attributes='
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/resource.rb:341:in `each'

rtirrell

scs = SubsetComparison.all # pk is "cid"
scs.map do |sc|
  puts sc.genes.first
end
# => "SELECT `egid`, `cid`, `hgid`, `value` FROM `genes` WHERE `cid` IN (1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1073, 1074, 1075, 1076, 1077, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, ...);"

rtirrell

>> scs.map do |sc|
?> puts sc.genes.first.value
>> end
 ~ (0.002284) SET sql_auto_is_null = 0
 ~ (0.002567) SET SESSION sql_mode = 'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
 ~ (0.049798) SELECT `egid`, `cid`, `hgid`, `value` FROM `genes` WHERE `cid` IN (1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1073, 1074, 1075, 1076, 1077, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 

rtirrell

class SubsetComparison
  
  include DataMapper::Resource
  
  property :id, Integer, :key => true
  property :subset_A, Integer
  property :subset_B, Integer
  property :comparison_type, Enum["CTL_VS_DZ", "UNTRT_VS_TRT", "TIME"]
  property :disease_concept_id, String
  property :tissue_concept_id, String