{ "_id": "6ad1e49d29625c14e47aee28", "Package": "expDB", "Type": "Package", "Title": "Database for Experiment Dataset", "Version": "0.3.0", "Maintainer": "Bangyou Zheng ", "Authors@R": "person(\"Bangyou\", \"Zheng\", \nemail = \"bangyou.zheng@csiro.au\",\nrole = c(\"aut\", \"cre\"))", "Description": "A 'SQLite' database is designed to store all information\nof experiment-based data including metadata, experiment design,\nmanagements, phenotypic values and climate records. The dataset\ncan be imported from an 'Excel' file.", "License": "MIT + file LICENSE", "URL": "https://expdb.bangyou.me/, https://github.com/byzheng/expdb", "BugReports": "https://github.com/byzheng/expdb/issues", "Encoding": "UTF-8", "RoxygenNote": "7.3.2", "Config/pak/sysreqs": "libicu-dev libpng-dev", "Repository": "https://byzheng.r-universe.dev", "Date/Publication": "2025-09-23 11:52:53 UTC", "RemoteUrl": "https://github.com/byzheng/expdb", "RemoteRef": "HEAD", "RemoteSha": "9e0a9c568664a6fec62e78744242294ad94ffee1", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-16 07:55:16 UTC", "User": "root" }, "Author": "Bangyou Zheng [aut, cre]", "_user": "byzheng", "_type": "src", "_file": "expDB_0.3.0.tar.gz", "_fileid": "https://r2.ropensci.org/028e0573c11e16829fa52f5b75b8ca0f4deb098049c1766c7e5899e79500abc6", "_filesize": 257857, "_sha256": "028e0573c11e16829fa52f5b75b8ca0f4deb098049c1766c7e5899e79500abc6", "_expires": "2027-01-24T08:47:21.000Z", "_created": "2026-10-16T07:55:16.000Z", "_published": "2026-10-16T08:47:25.002Z", "_buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116872574552, "time": 146, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12032517747" }, { "job": 116872574531, "time": 111, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12033451151" }, { "job": 116872574967, "time": 101, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12035920312" }, { "job": 116872574679, "time": 102, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12034948846" }, { "job": 116869201541, "time": 598, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12032781808" }, { "job": 116872574797, "time": 93, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12033496019" }, { "job": 116872574830, "time": 79, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12033006690" }, { "job": 116872574815, "time": 94, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12032633014" }, { "job": 116872574725, "time": 75, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12033490963" } ], "_upstream": "https://github.com/byzheng/expdb", "_commit": { "id": "9e0a9c568664a6fec62e78744242294ad94ffee1", "author": "Bangyou Zheng ", "committer": "Bangyou Zheng ", "message": "A new version to CRAN\n", "time": 1758628373 }, "_maintainer": { "name": "Bangyou Zheng", "email": "bangyou.zheng@csiro.au", "login": "zhe00a", "description": "", "uuid": 244883958 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "readxl", "role": "Imports" }, { "package": "png", "role": "Imports" }, { "package": "grid", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "weaana", "version": ">= 0.1.1", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "reshape2", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "byzheng", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "zhe00a", "count": 40, "uuid": 244883958 }, { "user": "byzheng", "count": 18, "uuid": 1657381 } ], "_userbio": { "uuid": 1657381, "type": "user", "name": "Bangyou Zheng", "followers": 54, "description": "Bangyou is a research scientist at CSIRO. His research interests include crop modelling, crop adaptation, high throughput phenotype, big data and R programming." }, "_downloads": { "count": 339, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/expDB" }, "_devurl": "https://github.com/byzheng/expdb", "_pkgdown": "https://expdb.bangyou.me/", "_searchresults": 4, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/expDB.html", "extra/manual.pdf", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/byzheng/expdb", "_realowner": "byzheng", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2021-10-08" }, { "version": "0.3.0", "date": "2025-09-23" } ], "_exports": [ "approx_zadoks", "dbAddDesigns", "dbAddFertilization", "dbAddGene", "dbAddGeneAllele", "dbAddGenotype", "dbAddIrrigatons", "dbAddLog", "dbAddMethods", "dbAddMets", "dbAddNodes", "dbAddPhenotype", "dbAddResearcher", "dbAddSites", "dbAddSource", "dbAddTraits", "dbAddTrials", "dbAddTrialSoil", "dbAddWeather", "dbExportMet", "dbGenotypeCheckName", "dbGetDryWeightPerStem", "dbGetFertilization", "dbGetFieldMaturity", "dbGetFieldPopulation", "dbGetFieldStemNumber", "dbGetFieldTillerNumber", "dbGetGene", "dbGetGenotype", "dbGetIrrigation", "dbGetLog", "dbGetMetInfo", "dbGetOrganFinalLeafNumber", "dbGetOrganHaunIndex", "dbGetPhenotype", "dbGetPlantFlowering", "dbGetPlantHeading", "dbGetPlantStemElongation", "dbGetPlantStemNumber", "dbGetPlantTillerNumber", "dbGetSites", "dbGetSource", "dbGetTraits", "dbGetTrials", "dbGetWeather", "dbGetZadoksStage", "dbImportXLSX", "dbListTrials", "expdbConnect", "expdbCreateDB", "expdbDisconnect", "harvestQuadratDetail" ], "_help": [ { "page": "approx_zadoks", "title": "Approximate Date for a Target Zadoks Stage", "topics": [ "approx_zadoks" ] }, { "page": "dbAddDesigns", "title": "Add design for a trial", "topics": [ "dbAddDesigns" ] }, { "page": "dbAddFertilization", "title": "Insert or Update fertilization into expDB", "topics": [ "dbAddFertilization" ] }, { "page": "dbAddGene", "title": "Add gene information into database", "topics": [ "dbAddGene" ] }, { "page": "dbAddGeneAllele", "title": "Add gene allele information into database", "topics": [ "dbAddGeneAllele" ] }, { "page": "dbAddGenotype", "title": "Add genotypes into expDB", "topics": [ "dbAddGenotype" ] }, { "page": "dbAddIrrigatons", "title": "Insert or Update irrigation into expDB", "topics": [ "dbAddIrrigatons" ] }, { "page": "dbAddLog", "title": "Add log from expDB", "topics": [ "dbAddLog" ] }, { "page": "dbAddMethods", "title": "Insert or Update methods into expDB", "topics": [ "dbAddMethods" ] }, { "page": "dbAddMets", "title": "Insert and update met into expDB", "topics": [ "dbAddMets" ] }, { "page": "dbAddNodes", "title": "Add nodes into expDB", "topics": [ "dbAddNodes" ] }, { "page": "dbAddPhenotype", "title": "Add design for a trial", "topics": [ "dbAddPhenotype" ] }, { "page": "dbAddResearcher", "title": "Insert and update researcher into expDB", "topics": [ "dbAddResearcher" ] }, { "page": "dbAddSites", "title": "Insert or update site into expDB", "topics": [ "dbAddSites" ] }, { "page": "dbAddSource", "title": "Insert and update source into expDB", "topics": [ "dbAddSource" ] }, { "page": "dbAddTraits", "title": "Insert or update trait into expDB", "topics": [ "dbAddTraits" ] }, { "page": "dbAddTrials", "title": "Insert or Update trial into expDB", "topics": [ "dbAddTrials" ] }, { "page": "dbAddTrialSoil", "title": "Add soil for a trial", "topics": [ "dbAddTrialSoil" ] }, { "page": "dbAddWeather", "title": "Add weather records into expDB", "topics": [ "dbAddWeather" ] }, { "page": "dbAppendTable", "title": "Append a table into db and check the column name", "topics": [ "dbAppendTable" ] }, { "page": "dbExportMet", "title": "Export trials weather records to met file", "topics": [ "dbExportMet" ] }, { "page": "dbGenotypeCheckName", "title": "Check genotype names", "topics": [ "dbGenotypeCheckName" ] }, { "page": "dbGetDryWeightPerStem", "title": "Get the dry weight per stem", "topics": [ "dbGetDryWeightPerStem" ] }, { "page": "dbGetFertilization", "title": "Get fertilization from database", "topics": [ "dbGetFertilization" ] }, { "page": "dbGetFieldMaturity", "title": "Estimation of maturity", "topics": [ "dbGetFieldMaturity" ] }, { "page": "dbGetFieldPopulation", "title": "Estimation of plant populations", "topics": [ "dbGetFieldPopulation" ] }, { "page": "dbGetFieldStemNumber", "title": "Estimation of stem number per unit area", "topics": [ "dbGetFieldStemNumber" ] }, { "page": "dbGetFieldTillerNumber", "title": "Estimation of tiller number per unit area", "topics": [ "dbGetFieldTillerNumber" ] }, { "page": "dbGetGene", "title": "Get the gene information", "topics": [ "dbGetGene" ] }, { "page": "dbGetGenotype", "title": "Get the genotype information", "topics": [ "dbGetGenotype" ] }, { "page": "dbGetIrrigation", "title": "Get irrigation from database", "topics": [ "dbGetIrrigation" ] }, { "page": "dbGetLog", "title": "Get log from expDB", "topics": [ "dbGetLog" ] }, { "page": "dbGetMetInfo", "title": "Get met information", "topics": [ "dbGetMetInfo" ] }, { "page": "dbGetOrganFinalLeafNumber", "title": "Get the final leaf number", "topics": [ "dbGetOrganFinalLeafNumber" ] }, { "page": "dbGetOrganHaunIndex", "title": "Get Haun Index", "topics": [ "dbGetOrganHaunIndex" ] }, { "page": "dbGetPhenotype", "title": "Get phenotype values through a group of conditions", "topics": [ "dbGetPhenotype" ] }, { "page": "dbGetPlantFlowering", "title": "Estimation of flowering time", "topics": [ "dbGetPlantFlowering" ] }, { "page": "dbGetPlantHeading", "title": "Estimation of heading time", "topics": [ "dbGetPlantHeading" ] }, { "page": "dbGetPlantStemElongation", "title": "Estimation of stem elongation", "topics": [ "dbGetPlantStemElongation" ] }, { "page": "dbGetPlantStemNumber", "title": "Estimation of stem number per plant", "topics": [ "dbGetPlantStemNumber" ] }, { "page": "dbGetPlantTillerNumber", "title": "Estimation of tiller number per plant", "topics": [ "dbGetPlantTillerNumber" ] }, { "page": "dbGetSites", "title": "Get site into expDB", "topics": [ "dbGetSites" ] }, { "page": "dbGetSource", "title": "Get source from expDB", "topics": [ "dbGetSource" ] }, { "page": "dbGetTraits", "title": "Get trait list", "topics": [ "dbGetTraits" ] }, { "page": "dbGetTrials", "title": "Get trials by a groups of conditions.", "topics": [ "dbGetTrials" ] }, { "page": "dbGetWeather", "title": "Get weather records from expDB", "topics": [ "dbGetWeather" ] }, { "page": "dbGetZadoksStage", "title": "Obtain the key phenology stage", "topics": [ "dbGetZadoksStage" ] }, { "page": "dbImportXLSX", "title": "Import data from excel file", "topics": [ "dbImportXLSX" ] }, { "page": "dbInsertUpdateByRow", "title": "Insert new rows or update existing rows to a specific table according to a specific column (unique) by each row", "topics": [ "dbInsertUpdateByRow" ] }, { "page": "dbListTrials", "title": "List all trials", "topics": [ "dbListTrials" ] }, { "page": "expdbConnect", "title": "Connect to expDB", "topics": [ "expdbConnect" ] }, { "page": "expdbCreateDB", "title": "create to expDB", "topics": [ "expdbCreateDB" ] }, { "page": "expdbDisconnect", "title": "Didconnect to expDB", "topics": [ "expdbDisconnect" ] }, { "page": "getIdByUniqueIndex", "title": "Get index id by unique_columns.", "topics": [ "getIdByUniqueIndex" ] }, { "page": "harvestQuadratDetail", "title": "Process quadrat (detail) harvestQuadratDetail", "topics": [ "harvestQuadratDetail" ] } ], "_readme": "https://github.com/byzheng/expdb/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "cellranger", "cli", "cpp11", "crayon", "DBI", "dplyr", "fastmap", "generics", "glue", "hms", "lifecycle", "lubridate", "magrittr", "memoise", "pillar", "pkgconfig", "plyr", "png", "prettyunits", "progress", "purrr", "R6", "Rcpp", "readxl", "rematch", "reshape2", "rlang", "RSQLite", "settings", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "utf8", "vctrs", "weaana", "withr" ], "_score": 2.6989700043360187, "_indexed": true, "_nocasepkg": "expdb", "_universes": [ "byzheng", "zhe00a" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0", "date": "2026-10-16T07:57:50.000Z", "distro": "resolute", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/f67c2386a6337c13416ca91b7f9c31f76150ad7db7af9af647af930b4b12957f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.6.1", "os": "linux", "version": "0.3.0", "date": "2026-10-16T07:57:13.000Z", "distro": "resolute", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/7d788647ab6771be617394a15ce95c58c60ab671ad72f1c950d7739878c3b66e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0", "date": "2026-10-16T08:46:40.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/1ee67be4cb20e93db9ff6fce181f88ca8e9fe8eb2b397dc15830190843cc8269", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.6.1", "os": "mac", "version": "0.3.0", "date": "2026-10-16T08:40:54.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/ce558a75e342be8ba422863c232da400a6af892158e4856ea026f46e4a5b1c7a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0", "date": "2026-10-16T07:57:13.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/d9515eb971909fa73b03c4a0cc88d7d3a5729ff93d5bc9ad2553d35c1d948c5c", "status": "success", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.7.0", "os": "win", "version": "0.3.0", "date": "2026-10-16T07:56:35.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/2697c5009afbaa82e3efbc3833e29b049837517a562e796721e2a50a4f25de76", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.5.3", "os": "win", "version": "0.3.0", "date": "2026-10-16T07:56:49.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/7618b2084e133a0015660b23e1b68e222288794acde5da5b3ae5136787e4a2a7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" }, { "r": "4.6.1", "os": "win", "version": "0.3.0", "date": "2026-10-16T07:56:28.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "https://r2.ropensci.org/f07a6d1e92e492fcb4cb0115e085168781fe42c47f65d4f4c4142bc043030a2a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/38869214214" } ] }