Struct Plants

pub struct Plants {

    pub id: i32,
    pub unique_name: String,
    pub common_name_en: Option<Vec<Option<String>>>,
    pub common_name_de: Option<Vec<Option<String>>>,
    pub family: Option<String>,
    pub edible_uses_en: Option<String>,
    pub functions: Option<String>,
    pub heat_zone: Option<i16>,
    pub shade: Option<Shade>,
    pub soil_ph: Option<Vec<Option<SoilPh>>>,
    pub soil_texture: Option<Vec<Option<SoilTextureEnum>>>,
    pub ecosystem_niche: Option<String>,
    pub deciduous_or_evergreen: Option<DeciduousOrEvergreen>,
    pub herbaceous_or_woody: Option<HerbaceousOrWoody>,
    pub life_cycle: Option<Vec<Option<LifeCycle>>>,
    pub growth_rate: Option<Vec<Option<GrowthRate>>>,
    pub height: Option<i32>,
    pub fertility: Option<Vec<Option<Fertility>>>,
    pub created_at: NaiveDateTime,
    pub updated_at: NaiveDateTime,
    pub has_drought_tolerance: Option<bool>,
    pub tolerates_wind: Option<bool>,
    pub preferable_permaculture_zone: Option<i16>,
    pub hardiness_zone: Option<String>,
    pub light_requirement: Option<Vec<Option<LightRequirement>>>,
    pub water_requirement: Option<Vec<Option<WaterRequirementEnum>>>,
    pub propagation_method: Option<Vec<Option<PropagationMethod>>>,
    pub alternate_name: Option<String>,
    pub edible: Option<bool>,
    pub edible_parts: Option<Vec<Option<String>>>,
    pub spread: Option<i32>,
    pub warning: Option<String>,
    pub version: Option<i16>,
    pub external_source: Option<ExternalSource>,
    pub sowing_outdoors: Option<Vec<Option<i16>>>,
    pub harvest_time: Option<Vec<Option<i16>>>,
    pub seed_weight_1000: Option<f64>,
}

The Plants entity builds up an hierarchical structure, see /doc/database/hierarchy.md:

Hierarchy

This document explains the hierarchy of the plants table. Please make sure that you already read the biology section of the glossary.

Introduction

The plants table contains entries of:

• concrete plants, or
• abstract plants (representants of ranks)

Concrete plants can be:

• dragged and dropped to the map and
• used as seed entry.

Abstract plants can be:

• used to inherit attributes.

A concrete plant can be of following rank:

• on species level, or
• on variety level, or
• on cultivar level.

Furthermore following must be true:

• genus is below a family,
• specie is below a genus,
• a variety is below a specie,
• a cultivar is below to a specie or a variety

The diagram below shows the hierarchy of entities with height and width as an example of attribute classification.

classDiagram

  class Family:::abstract {
    +int height
    +int width
  }
  class Genus:::abstract {
    +int height
    +int width
  }
  class Species {
    +int height
    +int width
  }
  class Variety {
    +int height
    +int width
  }
  class Cultivar {
    +int height
    +int width
  }

  Variety <|-- Cultivar
  Species <|-- Cultivar
  Species <|-- Variety
  Genus <|-- Species
  Family <|-- Genus

Each of these entities can have their own attributes. E.g., a variety below a specie can have different height than the specie itself.

Unique Name

In the database we have a column unique_name. The unique name are, either for abstract plants:

• single latin word to specify “family”, which always ends on: -aceae
• single latin word to specify “genus”

Or is built up by several words (for concrete plants):

• single latin word to specify “genus”
• single latin word to specify “specie”
• optional single latin word to specify “variety”
• optional several words in single quotes to specify “cultivar”, which starts with a capital letter

E.g. Brassica oleracea italica 'Ramoso calabrese'

Hybrid Names

Hybrid names are built up differently. Either two parent binomials, separated by a “x” or “×” or a given binomial, with or without an intercalated “×” (see Wikipedia). So the name does not necessarily say if a plant is a hybrid.

