{ "_id": "6a1ef902b401979e73417f00", "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-05-19 05:54:02 UTC", "User": "root" }, "Author": "Bangyou Zheng [aut, cre]", "MD5sum": "132545e789139467ee8397e61d5827f4", "_user": "byzheng", "_type": "src", "_file": "expDB_0.3.0.tar.gz", "_fileid": "84a9aa186363856663944616bc7002bc1510d84069ed248ccc8818f57d2e4c76", "_filesize": 257248, "_sha256": "84a9aa186363856663944616bc7002bc1510d84069ed248ccc8818f57d2e4c76", "_created": "2026-05-19T05:54:02.000Z", "_published": "2026-06-02T15:38:42.645Z", "_distro": "noble", "_jobs": [ { "job": 79110278713, "time": 127, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7075904589" }, { "job": 79110278965, "time": 139, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7075907285" }, { "job": 79110279347, "time": 75, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7075893208" }, { "job": 79110279398, "time": 75, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7075893376" }, { "job": 79110277984, "time": 203, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7075877398" }, { "job": 79110278363, "time": 118, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7362519349" }, { "job": 79110279149, "time": 122, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7075903615" }, { "job": 79110279409, "time": 132, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7075905851" }, { "job": 79110280371, "time": 89, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7075896217" } ], "_buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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": [ { "week": "2025-35", "n": 7 }, { "week": "2025-39", "n": 1 } ], "_tags": [ { "name": "v0.3.0", "date": "2025-09-23" } ], "_stars": 0, "_contributors": [ { "user": "zhe00a", "count": 40, "uuid": 244883958 }, { "user": "byzheng", "count": 18, "uuid": 1657381 } ], "_userbio": { "uuid": 1657381, "type": "user", "name": "Bangyou Zheng", "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": 245, "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.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/expDB.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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": 3, "_indexed": true, "_nocasepkg": "expdb", "_universes": [ "byzheng", "zhe00a" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0", "date": "2026-05-19T05:56:07.000Z", "distro": "noble", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "a6c0e2caf0a9b68543efe90e6a87d63bcd62eef8bbba63035bf7239548442fc5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.6.0", "os": "linux", "version": "0.3.0", "date": "2026-05-19T05:56:16.000Z", "distro": "noble", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "dda1ed62c0bef67a7c5730ef41cb147a3f8e487a283b8649232b810db1d678b7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0", "date": "2026-05-19T05:55:21.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "a3cd103281b8443830648a86ebae8104b62f190a784031a4f25f45020101af78", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.6.0", "os": "mac", "version": "0.3.0", "date": "2026-05-19T05:55:22.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "922a4af85d0f5c85c1b97b03b89d9efeb689f8406b55080fd95e868bf8cfef68", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.7.0", "os": "win", "version": "0.3.0", "date": "2026-05-19T05:55:58.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "0fa0fc56139dd676e663859bf74fe975c3c40062c08a60a0faab27bc24ed9a6b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.5.3", "os": "win", "version": "0.3.0", "date": "2026-05-19T05:56:09.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "6742904ac767b04e77ba3546d6dd197b7f9ccca65ceb73166f7511dbd66a2a3f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.6.0", "os": "win", "version": "0.3.0", "date": "2026-05-19T05:55:19.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "c092e37f79c8680f32d32d93154bf80e503492cdd0db13a389d6da82f0645129", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0", "date": "2026-06-02T15:38:13.000Z", "commit": "9e0a9c568664a6fec62e78744242294ad94ffee1", "fileid": "7b137ed1a3868ba98c3e7d534a4c5553676a3d1857c0faaf51dbddb1fb42b787", "status": "success", "buildurl": "https://github.com/r-universe/byzheng/actions/runs/26078949585" } ] }