fleetfolio/aws_ec2_application_load_balancer.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_ec2_application_load_balancer.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; 

 SELECT
   'AWS EC2 Application Load Balancer' AS title,
   sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/fleetfolio/aws_ec2_application_load_balancer.sql' AS link; 


 --- Dsply Page Title
 SELECT
     'title'   as component,
     "AWS EC2 Application Load Balancer" contents;

    select
     'text'              as component,
     'The AWS EC2 Application Load Balancer (ALB) is a highly scalable and flexible load balancing service designed to distribute incoming HTTP and HTTPS traffic across multiple targets, such as EC2 instances, containers, and IP addresses, within one or more Availability Zones. It operates at the application layer (Layer 7 of the OSI model), allowing advanced routing based on content such as URL paths, host headers, and HTTP headers. ALB supports features like SSL termination, WebSocket support, and integration with AWS services like Auto Scaling and ECS, making it ideal for modern web applications and microservices architectures.' as contents;


 SET total_rows = (SELECT COUNT(*) FROM list_aws_ec2_application_load_balancer );
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1; 
SELECT 'table' AS component,
       TRUE as sort,
       TRUE as search;
   SELECT 
   name,
   account,
   owner,
   vpc,
   region,
   dns_name as 'dns name',
   ip_address_type as 'ip address type',
   scheme,
   type
   FROM list_aws_ec2_application_load_balancer;
    SELECT 'text' AS component,
    (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) ||     ')' ELSE '' END) || ' ' ||
    '(Page ' || $current_page || ' of ' || $total_pages || ") " ||
    (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) ||     ')' ELSE '' END)
    AS contents_md 
;