There is no special handling of hybrid names necessary, as the hybrid name is stored as unique name in the database.

Displaying the Unique Name

The unique name of a plant should be displayed as follows:

• Latin name should be displayed in italics.
• The cultivar name should be in regular font, enclosed in single quotes (as stored in the database).

For example: Brassica oleracea italica ‘Ramoso calabrese’

The unique name alone usually is not displayed.

Displaying the Complete Name

The complete name of a plant should be displayed as follows:

• If there is a common name, the common name appears first and should start with a capital letter (e.g., “tomato” becomes “Tomato”).
• If it is a plant name from the seed database, the name continues with hyphen - and the additional name.
• This is followed by the unique name in brackets, unique name as described above in Unique Name.

The general format is:

Common name - additional name (unique name)

In cases where the common name is not available in the current language, it should be displayed as:

unique name - additional name

The cultivar is a part of the unique name.

For example (assuming Brassica oleracea italica doesn’t have a common name):

• Italian broccoli - violett (Brassica oleracea italica ‘Ramoso calabrese’)
• Italian broccoli - violett (Brassica oleracea italica)
• Italian broccoli (Brassica oleracea italica)
• Brassica oleracea italica ‘Ramoso calabrese’ - violett
• Brassica oleracea italica ‘Ramoso calabrese’
• Brassica oleracea italica - violett
• Brassica oleracea italica

Displaying the Short Name

The short name should be displayed as follows:

• Common name or, if common name is not not available, the unique name as described above in Unique Name.
• If additional name is available, - and the additional name should be appended.

For example (assuming Abies mariesii and Brassica oleracea italica don’t have common names):

• Tomato - Gelbe Birne
• Abies mariesii
• Brassica oleracea italica ‘Ramoso calabrese’ - violett

Usage of Plant Names

• The short name is for overview, e.g. when you see all labels in the map editor at once (plant labels).
• The complete name should always be given if the user wants to know precisely which plant she is dealing with, e.g.:
  • when the mouse is hovering over a plant in the plant layer,
  • in search results or
  • in plant details (left bottom toolbar).
• The additional name must always be added if a plant is connected with a seed.

Rules

We know about names (abstract and concrete, including hybrid):

• If it contains more than one word, it is a concrete plant.
• If it contains only one word, it is an abstract plant (family or genus).
• All entries with 2 words are a specie (de: Art),
• All entries with 3 or more words are either:
  • variety (de: Varietät) if all is spelled italic, or
  • are cultivar (de: Sorte) if last part of the name (can be more than 1 word!) is not latin, not italic, is in ‘single quotes’
• All entries with a single x between the words are hybrid. We treat them like specie.

Inserting Relations

When inserting, family, genus, specie and variety must be treated in a way that they also include all entries below in the hierarchy. Important is that the processing is from most generic to most specific, so that specific entries overwrite generic entries.

Attributes

Columns are documented in their respective structs.

We prefer strongly-typed data, e.g.:

• enums
• array of enums
• numbers

Columns that contain text should be postfixed with:

• _en for English text
• _de for German text

As we often copy data from other sources, we maintain following columns for external references:

• external_source: an array from enum where the first entry is the “main source” the other columns refer to:
• external_id: an identifier of that source
• external_url: the URL from where the data was taken

Plants are additionally classified as:

• is_concrete_plant (is a concrete plant as opposite to an abstract plant)
• is_tree (as search help within the tree layer)

from Permapeople

Following columns are removed:

• environment (and its references)
• type and is_variety, as variety is now determined from the name (rank to be calculated from name, see above)
• wildflower
• plants_of_the_world_online_name_synonym (redundant to link)
• dutch_name, danish_name, french_name
• when_to_harvest
• propagation_cuttings
• alternate_scientific_name
• hortipedia
• invasive_in
• years_to_bear
• useful_tropical_plants
• thinning
• light_tolerance
• chill_hours, beef_tomato, invasive
• folder_name (at least in DB)
• native_climate_zones
• adapted_climate_zones
• propagation_direct_sowing

