Skip to main content

​
Definition

Assembly: CloudNimble.BlazorEssentials.TursoDb.dll Namespace: CloudNimble.BlazorEssentials.TursoDb.Schema Inheritance: System.Object

​
Syntax

CloudNimble.BlazorEssentials.TursoDb.Schema.SqlGenerator

​
Summary

Generates SQL DDL statements from entity metadata.

​
Methods

​
GenerateAllDdl

Generates all DDL statements needed to create the table and indexes.

​
Syntax

public static System.Collections.Generic.IEnumerable<string> GenerateAllDdl(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: System.Collections.Generic.IEnumerable<string> All SQL DDL statements.

​
GenerateCount

Generates a SELECT COUNT(*) statement.

​
Syntax

public static string GenerateCount(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: string The SQL COUNT statement.

​
GenerateCreateIndexes

Generates CREATE INDEX statements for all indexed columns.

​
Syntax

public static System.Collections.Generic.IEnumerable<string> GenerateCreateIndexes(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: System.Collections.Generic.IEnumerable<string> The SQL CREATE INDEX statements.

​
GenerateCreateTable

Generates a CREATE TABLE IF NOT EXISTS statement for the entity.

​
Syntax

public static string GenerateCreateTable(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: string The SQL CREATE TABLE statement.

​
GenerateDelete

Generates a DELETE statement for the entity.

​
Syntax

public static string GenerateDelete(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: string The SQL DELETE statement.

​
GenerateInsert

Generates an INSERT statement for the entity.

​
Syntax

public static string GenerateInsert(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata, string columns, string placeholders)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.
columnsstringThe column names.
placeholdersstringThe parameter placeholders.

​
Returns

Type: string The SQL INSERT statement.

​
GenerateSelectAll

Generates a SELECT * statement for the entity.

​
Syntax

public static string GenerateSelectAll(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: string The SQL SELECT statement.

​
GenerateSelectByKey

Generates a SELECT statement to find by primary key.

​
Syntax

public static string GenerateSelectByKey(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.

​
Returns

Type: string The SQL SELECT statement.

​
GenerateUpdate

Generates an UPDATE statement for the entity.

​
Syntax

public static string GenerateUpdate(CloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadata metadata, string setClause)

​
Parameters

NameTypeDescription
metadataCloudNimble.BlazorEssentials.TursoDb.Schema.EntityMetadataThe entity metadata.
setClausestringThe SET clause.

​
Returns

Type: string The SQL UPDATE statement.