search for: mysqlconnection

(I think this is being caused by the new methods package in RC.) In the RC (March 24) some of my packages are generating a Note Note: Method with signature "MySQLConnection#integer" chosen for function "coerce", target signature "TSMySQLConnection#integer". "dbObjectId#integer" would also be valid This is coming from a call to dbGetQuery() in package DBI. The method with the signature "TSMySQLConnection#integer" is g...

...classDef, 2: methods currently exist for coercing from "TSconnection" to "DBIConnection"; they will be replaced. in: ..removePreviousCoerce(class1, class2, where, prevIs) # (warning may be important, but I don't understand it) > setAs("TSconnection", "MySQLConnection", def = function(from) from at con) > setIs("TSconnection", "MySQLConnection", coerce = function(x) x at con) Warning messages: 1: there is no automatic definition for as(object, "MySQLConnection") <- value when object has class "TSconnection" an...

Hi, I'm trying to R CMD check a package, however I have hit a snag. There seems to be a problem with the creation of the /html files (the only file that's constructed here is the 00Index.html). I've tested each of the .Rd files independently with R CMD Rdconv, they all happily create html files without complaint. R CMD check <package> gives the no warnings. I'm therefore

...I would like to retrieve data stored in MySQL database, so I installed RMySQL package. I can successfully connect with the my database using the following code > dvr<-dbDriver("MySQL") > con2<-dbConnect(dvr,group="exbardiv") > mysqlDescribeConnection(con2) <MySQLConnection:(972,0)> User: mmorag Host: localhost Dbname: exbardiv Connection type: localhost via TCP/IP No resultSet available I can even see the tables in the database > dbListTables(con2) [1] "agoueb" "high_ld" "rescue" "sjlc_info" &quot...

...es not work in assignTable() in RMySQL ? More specifically: I cannot append a data.frame to an existing table in a MySQL database, although I can use the same data.frame to create a new table. Even more specifically: > assignTable(con,"employee",dita,append=T) Error in execStatement.MySQLConnection(con, statement, ...) : RS-DBI driver: (could not run statement: Table 'employee' already exists) [1] FALSE === Jan de Leeuw; Professor and Chair, UCLA Department of Statistics; US mail: 9432 Boulter Hall, Box 951554, Los Angeles, CA 90095-1554 phone (310)-825-9550; fax (310)-206...

...d package: DBI [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "dbGetInfo" [1] "dbListResults" [1] "summary" [1] &quot...

...st ** save image [1] TRUE [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "dbGetInfo" [1] "dbListResults" [1] "summary" [1] "dbListTabl...

...t; > [1] "format" > [1] "show" > [1] "print" > [1] "MySQLObject" > [1] "MySQLDriver" > [1] "dbUnloadDriver" > [1] "dbGetInfo" > [1] "dbListConnections" > [1] "summary" > [1] "MySQLConnection" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbDisconnect" > [1] "dbSendQuery" > [1] "dbGetQuery" > [1] "dbGetException" > [1] "dbGetInfo" > [1] "dbListResults"...

I am trying to use R interfaced with MySQL. Present goal is that R should calculate the 85% quantile of AvgSpeed for each LinieID. Looking through documentation of the RMySQL Package, I guessed that dbApply would do the trick due to this example ## compute quanitiles for each network agent con <- dbConnect(MySQL(), group="vitalAnalysis") res <- dbSendQuery(con,

There is a little problem in handling logicals in RMySQL: # here is the MySQL connection > con <MySQLConnection:(1816,0)> # here is the data frame > print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE))) x y 1 TRUE FALSE 2 FALSE TRUE # as promised, the two data frame columns are identified as logicals and # the field types are set to tinyint > field.types <- sapply(a, dbDataType...

...return(.Object); } ); #----------------------------------------------------- # CLASS Employee (extends Person) #----------------------------------------------------- setClass("Employee",representation("Person", service="character", con="MySQLConnection")); # con : connection to be established with MySQL database # constructor setMethod("initialize","Employee", function(.Object) { .Object <- callNextMethod(); # calls the superclass constructor .Object at con <- db...

...return(.Object); } ); #----------------------------------------------------- # CLASS Employee (extends Person) #----------------------------------------------------- setClass("Employee",representation("Person", service="character", con="MySQLConnection")); # con : connection to be established with MySQL database # constructor setMethod("initialize","Employee", function(.Object) { .Object <- callNextMethod(); # calls the superclass constructor .Object at con <- db...

I have to write extensions to R regularly. One of them was an interface to a mysql database on a different computer. The best way to do that is to have something like mysql<-function (dbname, host = "zap", user = "nobody", password = "ok") { handle <<- .RC("mysqlconnect", c(host, user, password, dbname)) } and query<-function (cmd) {

...the last statement above. On the asumption tha tthat is a data frame, I tried dbWriteTable(con,"test1",ndf); But I received the following error: Error in function (classes, fdef, mtable) : unable to find an inherited method for function "dbWriteTable", for signature "MySQLConnection", "character", "matrix" Then, on the assumption it is trivial to convert a matrix into a data.frame, i tried: dbWriteTable(con,"test2",as.data.frame(ndf)); But this produced the following error: Error in write.table(x, file, nrow(x), p, rnames, sep, eol, na, de...

...exist",* * default.file))* * }* * drvId <- as(drv, "integer")* * conId <- .Call("RS_MySQL_newConnection", drvId, con.params,* * groups, default.file, PACKAGE = .MySQLPkgName) // here it gets stopped,traceback line 1* * new("MySQLConnection", Id = conId)* *}* -- Thanks in advance Moumita [[alternative HTML version deleted]]

...mat" in "RMySQL" Creating a new generic function for "print" in "RMySQL" ** help >>> Building/Updating help pages for package 'RMySQL' Formats: text html latex example MySQL text html latex example MySQLConnection-class text html latex example MySQLDriver-class text html latex example MySQLObject-class text html latex example MySQLResult-class text html latex example RMySQL-package text...