Other minor problems:

• fix Labiatae to be lamiaceae (family rank)
• Remove all “var.” from the database entries (staying with the 3 words).

from Reinsaat

Unique name:

• use Scientific name subheading together with name (as cultivar, see above) for our unique_name (Cucurbita ssp. from Scientific name kulturhinweise shouldn’t exist)
• Remove all occurrences of L., MIll., and var..
• Entries on Reinsaat that are spelled like “Brassica oleracea convar. botrytis var. italica” https://www.reinsaat.at/shop/EN/brassica/broccoli/limba/ exist in our database as “Brassica oleracea italica”. Add the Reinsaat entry to our database in a different row with the following nomenclature: Brassica oleracea italica ‘Limba’, with Brassica oleracea italica as parent, by following rules:
  • Remove the term “convar.” and its following word.
  • Remove the “ssp.” and its following word.
• The name maps to cultivar (de: Sorte), i.e. a rank below variety and is expressed in non-latin words, such as ‘Limba’. In our database we want them:
  • back together in one name (the unique name, as described above) e.g. Brassica oleracea italica ‘Limba’ or Malus domestica ‘Gala’.
  • with a link to the variety, if present, otherwise species

Individual problems:

• Daucus carota L. ssp. sativus –> Daucus carota sativus
• Petroselinum crispum ssp. tuberosum –> Petroselinum crispum tuberosum
• Papaver somnif. var. paeonifl. –> Papaver somniferum paeoniflorum
• Alcea rosea fl. pl. –> Alcea rosea flore pleno
• Campanula lat. macr. –> Campanula latifolia macrantha
• Malva sylvestris ssp. maur. –> Malva sylvestris mauritiana
• Sonnenblume, Velvet Queen: None should be Helianthus annuus

Further Readings

• Rationale is explained in this decision.

Fields

id: i32

• The internal id of the plant.
• Fill ratio: 100%

unique_name: String

• The unique name of the plant.
• The structure is described above (doc/database/hierarchy.md).
• Fill ratio: 100%

common_name_en: Option<Vec<Option<String>>>

• The list of the common names of the plant in English.
• Fetched from PracticalPlants and Permapeople.
• Fill ratio: 90%

common_name_de: Option<Vec<Option<String>>>

• The list of the common names of the plant in German.
• Fetched from Wikidata API if not present in any source datasets.
• Fill ratio: 25%

family: Option<String>

• Family of the plant.
• See /doc/architecture/glossary.md.
• Used to build up hierarchy.
• Fetched from PracticalPlants and Permapeople.
• Fill ratio: 88%

edible_uses_en: Option<String>

• TODO: comment out
• The edible use of the plant, answering: Which food type can be produced from this plant, e.g. oil?
• Interesting for search functionality.
• Fetched from Permapeople as edible_uses and merged with Reinsaat.
• Fill ratio: 6%

functions: Option<String>

• TODO: use in search (and attribute)
• Used for search ranking (diversity).
• ecological and environmental function of the plant, especially nitrogen fixer is relevant for PermaplanT.
• Fetched from PracticalPlants)
• Fill ratio: 13%

heat_zone: Option<i16>

• TODO: comment out
• Not used.
• Use hardiness_zone instead.
• indication of the heat range a plant endures.
• Fetched from PracticalPlants.
• Fill ratio: 0.05%

shade: Option<Shade>

• Shade tolerance of the plant, to be used together with light_requirement.
• Used in shade layer.
• For example a plant that has “no shade”, should get a warning if placed in a shade.
• No shade: full sun exposure
• Light shade: moderately shaded throughout the day
• Partial shade: about 3-6 hours of direct sunlight
• Permanent shade: less than 3 hours of direct sunlight
• Shade indicates the shade tolerance. Plants obviously grow better with better light conditions.
• Warnings should only show if a plant is moved into a too dark spot. No warning should be shown when moved into a lighter spot.
• Fetched from PracticalPlants.
• Fill ratio: 63%

