sql
Installation
Entrypoint
Types
Sql
ColumnDetails

sql

No long description provided.

Installation

dagger install github.com/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4

Entrypoint

Return Type

Sql !

Arguments

Name	Type	Default Value	Description
conn	Secret !	-	No description provided

Example

dagger -m github.com/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 call \
 --conn env:MYSECRET

func (m *myModule) example(conn *Secret) *Sql  {
	return dag.
			Sql(conn)
}

@function
def example(conn: dagger.Secret) -> dag.Sql:
	return (
		dag.sql(conn)
	)

@func()
example(conn: Secret): 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

Name	Type	Default Value	Description
schema	String !	"public"	No description provided

Example

dagger -m github.com/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 call \
 --conn env:MYSECRET list-tables --schema string

func (m *myModule) example(ctx context.Context, conn *Secret, schema string) []string  {
	return dag.
			Sql(conn).
			ListTables(ctx, schema)
}

@function
async def example(conn: dagger.Secret, schema: str) -> List[str]:
	return await (
		dag.sql(conn)
		.list_tables(schema)
	)

@func()
async example(conn: Secret, 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

Name	Type	Default Value	Description
table	String !	-	No description provided

Example

dagger -m github.com/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 call \
 --conn env:MYSECRET list-columns --table string

func (m *myModule) example(ctx context.Context, conn *Secret, table string) []string  {
	return dag.
			Sql(conn).
			ListColumns(ctx, table)
}

@function
async def example(conn: dagger.Secret, table: str) -> List[str]:
	return await (
		dag.sql(conn)
		.list_columns(table)
	)

@func()
async example(conn: Secret, 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

Name	Type	Default Value	Description
table	String !	-	No description provided
column	String !	-	No description provided

Example

dagger -m github.com/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 call \
 --conn env:MYSECRET list-column-details --table string --column string

func (m *myModule) example(conn *Secret, table string, column string) *SqlColumnDetails  {
	return dag.
			Sql(conn).
			ListColumnDetails(table, column)
}

@function
def example(conn: dagger.Secret, table: str, column: str) -> dag.SqlColumnDetails:
	return (
		dag.sql(conn)
		.list_column_details(table, column)
	)

@func()
example(conn: Secret, 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

Name	Type	Default Value	Description
query	String !	-	No description provided

Example

dagger -m github.com/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 call \
 --conn env:MYSECRET run-query --query string

func (m *myModule) example(ctx context.Context, conn *Secret, query string) string  {
	return dag.
			Sql(conn).
			RunQuery(ctx, query)
}

@function
async def example(conn: dagger.Secret, query: str) -> str:
	return await (
		dag.sql(conn)
		.run_query(query)
	)

@func()
async example(conn: Secret, 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/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 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/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 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/jasonmccallister/sql@e1267aa57b6a46f8dd2f31aa9507c3e6584281a4 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()
}