1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
<html><head><title>Get dose-response data</title>
<link rel="stylesheet" type="text/css" href="Rchm.css">
</head>
<body>
<table width="100%"><tr><td>drdata(drfit)</td><td align="right">R Documentation</td></tr></table><object type="application/x-oleobject" classid="clsid:1e2a7bd0-dab9-11d0-b93a-00c04fc99f9e">
<param name="keyword" value="R: drdata">
<param name="keyword" value=" Get dose-response data">
</object>
<h2>Get dose-response data</h2>
<h3>Description</h3>
<p>
Get dose-response data from a remote mysql server
</p>
<h3>Usage</h3>
<pre>
drdata(substances, experimentator = "%", db = "cytotox", celltype = "IPC-81",
whereClause = "1", ok = "'ok'")
</pre>
<h3>Arguments</h3>
<table summary="R argblock">
<tr valign="top"><td><code>substances</code></td>
<td>
A string or an array of strings with the substance names for
which dose-response data is to be retrieved.</td></tr>
<tr valign="top"><td><code>experimentator</code></td>
<td>
The name of the experimentator whose data is to be used.</td></tr>
<tr valign="top"><td><code>db</code></td>
<td>
The database to be used. Currently only "cytotox" of the UFT Department of
Bioorganic Chemistry is supported.</td></tr>
<tr valign="top"><td><code>celltype</code></td>
<td>
Currently, only data for IPC-81, C6, NB4, HeLa, Jurkat and U937 are supported.</td></tr>
<tr valign="top"><td><code>whereClause</code></td>
<td>
With this argument, additional conditions for the SQL query can be set,
e.g. "where plate != 710". The default is 1 (in SQL syntax this means TRUE).</td></tr>
<tr valign="top"><td><code>ok</code></td>
<td>
With the default value "'ok'", only data that has been checked and set to "ok"
in the database is retrieved. Another sensible argument would be "'ok','?'", in
order to additionally retrieve data which has not yet been checked.</td></tr>
</table>
<h3>Details</h3>
<p>
The function is currently only used for retrieving data from the
mysql database "cytotox" of the UFT Department of Bioorganic Chemistry.
Additionally to the installation of the RODBC package, it is required to set
up a ODBC data source with the name "cytotox", using an ODBC driver for mysql,
probably myODBC. Then, under Unix, you can use iodbc or unixodbc for setting
up the respective data source with data source name (DSN) "cytotox". For my
setting using unixodbc, I am using the file ‘<TT>/etc/odbcinst.ini</TT>’
containing:
<table summary="Rd table">
<tr>
<td align="left">[MySQL] </td> <td align="left"> </td> <td align="left"> </td>
</tr>
<tr>
<td align="left"> Description </td> <td align="left"> = </td> <td align="left"> MySQL driver for ODBC </td>
</tr>
<tr>
<td align="left"> Driver </td> <td align="left"> = </td> <td align="left"> /usr/local/lib/libmyodbc.so </td>
</tr>
<tr>
<td align="left"> Setup </td> <td align="left"> = </td> <td align="left"> /usr/lib/odbc/libodbcmyS.so </td>
</tr>
</table>
<p>
and the file ‘<TT>/etc/odbc.ini</TT>’ containing:
<table summary="Rd table">
<tr>
<td align="left">[cytotox] </td> <td align="left"> </td> <td align="left"> </td>
</tr>
<tr>
<td align="left"> Description </td> <td align="left"> = </td> <td align="left"> Cytotoxicity database of the department of bioorganic chemistry, UFT Bremen </td>
</tr>
<tr>
<td align="left"> Driver </td> <td align="left"> = </td> <td align="left"> MySQL </td>
</tr>
<tr>
<td align="left"> Trace </td> <td align="left"> = </td> <td align="left"> Yes </td>
</tr>
<tr>
<td align="left"> TraceFile </td> <td align="left"> = </td> <td align="left"> /tmp/odbc.log </td>
</tr>
<tr>
<td align="left"> Database </td> <td align="left"> = </td> <td align="left"> cytotox </td>
</tr>
<tr>
<td align="left"> Server </td> <td align="left"> = </td> <td align="left"> eckehaat </td>
</tr>
<tr>
<td align="left"> Port </td> <td align="left"> = </td> <td align="left"> 3306 </td>
</tr>
</table>
.
</p>
<h3>Value</h3>
<table summary="R argblock">
<tr valign="top"><td><code>data</code></td>
<td>
A data frame with a factor describing the dose levels, the numeric dose levels
and a numeric column describing the response, as well as the entries for
plate, experimentator, performed (date of test performance), celltype, unit
(of the dose/concentration), and for the ok field in the database.</td></tr>
</table>
<h3>Author(s)</h3>
<p>
Johannes Ranke
<a href="mailto:jranke@uni-bremen.de">jranke@uni-bremen.de</a>
<a href="http://www.uft.uni-bremen.de/chemie/ranke">http://www.uft.uni-bremen.de/chemie/ranke</a>
</p>
<h3>Examples</h3>
<pre>
# Get cytotoxicity data for Tributyltin and zinc pyrithione, tested with IPC-81 cells
## Not run: data <- drdata(c("TBT","Zn Pyrithion"))
</pre>
<hr><div align="center"><a href="00Index.html">[Package Contents]</a></div>
</body></html>
|
