Function parse_insert_row

convert_to_sqlite.py:122–166

Parse a single (...) row from an INSERT VALUES clause into a tuple.

(line, col_names)

def parse_insert_row(line, col_names):
    """Parse a single (...) row from an INSERT VALUES clause into a tuple."""
    # Remove leading ( and trailing ), then split by , while handling quotes
    line = line.strip()
    if line.startswith('('):
        line = line[1:]
    if line.endswith(');') or line.endswith(');\n'):
        line = line[:-2].strip()
    elif line.endswith(')'):
        line = line[:-1]
    
    values = []
    current = ''
    in_quotes = False
    quote_char = None
    escape_next = False
    
    for ch in line:
        if escape_next:
            current += ch
            escape_next = False
            continue
        if ch == '\\':
            current += ch
            escape_next = True
            continue
        if in_quotes:
            current += ch
            if ch == quote_char:
                in_quotes = False
        else:
            if ch in ("'", '"'):
                in_quotes = True
                quote_char = ch
                current += ch
            elif ch == ',':
                values.append(parse_sql_value(current))
                current = ''
            else:
                current += ch
    
    if current.strip():
        values.append(parse_sql_value(current.strip()))
    
    return tuple(values)


def column_map(col_str):