soil_ph: Option<Vec<Option<SoilPh>>>

• TODO: comment out
• Currently unused (maybe later used in pH layer).
• See explanation in /doc/architecture/context.md
• Soil PH can be tested by the user with simple means (e.g. litmus).
• Fetched from PracticalPlants and Permapeople (merged between Permapeople and PracticalPlants).
• Fill ratio: 1%

soil_texture: Option<Vec<Option<SoilTextureEnum>>>

• See explanation in /doc/architecture/context.md
• Used in soil layer.
• Fetched from PracticalPlants and Permapeople (merged with soil_type of Permapeople).
• Fill ratio: 88%

ecosystem_niche: Option<String>

• TODO: comment out
• Interesting for search functionality.
• Fetched from PracticalPlants
• informs about the (vertical) layer, that the plant usually inhabits, e.g. soil surface or canopy
• Fill ratio: 16%

deciduous_or_evergreen: Option<DeciduousOrEvergreen>

• TODO: use in search (and attribute)
• Only informational.
• deciduous = plants loose leaves in winter.
• evergreen = Plants don’t throw leaves (e.g. pine tree).
• Not applicable for annual plants.
• Fetched from PracticalPlants and merged with leaves of Permapeople.
• Fill ratio: 30%

herbaceous_or_woody: Option<HerbaceousOrWoody>

• TODO: use in attribute
• Only informational.
• Fetched from PracticalPlants
• informs about the plant physiology
• woody = grows woody parts
• herbaceous = doesn’t grow wood, shoots remain soft/green.
• Fill ratio: 26%

life_cycle: Option<Vec<Option<LifeCycle>>>

• Use in search (and attribute)
• Determines life span of the plant.
• Fetched from PracticalPlants and Permapeople (merged with life_cycle of Permapeople).
• Fill ratio: 68%

growth_rate: Option<Vec<Option<GrowthRate>>>

• TODO: comment out
• Only informational.
• Fetched from PracticalPlants and Permapeople (merged with growth of Permapeople).
• Fill ratio: 30%

height: Option<i32>

• Only informational, is in rw attribute
• Fetched from PracticalPlants as mature_size_height and merged with Permapeople.
• informs about the maximum height that the plant gains in cm
• Fill ratio: 80%

fertility: Option<Vec<Option<Fertility>>>

• TODO: comment out
• Only informational.
• Fetched from PracticalPlants
• Fill ratio: 18%

created_at: NaiveDateTime

• Is readonly in attribute
• The creation date of the entry.
• Only for administration.
• Fill ratio: 100%

updated_at: NaiveDateTime

• Is readonly in attribute
• The last update date of the entry.
• Only for administration.
• Fill ratio: 100%

has_drought_tolerance: Option<bool>

• ! TODO: show in attributes and search (icon)
• Will be used in watering layer.
• Fetched from PracticalPlants and merged with has_drought_tolerance of Permapeople.
• Fill ratio: 57%

tolerates_wind: Option<bool>

• TODO: comment out
• Fetched from PracticalPlants.
• Fill ratio: 10%

preferable_permaculture_zone: Option<i16>

• TODO: comment out
• Not used.
• Number value between -1..6 (-1 should be printed as 00)
• Fill ratio: 0%

hardiness_zone: Option<String>

• TODO: show in search
• USDA Hardiness Zone (without subranges).
• Important information.
• Fetched from PracticalPlants and Permapeople (merged with usda_hardiness_zone of Permapeople).
• Fill ratio: 63%

light_requirement: Option<Vec<Option<LightRequirement>>>

• Shade tolerance of the plant, to be used together with shade.
• Used in shade layer.
• For example a plant that has “Full sun”, should get a warning if placed in a shade.
• Fetched from* PracticalPlants and Permapeople (merged with sun of PracticalPlants)
• Full sun: full sun exposure
• Partial sun/shade: about 3-6 hours of direct sunlight or moderately shaded throughout the day
• Full shade: less than 3 hours of direct sunlight or almost no sunlight/no direct sunlight
• Fill ratio: 88%

