Table of Contents

Enum CommandType

Namespace
YndigoBlue.Velocity.Enums
Assembly
YndigoBlue.Velocity.dll

Specifies the type of database operation command to be executed.

public enum CommandType

Fields

AddRecord = 1

Adds a single record to a table.

AddRecords = 2

Adds multiple records to a table in a batch operation.

BeginTransaction = 3

Begins a new database transaction.

BuildDatabase = 4

Creates a complete database from a schema definition.

BuildSchema = 5

Creates all tables, views, and constraints defined in a schema.

BuildTable = 6

Creates a single table based on its definition.

CheckExists = 7

Checks if a schema object (table, view, etc.) exists in the database.

Command = 8

Base command type for generic command execution.

CommitTransaction = 9

Commits the current transaction, making all changes permanent.

CreateColumn = 10

Adds a new column to an existing table.

CreateConstraint = 11

Creates a constraint on a table (primary key, foreign key, unique, or check).

CreateFullTextIndex = 12

Creates a full-text index on one or more columns.

CreateIndex = 13

Creates a standard index on one or more columns.

CreateSchema = 14

Creates a new schema in the database.

CreateSpatialIndex = 15

Creates a spatial index on geometry or geography columns.

CreateTable = 16

Creates a new table in the database.

CreateView = 17

Creates a database view.

Data = 18

Generic data operation command.

DeleteRecords = 19

Deletes one or more records from a table based on criteria.

DropConstraint = 20

Removes a constraint from a table.

DropFullTextIndex = 21

Removes a full-text index from the database.

DropIndex = 22

Removes an index from a table.

DropSchema = 23

Drops an entire schema from the database.

DropSpatialIndex = 24

Removes a spatial index from the database.

DropTable = 25

Drops a table from the database.

DropView = 26

Drops a view from the database.

EmptyDatabase = 27

Removes all schemas and tables from a database.

EmptySchema = 28

Removes all tables from a specific schema.

ExportDatabase = 29

Exports an entire database to configuration files and CSV data.

ExportData = 30

Exports data from tables to CSV files.

ExportSchema = 31

Exports a schema definition to an XML, JSON, or YAML file.

FullTextRetrieval = 32

Retrieves documents from a full-text index.

FullTextSearch = 33

Performs a full-text search query.

GetDatabaseInfo = 34

Retrieves metadata information about the database.

GetScalar = 35

Executes a query and returns a single scalar value.

ImportData = 36

Imports data from CSV files into database tables.

Initialize = 37

Initializes database connections and resources.

LoadDatabase = 38

Loads the complete database schema metadata from the database.

LoadSchema = 39

Loads a specific schema's metadata from the database.

ReadDatabase = 40

Reads a database schema definition from a file.

ReadSchema = 41

Reads a schema definition from an XML, JSON, or YAML file.

Retrieve = 42

Executes a SELECT query to retrieve records.

RollbackTransaction = 43

Rolls back the current transaction, discarding all changes.

RunSql = 44

Executes a raw SQL statement against the database.

Performs a search query with filtering criteria.

UpdateFullTextIndex = 46

Updates a full-text index to include recent data changes.

UpdateRecords = 47

Updates existing records in a table based on criteria.

UpdateSchema = 48

Updates an existing schema by comparing it with a new definition.

WriteDatabase = 49

Writes a database schema definition to a file.

WriteSchema = 50

Writes a schema definition to an XML, JSON, or YAML file.

Remarks

Velocity uses a command pattern to encapsulate database operations. Each command type corresponds to a specific operation such as DDL (Data Definition Language), DML (Data Manipulation Language), or DQL (Data Query Language) actions.