Developer a Query Rewrite plugin for MySQL 5.7

Cerrado Publicado Aug 7, 2015 Pagado a la entrega
Cerrado Pagado a la entrega

We need a Query Rewrite plugin written for MySQL 5.7 that will replace certain clauses in the query with alternate values.

A discussion on the Query Rewrite plugin can be found here:

[url removed, login to view]

The plugin should be controlled via a table containing a list of the clauses that need to be replaced along with the target replacement clause.

For example:

Inbound Query:

CREATE TABLE SEQUENCECONTROL (

NAME VARCHAR(32) NOT NULL,

CURRENTVALUE INT NOT NULL,

INITIALVALUE INT NOT NULL,

INCR INT NOT NULL,

MAXVALUE INT NOT NULL,

CACHESIZE INT NOT NULL,

RESETTOINITIAL CHAR(1) NOT NULL

) TYPE=InnoDB;

Altered Query:

CREATE TABLE SEQUENCECONTROL (

NAME VARCHAR(32) NOT NULL,

CURRENTVALUE INT NOT NULL,

INITIALVALUE INT NOT NULL,

INCR INT NOT NULL,

MAX_VALUE INT NOT NULL,

CACHESIZE INT NOT NULL,

RESETTOINITIAL CHAR(1) NOT NULL

) ENGINE=InnoDB;

As you can see MAXVALUE has been rewitten as MAX_VALUE and TYPE=InnoDB has been rewritten as ENGINE=InnoDB.

Programación en C MySQL

Nº del proyecto: #8229145

Sobre el proyecto

3 propuestas Proyecto remoto Activo Oct 7, 2015

3 freelancers están ofertando un promedio de $137 por este trabajo

WhatTechnologies

A proposal has not yet been provided

$100 USD en 3 días
(2 comentarios)
2.4
avnish11niranjan

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0
ailingfoong

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0