water_requirement: Option<Vec<Option<WaterRequirementEnum>>>

• Used in hydrology layer.
• Fetched from PracticalPlants and Permapeople (merged with water of PracticalPlants).
• water = completely aquatic;
• wet = drowned, (often) flooded or in general very moist, e.g. swamp;
• moist = humid, regular water supply, e.g. flat bed with humus;
• well drained = dry, little water input.
• Fill ratio: 88%

propagation_method: Option<Vec<Option<PropagationMethod>>>

• TODO: comment out
• Only informational.
• Fetched from Permapeople (renamed from propagation)
• How to reproduce a plant: cuttings = cut pieces of wood; layering = let low branches reach the soil to root; Seed - direct sow = sow directly the seeds; division = split the rhizomes (roots) into pieces; Spores = plant reproduces via spores (e.g. ferns, funghi); seed - transplant = raise indoors from seed and transplant to outdoors later
• Fill ratio: 0.9%

alternate_name: Option<String>

• TODO: comment out
• Only informational.
• May be used in search functionality (low priority).
• Fetched from Permapeople.
• Fill ratio: 35%

edible: Option<bool>

• TODO: use in search (and as attribute)
• Important information.
• Fetched from Permapeople.
• Fill ratio: 62%

edible_parts: Option<Vec<Option<String>>>

• TODO: use as attribute (translation in frontend)
• Only informational.
• Fetched from Permapeople.
• which organ of the plant can be eaten, e.g. root, leaves.
• Fill ratio: 61%

spread: Option<i32>

• Used
• How far a plant spreads (The ‘width’ of a plant) in cm
• Fetched from Permapeople.
• Fill ratio: 0.1%

warning: Option<String>

• TODO: use in search (and as attribute)
• Important information.
• Fetched from Permapeople.
• specific warnings for eather human, animal or environmental well-being, e.g. toxic, invasive.
• Fill ratio: 8%

version: Option<i16>

• TODO: add to attributes
• Only for administration.
• The version of the entry.
• To be incremented after every relevant change.
• Fetched from Permapeople.
• Fill ratio: 90%

external_source: Option<ExternalSource>

• TODO: comment out
• Not used.
• Enum value indicating the source of the entry.
• Fill ratio: 100%

sowing_outdoors: Option<Vec<Option<i16>>>

• TODO: use as attribute
• String array of numbers representing a time period.
• The year is divided into 24 periods of half a month each.
• For example “[8,9,10]” means from the 2nd half of April to the 2nd half of May incl.
• Fetched from Reinsaat
• Aussaat/ Pflanzung Freiland should be called sowing_outdoors
• Fill ratio: 5%

harvest_time: Option<Vec<Option<i16>>>

• TODO: use as attribute
• String array of numbers representing a time period.
• The year is divided into 24 periods of half a month each.
• For example “[8,9,10]” means from the 2nd half of April to the 2nd half of May incl.
• Ernte should be called harvest_time
• Fetched from Reinsaat
• Fill ratio: 6%

seed_weight_1000: Option<f64>

• TODO: comment out
• Number for thousand grain weight (German: Tausendkornmasse)
• Used in doc/usecases/buy_seeds.md to calculate seed weight based on number of plants.
• Fetched from Permapeople as 1000_seed_weight_g and renamed.
• TODO: merge with data from reinsaat: Tausendkorngewicht (TKG) should be copied to seed_weight (remove g)
• Fill ratio: 4%

Implementations

impl Plants

pub async fn search( search_query: &str, page_parameters: PageParameters, conn: &mut AsyncPgConnection, ) -> QueryResult<Page<PlantsSummaryDto>>

Get the top plants matching the search query.

Uses pg_trgm to find matches in unique_name, common_name_de, common_name_en and edible_uses_en. Ranks them using the pg_trgm function similarity().

Errors

• Unknown, diesel doesn’t say why it might error.

pub async fn find_any( page_parameters: PageParameters, conn: &mut AsyncPgConnection, ) -> QueryResult<Page<PlantsSummaryDto>>

