package
0.4.86
Repository: https://github.com/flarco/dbio.git
Documentation: pkg.go.dev

# Functions

No description provided by the author
ChangeColumnTypeViaAdd swaps a new column with the old in order to change the type need to use this with snowflake when changing from date to string, or number to string.
CleanSQL removes creds from the query.
No description provided by the author
CommonColumns return common columns.
CopyFromAzure uses the Snowflake COPY INTO Table command from Azure https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html.
No description provided by the author
EnsureBinDuckDB ensures duckdb binary exists if missing, downloads and uses.
EnsureBinSQLite ensures sqlite binary exists if missing, downloads and uses.
GenerateAlterDDL generate a DDL based on a dataset.
No description provided by the author
GetSchemataAll obtains the schemata for all databases detected.
GetTablesSchemata obtains the schemata for specified tables.
No description provided by the author
InsertBatchStream inserts a stream into a table in batch.
InsertStream inserts a stream.
No description provided by the author
NewConn return the most proper connection for a given database.
NewConnContext return the most proper connection for a given database with context props are provided as `"Prop1=Value1", "Prop2=Value2", ...`.
No description provided by the author
No description provided by the author
No description provided by the author
ParseSQLMultiStatements splits a sql text into statements typically by a ';'.
No description provided by the author
PK returns the primary keys of a model.
SplitTableFullName retrusn the schema / table name.
SQLColumns returns the columns from database ColumnType.
TableExists returns true if the table exists.
TestPermissions tests the needed permissions in a given connection.
UID returns a unique ID for that object.
Upsert upserts from source table into target table.

# Constants

No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author

# Variables

Debug prints queries when true.
so that collision doesn't happen.
No description provided by the author
No description provided by the author
InferDBStream may need to be `true`, since precision and scale is not guaranteed.
UseBulkExportFlowCSV to use BulkExportFlowCSV.

# Structs

BaseConn is a database connection.
BaseTransaction is a database transaction.
BigQueryConn is a Google Big Query connection.
BigTableConn is a Google Big Query connection.
No description provided by the author
No description provided by the author
ClickhouseConn is a Clikchouse connection.
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
Database represents a schemata database.
DbX is db express.
DuckDbConn is a Duck DB connection.
No description provided by the author
ModelDbX is the base for any SQL model.
MsSQLServerConn is a Microsoft SQL Server connection.
MySQLConn is a MySQL or MariaDB connection.
OracleConn is a Postgres connection.
Pool is a pool of connections.
PostgresConn is a Postgres connection.
RedshiftConn is a Redshift connection.
No description provided by the author
Schema represents a schemata schema.
Schemata contains the full schema for a connection.
SnowflakeConn is a Snowflake connection.
SQLiteConn is a Google Big Query connection.
StarRocksConn is a StarRocks connection.
No description provided by the author
Table represents a schemata table.
Template is a database YAML template.
No description provided by the author

# Interfaces

Connection is the Base interface for Connections.
No description provided by the author

# Type aliases

No description provided by the author
No description provided by the author
WhereClause is the where clause.