Class "ViewerDataMySQL"

Description

An object representing the SQL query to view.

Objects from the Class

Objects can be created using the viewerDataMySQL function.

Slots

dbcon:

Object of class "MySQLConnection" giving a connection to the database server.

query:

Object of class "character" giving the SQL query.

colnames:

Object of class "character" giving the column names of the query result.

paddednames:

Object of class "character" giving the column names padded to the maximum width of the columns.

widths:

Object of class "numeric" giving the number of characters in each column of the result.

nlines:

Object of class "numeric" giving the number of rows in the result.

Extends

The virtual class "ViewerData", directly.

Methods

colNames

signature(data = "ViewerDataMySQL", cols = "ANY"): provide the names of the specified columns.

colWidths

signature(data = "ViewerDataMySQL"): provide the number of characters in each of the specified columns.

dimensions

signature(data = "ViewerDataMySQL"): provide the number of rows and columns in the data.

getText

signature(data = "ViewerDataMySQL", rows = "ANY", cols = "ANY"): provide a text version of a subset of the data as specified by the rows and columns.

Author(s)

Paul Murrell

See Also

Viewer

Examples

showClass("ViewerDataMySQL")