This program acts as a proxy database, in which, any one table can be spoofed, allowing developers the ability to work without conflicting with other developers or testers.
Note
The main branch uses a third-party library for the mysql protocol and is minimally functional, meaning it breaks in some scenarios. Because of this, I am implementing the mysql protocol on branch crashing-on-update-bug, to resolve these issues. Follow PR #2 to keep informed.
Have you ever been in development and the needed data is in the test environment, but working with it is almost impossible because application gates are always being opened and closed? With this program, just spoof the application gate table and connect to the proxy. You can easily modify the application gates without affecting the real gates in the test environment.
To begin, you must have Go and Docker installed. In case you are on mac, docker won't work by itself, unless you install docker desktop. If you're like me and PREFER CLIs, then install, colima which is a container runtime, and can serve as a "docker daemon".
First set these environment variables, in the terminal that will be running the proxy in, for connecting to your desired remote database
export DB_HOST=""
export DB_USER=""
export DB_PASS=""
export DB_NAME=""
Then you'll need to build the docker image and then start a container:
docker build -t imposter-img .
docker run -d --name imposter-cont -p 3306:3306 imposter-img
Then run:
go build
Continue by selecting the schema and table to be spoofed. After this, the proxy will begin running. The idea is that you connect your DBMS and your locally running APIs to this proxy, so that you can modify the locally spoofed table, without changing configurations that impact others, and such that others cannot impact you.
Finally, the proxy is running! Now we want it to do some tom-foolery. We can connect to it using the following credentials:
host - 127.0.0.1
port - 3307
username - root
password - "" (empty string)
For instance, you can enter these into a DBMS to view the spoofed database or you can use them when establishing a database connection programmatically , so this might look like:
host: '127.0.0.1',
user: 'root',
password: '',
database: 'my_db', // your actual db name
port: 3307,
Caution
This currently not compatible with Sequelize. I've found the best experience to be when using a raw driver/connector without an ORM. If you find an issue, file it!
I have begun writing my own codec on another brsnch.
- Matt Maloney : matttm