Documentation
¶
Overview ¶
Package sqlserver contains generated code for schema 'a_bit_of_everything'.
Index ¶
- func A0In0Out(ctx context.Context, db DB) error
- func A0In1Out(ctx context.Context, db DB) (int, error)
- func A1In0Out(ctx context.Context, db DB, aParam int) error
- func A1In1Out(ctx context.Context, db DB, aParam int) (int, error)
- func A2In2Out(ctx context.Context, db DB, paramOne, paramTwo int) (int, int, error)
- func AFunc0In(ctx context.Context, db DB) (int, error)
- func AFunc1In(ctx context.Context, db DB, aParam int) (int, error)
- func AFunc2In(ctx context.Context, db DB, paramOne, paramTwo int) (int, error)
- func Errorf(s string, v ...any)
- func Logf(s string, v ...any)
- func SetErrorLogger(logger any)
- func SetLogger(logger any)
- type ABitOfEverything
- type AForeignKey
- type AForeignKeyComposite
- type AIndex
- type AIndexComposite
- type AManualTable
- type APrimary
- type APrimaryComposite
- type APrimaryMulti
- func (apm *APrimaryMulti) Delete(ctx context.Context, db DB) error
- func (apm *APrimaryMulti) Deleted() bool
- func (apm *APrimaryMulti) Exists() bool
- func (apm *APrimaryMulti) Insert(ctx context.Context, db DB) error
- func (apm *APrimaryMulti) Save(ctx context.Context, db DB) error
- func (apm *APrimaryMulti) Update(ctx context.Context, db DB) error
- func (apm *APrimaryMulti) Upsert(ctx context.Context, db DB) error
- type ASequence
- type ASequenceMulti
- func (asm *ASequenceMulti) Delete(ctx context.Context, db DB) error
- func (asm *ASequenceMulti) Deleted() bool
- func (asm *ASequenceMulti) Exists() bool
- func (asm *ASequenceMulti) Insert(ctx context.Context, db DB) error
- func (asm *ASequenceMulti) Save(ctx context.Context, db DB) error
- func (asm *ASequenceMulti) Update(ctx context.Context, db DB) error
- func (asm *ASequenceMulti) Upsert(ctx context.Context, db DB) error
- type AUniqueIndex
- type AUniqueIndexComposite
- type AViewOfEverything
- type AViewOfEverythingSome
- type DB
- type ErrInsertFailed
- type ErrUpdateFailed
- type ErrUpsertFailed
- type Error
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func A1In1Out ¶
A1In1Out calls the stored procedure 'a_bit_of_everything.a_1_in_1_out(int) int' on db.
func A2In2Out ¶
A2In2Out calls the stored procedure 'a_bit_of_everything.a_2_in_2_out(int, int) (int, int)' on db.
func AFunc1In ¶
AFunc1In calls the stored function 'a_bit_of_everything.a_func_1_in(int) int' on db.
func AFunc2In ¶
AFunc2In calls the stored function 'a_bit_of_everything.a_func_2_in(int, int) int' on db.
func SetErrorLogger ¶
func SetErrorLogger(logger any)
SetErrorLogger sets the package error logger. Valid logger types:
io.Writer func(string, ...any) (int, error) // fmt.Printf func(string, ...any) // log.Printf
Types ¶
type ABitOfEverything ¶
type ABitOfEverything struct {
ABigint int64 `json:"a_bigint"` // a_bigint
ABigintNullable sql.NullInt64 `json:"a_bigint_nullable"` // a_bigint_nullable
ABinary []byte `json:"a_binary"` // a_binary
ABinaryNullable []byte `json:"a_binary_nullable"` // a_binary_nullable
ABit bool `json:"a_bit"` // a_bit
ABitNullable sql.NullBool `json:"a_bit_nullable"` // a_bit_nullable
AChar string `json:"a_char"` // a_char
ACharNullable sql.NullString `json:"a_char_nullable"` // a_char_nullable
ADate time.Time `json:"a_date"` // a_date
ADateNullable sql.NullTime `json:"a_date_nullable"` // a_date_nullable
ADatetime time.Time `json:"a_datetime"` // a_datetime
ADatetimeNullable sql.NullTime `json:"a_datetime_nullable"` // a_datetime_nullable
ADatetime2 time.Time `json:"a_datetime2"` // a_datetime2
ADatetime2Nullable sql.NullTime `json:"a_datetime2_nullable"` // a_datetime2_nullable
ADatetimeoffset time.Time `json:"a_datetimeoffset"` // a_datetimeoffset
ADatetimeoffsetNullable sql.NullTime `json:"a_datetimeoffset_nullable"` // a_datetimeoffset_nullable
ADecimal float64 `json:"a_decimal"` // a_decimal
ADecimalNullable sql.NullFloat64 `json:"a_decimal_nullable"` // a_decimal_nullable
AFloat float64 `json:"a_float"` // a_float
AFloatNullable sql.NullFloat64 `json:"a_float_nullable"` // a_float_nullable
AImage []byte `json:"a_image"` // a_image
AImageNullable []byte `json:"a_image_nullable"` // a_image_nullable
AInt int `json:"a_int"` // a_int
AIntNullable sql.NullInt64 `json:"a_int_nullable"` // a_int_nullable
AMoney string `json:"a_money"` // a_money
AMoneyNullable sql.NullString `json:"a_money_nullable"` // a_money_nullable
ANchar string `json:"a_nchar"` // a_nchar
ANcharNullable sql.NullString `json:"a_nchar_nullable"` // a_nchar_nullable
ANtext string `json:"a_ntext"` // a_ntext
ANtextNullable sql.NullString `json:"a_ntext_nullable"` // a_ntext_nullable
ANumeric float64 `json:"a_numeric"` // a_numeric
ANumericNullable sql.NullFloat64 `json:"a_numeric_nullable"` // a_numeric_nullable
ANvarchar string `json:"a_nvarchar"` // a_nvarchar
ANvarcharNullable sql.NullString `json:"a_nvarchar_nullable"` // a_nvarchar_nullable
AReal float32 `json:"a_real"` // a_real
ARealNullable sql.NullFloat64 `json:"a_real_nullable"` // a_real_nullable
ASmalldatetime time.Time `json:"a_smalldatetime"` // a_smalldatetime
ASmalldatetimeNullable sql.NullTime `json:"a_smalldatetime_nullable"` // a_smalldatetime_nullable
ASmallint int16 `json:"a_smallint"` // a_smallint
ASmallintNullable sql.NullInt64 `json:"a_smallint_nullable"` // a_smallint_nullable
ASmallmoney string `json:"a_smallmoney"` // a_smallmoney
ASmallmoneyNullable sql.NullString `json:"a_smallmoney_nullable"` // a_smallmoney_nullable
AText string `json:"a_text"` // a_text
ATextNullable sql.NullString `json:"a_text_nullable"` // a_text_nullable
ATime time.Time `json:"a_time"` // a_time
ATimeNullable sql.NullTime `json:"a_time_nullable"` // a_time_nullable
ATinyint bool `json:"a_tinyint"` // a_tinyint
ATinyintNullable sql.NullBool `json:"a_tinyint_nullable"` // a_tinyint_nullable
AVarbinary []byte `json:"a_varbinary"` // a_varbinary
AVarbinaryNullable []byte `json:"a_varbinary_nullable"` // a_varbinary_nullable
AVarchar string `json:"a_varchar"` // a_varchar
AVarcharNullable sql.NullString `json:"a_varchar_nullable"` // a_varchar_nullable
AXML []byte `json:"a_xml"` // a_xml
AXMLNullable []byte `json:"a_xml_nullable"` // a_xml_nullable
}
ABitOfEverything represents a row from 'a_bit_of_everything.a_bit_of_everything'.
type AForeignKey ¶
AForeignKey represents a row from 'a_bit_of_everything.a_foreign_key'.
func (*AForeignKey) APrimary ¶
APrimary returns the APrimary associated with the AForeignKey's (AKey).
Generated from foreign key 'a_key_fkey'.
type AForeignKeyComposite ¶
type AForeignKeyComposite struct {
AKey1 sql.NullInt64 `json:"a_key1"` // a_key1
AKey2 sql.NullInt64 `json:"a_key2"` // a_key2
}
AForeignKeyComposite represents a row from 'a_bit_of_everything.a_foreign_key_composite'.
func (*AForeignKeyComposite) APrimaryComposite ¶
func (afkc *AForeignKeyComposite) APrimaryComposite(ctx context.Context, db DB) (*APrimaryComposite, error)
APrimaryComposite returns the APrimaryComposite associated with the AForeignKeyComposite's (AKey1, AKey2).
Generated from foreign key 'a_foreign_key_composite_fkey'.
type AIndexComposite ¶
type AIndexComposite struct {
AKey1 sql.NullInt64 `json:"a_key1"` // a_key1
AKey2 sql.NullInt64 `json:"a_key2"` // a_key2
}
AIndexComposite represents a row from 'a_bit_of_everything.a_index_composite'.
func AIndexCompositeByAKey1AKey2 ¶
func AIndexCompositeByAKey1AKey2(ctx context.Context, db DB, aKey1, aKey2 sql.NullInt64) ([]*AIndexComposite, error)
AIndexCompositeByAKey1AKey2 retrieves a row from 'a_bit_of_everything.a_index_composite' as a AIndexComposite.
Generated from index 'a_index_composite_idx'.
type AManualTable ¶
type AManualTable struct {
AText sql.NullString `json:"a_text"` // a_text
}
AManualTable represents a row from 'a_bit_of_everything.a_manual_table'.
type APrimary ¶
type APrimary struct {
AKey int `json:"a_key"` // a_key
// contains filtered or unexported fields
}
APrimary represents a row from 'a_bit_of_everything.a_primary'.
func APrimaryByAKey ¶
APrimaryByAKey retrieves a row from 'a_bit_of_everything.a_primary' as a APrimary.
Generated from index 'a_primary_pkey'.
func (*APrimary) Deleted ¶
Deleted returns true when the APrimary has been marked for deletion from the database.
type APrimaryComposite ¶
type APrimaryComposite struct {
AKey1 int `json:"a_key1"` // a_key1
AKey2 int `json:"a_key2"` // a_key2
// contains filtered or unexported fields
}
APrimaryComposite represents a row from 'a_bit_of_everything.a_primary_composite'.
func APrimaryCompositeByAKey1AKey2 ¶
func APrimaryCompositeByAKey1AKey2(ctx context.Context, db DB, aKey1, aKey2 int) (*APrimaryComposite, error)
APrimaryCompositeByAKey1AKey2 retrieves a row from 'a_bit_of_everything.a_primary_composite' as a APrimaryComposite.
Generated from index 'a_primary_composite_pkey'.
func (*APrimaryComposite) Delete ¶
func (apc *APrimaryComposite) Delete(ctx context.Context, db DB) error
Delete deletes the APrimaryComposite from the database.
func (*APrimaryComposite) Deleted ¶
func (apc *APrimaryComposite) Deleted() bool
Deleted returns true when the APrimaryComposite has been marked for deletion from the database.
func (*APrimaryComposite) Exists ¶
func (apc *APrimaryComposite) Exists() bool
Exists returns true when the APrimaryComposite exists in the database.
func (*APrimaryComposite) Insert ¶
func (apc *APrimaryComposite) Insert(ctx context.Context, db DB) error
Insert inserts the APrimaryComposite to the database.
type APrimaryMulti ¶
type APrimaryMulti struct {
AKey int `json:"a_key"` // a_key
AText sql.NullString `json:"a_text"` // a_text
// contains filtered or unexported fields
}
APrimaryMulti represents a row from 'a_bit_of_everything.a_primary_multi'.
func APrimaryMultiByAKey ¶
APrimaryMultiByAKey retrieves a row from 'a_bit_of_everything.a_primary_multi' as a APrimaryMulti.
Generated from index 'a_primary_multi_pkey'.
func (*APrimaryMulti) Delete ¶
func (apm *APrimaryMulti) Delete(ctx context.Context, db DB) error
Delete deletes the APrimaryMulti from the database.
func (*APrimaryMulti) Deleted ¶
func (apm *APrimaryMulti) Deleted() bool
Deleted returns true when the APrimaryMulti has been marked for deletion from the database.
func (*APrimaryMulti) Exists ¶
func (apm *APrimaryMulti) Exists() bool
Exists returns true when the APrimaryMulti exists in the database.
func (*APrimaryMulti) Insert ¶
func (apm *APrimaryMulti) Insert(ctx context.Context, db DB) error
Insert inserts the APrimaryMulti to the database.
func (*APrimaryMulti) Save ¶
func (apm *APrimaryMulti) Save(ctx context.Context, db DB) error
Save saves the APrimaryMulti to the database.
func (*APrimaryMulti) Update ¶
func (apm *APrimaryMulti) Update(ctx context.Context, db DB) error
Update updates a APrimaryMulti in the database.
func (*APrimaryMulti) Upsert ¶
func (apm *APrimaryMulti) Upsert(ctx context.Context, db DB) error
Upsert performs an upsert for APrimaryMulti.
type ASequence ¶
type ASequence struct {
ASeq int `json:"a_seq"` // a_seq
// contains filtered or unexported fields
}
ASequence represents a row from 'a_bit_of_everything.a_sequence'.
func ASequenceByASeq ¶
ASequenceByASeq retrieves a row from 'a_bit_of_everything.a_sequence' as a ASequence.
Generated from index 'a_sequence_pkey'.
func (*ASequence) Deleted ¶
Deleted returns true when the ASequence has been marked for deletion from the database.
type ASequenceMulti ¶
type ASequenceMulti struct {
ASeq int `json:"a_seq"` // a_seq
AText sql.NullString `json:"a_text"` // a_text
// contains filtered or unexported fields
}
ASequenceMulti represents a row from 'a_bit_of_everything.a_sequence_multi'.
func ASequenceMultiByASeq ¶
ASequenceMultiByASeq retrieves a row from 'a_bit_of_everything.a_sequence_multi' as a ASequenceMulti.
Generated from index 'a_sequence_multi_pkey'.
func (*ASequenceMulti) Delete ¶
func (asm *ASequenceMulti) Delete(ctx context.Context, db DB) error
Delete deletes the ASequenceMulti from the database.
func (*ASequenceMulti) Deleted ¶
func (asm *ASequenceMulti) Deleted() bool
Deleted returns true when the ASequenceMulti has been marked for deletion from the database.
func (*ASequenceMulti) Exists ¶
func (asm *ASequenceMulti) Exists() bool
Exists returns true when the ASequenceMulti exists in the database.
func (*ASequenceMulti) Insert ¶
func (asm *ASequenceMulti) Insert(ctx context.Context, db DB) error
Insert inserts the ASequenceMulti to the database.
func (*ASequenceMulti) Save ¶
func (asm *ASequenceMulti) Save(ctx context.Context, db DB) error
Save saves the ASequenceMulti to the database.
func (*ASequenceMulti) Update ¶
func (asm *ASequenceMulti) Update(ctx context.Context, db DB) error
Update updates a ASequenceMulti in the database.
func (*ASequenceMulti) Upsert ¶
func (asm *ASequenceMulti) Upsert(ctx context.Context, db DB) error
Upsert performs an upsert for ASequenceMulti.
type AUniqueIndex ¶
AUniqueIndex represents a row from 'a_bit_of_everything.a_unique_index'.
func AUniqueIndexByAKey ¶
AUniqueIndexByAKey retrieves a row from 'a_bit_of_everything.a_unique_index' as a AUniqueIndex.
Generated from index 'a_unique_index_idx'.
type AUniqueIndexComposite ¶
type AUniqueIndexComposite struct {
AKey1 sql.NullInt64 `json:"a_key1"` // a_key1
AKey2 sql.NullInt64 `json:"a_key2"` // a_key2
}
AUniqueIndexComposite represents a row from 'a_bit_of_everything.a_unique_index_composite'.
func AUniqueIndexCompositeByAKey1AKey2 ¶
func AUniqueIndexCompositeByAKey1AKey2(ctx context.Context, db DB, aKey1, aKey2 sql.NullInt64) (*AUniqueIndexComposite, error)
AUniqueIndexCompositeByAKey1AKey2 retrieves a row from 'a_bit_of_everything.a_unique_index_composite' as a AUniqueIndexComposite.
Generated from index 'a_unique_index_composite_idx'.
type AViewOfEverything ¶
type AViewOfEverything struct {
ABigint int64 `json:"a_bigint"` // a_bigint
ABigintNullable sql.NullInt64 `json:"a_bigint_nullable"` // a_bigint_nullable
ABinary []byte `json:"a_binary"` // a_binary
ABinaryNullable []byte `json:"a_binary_nullable"` // a_binary_nullable
ABit bool `json:"a_bit"` // a_bit
ABitNullable sql.NullBool `json:"a_bit_nullable"` // a_bit_nullable
AChar string `json:"a_char"` // a_char
ACharNullable sql.NullString `json:"a_char_nullable"` // a_char_nullable
ADate time.Time `json:"a_date"` // a_date
ADateNullable sql.NullTime `json:"a_date_nullable"` // a_date_nullable
ADatetime time.Time `json:"a_datetime"` // a_datetime
ADatetimeNullable sql.NullTime `json:"a_datetime_nullable"` // a_datetime_nullable
ADatetime2 time.Time `json:"a_datetime2"` // a_datetime2
ADatetime2Nullable sql.NullTime `json:"a_datetime2_nullable"` // a_datetime2_nullable
ADatetimeoffset time.Time `json:"a_datetimeoffset"` // a_datetimeoffset
ADatetimeoffsetNullable sql.NullTime `json:"a_datetimeoffset_nullable"` // a_datetimeoffset_nullable
ADecimal float64 `json:"a_decimal"` // a_decimal
ADecimalNullable sql.NullFloat64 `json:"a_decimal_nullable"` // a_decimal_nullable
AFloat float64 `json:"a_float"` // a_float
AFloatNullable sql.NullFloat64 `json:"a_float_nullable"` // a_float_nullable
AImage []byte `json:"a_image"` // a_image
AImageNullable []byte `json:"a_image_nullable"` // a_image_nullable
AInt int `json:"a_int"` // a_int
AIntNullable sql.NullInt64 `json:"a_int_nullable"` // a_int_nullable
AMoney string `json:"a_money"` // a_money
AMoneyNullable sql.NullString `json:"a_money_nullable"` // a_money_nullable
ANchar string `json:"a_nchar"` // a_nchar
ANcharNullable sql.NullString `json:"a_nchar_nullable"` // a_nchar_nullable
ANtext string `json:"a_ntext"` // a_ntext
ANtextNullable sql.NullString `json:"a_ntext_nullable"` // a_ntext_nullable
ANumeric float64 `json:"a_numeric"` // a_numeric
ANumericNullable sql.NullFloat64 `json:"a_numeric_nullable"` // a_numeric_nullable
ANvarchar string `json:"a_nvarchar"` // a_nvarchar
ANvarcharNullable sql.NullString `json:"a_nvarchar_nullable"` // a_nvarchar_nullable
AReal float32 `json:"a_real"` // a_real
ARealNullable sql.NullFloat64 `json:"a_real_nullable"` // a_real_nullable
ASmalldatetime time.Time `json:"a_smalldatetime"` // a_smalldatetime
ASmalldatetimeNullable sql.NullTime `json:"a_smalldatetime_nullable"` // a_smalldatetime_nullable
ASmallint int16 `json:"a_smallint"` // a_smallint
ASmallintNullable sql.NullInt64 `json:"a_smallint_nullable"` // a_smallint_nullable
ASmallmoney string `json:"a_smallmoney"` // a_smallmoney
ASmallmoneyNullable sql.NullString `json:"a_smallmoney_nullable"` // a_smallmoney_nullable
AText string `json:"a_text"` // a_text
ATextNullable sql.NullString `json:"a_text_nullable"` // a_text_nullable
ATime time.Time `json:"a_time"` // a_time
ATimeNullable sql.NullTime `json:"a_time_nullable"` // a_time_nullable
ATinyint bool `json:"a_tinyint"` // a_tinyint
ATinyintNullable sql.NullBool `json:"a_tinyint_nullable"` // a_tinyint_nullable
AVarbinary []byte `json:"a_varbinary"` // a_varbinary
AVarbinaryNullable []byte `json:"a_varbinary_nullable"` // a_varbinary_nullable
AVarchar string `json:"a_varchar"` // a_varchar
AVarcharNullable sql.NullString `json:"a_varchar_nullable"` // a_varchar_nullable
AXML []byte `json:"a_xml"` // a_xml
AXMLNullable []byte `json:"a_xml_nullable"` // a_xml_nullable
}
-- views CREATE VIEW a_view_of_everything AS SELECT * FROM a_bit_of_everything;
type AViewOfEverythingSome ¶
type AViewOfEverythingSome struct {
ABit bool `json:"a_bit"` // a_bit
AText string `json:"a_text"` // a_text
}
CREATE VIEW a_view_of_everything_some AS SELECT a_bit, a_text FROM a_bit_of_everything;
type DB ¶
type DB interface {
ExecContext(context.Context, string, ...any) (sql.Result, error)
QueryContext(context.Context, string, ...any) (*sql.Rows, error)
QueryRowContext(context.Context, string, ...any) *sql.Row
}
DB is the common interface for database operations that can be used with types from schema 'a_bit_of_everything'.
This works with both database/sql.DB and database/sql.Tx.
type ErrInsertFailed ¶
type ErrInsertFailed struct {
Err error
}
ErrInsertFailed is the insert failed error.
func (*ErrInsertFailed) Error ¶
func (err *ErrInsertFailed) Error() string
Error satisfies the error interface.
func (*ErrInsertFailed) Unwrap ¶
func (err *ErrInsertFailed) Unwrap() error
Unwrap satisfies the unwrap interface.
type ErrUpdateFailed ¶
type ErrUpdateFailed struct {
Err error
}
ErrUpdateFailed is the update failed error.
func (*ErrUpdateFailed) Error ¶
func (err *ErrUpdateFailed) Error() string
Error satisfies the error interface.
func (*ErrUpdateFailed) Unwrap ¶
func (err *ErrUpdateFailed) Unwrap() error
Unwrap satisfies the unwrap interface.
type ErrUpsertFailed ¶
type ErrUpsertFailed struct {
Err error
}
ErrUpsertFailed is the upsert failed error.
func (*ErrUpsertFailed) Error ¶
func (err *ErrUpsertFailed) Error() string
Error satisfies the error interface.
func (*ErrUpsertFailed) Unwrap ¶
func (err *ErrUpsertFailed) Unwrap() error
Unwrap satisfies the unwrap interface.
type Error ¶
type Error string
Error is an error.
const ( // ErrAlreadyExists is the already exists error. ErrAlreadyExists Error = "already exists" // ErrDoesNotExist is the does not exist error. ErrDoesNotExist Error = "does not exist" // ErrMarkedForDeletion is the marked for deletion error. ErrMarkedForDeletion Error = "marked for deletion" )
Error values.
Source Files
¶
- abitofeverything.dbtpl.go
- aforeignkey.dbtpl.go
- aforeignkeycomposite.dbtpl.go
- aindex.dbtpl.go
- aindexcomposite.dbtpl.go
- amanualtable.dbtpl.go
- aprimary.dbtpl.go
- aprimarycomposite.dbtpl.go
- aprimarymulti.dbtpl.go
- asequence.dbtpl.go
- asequencemulti.dbtpl.go
- auniqueindex.dbtpl.go
- auniqueindexcomposite.dbtpl.go
- aviewofeverything.dbtpl.go
- aviewofeverythingsome.dbtpl.go
- dbtpl.dbtpl.go
- sf_afunc0in.dbtpl.go
- sf_afunc1in.dbtpl.go
- sf_afunc2in.dbtpl.go
- sp_a0in0out.dbtpl.go
- sp_a0in1out.dbtpl.go
- sp_a1in0out.dbtpl.go
- sp_a1in1out.dbtpl.go
- sp_a2in2out.dbtpl.go