fetch-methods            package:RSQLite            R Documentation

_F_e_t_c_h _r_e_c_o_r_d_s _f_r_o_m _a _p_r_e_v_i_o_u_s_l_y _e_x_e_c_u_t_e_d _q_u_e_r_y

_D_e_s_c_r_i_p_t_i_o_n:

     This method is a straight-forward implementation of the
     corresponding generic function.

_D_e_t_a_i_l_s:

     The 'RSQLite' implementations retrieves all records into a  buffer
     internally managed by the RSQLite driver (thus this memory in not
     managed by R but its part of the R process), and 'fetch' simple
     returns records from this internal buffer.

_M_e_t_h_o_d_s:



     _r_e_s an 'SQLiteResult' object.

     _n maximum number of records to retrieve per fetch. Use 'n = -1' to
          retrieve all pending records; use a value of 'n = 0' for
          fetching the default number  of rows 'fetch.default.rec'
          defined in the  'SQLite' initialization invocation.

     ...  currently not used.

_R_e_f_e_r_e_n_c_e_s:

     See the Database Interface definition document 'DBI.pdf' in the
     base directory of this package or <URL:
     http://stat.bell-labs.com/RS-DBI>.

_S_e_e _A_l_s_o:

     'SQLite', 'dbConnect', 'dbSendQuery', 'dbGetQuery',
     'dbClearResult', 'dbCommit', 'dbGetInfo', 'dbReadTable'.

_E_x_a_m_p_l_e_s:

     drv <- dbDriver("SQLite")
     tfile <- tempfile()
     con <- dbConnect(drv, dbname = tfile)
     data(USJudgeRatings)
     dbWriteTable(con, "jratings", USJudgeRatings)

     res <- dbSendQuery(con, statement = paste(
                           "SELECT row_names, ORAL, DILG, FAMI",
                           "FROM jratings"))

     # we now fetch the first 10 records from the resultSet into a data.frame
     data1 <- fetch(res, n = 10)   
     dim(data1)

     dbHasCompleted(res)

     # let's get all remaining records
     data2 <- fetch(res, n = -1)

     dbClearResult(res)
     dbDisconnect(con)

