Method Run

internal/cmd/sheets_table.go:216–287

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsTableDeleteCmd) Run(ctx context.Context, flags *RootFlags) error {
	u := ui.FromContext(ctx)
	spreadsheetID := normalizeGoogleID(strings.TrimSpace(c.SpreadsheetID))
	in := strings.TrimSpace(c.TableID)
	if spreadsheetID == "" {
		return usage("empty spreadsheetId")
	}
	if in == "" {
		return usage("empty tableId")
	}

	if dryRunErr := dryRunExit(ctx, flags, "sheets.table.delete", map[string]any{
		"spreadsheet_id":         spreadsheetID,
		"table_id_or_name":       in,
		"discard_data":           c.DiscardData,
		"deletes_table_contents": true,
	}); dryRunErr != nil {
		return dryRunErr
	}

	if !c.DiscardData {
		return usage("sheets table delete also deletes every cell in the table range; pass --discard-data to confirm intentional data deletion")
	}

	account, err := requireAccount(flags)
	if err != nil {
		return err
	}
	svc, err := sheetsService(ctx, account)
	if err != nil {
		return err
	}

	tables, err := fetchSpreadsheetTables(ctx, svc, spreadsheetID)
	if err != nil {
		return err
	}
	table, found, err := resolveSheetsTable(in, tables)
	if err != nil {
		return err
	}
	if !found {
		return usagef("unknown table %q", in)
	}

	if err := confirmDestructiveChecked(ctx, flagsWithoutDryRun(flags), "delete table "+table.Name); err != nil {
		return err
	}

	req := &sheets.BatchUpdateSpreadsheetRequest{
		Requests: []*sheets.Request{
			{
				DeleteTable: &sheets.DeleteTableRequest{TableId: table.TableID},
			},
		},
	}
	if _, err := svc.Spreadsheets.BatchUpdate(spreadsheetID, req).Do(); err != nil {
		return err