Versions in this module Expand all Collapse all v0 v0.4.7 Aug 25, 2026 v0.4.6 Aug 18, 2026 v0.4.5 Aug 17, 2026 v0.4.4 Aug 17, 2026 v0.4.3 Aug 17, 2026 v0.4.2 Aug 17, 2026 v0.4.1 Aug 16, 2026 v0.4.0 Aug 15, 2026 v0.3.0 Aug 13, 2026 v0.2.0 Aug 9, 2026 Changes in this version + type AuditLog struct + Action string + ActorUserID pgtype.UUID + ActorUsername string + CreatedAt pgtype.Timestamptz + ID pgtype.UUID + Metadata []byte + ResourceID string + ResourceType string + type AuthDeviceAuthorization struct + ApprovedAt pgtype.Timestamptz + ApprovedByUserID pgtype.UUID + ClientName string + CreatedAt pgtype.Timestamptz + DeviceCode string + ExpiresAt pgtype.Timestamptz + ID pgtype.UUID + LastPolledAt pgtype.Timestamptz + RequestedScopes []string + Status string + UpdatedAt pgtype.Timestamptz + UserCode string + type AuthSession struct + ClientName string + CreatedAt pgtype.Timestamptz + ExpiresAt pgtype.Timestamptz + ID pgtype.UUID + IdleExpiresAt pgtype.Timestamptz + LastUsedAt pgtype.Timestamptz + RefreshTokenFamilyID pgtype.UUID + RefreshTokenHash string + RevokeReason string + RevokedAt pgtype.Timestamptz + UpdatedAt pgtype.Timestamptz + UserAgent string + UserID pgtype.UUID + type CountActiveAuthSessionsByUserIDParams struct + UserID pgtype.UUID + type CountAuditLogsParams struct + Action interface{} + ActorUsername interface{} + ResourceID interface{} + ResourceType interface{} + type CreateAuditLogParams struct + Action string + ActorUserID pgtype.UUID + ActorUsername string + Metadata []byte + ResourceID string + ResourceType string + type CreateAuthDeviceAuthorizationParams struct + ClientName string + DeviceCode string + ExpiresAt pgtype.Timestamptz + RequestedScopes []string + Status string + UserCode string + type CreateAuthSessionParams struct + ClientName string + ExpiresAt pgtype.Timestamptz + IdleExpiresAt pgtype.Timestamptz + LastUsedAt pgtype.Timestamptz + RefreshTokenFamilyID pgtype.UUID + RefreshTokenHash string + UserAgent string + UserID pgtype.UUID + type CreateNetworkDeviceParams struct + CreatedByUserID pgtype.UUID + Disabled bool + DisplayName string + MacAddress string + UpdatedByUserID pgtype.UUID + VlanID int32 + type CreateVlanParams struct + Description string + Name string + VlanID int32 + type DBTX interface + Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error) + Query func(context.Context, string, ...interface{}) (pgx.Rows, error) + QueryRow func(context.Context, string, ...interface{}) pgx.Row + type DeleteNetworkDeviceParams struct + ID pgtype.UUID + type DeleteRadcheckCleartextPasswordByUsernameParams struct + Username string + type DeleteRadgrouprepliesByGroupnameParams struct + Groupname string + type DeleteRadusergroupsByUsernameParams struct + Username string + type DeleteVlanParams struct + VlanID int32 + type GetAuthDeviceAuthorizationByDeviceCodeParams struct + DeviceCode string + type GetAuthDeviceAuthorizationByUserCodeParams struct + UserCode string + type GetAuthSessionByIDParams struct + ID pgtype.UUID + type GetAuthSessionByRefreshTokenHashParams struct + RefreshTokenHash string + type GetNetworkDeviceByIDParams struct + ID pgtype.UUID + type GetNetworkDeviceByMACAddressParams struct + MacAddress string + type GetUserByIDParams struct + ID pgtype.UUID + type GetUserByUsernameParams struct + Username string + type GetVlanByNameParams struct + Name string + type GetVlanByVlanIDParams struct + VlanID int32 + type InsertRadgroupreplyParams struct + Attribute string + Groupname string + Op string + Value string + type InsertRadusergroupParams struct + Groupname string + Priority int32 + Username string + type ListActiveAuthSessionsByUserPageParams struct + LimitCount int32 + OffsetCount int32 + UserID pgtype.UUID + type ListActiveAuthSessionsPageParams struct + LimitCount int32 + OffsetCount int32 + type ListAuditLogsParams struct + Action interface{} + ActorUsername interface{} + LimitCount int32 + OffsetCount int32 + ResourceID interface{} + ResourceType interface{} + type ListAuthSessionsByUserIDParams struct + UserID pgtype.UUID + type Nas struct + Community *string + Description *string + ID int64 + LimitProxyState string + Nasname string + Ports *int32 + RequireMa string + Secret string + Server *string + Shortname string + Type string + type Nasreload struct + Nasipaddress netip.Addr + Reloadtime pgtype.Timestamptz + type NetworkDevice struct + CreatedAt pgtype.Timestamptz + CreatedByUserID pgtype.UUID + Disabled bool + DisplayName string + ID pgtype.UUID + MacAddress string + UpdatedAt pgtype.Timestamptz + UpdatedByUserID pgtype.UUID + VlanID int32 + type Querier interface + CountActiveAuthSessions func(ctx context.Context) (int64, error) + CountActiveAuthSessionsByUserID func(ctx context.Context, arg CountActiveAuthSessionsByUserIDParams) (int64, error) + CountAuditLogs func(ctx context.Context, arg CountAuditLogsParams) (int64, error) + CountNetworkDevices func(ctx context.Context) (int64, error) + CountVlans func(ctx context.Context) (int64, error) + CreateAuditLog func(ctx context.Context, arg CreateAuditLogParams) (AuditLog, error) + CreateAuthDeviceAuthorization func(ctx context.Context, arg CreateAuthDeviceAuthorizationParams) (AuthDeviceAuthorization, error) + CreateAuthSession func(ctx context.Context, arg CreateAuthSessionParams) (AuthSession, error) + CreateNetworkDevice func(ctx context.Context, arg CreateNetworkDeviceParams) (NetworkDevice, error) + CreateVlan func(ctx context.Context, arg CreateVlanParams) (Vlan, error) + DeleteNetworkDevice func(ctx context.Context, arg DeleteNetworkDeviceParams) error + DeleteRadcheckCleartextPasswordByUsername func(ctx context.Context, arg DeleteRadcheckCleartextPasswordByUsernameParams) error + DeleteRadgrouprepliesByGroupname func(ctx context.Context, arg DeleteRadgrouprepliesByGroupnameParams) error + DeleteRadusergroupsByUsername func(ctx context.Context, arg DeleteRadusergroupsByUsernameParams) error + DeleteVlan func(ctx context.Context, arg DeleteVlanParams) error + GetAuthDeviceAuthorizationByDeviceCode func(ctx context.Context, arg GetAuthDeviceAuthorizationByDeviceCodeParams) (AuthDeviceAuthorization, error) + GetAuthDeviceAuthorizationByUserCode func(ctx context.Context, arg GetAuthDeviceAuthorizationByUserCodeParams) (AuthDeviceAuthorization, error) + GetAuthSessionByID func(ctx context.Context, arg GetAuthSessionByIDParams) (AuthSession, error) + GetAuthSessionByRefreshTokenHash func(ctx context.Context, arg GetAuthSessionByRefreshTokenHashParams) (AuthSession, error) + GetNetworkDeviceByID func(ctx context.Context, arg GetNetworkDeviceByIDParams) (NetworkDevice, error) + GetNetworkDeviceByMACAddress func(ctx context.Context, arg GetNetworkDeviceByMACAddressParams) (NetworkDevice, error) + GetUserByID func(ctx context.Context, arg GetUserByIDParams) (User, error) + GetUserByUsername func(ctx context.Context, arg GetUserByUsernameParams) (User, error) + GetVlanByName func(ctx context.Context, arg GetVlanByNameParams) (Vlan, error) + GetVlanByVlanID func(ctx context.Context, arg GetVlanByVlanIDParams) (Vlan, error) + InsertRadgroupreply func(ctx context.Context, arg InsertRadgroupreplyParams) error + InsertRadusergroup func(ctx context.Context, arg InsertRadusergroupParams) error + ListActiveAuthSessionsByUserPage func(ctx context.Context, arg ListActiveAuthSessionsByUserPageParams) ([]AuthSession, error) + ListActiveAuthSessionsPage func(ctx context.Context, arg ListActiveAuthSessionsPageParams) ([]AuthSession, error) + ListAuditLogs func(ctx context.Context, arg ListAuditLogsParams) ([]AuditLog, error) + ListAuthSessions func(ctx context.Context) ([]AuthSession, error) + ListAuthSessionsByUserID func(ctx context.Context, arg ListAuthSessionsByUserIDParams) ([]AuthSession, error) + ListNetworkDevices func(ctx context.Context) ([]NetworkDevice, error) + ListVlans func(ctx context.Context) ([]Vlan, error) + RevokeAllActiveAuthSessions func(ctx context.Context, arg RevokeAllActiveAuthSessionsParams) (int64, error) + RevokeAuthSession func(ctx context.Context, arg RevokeAuthSessionParams) (AuthSession, error) + RevokeAuthSessionFamily func(ctx context.Context, arg RevokeAuthSessionFamilyParams) (int64, error) + RevokeOtherAuthSessionsForUser func(ctx context.Context, arg RevokeOtherAuthSessionsForUserParams) (int64, error) + TouchAuthSession func(ctx context.Context, arg TouchAuthSessionParams) (AuthSession, error) + UpdateAuthDeviceAuthorizationStatus func(ctx context.Context, arg UpdateAuthDeviceAuthorizationStatusParams) (AuthDeviceAuthorization, error) + UpdateNetworkDevice func(ctx context.Context, arg UpdateNetworkDeviceParams) (NetworkDevice, error) + UpdateRadusergroupsGroupname func(ctx context.Context, arg UpdateRadusergroupsGroupnameParams) error + UpdateVlan func(ctx context.Context, arg UpdateVlanParams) (Vlan, error) + UpsertRadcheckCleartextPassword func(ctx context.Context, arg UpsertRadcheckCleartextPasswordParams) error + UpsertUserByUsername func(ctx context.Context, arg UpsertUserByUsernameParams) (User, error) + type Queries struct + func New(db DBTX) *Queries + func (q *Queries) CountActiveAuthSessions(ctx context.Context) (int64, error) + func (q *Queries) CountActiveAuthSessionsByUserID(ctx context.Context, arg CountActiveAuthSessionsByUserIDParams) (int64, error) + func (q *Queries) CountAuditLogs(ctx context.Context, arg CountAuditLogsParams) (int64, error) + func (q *Queries) CountNetworkDevices(ctx context.Context) (int64, error) + func (q *Queries) CountVlans(ctx context.Context) (int64, error) + func (q *Queries) CreateAuditLog(ctx context.Context, arg CreateAuditLogParams) (AuditLog, error) + func (q *Queries) CreateAuthDeviceAuthorization(ctx context.Context, arg CreateAuthDeviceAuthorizationParams) (AuthDeviceAuthorization, error) + func (q *Queries) CreateAuthSession(ctx context.Context, arg CreateAuthSessionParams) (AuthSession, error) + func (q *Queries) CreateNetworkDevice(ctx context.Context, arg CreateNetworkDeviceParams) (NetworkDevice, error) + func (q *Queries) CreateVlan(ctx context.Context, arg CreateVlanParams) (Vlan, error) + func (q *Queries) DeleteNetworkDevice(ctx context.Context, arg DeleteNetworkDeviceParams) error + func (q *Queries) DeleteRadcheckCleartextPasswordByUsername(ctx context.Context, arg DeleteRadcheckCleartextPasswordByUsernameParams) error + func (q *Queries) DeleteRadgrouprepliesByGroupname(ctx context.Context, arg DeleteRadgrouprepliesByGroupnameParams) error + func (q *Queries) DeleteRadusergroupsByUsername(ctx context.Context, arg DeleteRadusergroupsByUsernameParams) error + func (q *Queries) DeleteVlan(ctx context.Context, arg DeleteVlanParams) error + func (q *Queries) GetAuthDeviceAuthorizationByDeviceCode(ctx context.Context, arg GetAuthDeviceAuthorizationByDeviceCodeParams) (AuthDeviceAuthorization, error) + func (q *Queries) GetAuthDeviceAuthorizationByUserCode(ctx context.Context, arg GetAuthDeviceAuthorizationByUserCodeParams) (AuthDeviceAuthorization, error) + func (q *Queries) GetAuthSessionByID(ctx context.Context, arg GetAuthSessionByIDParams) (AuthSession, error) + func (q *Queries) GetAuthSessionByRefreshTokenHash(ctx context.Context, arg GetAuthSessionByRefreshTokenHashParams) (AuthSession, error) + func (q *Queries) GetNetworkDeviceByID(ctx context.Context, arg GetNetworkDeviceByIDParams) (NetworkDevice, error) + func (q *Queries) GetNetworkDeviceByMACAddress(ctx context.Context, arg GetNetworkDeviceByMACAddressParams) (NetworkDevice, error) + func (q *Queries) GetUserByID(ctx context.Context, arg GetUserByIDParams) (User, error) + func (q *Queries) GetUserByUsername(ctx context.Context, arg GetUserByUsernameParams) (User, error) + func (q *Queries) GetVlanByName(ctx context.Context, arg GetVlanByNameParams) (Vlan, error) + func (q *Queries) GetVlanByVlanID(ctx context.Context, arg GetVlanByVlanIDParams) (Vlan, error) + func (q *Queries) InsertRadgroupreply(ctx context.Context, arg InsertRadgroupreplyParams) error + func (q *Queries) InsertRadusergroup(ctx context.Context, arg InsertRadusergroupParams) error + func (q *Queries) ListActiveAuthSessionsByUserPage(ctx context.Context, arg ListActiveAuthSessionsByUserPageParams) ([]AuthSession, error) + func (q *Queries) ListActiveAuthSessionsPage(ctx context.Context, arg ListActiveAuthSessionsPageParams) ([]AuthSession, error) + func (q *Queries) ListAuditLogs(ctx context.Context, arg ListAuditLogsParams) ([]AuditLog, error) + func (q *Queries) ListAuthSessions(ctx context.Context) ([]AuthSession, error) + func (q *Queries) ListAuthSessionsByUserID(ctx context.Context, arg ListAuthSessionsByUserIDParams) ([]AuthSession, error) + func (q *Queries) ListNetworkDevices(ctx context.Context) ([]NetworkDevice, error) + func (q *Queries) ListVlans(ctx context.Context) ([]Vlan, error) + func (q *Queries) RevokeAllActiveAuthSessions(ctx context.Context, arg RevokeAllActiveAuthSessionsParams) (int64, error) + func (q *Queries) RevokeAuthSession(ctx context.Context, arg RevokeAuthSessionParams) (AuthSession, error) + func (q *Queries) RevokeAuthSessionFamily(ctx context.Context, arg RevokeAuthSessionFamilyParams) (int64, error) + func (q *Queries) RevokeOtherAuthSessionsForUser(ctx context.Context, arg RevokeOtherAuthSessionsForUserParams) (int64, error) + func (q *Queries) TouchAuthSession(ctx context.Context, arg TouchAuthSessionParams) (AuthSession, error) + func (q *Queries) UpdateAuthDeviceAuthorizationStatus(ctx context.Context, arg UpdateAuthDeviceAuthorizationStatusParams) (AuthDeviceAuthorization, error) + func (q *Queries) UpdateNetworkDevice(ctx context.Context, arg UpdateNetworkDeviceParams) (NetworkDevice, error) + func (q *Queries) UpdateRadusergroupsGroupname(ctx context.Context, arg UpdateRadusergroupsGroupnameParams) error + func (q *Queries) UpdateVlan(ctx context.Context, arg UpdateVlanParams) (Vlan, error) + func (q *Queries) UpsertRadcheckCleartextPassword(ctx context.Context, arg UpsertRadcheckCleartextPasswordParams) error + func (q *Queries) UpsertUserByUsername(ctx context.Context, arg UpsertUserByUsernameParams) (User, error) + func (q *Queries) WithTx(tx pgx.Tx) *Queries + type Radacct struct + Acctauthentic *string + Acctinputoctets *int64 + Acctinterval *int64 + Acctoutputoctets *int64 + Acctsessionid string + Acctsessiontime *int64 + Acctstarttime pgtype.Timestamptz + Acctstoptime pgtype.Timestamptz + Acctterminatecause *string + Acctuniqueid string + Acctupdatetime pgtype.Timestamptz + Calledstationid *string + Callingstationid *string + Class *string + ConnectinfoStart *string + ConnectinfoStop *string + Delegatedipv6prefix *netip.Addr + Framedinterfaceid *string + Framedipaddress *netip.Addr + Framedipv6address *netip.Addr + Framedipv6prefix *netip.Addr + Framedprotocol *string + Groupname *string + Nasipaddress netip.Addr + Nasportid *string + Nasporttype *string + Radacctid int64 + Realm *string + Servicetype *string + Username *string + type Radcheck struct + Attribute string + ID int64 + Op string + Username string + Value string + type Radgroupcheck struct + Attribute string + Groupname string + ID int64 + Op string + Value string + type Radgroupreply struct + Attribute string + Groupname string + ID int64 + Op string + Value string + type Radpostauth struct + Authdate pgtype.Timestamptz + Calledstationid *string + Callingstationid *string + Class *string + ID int64 + Pass *string + Reply *string + Username string + type Radreply struct + Attribute string + ID int64 + Op string + Username string + Value string + type Radusergroup struct + Groupname string + ID int64 + Priority int32 + Username string + type RevokeAllActiveAuthSessionsParams struct + RevokeReason string + type RevokeAuthSessionFamilyParams struct + RefreshTokenFamilyID pgtype.UUID + RevokeReason string + type RevokeAuthSessionParams struct + ID pgtype.UUID + RevokeReason string + type RevokeOtherAuthSessionsForUserParams struct + ID pgtype.UUID + RevokeReason string + UserID pgtype.UUID + type TouchAuthSessionParams struct + ID pgtype.UUID + IdleExpiresAt pgtype.Timestamptz + LastUsedAt pgtype.Timestamptz + type UpdateAuthDeviceAuthorizationStatusParams struct + ApprovedAt pgtype.Timestamptz + ApprovedByUserID pgtype.UUID + ID pgtype.UUID + LastPolledAt pgtype.Timestamptz + Status string + type UpdateNetworkDeviceParams struct + Disabled bool + DisplayName string + ID pgtype.UUID + MacAddress string + UpdatedByUserID pgtype.UUID + VlanID int32 + type UpdateRadusergroupsGroupnameParams struct + NewGroupname string + OldGroupname string + type UpdateVlanParams struct + CurrentVlanID int32 + Description string + Name string + VlanID int32 + type UpsertRadcheckCleartextPasswordParams struct + Username string + Value string + type UpsertUserByUsernameParams struct + Email string + Groups []string + Name string + Username string + type User struct + CreatedAt pgtype.Timestamptz + Email string + Groups []string + ID pgtype.UUID + Name string + UpdatedAt pgtype.Timestamptz + Username string + type Vlan struct + CreatedAt pgtype.Timestamptz + Description string + Name string + UpdatedAt pgtype.Timestamptz + VlanID int32