5 Jul
2018
5 Jul
'18
2:09 a.m.
Hello,
I've made the ui for adding check constraints. Ive taken reference from qbe.
But it generates sql query in javascript in the file db_multi_table_query.js
I'm unsure whether I should generate the query on client or server side??
Any suggestions??
On Wed, Jul 4, 2018 at 2:12 AM, Lakshay arora <arora.lakshya123(a)gmail.com>
wrote:
Hello,
I'm currently working on this
<https://github.com/phpmyadmin/phpmyadmin/issues/13592>(Add support for
CHECK constraints), as a part of my GSOC project.
As Isaac has written in his comment, this feature involves three parts.
The order in which I want to work on this is the following -
1. Implement an interface for interacting with these constraints
2. Update parser to understand this syntax
3. Update the export interface to allow including these in an export
For the first part-
I am thinking of implementing this something like query by example,
- we show the operator in a select dropdown, and 2 options, to enter
value or another column name
The constraints will be shown like indexes are, in the table structure,
where there will be an option to delete or add new check constraint on the
table.
For second and third parts-
Not sure yet.