annotate data/models.R @ 3:fa97d16330be draft

" master branch Updating"
author lain
date Thu, 17 Dec 2020 10:13:58 +0000
parents a174cbbb12dd
children 00079fadc240
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
1
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
2 tryCatch({
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
3 DBModelR::ModelDefinition(table="yui", fields=list(yui="INTEGER"))
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
4 }, error=function(e) {
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
5 stop("Please, install DBModelR before you source this file.")
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
6 })
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
7
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
8 list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
9 adduct=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
10 table="adduct",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
11 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
12 name="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
13 mass="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
14 charge="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
15 multi="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
16 formula_add="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
17 formula_ded="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
18 sign="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
19 oidscore="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
20 quasi="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
21 ips="FLOAT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
22 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
23 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
24 cluster=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
25 table="cluster",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
26 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
27 clusterID="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
28 formula="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
29 annotation="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
30 coeff="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
31 r_squared="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
32 charge="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
33 mean_rt="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
34 score="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
35 deviation="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
36 status="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
37 adduct="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
38 curent_group="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
39 pc_group="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
40 align_group="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
41 xcms_group="INTEGER"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
42 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
43 one=list("sample", "compound")
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
44 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
45 compound=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
46 table="compound",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
47 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
48 name="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
49 common_name="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
50 formula="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
51 charge="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
52 date="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
53 mz="FLOAT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
54 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
55 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
56 feature=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
57 table="feature",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
58 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
59 featureID="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
60 mz="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
61 mz_min="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
62 mz_max="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
63 rt="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
64 rt_min="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
65 rt_max="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
66 int_o="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
67 int_b="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
68 max_o="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
69 iso="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
70 abundance="FLOAT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
71 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
72 one=list("cluster")
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
73 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
74 instrument=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
75 table="instrument",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
76 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
77 model="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
78 manufacturer="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
79 analyzer="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
80 detector_type="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
81 ion_source="TEXT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
82 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
83 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
84 instrument_config=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
85 table="instrument_config",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
86 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
87 resolution="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
88 agc_target="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
89 maximum_IT="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
90 number_of_scan_range="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
91 scan_range="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
92 version="TEXT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
93 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
94 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
95 project=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
96 table="project",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
97 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
98 name="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
99 comment="TEXT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
100 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
101 one=list("sample")
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
102 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
103 sample=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
104 table="sample",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
105 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
106 name="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
107 path="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
108 polarity="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
109 kind="TEXT", ## rdata or mxml or enriched_rdata
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
110 raw="BLOB"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
111 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
112 one=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
113 "peak_picking_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
114 "pairing_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
115 "alignmenmt_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
116 "camera_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
117 "instrument",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
118 "instrument_config",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
119 "software",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
120 "smol_xcms_set"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
121 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
122 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
123 smol_xcms_set=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
124 table="smol_xcms_set",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
125 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
126 raw="BLOB"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
127 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
128 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
129 software=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
130 table="software",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
131 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
132 name="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
133 version="TEXT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
134 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
135 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
136 # camera_parameters=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
137 # table="camera_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
138 # fields=list()
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
139 # ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
140 # pairing_parameters=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
141 # table="pairing_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
142 # fields=list()
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
143 # ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
144 peak_picking_parameters=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
145 table="peak_picking_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
146 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
147 ppm="FLOAT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
148 peakwidth="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
149 snthresh="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
150 prefilterStep="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
151 prefilterLevel="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
152 mzdiff="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
153 fitgauss="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
154 noise="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
155 mzCenterFun="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
156 integrate="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
157 firstBaselineCheck="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
158 snthreshIsoROIs="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
159 maxCharge="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
160 maxIso="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
161 mzIntervalExtension="TEXT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
162 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
163 ),
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
164 alignmenmt_parameters=DBModelR::ModelDefinition(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
165 table="alignmenmt_parameters",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
166 fields=list(
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
167 binSize="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
168 centerSample="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
169 response="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
170 distFun="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
171 gapInit="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
172 gapExtend="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
173 factorDiag="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
174 factorGap="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
175 localAlignment="INTEGER",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
176 initPenalty="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
177 bw="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
178 minFraction="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
179 minSamples="TEXT",
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
180 maxFeatures="TEXT"
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
181 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
182 )
a174cbbb12dd " master branch Updating"
lain
parents:
diff changeset
183 )