Libraries.Data.Database.CreateTable

The CreateTable class is a query make a new table on a database. To create a table you need to give it a name using SetTable and then the table needs at least one column.

Example Code

use Libraries.Data.Database.CreateTable

    CreateTable table
    table:SetTable("Users")
    table:AddIntegerColumn("id")

This action adds a 32 bit integer column to the table.

Example Code

use Libraries.Data.Database.CreateTable

        CreateTable mine
        mine:AddIntegerColumn("id")

This action adds a 32 bit integer column to the table.

Example Code

use Libraries.Data.Database.CreateTable

        CreateTable mine
        mine:AddIntegerColumn("id")

Adds objects that have been remapped to single table for reference in actions called when building the query to text. Examples of RemappableNames are columns, tables, and subqueries.

At the plugin level prepared statements are used to add a layer of security from injection attacks. Every parameter in the prepared paramter array will be stripped from the actual query text and set appropriately at the plugin level.

Adds a subquery to this query. Only Find queries are supported for now. A Subquery is a query that exists another outer query. An example could be a Find where the table to search through is actually the result of another query.

This adds a name that can be used in the place of a table. This action does not set the table of this query but only a name that can be referenced if the table is added.

Example Code

use Libraries.Data.Database.Find

        Find query
        query:SetTable("orders", "o")
        query:AddTableNameRemap("members", "m")
        query:AddInnerJoin("m", "o:name = m:name")

Internal. Queries keep track of what tables are referenced to check for ambiguous column names

This action adds a text column to the table. If the value is less than 0, this throws an error. If the value is greater than 0 and less than 65,535, a VARCHAR is created on the database. If the value is greater than this, a LONGTEXT is created, which has a maximum value of 4,294,967,295. If the version of this action is called with fixed = true, then the integer can have a maximum size of 255 characters and the text is always of fixed length.

Example Code

use Libraries.Data.Database.CreateTable

        CreateTable mine
        mine:AddTextColumn("LastName", 400)

This action adds a text column to the table. If the value is less than 0, this throws an error. If the value is greater than 0 and less than 65,535, a VARCHAR is created on the database. If the value is greater than this, a LONGTEXT is created, which has a maximum value of 4,294,967,295. If the version of this action is called with fixed = true, then the integer can have a maximum size of 255 characters and the text is always of fixed length.

Example Code

use Libraries.Data.Database.CreateTable

        CreateTable mine
        mine:AddTextColumn("LastName", 255, true)

This action compares two object hash codes and returns an integer. The result is larger if this hash code is larger than the object passed as a parameter, smaller, or equal. In this case, -1 means smaller, 0 means equal, and 1 means larger. This action was changed in Quorum 7 to return an integer, instead of a CompareResult object, because the previous implementation was causing efficiency issues.

Example Code

Object o
        Object t
        integer result = o:Compare(t) //1 (larger), 0 (equal), or -1 (smaller)

No matter the data type, this action removes the previously added column from the create query.

Example Code

use Libraries.Data.Database.CreateTable

        CreateTable mine
        mine:RemoveColumn("LastName")

Clears the prepared parameter list. Necessary because running a query again without emptying the list will cause the list of parameters to not shrink

Empties the table references hash table.

This action determines if two objects are equal based on their hash code values.

Example Code

use Libraries.Language.Object
        use Libraries.Language.Types.Text
        Object o
        Text t
        boolean result = o:Equals(t)

Some queries make use of the filter which is an expression checked against the values of the columns in the rows of a database table. The filter is written using Quorum syntax and will be type checked to see if it's valid. Column names can be used and the names made by the user using name remaps. An example filter would be "priority < 4" where priority is a column that exists and can be mapped to an integer.

Example Code

use Libraries.Data.Database.Delete

        Delete query
        query:SetTable("orders")
        query:Filter("priority < 4")

Returns the meta data object set for this query

This action gets the hash code for an object.

Example Code

Object o
        integer hash = o:GetHashCode()

Grabs the table containing all aliases that have been set in this query

Used at the plugin level to get all parameters that need to be set in the prepared statement

Returns the filter as given by the user. The filter will be converted to a syntax accepted by the database server and this action returns whatever the user originally typed

Returns the alias

Returns the table this query is meant to be ran against

Internal. Used by other actions to grab what tables are referenced to check if column names are valid.

Returns the filter as translated by the quorum compiler. The filter will be converted to a syntax accepted by the database server and this action returns whatever the user originally typed

No matter the data type, this action removes the previously added column from the create query.

Example Code

use Libraries.Data.Database.CreateTable

        CreateTable mine
        mine:RemoveColumn("LastName")

Sets the DatabaseMetaData for this query. This is necessary for checking things like if a table referenced exists or if a filter has valid column references.

Sets the alias

This action sets the table of the query. Most queries run against a single table and this action is used to set which table the query will affect or search.

Example Code

use Libraries.Data.Database.Find

        Find query
        query:SetTable("members")

This action sets the table of the query. Most queries run against a single table and this action is used to set which table the query will affect or search. This action also lets you rename the table so in filters a different name can be used.

Example Code

use Libraries.Data.Database.Find

        Find query
        query:SetTable("members", "m")

This action sets the table of the query. Most queries run against a single table and this action is used to set which table the query will affect or search. This action also lets you rename the table so in filters a different name can be used.

Example Code

use Libraries.Data.Database.Find

        Find query
        query:SetTableWithName("members", "m")

By default convert to structured query language.