Get a page of some plants.

Errors

• Unknown, diesel doesn’t say why it might error.

pub async fn find_by_id( id: i32, conn: &mut AsyncPgConnection, ) -> QueryResult<PlantsSummaryDto>

Fetch plant by id from the database.

Errors

• Unknown, diesel doesn’t say why it might error.

Trait Implementations

impl Debug for Plants

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<Plants> for PlantsSummaryDto

fn from(plants: Plants) -> Self

Converts to this type from the input type.

impl HasTable for Plants

type Table = table

The table this type is associated with.

fn table() -> Self::Table

Returns the table this type is associated with.

impl<'ident> Identifiable for &'ident Plants

type Id = &'ident i32

The type of this struct’s identifier.

fn id(self) -> Self::Id

Returns the identifier for this record.

impl<__DB: Backend, __ST0, __ST1, __ST2, __ST3, __ST4, __ST5, __ST6, __ST7, __ST8, __ST9, __ST10, __ST11, __ST12, __ST13, __ST14, __ST15, __ST16, __ST17, __ST18, __ST19, __ST20, __ST21, __ST22, __ST23, __ST24, __ST25, __ST26, __ST27, __ST28, __ST29, __ST30, __ST31, __ST32, __ST33, __ST34, __ST35, __ST36> Queryable<(__ST0, __ST1, __ST2, __ST3, __ST4, __ST5, __ST6, __ST7, __ST8, __ST9, __ST10, __ST11, __ST12, __ST13, __ST14, __ST15, __ST16, __ST17, __ST18, __ST19, __ST20, __ST21, __ST22, __ST23, __ST24, __ST25, __ST26, __ST27, __ST28, __ST29, __ST30, __ST31, __ST32, __ST33, __ST34, __ST35, __ST36), __DB> for Plants

where (i32, String, Option<Vec<Option<String>>>, Option<Vec<Option<String>>>, Option<String>, Option<String>, Option<String>, Option<i16>, Option<Shade>, Option<Vec<Option<SoilPh>>>, Option<Vec<Option<SoilTextureEnum>>>, Option<String>, Option<DeciduousOrEvergreen>, Option<HerbaceousOrWoody>, Option<Vec<Option<LifeCycle>>>, Option<Vec<Option<GrowthRate>>>, Option<i32>, Option<Vec<Option<Fertility>>>, NaiveDateTime, NaiveDateTime, Option<bool>, Option<bool>, Option<i16>, Option<String>, Option<Vec<Option<LightRequirement>>>, Option<Vec<Option<WaterRequirementEnum>>>, Option<Vec<Option<PropagationMethod>>>, Option<String>, Option<bool>, Option<Vec<Option<String>>>, Option<i32>, Option<String>, Option<i16>, Option<ExternalSource>, Option<Vec<Option<i16>>>, Option<Vec<Option<i16>>>, Option<f64>): FromStaticSqlRow<(__ST0, __ST1, __ST2, __ST3, __ST4, __ST5, __ST6, __ST7, __ST8, __ST9, __ST10, __ST11, __ST12, __ST13, __ST14, __ST15, __ST16, __ST17, __ST18, __ST19, __ST20, __ST21, __ST22, __ST23, __ST24, __ST25, __ST26, __ST27, __ST28, __ST29, __ST30, __ST31, __ST32, __ST33, __ST34, __ST35, __ST36), __DB>,

type Row = (i32, String, Option<Vec<Option<String>>>, Option<Vec<Option<String>>>, Option<String>, Option<String>, Option<String>, Option<i16>, Option<Shade>, Option<Vec<Option<SoilPh>>>, Option<Vec<Option<SoilTextureEnum>>>, Option<String>, Option<DeciduousOrEvergreen>, Option<HerbaceousOrWoody>, Option<Vec<Option<LifeCycle>>>, Option<Vec<Option<GrowthRate>>>, Option<i32>, Option<Vec<Option<Fertility>>>, NaiveDateTime, NaiveDateTime, Option<bool>, Option<bool>, Option<i16>, Option<String>, Option<Vec<Option<LightRequirement>>>, Option<Vec<Option<WaterRequirementEnum>>>, Option<Vec<Option<PropagationMethod>>>, Option<String>, Option<bool>, Option<Vec<Option<String>>>, Option<i32>, Option<String>, Option<i16>, Option<ExternalSource>, Option<Vec<Option<i16>>>, Option<Vec<Option<i16>>>, Option<f64>)

