lie/connection.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
              

                 --- Display breadcrumb
  SELECT
     'breadcrumb' AS component;
   SELECT
     'Home' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
   SELECT
     'LinkedIn Explorer' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link;
   SELECT
     'Profile' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link;
   SELECT
     'Connection' AS title,
     sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/connection.sql' AS link;
-- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui)
     SET total_rows = (SELECT COUNT(*) FROM linkedin_connection_overview );
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
       'text'              as component,
       'The Source List page provides a streamlined view of all collected content sources. This page displays only the origins of the content, such as sender information for email sources, making it easy to see where each piece of content came from. Use this list to quickly review and identify the various sources contributing to the curated content collection.' as contents;

     -- Display uniform_resource table with pagination
     SELECT 'table' AS component,
           'subject' AS markdown,
           'Column Count' as align_right,
           TRUE as sort,
           TRUE as search;
  
      SELECT
         first_name,
         last_name,
         email
         FROM linkedin_connection_overview
         LIMIT $limit
       OFFSET $offset;
       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 
;