fleetfolio/aws_trust_boundary_list.sql
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
-- not including breadcrumbs from sqlpage_aide_navigation
-- not including page title from sqlpage_aide_navigation
SELECT 'title' AS component, (SELECT COALESCE(title, caption)
FROM sqlpage_aide_navigation
WHERE namespace = 'prime' AND path = 'fleetfolio/aws_trust_boundary_list.sql/index.sql') as contents;
;
--- Display breadcrumb
SELECT
'breadcrumb' AS component;
SELECT
'Home' AS title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT
'FleetFolio' AS title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/index.sql' AS link;
SELECT
'Boundary' AS title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/boundary.sql' AS link;
SELECT
'AWS Trust Boundary' AS title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/aws_trust_boundary_list.sql' AS link;
--- Dsply Page Title
SELECT
'title' as component,
"AWS Trust Boundary" contents;
-- Dashboard count
select
'card' as component,
4 as columns;
select
"AWS EC2 instance " as title,
'square' as icon,
'orange' as color,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/aws_ec2_instance_list.sql' as link;
select
"AWS S3 buckets" as title,
"bucket" as icon,
'blue' as color,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/aws_s3_bucket_list.sql' as link;
select
"AWS VPC" as title,
"cloud" as icon,
'black' as color,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/aws_vpc_list.sql' as link;
select
"AWS EC2 Application Load Balancer" as title,
"load-balancer" as icon,
'orange' as color,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/aws_ec2_application_load_balancer.sql' as link;