Get information about truffles associated with an oak tree

This function retrieves information about truffles associated with a specific oak tree based on the oak tree's ID from the provided truffle database.

Usage

get_info_chene_truffe(dbtruffe, theidoak)

Arguments

dbtruffe

Database containing information about truffles.

theidoak

ID of the oak tree for which information about associated truffles is to be retrieved.

Value

A list containing information about truffles associated with the oak tree, including the total weight, date of the last truffle found, and any comments.

Examples

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

get_info_chene_truffe(dbtruffe = truffe, theidoak = "119")
#> $weight_tot
#> [1] 0
#> 
#> $derniere_truffe
#> [1] "-"
#> 
#> $last_comment
#> [1] "-"
#> 
#> $other_comments
#> [1] "-"
#> 
DBI::dbDisconnect(conn)