import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class UpdateLivestreamTemplate5 {
    public static void main(String[] args) {
        try {
            Class.forName("oracle.jdbc.OracleDriver");
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/sisvietnam", "sisvietnam", "sisvietnam");
            
            // Revert the URL in the database to exactly what the user requested, without autoplay
            PreparedStatement updatePost = conn.prepareStatement(
                "UPDATE sis_post SET meta_description = ? WHERE slug = 'sis-vi-suc-khoe-cong-dong-ky-134'"
            );
            updatePost.setString(1, "https://www.youtube.com/embed/j63kT9Bjrb4?si=N5JwIcuRn-iRxkYu");
            updatePost.executeUpdate();
            
            // We remove the custom image and play button entirely and let YouTube handle it!
            String htmlTemplate = 
"<style>\n" +
"  .tabbed-media-content-media-item { width: 100%; aspect-ratio: 16/9; position: relative; display: block; overflow: hidden; }\n" +
"  .tabbed-media-content-media-item .f--video-embed { width: 100%; height: 100%; }\n" +
"  .tabbed-media-content-media-item .f--video-embed iframe { width: 100%; height: 100%; border: none; }\n" +
"</style>\n" +
"<div class=\"cc--component-container cc--tabbed-media-content\" style=\"background-color: var(--color-gray-100);\">\n" +
"  <div class=\"c--component c--tabbed-media-content\">\n" +
"    <div class=\"tabbed-media-content-text-col\">\n" +
"      <div data-component-id=\"umass_base:section-title\" class=\"f--section-title\">\n" +
"        <h2 style=\"color: var(--color-brand);\">LiveStream</h2>\n" +
"      </div>\n" +
"      <div data-component-id=\"umass_base:tabbed-container\" data-once=\"tabbed-container\">\n" +
"        <div class=\"tab-labels-container\" role=\"tablist\">\n" +
"          <div class=\"tab-labels-inner\">\n" +
"            {{#each livestream_posts}}\n" +
"            <a href=\"#tabbed-content-{{index}}\" class=\"tab-label link-context-dark\" role=\"tab\" aria-selected=\"false\" aria-controls=\"tabbed-content-{{index}}\">{{title}}</a>\n" +
"            {{/each}}\n" +
"          </div>\n" +
"        </div>\n" +
"        <div class=\"tab-content-container\">\n" +
"          {{#each livestream_posts}}\n" +
"          <div class=\"tab-content-panel\" id=\"tabbed-content-{{index}}\" role=\"tabpanel\" aria-live=\"polite\">\n" +
"            <div class=\"f--field f--cta-title\">\n" +
"              <h2 style=\"color: var(--color-black);\"> {{excerpt}} </h2>\n" +
"            </div>\n" +
"            <div data-component-id=\"umass_base:description\" class=\"f--description\">\n" +
"              <div style=\"color:var(--color-black);\">{{content}}</div>\n" +
"            </div>\n" +
"            <div class=\"cta-container\">\n" +
"              <div class=\"f--field f--button\">\n" +
"                <a href=\"/post/{{slug}}\" class=\"button-primary button-context-light \" aria-label=\"Tìm Hiểu Thêm\" data-component-id=\"umass_base:button\">\n" +
"                  <span class=\"button-text\"> Tìm Hiểu Thêm </span>\n" +
"                </a>\n" +
"              </div>\n" +
"            </div>\n" +
"          </div>\n" +
"          {{/each}}\n" +
"        </div>\n" +
"      </div>\n" +
"    </div>\n" +
"    <div class=\"tabbed-media-content-media-col\">\n" +
"      {{#each livestream_posts}}\n" +
"      <div class=\"tabbed-media-content-media-item with-video\" data-tab-id=\"tabbed-content-{{index}}\">\n" +
"        <div data-component-id=\"umass_base:video-embed\" class=\"f--field f--video-embed\">\n" +
"          <iframe title=\"YouTube video player\" src=\"{{metaDescription}}\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen></iframe>\n" +
"        </div>\n" +
"      </div>\n" +
"      {{/each}}\n" +
"    </div>\n" +
"  </div>\n" +
"</div>\n" +
"<script>\n" +
"  document.addEventListener(\"DOMContentLoaded\", function() {\n" +
"    var tabs = document.querySelectorAll('.tabbed-media-content-media-item[data-tab-id=\"tabbed-content-0\"]');\n" +
"    if(tabs.length > 0) tabs[0].classList.add('is-active');\n" +
"    \n" +
"    var panels = document.querySelectorAll('#tabbed-content-0.tab-content-panel');\n" +
"    if(panels.length > 0) panels[0].classList.add('is-active');\n" +
"\n" +
"    var labels = document.querySelectorAll('a.tab-label[aria-controls=\"tabbed-content-0\"]');\n" +
"    if(labels.length > 0) labels[0].setAttribute('aria-selected', 'true');\n" +
"\n" +
"    var allLabels = document.querySelectorAll('.tab-labels-inner .tab-label');\n" +
"    allLabels.forEach(function(label) {\n" +
"      label.addEventListener('click', function(e) {\n" +
"        e.preventDefault();\n" +
"        allLabels.forEach(function(l) { l.setAttribute('aria-selected', 'false'); });\n" +
"        this.setAttribute('aria-selected', 'true');\n" +
"        \n" +
"        var targetId = this.getAttribute('aria-controls');\n" +
"        document.querySelectorAll('.tab-content-panel').forEach(function(p) { p.classList.remove('is-active'); });\n" +
"        document.querySelectorAll('.tabbed-media-content-media-item').forEach(function(m) { \n" +
"             m.classList.remove('is-active'); \n" +
"        });\n" +
"        \n" +
"        var targetPanel = document.getElementById(targetId);\n" +
"        if(targetPanel) targetPanel.classList.add('is-active');\n" +
"        var targetMedia = document.querySelector('.tabbed-media-content-media-item[data-tab-id=\"' + targetId + '\"]');\n" +
"        if(targetMedia) targetMedia.classList.add('is-active');\n" +
"      });\n" +
"    });\n" +
"  });\n" +
"</script>";
            
            PreparedStatement updateTemplate = conn.prepareStatement(
                "UPDATE sis_component_template SET html_template = ? WHERE slug = 'tabbed-livestream'"
            );
            updateTemplate.setString(1, htmlTemplate);
            updateTemplate.executeUpdate();
            
            System.out.println("Update complete!");
            
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}