8665741536

Committed 12 Apr 2024 05:19PM UTC coverage: 57.738% (-0.07%) from 57.812%

Build # 8665741536

Build Type

Pull #2138

github

Committed by

sweatybridge

Commit Message

fix: add schema column to table sizes query

Pull Request Pull Request #2138: fix: exclude supabase managed schemas from inspect subcommand

Run Details

2 of 46 new or added lines in 20 files covered. (4.35%)

5 existing lines in 1 file now uncovered.

6376 of 11043 relevant lines covered (57.74%)

662.93 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/internal/inspect/outliers/outliers.go

package outliers

import (
        "context"
        "fmt"
        "regexp"

        "github.com/go-errors/errors"
        "github.com/jackc/pgconn"
        "github.com/jackc/pgx/v4"
        "github.com/spf13/afero"
        "github.com/supabase/cli/internal/inspect"
        "github.com/supabase/cli/internal/migration/list"
        "github.com/supabase/cli/internal/utils"
        "github.com/supabase/cli/internal/utils/pgxv5"
)

type Result struct {
        Total_exec_time string
        Prop_exec_time  string
        Ncalls          string
        Sync_io_time    string
        Query           string
}

func Run(ctx context.Context, config pgconn.Config, fsys afero.Fs, options ...func(*pgx.ConnConfig)) error {
        conn, err := utils.ConnectByConfig(ctx, config, options...)
        if err != nil {
                return err
        }
        rows, err := conn.Query(ctx, inspect.OUTLIERS_QUERY)
        if err != nil {
                return errors.Errorf("failed to query rows: %w", err)
        }
        result, err := pgxv5.CollectRows[Result](rows)
        if err != nil {
                return err
        }
        // TODO: implement a markdown table marshaller
        table := "|Query|Execution Time|Proportion of exec time|Number Calls|Sync IO time|\n|-|-|-|-|-|\n"
        for _, r := range result {
                re := regexp.MustCompile(`\s+|\r+|\n+|\t+|\v`)
                query := re.ReplaceAllString(r.Query, " ")

                re = regexp.MustCompile(`\|`)
                query = re.ReplaceAllString(query, `\|`)
                table += fmt.Sprintf("|`%s`|`%s`|`%s`|`%s`|`%s`|\n", query, r.Total_exec_time, r.Prop_exec_time, r.Ncalls, r.Sync_io_time)
        }
        return list.RenderTable(table)
}

1	package outliers
2
3	import (
4	"context"
5	"fmt"
6	"regexp"
7
8	"github.com/go-errors/errors"
9	"github.com/jackc/pgconn"
10	"github.com/jackc/pgx/v4"
11	"github.com/spf13/afero"
12	"github.com/supabase/cli/internal/inspect"
13	"github.com/supabase/cli/internal/migration/list"
14	"github.com/supabase/cli/internal/utils"
15	"github.com/supabase/cli/internal/utils/pgxv5"
16	)
17
18	type Result struct {
19	Total_exec_time string
20	Prop_exec_time string
21	Ncalls string
22	Sync_io_time string
23	Query string
24	}
25
26	func Run(ctx context.Context, config pgconn.Config, fsys afero.Fs, options ...func(*pgx.ConnConfig)) error {	×
27	conn, err := utils.ConnectByConfig(ctx, config, options...)	×
28	if err != nil {	×
29	return err	×
30	}	×
NEW 31	rows, err := conn.Query(ctx, inspect.OUTLIERS_QUERY)	×
32	if err != nil {	×
33	return errors.Errorf("failed to query rows: %w", err)	×
34	}	×
35	result, err := pgxv5.CollectRows[Result](rows)	×
36	if err != nil {	×
37	return err	×
38	}	×
39	// TODO: implement a markdown table marshaller
40	table := "\|Query\|Execution Time\|Proportion of exec time\|Number Calls\|Sync IO time\|\n\|-\|-\|-\|-\|-\|\n"	×
41	for _, r := range result {	×
42	re := regexp.MustCompile(`\s+\|\r+\|\n+\|\t+\|\v`)	×
43	query := re.ReplaceAllString(r.Query, " ")	×
44		×
45	re = regexp.MustCompile(`\\|`)	×
46	query = re.ReplaceAllString(query, `\\|`)	×
47	table += fmt.Sprintf("\|`%s`\|`%s`\|`%s`\|`%s`\|`%s`\|\n", query, r.Total_exec_time, r.Prop_exec_time, r.Ncalls, r.Sync_io_time)	×
48	}	×
49	return list.RenderTable(table)	×
50	}

supabase / cli / 8665741536

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous