PL-Admin is a PL/SQL Manager that provides you with an easy way to clone a main schema, compile pl/sql code on realtime, check for database errors, check for differences between repos and databases, and so much more.
This tool was created to deal with database-centered apps, with too much logic on the database side and very little on the code side.
$ docker -v
Docker version 19.03.5 # Or greaterversion: "3.7"
services:
pladmin-omega:
image: viva/pl-admin
container_name: pladmin-omega
build:
context: '.'
volumes:
- <you_plsql_path>:/plsql # <-- DO NOT FORGET SETUP YOUR PL/SQL PATH
tty: true
networks:
- backend- Clone the repo
# Git
git clone <repo_url>- Creating images and container
# Build the docker image
docker build --no-cache -t viva/pl-admin .
# Create the container
# Do not forget replace <path_to_plsql_code> for your plsql path
docker run -ti --name=pladmin-omega -d -v <path/to/plsql_code>:/plsql viva/pl-admin
# In case that you have other schema just create another container with other name
docker run -ti --name=pladmin-reclamaciones -d -v <path/to/plsql_code>:/plsql viva/pl-admin- Copy
.env.samplefile to each pl/sql path and change the params
cp .env.sample you_plsql_path/.envCreate an alias the made the proccess more easier
# Open your profile config should be .bash_profile or .zshrc
vim ~/.bash_profile
# Enter this line:
alias pladmin="docker container exec -ti pladmin-omega pladmin"
# If you have multiple schemas, enter this line too:
alias pl-reclamaciones="docker container exec -ti pladmin-reclamaciones pladmin"
# Close the file and source you new alias
source ~/.bash_profile- Usage
- Creating a New Shcema
- Export changes from your Database to Git (db2wc)
- Change SYS DBA Password
- The file name has to be the same of the object name.
- Do not duplicate files names.
- The file extension indicates what kind of object it is.
- Each object type has to be in it's corresponding directory.
| Object Type | File Extention | Directory |
|---|---|---|
| PACKAGE | .pks | ./packages |
| PACKAGE BODY | .pkb | ./packages |
| VIEW | .vw | ./views |
| FUNCTION | .fnc | ./functions |
| PROCEDURE | .prc | ./procedures |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent