{% extends 'base.html' %}

{% block content %}

<body>
    <!-- Navbar Start -->
    <div class="container-fluid nav-bar p-0">
        <div class="container-lg p-0">
            <nav class="navbar navbar-expand-lg bg-secondary navbar-dark">
                <a href="index.html" class="navbar-brand">
                    <h1 class="m-0 text-white display-4"><span class="text-primary">HTTP_509</h1>
                </a>
                <!-- <button type="button" class="navbar-toggler" data-toggle="collapse" data-target="#navbarCollapse">
                    <span class="navbar-toggler-icon"></span>
                </button> -->
                <div class="collapse navbar-collapse justify-content-between" id="navbarCollapse">
                    <div class="navbar-nav ml-auto py-0">
                        <a href="index.html" class="nav-item nav-link active">Home</a>
                        <a href="service.html" class="nav-item nav-link">Services</a>
                    </div>
                </div>
            </nav>
        </div>
    </div>
    <!-- Navbar End -->


    <!-- Services Start -->
    <div class="container-fluid pt-5 pb-3">
        <div class="container">
            <br />
            <br />
            <br />
            <h4></h4>
            <h4></h4>
            <form action="{{url_for('result')}}" method="POST" , name="schemapicker">
                {{ form.csrt_token }}
                <b>{{ form.startdate.label }}:</b> {{ form.startdate.data }} {{form.hidden_tag() }}
                <b>{{ form.enddate.label }}:</b> {{ form.enddate.data }} {{form.hidden_tag() }}
                <h3>Select source database schema to copy from:</h3>
                <select name="source" method="GET" action="">
                    <option value="Select Source Schema" SELECTED>Select Source Schema</option>
                    {%for target in targets %}
                    <option value="{{ target['database'] }}.{{ target['schemaname'] }}">{{ target['database']
                        }}.{{ target['schemaname'] }}</option>
                    {% endfor %}
                </select>
                <h3>Select target database schema to copy to:</h3>
                <select name="target" method="GET" action="">
                    <option value="Select Target Schema" SELECTED>Select Target Schema</option>
                    {%for target in targets %}
                    <option value="{{ target['database'] }}.{{ target['schemaname'] }}">{{ target['database']
                        }}.{{ target['schemaname'] }}</option>
                    {% endfor %}
                </select>
                <br />
                <br />
                <p> {{ form.submit() }}</p>
            </form>
        </div>
    </div>
    <!-- Services End -->

    <!-- Footer Start -->
    <div class="container-fluid py-4 px-sm-3 px-md-5">
        <p class="m-0 text-center">
            &copy; <a class="font-weight-semi-bold" href="#">HTTP_509</a>. All Rights Reserved. Designed by
            <a class="font-weight-semi-bold" href="https://htmlcodex.com">HTML Codex</a>
        </p>
    </div>
    <!-- Footer End -->


    <!-- Back to Top -->
    <a href="#" class="btn btn-lg btn-primary back-to-top"><i class="fa fa-angle-up"></i></a>


    <!-- JavaScript Libraries -->
    <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.bundle.min.js"></script>
    <script src="lib/easing/easing.min.js"></script>
    <script src="lib/waypoints/waypoints.min.js"></script>
    <script src="lib/counterup/counterup.min.js"></script>
    <script src="lib/owlcarousel/owl.carousel.min.js"></script>

    <!-- Contact Javascript File -->
    <script src="mail/jqBootstrapValidation.min.js"></script>
    <script src="mail/contact.js"></script>

    <!-- Template Javascript -->
    <script src="js/main.js"></script>
</body>

{% endblock %}