The Rust type you’d like to map from.

fn build(row: Self::Row) -> Result<Self>

Construct an instance of this type

impl<__DB: Backend> QueryableByName<__DB> for Plants

where i32: FromSql<SqlTypeOf<id>, __DB>, String: FromSql<SqlTypeOf<unique_name>, __DB>, Option<Vec<Option<String>>>: FromSql<SqlTypeOf<common_name_en>, __DB> + FromSql<SqlTypeOf<common_name_de>, __DB> + FromSql<SqlTypeOf<edible_parts>, __DB>, Option<String>: FromSql<SqlTypeOf<family>, __DB> + FromSql<SqlTypeOf<edible_uses_en>, __DB> + FromSql<SqlTypeOf<functions>, __DB> + FromSql<SqlTypeOf<ecosystem_niche>, __DB> + FromSql<SqlTypeOf<hardiness_zone>, __DB> + FromSql<SqlTypeOf<alternate_name>, __DB> + FromSql<SqlTypeOf<warning>, __DB>, Option<i16>: FromSql<SqlTypeOf<heat_zone>, __DB> + FromSql<SqlTypeOf<preferable_permaculture_zone>, __DB> + FromSql<SqlTypeOf<version>, __DB>, Option<Shade>: FromSql<SqlTypeOf<shade>, __DB>, Option<Vec<Option<SoilPh>>>: FromSql<SqlTypeOf<soil_ph>, __DB>, Option<Vec<Option<SoilTextureEnum>>>: FromSql<SqlTypeOf<soil_texture>, __DB>, Option<DeciduousOrEvergreen>: FromSql<SqlTypeOf<deciduous_or_evergreen>, __DB>, Option<HerbaceousOrWoody>: FromSql<SqlTypeOf<herbaceous_or_woody>, __DB>, Option<Vec<Option<LifeCycle>>>: FromSql<SqlTypeOf<life_cycle>, __DB>, Option<Vec<Option<GrowthRate>>>: FromSql<SqlTypeOf<growth_rate>, __DB>, Option<i32>: FromSql<SqlTypeOf<height>, __DB> + FromSql<SqlTypeOf<spread>, __DB>, Option<Vec<Option<Fertility>>>: FromSql<SqlTypeOf<fertility>, __DB>, NaiveDateTime: FromSql<SqlTypeOf<created_at>, __DB> + FromSql<SqlTypeOf<updated_at>, __DB>, Option<bool>: FromSql<SqlTypeOf<has_drought_tolerance>, __DB> + FromSql<SqlTypeOf<tolerates_wind>, __DB> + FromSql<SqlTypeOf<edible>, __DB>, Option<Vec<Option<LightRequirement>>>: FromSql<SqlTypeOf<light_requirement>, __DB>, Option<Vec<Option<WaterRequirementEnum>>>: FromSql<SqlTypeOf<water_requirement>, __DB>, Option<Vec<Option<PropagationMethod>>>: FromSql<SqlTypeOf<propagation_method>, __DB>, Option<ExternalSource>: FromSql<SqlTypeOf<external_source>, __DB>, Option<Vec<Option<i16>>>: FromSql<SqlTypeOf<sowing_outdoors>, __DB> + FromSql<SqlTypeOf<harvest_time>, __DB>, Option<f64>: FromSql<SqlTypeOf<seed_weight_1000>, __DB>,

fn build<'__a>(row: &impl NamedRow<'__a, __DB>) -> Result<Self>

Construct an instance of Self from the database row