Dagger
Search

sql

No long description provided.

Installation

dagger install github.com/ddelnano/sql@v1.0.1

Entrypoint

Return Type 
Sql !
Arguments
NameTypeDefault ValueDescription
connString !-No description provided
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 --conn string
func (m *MyModule) Example(conn string) *dagger.Sql  {
	return dag.
			Sql(conn)
}
@function
def example(conn: str) -> dagger.Sql:
	return (
		dag.sql(conn)
	)
@func()
example(conn: string): Sql {
	return dag
		.sql(conn)
}

Types

Sql 🔗

listTables() 🔗

List the tables in a database and return the names of the tables

Return Type 
[String ! ] !
Arguments
NameTypeDefault ValueDescription
schemaString !"public"No description provided
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 --conn string list-tables --schema string
func (m *MyModule) Example(ctx context.Context, conn string, schema string) []string  {
	return dag.
			Sql(conn).
			ListTables(ctx, schema)
}
@function
async def example(conn: str, schema: str) -> List[str]:
	return await (
		dag.sql(conn)
		.list_tables(schema)
	)
@func()
async example(conn: string, schema: string): Promise<string[]> {
	return dag
		.sql(conn)
		.listTables(schema)
}

listColumns() 🔗

List the columns in a table and and return the names

Return Type 
[String ! ] !
Arguments
NameTypeDefault ValueDescription
tableString !-No description provided
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 --conn string list-columns --table string
func (m *MyModule) Example(ctx context.Context, conn string, table string) []string  {
	return dag.
			Sql(conn).
			ListColumns(ctx, table)
}
@function
async def example(conn: str, table: str) -> List[str]:
	return await (
		dag.sql(conn)
		.list_columns(table)
	)
@func()
async example(conn: string, table: string): Promise<string[]> {
	return dag
		.sql(conn)
		.listColumns(table)
}

listColumnDetails() 🔗

List the details for a specific column in a table

Return Type 
ColumnDetails !
Arguments
NameTypeDefault ValueDescription
tableString !-No description provided
columnString !-No description provided
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 --conn string list-column-details --table string --column string
func (m *MyModule) Example(conn string, table string, column string) *dagger.SqlColumnDetails  {
	return dag.
			Sql(conn).
			ListColumnDetails(table, column)
}
@function
def example(conn: str, table: str, column: str) -> dagger.SqlColumnDetails:
	return (
		dag.sql(conn)
		.list_column_details(table, column)
	)
@func()
example(conn: string, table: string, column: string): SqlColumnDetails {
	return dag
		.sql(conn)
		.listColumnDetails(table, column)
}

runQuery() 🔗

Query the database and return the results in comma-separated format

Return Type 
String !
Arguments
NameTypeDefault ValueDescription
queryString !-No description provided
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 --conn string run-query --query string
func (m *MyModule) Example(ctx context.Context, conn string, query string) string  {
	return dag.
			Sql(conn).
			RunQuery(ctx, query)
}
@function
async def example(conn: str, query: str) -> str:
	return await (
		dag.sql(conn)
		.run_query(query)
	)
@func()
async example(conn: string, query: string): Promise<string> {
	return dag
		.sql(conn)
		.runQuery(query)
}

ColumnDetails 🔗

ColumnDetails represents the details of a column in a database table

name() 🔗

Return Type 
String !
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 list-column-details --table string --column string \
 name
func (m *MyModule) Example(ctx context.Context, table string, column string) string  {
	return dag.
			Sql().
			ListColumnDetails(table, column).
			Name(ctx)
}
@function
async def example(table: str, column: str) -> str:
	return await (
		dag.sql()
		.list_column_details(table, column)
		.name()
	)
@func()
async example(table: string, column: string): Promise<string> {
	return dag
		.sql()
		.listColumnDetails(table, column)
		.name()
}

dataType() 🔗

Return Type 
String !
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 list-column-details --table string --column string \
 data-type
func (m *MyModule) Example(ctx context.Context, table string, column string) string  {
	return dag.
			Sql().
			ListColumnDetails(table, column).
			DataType(ctx)
}
@function
async def example(table: str, column: str) -> str:
	return await (
		dag.sql()
		.list_column_details(table, column)
		.data_type()
	)
@func()
async example(table: string, column: string): Promise<string> {
	return dag
		.sql()
		.listColumnDetails(table, column)
		.dataType()
}

isNullable() 🔗

Return Type 
Boolean !
Example
dagger -m github.com/ddelnano/sql@7d66950454e8c0e7d46ea42708aa8f89fb2bc6cc call \
 list-column-details --table string --column string \
 is-nullable
func (m *MyModule) Example(ctx context.Context, table string, column string) bool  {
	return dag.
			Sql().
			ListColumnDetails(table, column).
			IsNullable(ctx)
}
@function
async def example(table: str, column: str) -> bool:
	return await (
		dag.sql()
		.list_column_details(table, column)
		.is_nullable()
	)
@func()
async example(table: string, column: string): Promise<boolean> {
	return dag
		.sql()
		.listColumnDetails(table, column)
		.isNullable()
}