exodata-core 0.2.0

Core data loading, metadata, insight, and table logic for Exoplanets Catalog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

use super::{InsightDef, InsightTable};

pub const DEF: InsightDef = InsightDef {
    meta: &exo_types::insights::distant_exoplanets::META,
    table: InsightTable::Exoplanets,
    sql: r#"
        SELECT pl_name, hostname, pl_orbsmax, pl_orbper, disc_year
        FROM exoplanets
        WHERE default_flag = 1
          AND pl_name IS NOT NULL
          AND pl_name != ''
          AND pl_orbsmax IS NOT NULL
        ORDER BY pl_orbsmax DESC, pl_name ASC
        LIMIT 10
    "#,
};