Module convert

Module convert 

Source
Expand description

Convert command for translating SQL dumps between dialects.

Supports conversion between MySQL, PostgreSQL, and SQLite dialects with:

  • Identifier quoting conversion (backticks ↔ double quotes)
  • String escape normalization (' ↔ ‘’)
  • Data type mapping (AUTO_INCREMENT ↔ SERIAL ↔ INTEGER PRIMARY KEY)
  • COPY FROM stdin → INSERT conversion
  • Session header conversion
  • Warning system for unsupported features

Structs§

ConvertConfig
Configuration for the convert command
ConvertStats
Statistics from convert operation
Converter
Main converter that dispatches to specific dialect converters
CopyHeader
Result of parsing a COPY header
TypeMapper
Type mapper for converting between dialects
WarningCollector
Collects warnings during conversion

Enums§

ConvertWarning
Warning types that can occur during conversion
CopyValue
A parsed value from COPY data

Functions§

copy_to_inserts
Convert a COPY data block to INSERT statements
parse_copy_data
Parse COPY data block into rows of values
parse_copy_header
Parse a COPY header to extract table and columns Input: “COPY schema.table (col1, col2) FROM stdin;”
run
Run the convert command