Sha256: 5a6127a66446c669d1bcc21d626c98355bbcf8d603cee53cf9254848bbbcbfdd

Contents?: true

Size: 1.48 KB

Versions: 8

Compression:

Stored size: 1.48 KB

Contents

in:
  type: file
  path_prefix: '/sqlserver/data/test1/test1.csv'
  parser:
    charset: UTF-8
    newline: CRLF
    type: csv
    delimiter: ','
    quote: ''
    columns:
    - {name: ID, type: string}
    - {name: TINYINT_ITEM, type: long}
    - {name: SMALLINT_ITEM, type: long}
    - {name: INT_ITEM, type: long}
    - {name: BIGINT_ITEM, type: long}
    - {name: BIT_ITEM, type: boolean}
    - {name: DECIMAL_ITEM, type: string}
    - {name: NUMERIC_ITEM, type: string}
    - {name: SMALLMONEY_ITEM, type: string}
    - {name: MONEY_ITEM, type: string}
    - {name: REAL_ITEM, type: double}
    - {name: FLOAT_ITEM, type: double}
    - {name: CHAR_ITEM, type: string}
    - {name: VARCHAR_ITEM, type: string}
    - {name: TEXT_ITEM, type: string}
    - {name: NCHAR_ITEM, type: string}
    - {name: NVARCHAR_ITEM, type: string}
    - {name: NTEXT_ITEM, type: string}
    - {name: DATE_ITEM, type: timestamp, format: '%Y/%m/%d'}
    - {name: DATETIME_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: DATETIME2_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: DATETIME2_2_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: SMALLDATETIME_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: TIME_ITEM, type: timestamp, format: '%H:%M:%S.%N'}
    - {name: TIME_2_ITEM, type: timestamp, format: '%H:%M:%S.%N'}
out:
    type: sqlserver
    host: localhost
    database: TESTDB
    user: TEST_USER
    password: test_pw
    table: TEST1
    mode: insert

Version data entries

8 entries across 8 versions & 1 rubygems

Version Path
embulk-output-sqlserver-0.6.5 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.6.4 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.6.3 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.6.2 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.6.1 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.6.0 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.5.1 src/test/resources/sqlserver/yml/test-insert.yml
embulk-output-sqlserver-0.5.0 src/test/resources/sqlserver/yml/test-insert.yml