From 8154a03c79eb910c42dcff03fd8fa611cdc8cc9d Mon Sep 17 00:00:00 2001
From: "(no author)" <(no author)@d1b72e20-2ee0-0310-a1c4-ad5adbbefcdc>
Date: Tue, 27 Jul 2004 07:36:01 +0000
Subject: First version published on CRAN
git-svn-id: http://kriemhild.uft.uni-bremen.de/svn/drfit@1 d1b72e20-2ee0-0310-a1c4-ad5adbbefcdc
---
chm/drdata.html | 146 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 146 insertions(+)
create mode 100644 chm/drdata.html
(limited to 'chm/drdata.html')
diff --git a/chm/drdata.html b/chm/drdata.html
new file mode 100644
index 0000000..7dd4a2b
--- /dev/null
+++ b/chm/drdata.html
@@ -0,0 +1,146 @@
+Get dose-response data
+
+
+
+
+
drdata(drfit)
R Documentation
+
+
+
Get dose-response data
+
+
+
Description
+
+
+Get dose-response data from a remote mysql server
+
+
+
+
Usage
+
+
+ drdata(substances, experimentator = "%", db = "cytotox", celltype = "IPC-81",
+ whereClause = "1", ok = "'ok'")
+
+
+
+
Arguments
+
+
+
substances
+
+A string or an array of strings with the substance names for
+which dose-response data is to be retrieved.
+
experimentator
+
+The name of the experimentator whose data is to be used.
+
db
+
+The database to be used. Currently only "cytotox" of the UFT Department of
+Bioorganic Chemistry is supported.
+
celltype
+
+Currently, only data for IPC-81, C6, NB4, HeLa, Jurkat and U937 are supported.
+
whereClause
+
+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).
+
ok
+
+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.
+
+
+
Details
+
+
+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 ‘/etc/odbcinst.ini’
+containing:
+
+
+
[MySQL]
+
+
+
Description
=
MySQL driver for ODBC
+
+
+
Driver
=
/usr/local/lib/libmyodbc.so
+
+
+
Setup
=
/usr/lib/odbc/libodbcmyS.so
+
+
+
+and the file ‘/etc/odbc.ini’ containing:
+
+
+
[cytotox]
+
+
+
Description
=
Cytotoxicity database of the department of bioorganic chemistry, UFT Bremen
+
+
+
Driver
=
MySQL
+
+
+
Trace
=
Yes
+
+
+
TraceFile
=
/tmp/odbc.log
+
+
+
Database
=
cytotox
+
+
+
Server
=
eckehaat
+
+
+
Port
=
3306
+
+
+.
+
+
+
+
Value
+
+
+
data
+
+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.