Run a SQL Query script on the CHILDES database
get_sql_query( sql_query_string, connection = NULL, db_version = "current", db_args = NULL )
sql_query_string | A valid sql query string character |
---|---|
connection | A connection to the CHILDES database |
db_version | String of the name of database version to use |
db_args | List with host, user, and password defined |
The database after calling the supplied SQL query
# \donttest{ get_sql_query("SELECT * FROM collection")#>#> # A tibble: 33 x 3 #> id name data_source #> <int> <chr> <chr> #> 1 1 Frogs CHILDES #> 2 2 Eng-NA CHILDES #> 3 3 Scandinavian CHILDES #> 4 4 Spanish CHILDES #> 5 5 French CHILDES #> 6 6 DutchAfrikaans CHILDES #> 7 7 Chinese CHILDES #> 8 8 Other CHILDES #> 9 9 Japanese CHILDES #> 10 10 Romance CHILDES #> # … with 23 more rows# }