Developer a Query Rewrite plugin for MySQL 5.7

Closed Posted Aug 7, 2015 Paid on delivery
Closed Paid on delivery

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.

C Programming MySQL

Project ID: #8229145

About the project

3 proposals Remote project Active Oct 7, 2015

3 freelancers are bidding on average $137 for this job

WhatTechnologies

A proposal has not yet been provided

$100 USD in 3 days
(2 Reviews)
2.4
avnish11niranjan

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
ailingfoong

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0