struct Triki::SqlServer

Overview

SQL Server dump parser and writer.

Handles INSERT INTO [dbo].[table] ... VALUES statements.

Included Modules

Defined in:

triki/sql_server.cr

Instance Method Summary

Instance methods inherited from module Triki::ConfigScaffoldGenerator

config_table_close config_table_close, config_table_open(table_name) config_table_open, emit_scaffold(table_name : String, existing_config : ConfigTableHash | Nil, extra_columns : ColumnList, columns_to_scaffold : ColumnList, output_io : IO) emit_scaffold, formatted_line(column : String, definition : ConfigColumn | String, comment : String | Nil = nil) : String formatted_line, generate_config(obfuscator : Triki, config : ConfigHash, input_io : IO, output_io : IO) generate_config

Instance methods inherited from module Triki::InsertStatementParser

parse(obfuscator : Triki, config : ConfigHash, input_io : IO, output_io : IO) : Nil parse

Instance methods inherited from struct Triki::Base

initialize initialize, make_insert_statement(table_name : String, column_names : ColumnList, values : Array(Array(RowContent)), ignore = false) : String make_insert_statement, make_valid_value_string(value : RowContent) : RowContent make_valid_value_string, parse(obfuscator : Triki, config : ConfigHash, input_io : IO, output_io : IO) : Nil parse, rows_to_be_inserted(line : String) : Array(Array(String | Nil)) rows_to_be_inserted

Constructor methods inherited from struct Triki::Base

new new

Instance Method Detail

def make_insert_statement(table_name : String, column_names : ColumnList, values : Array(Array(RowContent)), ignore = false) : String #
Description copied from struct Triki::Base

Reassembles an INSERT/COPY statement from the given rows.


[View source]
def make_valid_value_string(value : RowContent) : RowContent #
Description copied from struct Triki::Base

Quotes or formats a single value for the target database dialect.


[View source]
def rows_to_be_inserted(line : String) : Array(Array(String | Nil)) #
Description copied from struct Triki::Base

Extracts rows of values from a single INSERT/COPY line.


[View source]
def table_data(line) #

[View source]