如何在R Studio中自动刷新SQL查询

install.packages("DBI")
install.packages("pool")

library(DBI)
library(pool)

# 替换以下参数为你的数据库连接信息
db <- dbPool(
  drv = RMySQL::MySQL(),
  dbname = "your_database_name",
  host = "your_host",
  port = your_port,
  user = "your_username",
  password = "your_password"
)

execute_query <- function(query) {
  dbGetQuery(db, query)
}

install.packages("cronR")

library(cronR)

# 替换以下参数为你的SQL查询和刷新频率
query <- "SELECT * FROM your_table"
frequency <- cron_r("*/5 * * * *")

# 创建定时任务
task <- cron_rscript(
  script = "path_to_your_r_script.R",  # 替换为你的R脚本路径
  frequency = frequency,
  id = "refresh_sql_query"
)

# 启动定时任务
cron_add(task)