InsitesSqlConnectJDBC: SQL Server Connection

In ivanliu1989/RQuantAPI: A collection of functions of API connections from different brokers

Description

Connect to Sql Server databases

Usage

InsitesSqlConnectJDBC(disconnect = FALSE, conn = NULL, firstTime = FALSE)

Arguments

disconnect	TRUE/FALSE disconnect or connect
conn	only requeired if you want to disconnect an existing connection
firstTime	TRUE/FALSE if it's the first time to connect

Value

A conn of database

Examples

# connect
conn <- InsitesSqlConnectJDBC()
sqlquery1 <- "select capiq_symbol_ticker, capiq_symbol_exchange, pricing_date, price_close, volume from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
sqlquery2 <- "select distinct capiq_symbol_ticker, capiq_symbol_exchange from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
res <- dbGetQuery(conn, sqlquery1)
res <- dbGetQuery(conn, sqlquery2)
sqlText <- paste("SELECT top 10 * FROM TABLE_NAME", sep="")
queryResults <- dbGetQuery(conn, sqlText)

# disconnect
InsitesSqlConnectJDBC(disconnect = TRUE, conn)

ivanliu1989/RQuantAPI documentation built on Sept. 13, 2019, 11:54 a.m.