From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 .../table/structure/display_partitions.twig        | 145 +++++++++++++++++++++
 1 file changed, 145 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/table/structure/display_partitions.twig

(limited to 'srcs/phpmyadmin/templates/table/structure/display_partitions.twig')

diff --git a/srcs/phpmyadmin/templates/table/structure/display_partitions.twig b/srcs/phpmyadmin/templates/table/structure/display_partitions.twig
new file mode 100644
index 0000000..b10a0bc
--- /dev/null
+++ b/srcs/phpmyadmin/templates/table/structure/display_partitions.twig
@@ -0,0 +1,145 @@
+<div id="partitions">
+    <fieldset>
+        <legend>
+            {% trans 'Partitions' %}
+            {{ show_mysql_docu('partitioning') }}
+        </legend>
+        {% if partitions is empty %}
+            {{ 'No partitioning defined!'|trans|notice }}
+        {% else %}
+            <p>
+                {% trans 'Partitioned by:' %}
+                <code>{{ partition_method }}({{ partition_expression }})</code>
+            </p>
+            {% if has_sub_partitions %}
+                <p>
+                    {% trans 'Sub partitioned by:' %}
+                    <code>{{ sub_partition_method }}({{ sub_partition_expression }})</code>
+                <p>
+            {% endif %}
+            <table>
+                <thead>
+                    <tr>
+                        <th colspan="2">#</th>
+                        <th>{% trans 'Partition' %}</th>
+                        {% if has_description %}
+                            <th>{% trans 'Expression' %}</th>
+                        {% endif %}
+                        <th>{% trans 'Rows' %}</th>
+                        <th>{% trans 'Data length' %}</th>
+                        <th>{% trans 'Index length' %}</th>
+                        <th>{% trans 'Comment' %}</th>
+                        <th colspan="{{ range_or_list ? '7' : '6' }}">
+                            {% trans 'Action' %}
+                        </th>
+                    </tr>
+                </thead>
+                <tbody>
+                {% for partition in partitions %}
+                    <tr class="noclick{{ has_sub_partitions ? ' marked' }}">
+                        {% if has_sub_partitions %}
+                            <td>{{ partition.getOrdinal() }}</td>
+                            <td></td>
+                        {% else %}
+                            <td colspan="2">{{ partition.getOrdinal() }}</td>
+                        {% endif %}
+                        <th>{{ partition.getName() }}</th>
+                        {% if has_description %}
+                            <td>
+                                <code>
+                                    {{- partition.getExpression() -}}
+                                    {{- partition.getMethod() == 'LIST' ? ' IN (' : ' < ' -}}
+                                    {{- partition.getDescription() -}}
+                                    {{- partition.getMethod() == 'LIST' ? ')' -}}
+                                </code>
+                            </td>
+                        {% endif %}
+                        <td class="value">{{ partition.getRows() }}</td>
+                        <td class="value">
+                            {% set data_length = format_byte_down(
+                                partition.getDataLength(),
+                                3,
+                                1
+                            ) %}
+                            <span>{{ data_length[0] }}</span>
+                            <span class="unit">{{ data_length[1] }}</span>
+                        </td>
+                        <td class="value">
+                            {% set index_length = format_byte_down(
+                                partition.getIndexLength(),
+                                3,
+                                1
+                            ) %}
+                            <span>{{ index_length[0] }}</span>
+                            <span class="unit">{{ index_length[1] }}</span>
+                        </td>
+                        <td>{{ partition.getComment() }}</td>
+                        {% for action, icon in action_icons %}
+                            <td>
+                                <a href="tbl_structure.php" data-post="{{ url_query -}}
+                                    &amp;partition_maintenance=1&amp;sql_query=
+                                    {{- ("ALTER TABLE " ~ backquote(table) ~ " " ~ action
+                                        ~ " PARTITION " ~ partition.getName())|url_encode }}"
+                                    id="partition_action_{{ action }}"
+                                    name="partition_action_{{ action }}"
+                                    class="ajax">
+                                    {{ icon|raw }}
+                                </a>
+                            </td>
+                        {% endfor %}
+
+                        {% if has_sub_partitions %}
+                            {% for sub_partition in partition.getSubPartitions() %}
+                                <tr class="noclick">
+                                    <td></td>
+                                    <td>{{ sub_partition.getOrdinal() }}</td>
+                                    <td>{{ sub_partition.getName() }}</td>
+                                    {% if has_description %}
+                                        <td></td>
+                                    {% endif %}
+                                    <td class="value">{{ sub_partition.getRows() }}</td>
+                                    <td class="value">
+                                        {% set data_length = format_byte_down(
+                                            sub_partition.getDataLength(),
+                                            3,
+                                            1
+                                        ) %}
+                                        <span>{{ data_length[0] }}</span>
+                                        <span class="unit">{{ data_length[1] }}</span>
+                                    </td>
+                                    <td class="value">
+                                        {% set index_length = format_byte_down(
+                                            sub_partition.getIndexLength(),
+                                            3,
+                                            1
+                                        ) %}
+                                        <span>{{ index_length[0] }}</span>
+                                        <span class="unit">{{ index_length[1] }}</span>
+                                    </td>
+                                    <td>{{ sub_partition.getComment() }}</td>
+                                    <td colspan="{{ range_or_list ? '7' : '6' }}"></td>
+                                </tr>
+                            {% endfor %}
+                        {% endif %}
+                    </tr>
+                {% endfor %}
+                </tbody>
+            </table>
+        {% endif %}
+    </fieldset>
+    <fieldset class="tblFooters print_ignore">
+        <form action="tbl_structure.php" method="post">
+            {{ get_hidden_inputs(db, table) }}
+            <input type="hidden" name="edit_partitioning" value="true">
+            {% if partitions is empty %}
+                <input class="btn btn-secondary" type="submit" name="edit_partitioning" value="{% trans 'Partition table' %}">
+            {% else %}
+                {{ link_or_button(remove_url, 'Remove partitioning'|trans, {
+                    'class': 'button ajax',
+                    'id': 'remove_partitioning'
+                }) }}
+                <input class="btn btn-secondary" type="submit" name="edit_partitioning" value="{% trans 'Edit partitioning' %}">
+            {% endif %}
+        </form>
+    </fieldset>
+</div>
-- 
cgit