datatable

数据表相关 CLI 命令（本地操作，无需 Dimine 运行）。

cmd_datatable_add_record(fmt, file, values)

向 .dmd 数据表添加记录并保存（本地操作）。

Source code in dimine_python_sdk\cli\commands\datatable.py

def cmd_datatable_add_record(fmt: str, file: str, values: str) -> None:
    """向 .dmd 数据表添加记录并保存（本地操作）。"""
    err = require_local_sdk()
    if err:
        output_error(err, fmt)

    file_path = resolve_path(file)

    try:
        records = parse_key_values(values)
    except ValueError as e:
        output_error(str(e), fmt)

    from dimine_python_sdk.lib.db import DmDataTable

    try:
        dt = DmDataTable(file_path)

        added_count = 0
        for record_data in records:
            if not isinstance(record_data, dict):
                output_error(f"记录必须是键值对格式，实际类型: {type(record_data).__name__}", fmt)
            dt.add_record()
            new_index = len(dt) - 1
            new_record = dt.get_record_from_index(new_index)
            for field_name, value in record_data.items():
                new_record.set_value(field_name, value)
            added_count += 1

        dt.save()

        output_result({
            "success": True,
            "file": file_path,
            "added_count": added_count,
            "total_records": len(dt),
            "message": f"已添加 {added_count} 条记录并保存",
        }, fmt)
    except SystemExit:
        raise
    except Exception as e:
        output_error(f"添加记录失败: {e}", fmt)

cmd_datatable_info(fmt, file, column=None, to_json_output=False)

加载并检查 .dmd 数据表文件（本地操作）。

Source code in dimine_python_sdk\cli\commands\datatable.py

def cmd_datatable_info(fmt: str, file: str, column: str | None = None,
                       to_json_output: bool = False) -> None:
    """加载并检查 .dmd 数据表文件（本地操作）。"""
    err = require_local_sdk()
    if err:
        output_error(err, fmt)

    file_path = resolve_path(file)

    from dimine_python_sdk.lib.db import DmDataTable

    try:
        dt = DmDataTable(file_path)

        field_names = dt.columns if hasattr(dt, "columns") else []
        record_count = len(dt)

        if column:
            try:
                col_values = list(dt[column])
            except (KeyError, TypeError):
                output_error(f"字段 '{column}' 不存在。可用字段: {field_names}", fmt)
            output_result({"column": column, "count": len(col_values), "values": col_values}, fmt)
            return

        result = {
            "file": file_path,
            "field_count": len(field_names),
            "record_count": record_count,
            "fields": field_names,
        }

        if to_json_output:
            records = []
            for row in dt:
                if hasattr(row, "to_dict"):
                    records.append(row.to_dict())
                else:
                    records.append(dict(zip(field_names, row)) if not isinstance(row, dict) else row)
            result["records"] = records

        output_result(result, fmt)
    except Exception as e:
        output_error(f"加载数据表失败: {e}", fmt)

cmd_datatable_save(fmt, file)

保存 .dmd 数据表文件（本地操作）。

Source code in dimine_python_sdk\cli\commands\datatable.py

def cmd_datatable_save(fmt: str, file: str) -> None:
    """保存 .dmd 数据表文件（本地操作）。"""
    err = require_local_sdk()
    if err:
        output_error(err, fmt)

    file_path = resolve_path(file)

    from dimine_python_sdk.lib.db import DmDataTable

    try:
        dt = DmDataTable(file_path)
        result = dt.save()
        output_result({
            "success": result in (True, 0),
            "file": file_path,
            "message": f"数据表已保存: {file_path}",
        }, fmt)
    except Exception as e:
        output_error(f"保存数据表失败: {e}", fmt)

cmd_datatable_set(fmt, file, index, field, value)

设置 .dmd 数据表字段值并保存（本地操作）。

Source code in dimine_python_sdk\cli\commands\datatable.py

def cmd_datatable_set(fmt: str, file: str, index: int, field: str, value: str) -> None:
    """设置 .dmd 数据表字段值并保存（本地操作）。"""
    err = require_local_sdk()
    if err:
        output_error(err, fmt)

    file_path = resolve_path(file)
    index = safe_int(index)

    from dimine_python_sdk.lib.db import DmDataTable

    try:
        dt = DmDataTable(file_path)
        field_names = dt.columns
        record_count = len(dt)

        if index < 0 or index >= record_count:
            output_error(f"记录索引 {index} 超出范围 [0, {record_count})", fmt)
        if field not in field_names:
            output_error(f"字段 '{field}' 不存在。可用字段: {field_names}", fmt)

        record = dt.get_record_from_index(index)
        # 尝试自动推断值的类型
        typed_value = _infer_value_type(value)
        record.set_value(field, typed_value)

        dt.save()

        output_result({
            "success": True,
            "file": file_path,
            "index": index,
            "field": field,
            "value": typed_value,
            "total_records": record_count,
            "message": f"已更新记录[{index}].{field} = {typed_value}",
        }, fmt)
    except SystemExit:
        raise
    except Exception as e:
        output_error(f"设置字段值失败: {e}", fmt)

register_commands(subparsers, format_parent)

向 subparsers 注册数据表相关子命令。

Source code in dimine_python_sdk\cli\commands\datatable.py

def register_commands(subparsers, format_parent) -> None:
    """向 subparsers 注册数据表相关子命令。"""
    p = subparsers.add_parser("datatable-info", parents=[format_parent], help="加载并检查 .dmd 数据表文件")
    p.add_argument("--file", required=True, help=".dmd 数据表文件路径")
    p.add_argument("--column", default=None, help="提取指定列的值")
    p.add_argument("--to-json", action="store_true", dest="to_json_output", default=False,
                   help="同时输出全部记录数据")

    p = subparsers.add_parser("datatable-save", parents=[format_parent], help="保存 .dmd 数据表文件")
    p.add_argument("--file", required=True, help=".dmd 数据表文件路径")

    p = subparsers.add_parser("datatable-add-record", parents=[format_parent], help="向 .dmd 数据表添加记录并保存")
    p.add_argument("--file", required=True, help=".dmd 数据表文件路径")
    p.add_argument("--values", required=True, help="JSON 记录数组 [{\"key\":\"val\",...},...]，如 '[{\"HoleID\":\"ZK001\",\"Depth\":500.0}]'")

    p = subparsers.add_parser("datatable-set", parents=[format_parent], help="设置 .dmd 数据表字段值并保存")
    p.add_argument("--file", required=True, help=".dmd 数据表文件路径")
    p.add_argument("--index", type=int, required=True, help="记录索引（从0开始）")
    p.add_argument("--field", required=True, help="字段名")
    p.add_argument("--value", required=True, help="新值")