17433978344

Committed 03 Sep 2025 12:49PM UTC coverage: 66.636% (-0.02%) from 66.655%

Build # 17433978344

Build Type

Pull #10193

github

Committed by

web-flow

Commit Message

Merge cb5c342e7 into ea6cc8154

Pull Request Pull Request #10193: sqldb: fix SQLStr helper

Run Details

4 of 11 new or added lines in 3 files covered. (36.36%)

83 existing lines in 18 files now uncovered.

136068 of 204197 relevant lines covered (66.64%)

21429.22 hits per line

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

73.53

/sqldb/sqlutils.go

package sqldb

import (
        "database/sql"
        "time"

        "golang.org/x/exp/constraints"
)

// NoOpReset is a no-op function that can be used as a default
// reset function ExecTx calls.
var NoOpReset = func() {}

// SQLInt16 turns a numerical integer type into the NullInt16 that sql/sqlc
// uses when an integer field can be permitted to be NULL.
//
// We use this constraints.Integer constraint here which maps to all signed and
// unsigned integer types.
func SQLInt16[T constraints.Integer](num T) sql.NullInt16 {
        return sql.NullInt16{
                Int16: int16(num),
                Valid: true,
        }
}

// SQLInt32 turns a numerical integer type into the NullInt32 that sql/sqlc
// uses when an integer field can be permitted to be NULL.
//
// We use this constraints.Integer constraint here which maps to all signed and
// unsigned integer types.
func SQLInt32[T constraints.Integer](num T) sql.NullInt32 {
        return sql.NullInt32{
                Int32: int32(num),
                Valid: true,
        }
}

// SQLInt64 turns a numerical integer type into the NullInt64 that sql/sqlc
// uses when an integer field can be permitted to be NULL.
//
// We use this constraints.Integer constraint here which maps to all signed and
// unsigned integer types.
func SQLInt64[T constraints.Integer](num T) sql.NullInt64 {
        return sql.NullInt64{
                Int64: int64(num),
                Valid: true,
        }
}

// SQLStr turns a string into the NullString that sql/sqlc uses when a string
// can be permitted to be NULL.
func SQLStr(s string) sql.NullString {
        return sql.NullString{
                String: s,
                Valid:  true,
        }
}

// SQLTime turns a time.Time into the NullTime that sql/sqlc uses when a time
// can be permitted to be NULL.
func SQLTime(t time.Time) sql.NullTime {
        return sql.NullTime{
                Time:  t,
                Valid: true,
        }
}

// ExtractSqlInt16 turns a NullInt16 into a numerical type. This can be useful
// when reading directly from the database, as this function handles extracting
// the inner value from the "option"-like struct.
func ExtractSqlInt16[T constraints.Integer](num sql.NullInt16) T {
        return T(num.Int16)
}

1	package sqldb
2
3	import (
4	"database/sql"
5	"time"
6
7	"golang.org/x/exp/constraints"
8	)
9
10	// NoOpReset is a no-op function that can be used as a default
11	// reset function ExecTx calls.
12	var NoOpReset = func() {}	22,435✔
13
14	// SQLInt16 turns a numerical integer type into the NullInt16 that sql/sqlc
15	// uses when an integer field can be permitted to be NULL.
16	//
17	// We use this constraints.Integer constraint here which maps to all signed and
18	// unsigned integer types.
19	func SQLInt16[T constraints.Integer](num T) sql.NullInt16 {	×
20	return sql.NullInt16{	×
21	Int16: int16(num),	×
22	Valid: true,	×
23	}	×
24	}	×
25
26	// SQLInt32 turns a numerical integer type into the NullInt32 that sql/sqlc
27	// uses when an integer field can be permitted to be NULL.
28	//
29	// We use this constraints.Integer constraint here which maps to all signed and
30	// unsigned integer types.
31	func SQLInt32[T constraints.Integer](num T) sql.NullInt32 {	20,592✔
32	return sql.NullInt32{	20,592✔
33	Int32: int32(num),	20,592✔
34	Valid: true,	20,592✔
35	}	20,592✔
36	}	20,592✔
37
38	// SQLInt64 turns a numerical integer type into the NullInt64 that sql/sqlc
39	// uses when an integer field can be permitted to be NULL.
40	//
41	// We use this constraints.Integer constraint here which maps to all signed and
42	// unsigned integer types.
43	func SQLInt64[T constraints.Integer](num T) sql.NullInt64 {	32,264✔
44	return sql.NullInt64{	32,264✔
45	Int64: int64(num),	32,264✔
46	Valid: true,	32,264✔
47	}	32,264✔
48	}	32,264✔
49
50	// SQLStr turns a string into the NullString that sql/sqlc uses when a string
51	// can be permitted to be NULL.
52	func SQLStr(s string) sql.NullString {	20,592✔
53	return sql.NullString{	20,592✔
54	String: s,	20,592✔
55	Valid: true,	20,592✔
56	}	20,592✔
57	}	20,592✔
58
59	// SQLTime turns a time.Time into the NullTime that sql/sqlc uses when a time
60	// can be permitted to be NULL.
61	func SQLTime(t time.Time) sql.NullTime {	66,060✔
62	return sql.NullTime{	66,060✔
63	Time: t,	66,060✔
64	Valid: true,	66,060✔
65	}	66,060✔
66	}	66,060✔
67
68	// ExtractSqlInt16 turns a NullInt16 into a numerical type. This can be useful
69	// when reading directly from the database, as this function handles extracting
70	// the inner value from the "option"-like struct.
NEW 71	func ExtractSqlInt16[T constraints.Integer](num sql.NullInt16) T {	×
NEW 72	return T(num.Int16)	×
NEW 73	}	×

lightningnetwork / lnd / 17433978344

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