Database <BadgeServer/>

Streamlined utilities for managing database tables, triggers, and columns

JO Functions > jo.database.addColumn()

<!-- @include: ./slots/headers.md#server|jo.database.addColumn -->

A function to create a column in a specific table if not exist <br>

<!-- @include: ./slots/descriptions.md#server|jo.database.addColumn -->

JO Functions > jo.database.addColumn() > Syntax

jo.database.addColumn(tableName, name, definition)

JO Functions > jo.database.addColumn() > Parameters

tableName : string

The name of the table

name : string

The name of the column

definition : string

The definition of the column

JO Functions > jo.database.addColumn() > Return Value

Type : boolean

Return true if the column is created, false otherwise

<!-- @include: ./slots/examples.md#server|jo.database.addColumn -->

<!-- @include: ./slots/footers.md#server|jo.database.addColumn -->

JO Functions > jo.database.addTable()

<!-- @include: ./slots/headers.md#server|jo.database.addTable -->

A function to create a table if not exist <br>

<!-- @include: ./slots/descriptions.md#server|jo.database.addTable -->

JO Functions > jo.database.addTable() > Syntax

jo.database.addTable(tableName, definition)

JO Functions > jo.database.addTable() > Parameters

tableName : string

The name of the table

definition : string

The definition of the table

JO Functions > jo.database.addTable() > Return Value

Type : boolean

Return true if the table is created, false otherwise

<!-- @include: ./slots/examples.md#server|jo.database.addTable -->

<!-- @include: ./slots/footers.md#server|jo.database.addTable -->

JO Functions > jo.database.addTrigger()

<!-- @include: ./slots/headers.md#server|jo.database.addTrigger -->

A function to create a trigger if not exist <br>

<!-- @include: ./slots/descriptions.md#server|jo.database.addTrigger -->

JO Functions > jo.database.addTrigger() > Syntax

jo.database.addTrigger(triggerName, definition)

JO Functions > jo.database.addTrigger() > Parameters

triggerName : string

The name of the trigger

definition : string

The definition of the trigger

JO Functions > jo.database.addTrigger() > Return Value

Type : boolean

Return true if the trigger is created, false otherwise

<!-- @include: ./slots/examples.md#server|jo.database.addTrigger -->

<!-- @include: ./slots/footers.md#server|jo.database.addTrigger -->

JO Functions > jo.database.doesTableExist()

<!-- @include: ./slots/headers.md#server|jo.database.doesTableExist -->

A function to check if a table exists <br>

<!-- @include: ./slots/descriptions.md#server|jo.database.doesTableExist -->

JO Functions > jo.database.doesTableExist() > Syntax

jo.database.doesTableExist(tableName)

JO Functions > jo.database.doesTableExist() > Parameters

tableName : string

The name of the table

JO Functions > jo.database.doesTableExist() > Return Value

Type : boolean

Return true if the table exists, false otherwise

<!-- @include: ./slots/examples.md#server|jo.database.doesTableExist -->

<!-- @include: ./slots/footers.md#server|jo.database.doesTableExist -->