DEV Community

Maik Michel
Maik Michel

Posted on • Originally published at micodify.de on

Modify Tables- dbFlux (4/9)

This is the fourth article in my series about the VSCode extension dbFLux. In the last article I showed you how to create automated TableAPIs with dbFlux. This time it's about how dbFlux can help you if you use dbFlow as deployment tool. See: https://github.com/MaikMichel/dbFlow

What is dbFLow? dbFlow is a deployment tool, with which you can deploy your APEX / Oracle applications. dbFLow is completely based on the Git workflow. dbFlow uses, like dbFLux , smartFS as the basic structure of the respective projects. The branching model is used to determine the differences to the respective stages and the resulting deployment artifact is provided.

dbFlow uses the so-called 2-phase deployment. The whole product can be treated as new / initial version or as update / patch. So the CreateTabelScript is always kept up to date, as if it is deployed against an empty / new database and additionally the changes are recorded in AlterTable scripts. So the deployment can either as an initial deployment import the table again or as a patch deployment change it, via an Alter-Table script for example.

dbFlux helps you to create these Alter-Table scripts. So let's say we have a table script checked in. For example the table todo_data/tables/todos.

create table todos (
  tdo_id number not null,
  tdo_name varchar2(250 char) not null,
  tdo_created_at date not null,
  tdo_created_by varchar2(250 char) not null,
  tdo_modified_at date not null,
  tdo_modified_by varchar2(250 char) not null
);

Enter fullscreen mode Exit fullscreen mode

This has to be committed via Git.

git commit -m "create table todos"
Enter fullscreen mode Exit fullscreen mode

At a later time this table is to be extended by a new column. To do this, change the file, for example, as follows:

create table todos (
  tdo_id number not null,
  tdo_name varchar2(250 char) not null,
  --
  tdo_desc varchar2(4000 char),
  --
  tdo_created_at date not null,
  tdo_created_by varchar2(250 char) not null,
  tdo_modified_at date not null,
  tdo_modified_by varchar2(250 char) not null
);

Enter fullscreen mode Exit fullscreen mode

Here I have inserted the column tdo_desc.

Now I can execute the command dbFLux: Create TableDDL File with the help of dbFlux (Ctrl+Alt+D).

After I have chosen the table / table script, dbFlux creates a file for me which contains the git diff to this file.

So it is easy for me as a developer to add the whole thing with an alter table add ....

Afterwards I can apply the file as usual with Ctrl+Alt+B.

List of the single articles of this series:

  1. Initialize Workspace
  2. Create Database Objects
  3. Configure Custom Trigger Runs
  4. Modify Table

AWS Q Developer image

Your AI Code Assistant

Automate your code reviews. Catch bugs before your coworkers. Fix security issues in your code. Built to handle large projects, Amazon Q Developer works alongside you from idea to production code.

Get started free in your IDE

Top comments (0)

Eliminate Context Switching and Maximize Productivity

Pieces.app

Pieces Copilot is your personalized workflow assistant, working alongside your favorite apps. Ask questions about entire repositories, generate contextualized code, save and reuse useful snippets, and streamline your development process.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay