Skip to content

A microservice that automates the scanning of databases and subsequent creation of inbound pipes with namespaced identifiers.

License

Notifications You must be signed in to change notification settings

JonasAls89/autoconnect

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Autoconnect

A docker-compose microservice that automates the scanning of databases and its table relations.

Currently autoconnect supports:

Databases [MySQL, PostgreSQL, MsSQL]

Prerequisites

docker

API Capabalities

Supports GET, POST

How to:

Run program using Docker-compose

  1. Open the docker-compose.yaml file. Fill out the environment section in the backend service defined there. You need to fill in sesam_jwt and sesam_base_url

    • To get your sesam_base_url, go into your sesam node via: https://portal.sesam.io/dashboard. When in your node, navigate to the Subscription tab -> Network tab. In the network tab you'll see the "Default URL". That is the URL that should be pasted in sesam_base_url.

    • To generate a SESAM JWT navigate to the Subscription tab -> JWT tab. In the JWT tab do as instructed to generate a JWT. Paste the JWT in sesam_jwt.

  2. Navigate to /app in your terminal. Then run the following:

    docker-compose build
    
    docker-compose up
    

    To gracefully stopping the containers running run ctrl+c

  3. Open your browser and navigate to https://localhost/ and start autoconnecting to your database!

Run program for development purposes

This repo uses the file package.json and yarn to run the required commands.

  1. Modify the base_url in app/frontend/src/api/index.js and app/frontend/src/components/NewIndex.vue to use https://localhost:5000/.
  • Comments will also be present in the respective files.
  1. Make sure you have installed yarn.

  2. Run backend - from root:

        yarn install
    
  3. Run backend - execute to run the script:

        yarn swagger
    
  4. Run frontend - from /frontend:

        yarn dev
    

About

A microservice that automates the scanning of databases and subsequent creation of inbound pipes with namespaced identifiers.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published