Get information about oak and truffles — get

This function retrieves information about oak trees and truffles based on the provided databases and oak tree ID.

Usage

get_info(dbchene, dbtruffe, dbreensemence, theidoak)

Arguments

dbchene: Database containing information about oak trees.
dbtruffe: Database containing information about truffles.
dbreensemence: Database containing reseeding information.
theidoak: ID of the oak tree for which information is to be retrieved.

Value

A list containing information about oak trees and truffles.

Examples

conn <- DBI::dbConnect(RSQLite::SQLite(), system.file("chenes_truffe.sqlite", package = "truffles"))
chene <- DBI::dbReadTable(conn, name = "chenes")
truffe <- DBI::dbReadTable(conn, name = "truffe")
reensemence <- DBI::dbReadTable(conn, name = "reens")

get_info(dbchene = chene, dbtruffe = truffe, dbreensemence = reensemence, theidoak = "162")
#> $chene
#> $chene$type
#> character(0)
#> 
#> $chene$planting_date
#> Date of length 0
#> 
#> 
#> $truffes
#> $truffes$weight_tot
#> [1] 0
#> 
#> $truffes$derniere_truffe
#> [1] "-"
#> 
#> $truffes$last_comment
#> [1] "-"
#> 
#> $truffes$other_comments
#> [1] "-"
#> 
#> 
#> $reensemence
#> [1] "-"
#> 
DBI::dbDisconnect(conn)