hecate 0.62.0

use err::HecateError;

pub fn get_json(conn: &r2d2::PooledConnection<r2d2_postgres::PostgresConnectionManager>) -> Result<serde_json::Value, HecateError> {
    match conn.query("
        SELECT COALESCE(row_to_json(d), 'false'::JSON)
        FROM (
            SELECT
                json_build_array(
                    ST_XMin(extent.extent),
                    ST_YMin(extent.extent),
                    ST_XMax(extent.extent),
                    ST_YMax(extent.extent)
                ) AS bbox,
                total.total AS total,
                time.time AS last_calc
            FROM
                (
                    SELECT
                        to_char(last_analyze, 'YYYY-MM-DD HH24:MI:SS') AS time
                    FROM
                        pg_stat_all_tables
                    WHERE
                        relname = 'geo'
                ) as time,
                (
                    SELECT
                        ST_EstimatedExtent('geo', 'geom') AS extent
                ) as extent,
                (
                    SELECT
                        pg_class.reltuples::bigint as total
                    FROM
                        pg_class
                    WHERE
                        oid = 'public.geo'::regclass
                ) as total
        ) d;
    ", &[]) {
        Err(err) => Err(HecateError::from_db(err)),
        Ok(res) => {
            let d_json: serde_json::Value = res.get(0).get(0);
            Ok(d_json)
        }
    }
}

pub fn regen(conn:  &r2d2::PooledConnection<r2d2_postgres::PostgresConnectionManager>) -> Result<bool, HecateError> {
    match conn.execute("
        ANALYZE geo;
    ", &[]) {
        Err(err) => Err(HecateError::from_db(err)),
        _ => Ok(true)
    }
}