Description Usage Arguments Examples
query raw data, all b_ tables at once
1 2 3 4 5 6 7 |
username |
username |
host |
host |
q |
query,boxtables kw should be used instead of bnnn box name. |
db |
default to getOption('snbDB_v2') |
.boxes |
default to 1:277 |
ncores |
number of cores to use |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | ## Not run:
# Simple SELECT
dbqSNB('snbAdmin', host = "scidb.mpio.orn.mpg.de", 'SELECT * FROM boxtables limit 1')
# Last entry
dbqSNB('snbAdmin', host = "scidb.mpio.orn.mpg.de", 'SELECT * FROM boxtables ORDER BY r_pk desc limit 1')
# SELECT last n days
x = dbqSNB('snbAdmin', host = "scidb.mpio.orn.mpg.de",
'SELECT datetime_, LB, transp FROM boxtables
WHERE datetime_ >= DATE_ADD( (SELECT max(datetime_) from boxtables) , INTERVAL -3 DAY) AND
YEAR(datetime_) = YEAR(CURDATE() )
')
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.