Appearance
Documentation / @kizami/db / node
node
Interfaces
- ChecksumComparison
- CopyDatabaseOptions
- CreateDatabaseOptions
- MigrateDataOptions
- MigrationReport
- TableChecksum
- TableCopyResult
- TablePlan
Type Aliases
Variables
Functions
- buildTablePlans
- copyDatabase
- createDatabase
- defaultMigrationsFolder
- formatMigrationReport
- migrateDataToPostgres
- migrateDb
References
AcceptedInvitation
Re-exports AcceptedInvitation
acceptInvitation
Re-exports acceptInvitation
AcceptInvitationInput
Re-exports AcceptInvitationInput
alias
Re-exports alias
ALLOWANCE_CLOSING_SNAPSHOT_CATEGORY_PREFIX
Re-exports ALLOWANCE_CLOSING_SNAPSHOT_CATEGORY_PREFIX
AllowanceDefinition
Re-exports AllowanceDefinition
allowanceDefinitions
Re-exports allowanceDefinitions
AllowanceDefinitionVersion
Re-exports AllowanceDefinitionVersion
allowanceDefinitionVersions
Re-exports allowanceDefinitionVersions
ApiKey
Re-exports ApiKey
apiKeys
Re-exports apiKeys
ApiKeySummary
Re-exports ApiKeySummary
appendClosingEvent
Re-exports appendClosingEvent
AppendClosingEventInput
Re-exports AppendClosingEventInput
ApprovalFlowKind
Re-exports ApprovalFlowKind
approvalFlowSettings
Re-exports approvalFlowSettings
ApprovalFlowSettings
Re-exports ApprovalFlowSettings
archiveShiftPattern
Re-exports archiveShiftPattern
AssignedPresetNameRow
Re-exports AssignedPresetNameRow
assignUserWorkPolicy
Re-exports assignUserWorkPolicy
AssignUserWorkPolicyParams
Re-exports AssignUserWorkPolicyParams
AuditLog
Re-exports AuditLog
AuditLogListFilter
Re-exports AuditLogListFilter
auditLogs
Re-exports auditLogs
AuditLogWithActor
Re-exports AuditLogWithActor
authCredentials
Re-exports authCredentials
AutoBreakWaiver
Re-exports AutoBreakWaiver
autoBreakWaivers
Re-exports autoBreakWaivers
AutoBreakWaiverStatus
Re-exports AutoBreakWaiverStatus
CLOSING_SNAPSHOT_CATEGORIES
Re-exports CLOSING_SNAPSHOT_CATEGORIES
ClosingEvent
Re-exports ClosingEvent
ClosingEventKind
Re-exports ClosingEventKind
closingEvents
Re-exports closingEvents
ClosingSnapshot
Re-exports ClosingSnapshot
ClosingSnapshotCategory
Re-exports ClosingSnapshotCategory
ClosingSnapshotGeneration
Re-exports ClosingSnapshotGeneration
closingSnapshots
Re-exports closingSnapshots
ClosingState
Re-exports ClosingState
consumeRecoveryCode
Re-exports consumeRecoveryCode
CorrectionRequest
Re-exports CorrectionRequest
correctionRequests
Re-exports correctionRequests
CorrectionStatus
Re-exports CorrectionStatus
countChildDepartments
Re-exports countChildDepartments
countMembershipsInDepartment
Re-exports countMembershipsInDepartment
countObservabilityGauges
Re-exports countObservabilityGauges
countPresetAssignments
Re-exports countPresetAssignments
countProposedLeaveGrantProposals
Re-exports countProposedLeaveGrantProposals
countUnread
Re-exports countUnread
CountUnreadParams
Re-exports CountUnreadParams
countUnusedRecoveryCodes
Re-exports countUnusedRecoveryCodes
createAllowanceDefinition
Re-exports createAllowanceDefinition
CreateAllowanceDefinitionParams
Re-exports CreateAllowanceDefinitionParams
createAutoBreakWaiver
Re-exports createAutoBreakWaiver
createCorrectionRequest
Re-exports createCorrectionRequest
createD1Database
Re-exports createD1Database
createDepartment
Re-exports createDepartment
CreateDepartmentInput
Re-exports CreateDepartmentInput
createInvitation
Re-exports createInvitation
createInvitationInTx
Re-exports createInvitationInTx
createLeaveRequest
Re-exports createLeaveRequest
createNotificationIfAbsent
Re-exports createNotificationIfAbsent
createPasswordResetToken
Re-exports createPasswordResetToken
createPreset
Re-exports createPreset
CreatePresetInput
Re-exports CreatePresetInput
createUser
Re-exports createUser
D1DatabaseBinding
Re-exports D1DatabaseBinding
Database
Re-exports Database
DatabaseHandle
Re-exports DatabaseHandle
DbClient
Re-exports DbClient
DbDialect
Re-exports DbDialect
deactivateUser
Re-exports deactivateUser
decideAutoBreakWaiver
Re-exports decideAutoBreakWaiver
DecideAutoBreakWaiverParams
Re-exports DecideAutoBreakWaiverParams
DEFAULT_APPROVAL_FLOW_STEPS
Re-exports DEFAULT_APPROVAL_FLOW_STEPS
deleteDepartment
Re-exports deleteDepartment
deleteHelpOverride
Re-exports deleteHelpOverride
deletePreset
Re-exports deletePreset
deletePushSubscription
Re-exports deletePushSubscription
deleteUserTotp
Re-exports deleteUserTotp
Department
Re-exports Department
departments
Re-exports departments
enableUserTotp
Re-exports enableUserTotp
ERASED_USER_NAME
Re-exports ERASED_USER_NAME
EraseUserParams
Re-exports EraseUserParams
eraseUserPersonalData
Re-exports eraseUserPersonalData
EraseUserResult
Re-exports EraseUserResult
findActiveLeaveGrantProposal
Re-exports findActiveLeaveGrantProposal
findApiKeyByHash
Re-exports findApiKeyByHash
findInvitationByTokenHash
Re-exports findInvitationByTokenHash
findNotificationByTypeAndDate
Re-exports findNotificationByTypeAndDate
FindNotificationByTypeAndDateParams
Re-exports FindNotificationByTypeAndDateParams
findPasswordResetTokenByHash
Re-exports findPasswordResetTokenByHash
findValidSlackLinkTokenByHash
Re-exports findValidSlackLinkTokenByHash
getAllowanceDefinitionVersionsTimeline
Re-exports getAllowanceDefinitionVersionsTimeline
GetAllowanceDefinitionVersionsTimelineParams
Re-exports GetAllowanceDefinitionVersionsTimelineParams
getApiKeyById
Re-exports getApiKeyById
getApprovalFlowSettings
Re-exports getApprovalFlowSettings
getAutoBreakWaiverById
Re-exports getAutoBreakWaiverById
getClosingSnapshotHistory
Re-exports getClosingSnapshotHistory
getClosingSnapshots
Re-exports getClosingSnapshots
getClosingSnapshotsForUsers
Re-exports getClosingSnapshotsForUsers
getClosingState
Re-exports getClosingState
getCorrectionRequest
Re-exports getCorrectionRequest
getDepartmentById
Re-exports getDepartmentById
getEffectiveSettingsVersion
Re-exports getEffectiveSettingsVersion
GetEffectiveSettingsVersionParams
Re-exports GetEffectiveSettingsVersionParams
getHelpOverride
Re-exports getHelpOverride
getHelpOverrides
Re-exports getHelpOverrides
getLatestInvitationForUser
Re-exports getLatestInvitationForUser
getLatestMembership
Re-exports getLatestMembership
getLatestPasswordResetTokenForUser
Re-exports getLatestPasswordResetTokenForUser
getLeaveGrantProposal
Re-exports getLeaveGrantProposal
getLeaveRequest
Re-exports getLeaveRequest
getNotificationSettings
Re-exports getNotificationSettings
getOrCreateTenantWorkPolicy
Re-exports getOrCreateTenantWorkPolicy
getOrCreateTenantWorkPolicyByKind
Re-exports getOrCreateTenantWorkPolicyByKind
GetOrCreateTenantWorkPolicyByKindParams
Re-exports GetOrCreateTenantWorkPolicyByKindParams
GetOrCreateTenantWorkPolicyParams
Re-exports GetOrCreateTenantWorkPolicyParams
getOriginalClosingSnapshots
Re-exports getOriginalClosingSnapshots
getOriginalClosingSnapshotsForUsers
Re-exports getOriginalClosingSnapshotsForUsers
getPresetById
Re-exports getPresetById
getPunchEventById
Re-exports getPunchEventById
getSettingsTimeline
Re-exports getSettingsTimeline
GetSettingsTimelineParams
Re-exports GetSettingsTimelineParams
getShiftPatternById
Re-exports getShiftPatternById
getShiftPlanById
Re-exports getShiftPlanById
getSlackUserLinkBySlackUserId
Re-exports getSlackUserLinkBySlackUserId
getSlackUserLinkByUserId
Re-exports getSlackUserLinkByUserId
getTenantById
Re-exports getTenantById
getTenantLeaveSettings
Re-exports getTenantLeaveSettings
getTenantOidcSettings
Re-exports getTenantOidcSettings
getTenantSlackSettings
Re-exports getTenantSlackSettings
getTenantSlackSettingsByTeamId
Re-exports getTenantSlackSettingsByTeamId
getTenantWorkPolicy
Re-exports getTenantWorkPolicy
getUserById
Re-exports getUserById
getUserNotificationSettings
Re-exports getUserNotificationSettings
getUserTotp
Re-exports getUserTotp
getValidPunchEvent
Re-exports getValidPunchEvent
GetValidPunchEventParams
Re-exports GetValidPunchEventParams
getValidShiftDayForDate
Re-exports getValidShiftDayForDate
HelpOverride
Re-exports HelpOverride
helpOverrides
Re-exports helpOverrides
insertAllowanceDefinitionVersion
Re-exports insertAllowanceDefinitionVersion
InsertAllowanceDefinitionVersionParams
Re-exports InsertAllowanceDefinitionVersionParams
insertApiKey
Re-exports insertApiKey
insertAuditLog
Re-exports insertAuditLog
insertLeaveGrant
Re-exports insertLeaveGrant
insertLeaveGrantProposal
Re-exports insertLeaveGrantProposal
insertPunchEvent
Re-exports insertPunchEvent
insertShiftPattern
Re-exports insertShiftPattern
InsertShiftPatternParams
Re-exports InsertShiftPatternParams
insertShiftPlan
Re-exports insertShiftPlan
InsertShiftPlanParams
Re-exports InsertShiftPlanParams
insertSlackLinkToken
Re-exports insertSlackLinkToken
InsertSlackLinkTokenInput
Re-exports InsertSlackLinkTokenInput
insertTenantSettingVersion
Re-exports insertTenantSettingVersion
InsertTenantSettingVersionParams
Re-exports InsertTenantSettingVersionParams
insertWorkPolicyVersion
Re-exports insertWorkPolicyVersion
InsertWorkPolicyVersionParams
Re-exports InsertWorkPolicyVersionParams
Invitation
Re-exports Invitation
invitations
Re-exports invitations
isUniqueConstraintError
Re-exports isUniqueConstraintError
LeaveGrant
Re-exports LeaveGrant
LeaveGrantProposal
Re-exports LeaveGrantProposal
leaveGrantProposals
Re-exports leaveGrantProposals
LeaveGrantProposalStatus
Re-exports LeaveGrantProposalStatus
leaveGrants
Re-exports leaveGrants
LeaveRequest
Re-exports LeaveRequest
leaveRequests
Re-exports leaveRequests
LeaveRequestStatus
Re-exports LeaveRequestStatus
linkSlackUser
Re-exports linkSlackUser
LinkSlackUserInput
Re-exports LinkSlackUserInput
listActiveLeaveRequestsForDate
Re-exports listActiveLeaveRequestsForDate
listActivePushSubscriptions
Re-exports listActivePushSubscriptions
listAllApprovedLeaveRequests
Re-exports listAllApprovedLeaveRequests
listAllowanceDefinitions
Re-exports listAllowanceDefinitions
listAllowanceDefinitionVersions
Re-exports listAllowanceDefinitionVersions
listApiKeys
Re-exports listApiKeys
ListApiKeysParams
Re-exports ListApiKeysParams
listApprovedLeaveRequestsInRange
Re-exports listApprovedLeaveRequestsInRange
listApprovedWaiverDatesInRange
Re-exports listApprovedWaiverDatesInRange
listAssignedPresetGrants
Re-exports listAssignedPresetGrants
ListAssignedPresetGrantsParams
Re-exports ListAssignedPresetGrantsParams
listAuditLogs
Re-exports listAuditLogs
listAutoBreakWaivers
Re-exports listAutoBreakWaivers
ListAutoBreakWaiversParams
Re-exports ListAutoBreakWaiversParams
listClosingStates
Re-exports listClosingStates
listConvertedFromGrantIds
Re-exports listConvertedFromGrantIds
listCorrectionRequests
Re-exports listCorrectionRequests
ListCorrectionRequestsParams
Re-exports ListCorrectionRequestsParams
listCurrentWorkPolicyKindsForTenant
Re-exports listCurrentWorkPolicyKindsForTenant
listDepartments
Re-exports listDepartments
listGrantedOnDates
Re-exports listGrantedOnDates
listInvitationsForTenant
Re-exports listInvitationsForTenant
listLeaveGrantProposals
Re-exports listLeaveGrantProposals
ListLeaveGrantProposalsParams
Re-exports ListLeaveGrantProposalsParams
listLeaveGrants
Re-exports listLeaveGrants
listLeaveRequests
Re-exports listLeaveRequests
ListLeaveRequestsParams
Re-exports ListLeaveRequestsParams
listNotifications
Re-exports listNotifications
ListNotificationsParams
Re-exports ListNotificationsParams
listPasswordResetTokensForTenant
Re-exports listPasswordResetTokensForTenant
listPresets
Re-exports listPresets
listShiftDayHistoryForPlan
Re-exports listShiftDayHistoryForPlan
listShiftPatterns
Re-exports listShiftPatterns
listShiftPlans
Re-exports listShiftPlans
listTenantAssignedPresetNames
Re-exports listTenantAssignedPresetNames
listTenantMembershipsWithDepartment
Re-exports listTenantMembershipsWithDepartment
listTenantPresetAssignmentRows
Re-exports listTenantPresetAssignmentRows
listTenantPresetGrantsByUser
Re-exports listTenantPresetGrantsByUser
listTenantSettingVersions
Re-exports listTenantSettingVersions
listTenantTotpEnabledUserIds
Re-exports listTenantTotpEnabledUserIds
listTenantUserIdsWithCredentials
Re-exports listTenantUserIdsWithCredentials
listTenantUsers
Re-exports listTenantUsers
listUserPolicyAssignments
Re-exports listUserPolicyAssignments
listValidPunches
Re-exports listValidPunches
ListValidPunchesParams
Re-exports ListValidPunchesParams
listValidShiftDaysForPlan
Re-exports listValidShiftDaysForPlan
listValidShiftDaysInRange
Re-exports listValidShiftDaysInRange
listWorkerHeartbeats
Re-exports listWorkerHeartbeats
listWorkPolicyVersions
Re-exports listWorkPolicyVersions
markNotificationRead
Re-exports markNotificationRead
MarkNotificationReadParams
Re-exports MarkNotificationReadParams
markPushSubscriptionFailed
Re-exports markPushSubscriptionFailed
markSlackLinkTokenUsed
Re-exports markSlackLinkTokenUsed
Membership
Re-exports Membership
MembershipDepartmentRow
Re-exports MembershipDepartmentRow
memberships
Re-exports memberships
MemberUser
Re-exports MemberUser
NewApiKeyInput
Re-exports NewApiKeyInput
NewAuditLogInput
Re-exports NewAuditLogInput
NewAutoBreakWaiverInput
Re-exports NewAutoBreakWaiverInput
NewClosingSnapshotInput
Re-exports NewClosingSnapshotInput
NewCorrectionRequestInput
Re-exports NewCorrectionRequestInput
NewInvitationInput
Re-exports NewInvitationInput
NewLeaveGrantInput
Re-exports NewLeaveGrantInput
NewLeaveGrantProposalInput
Re-exports NewLeaveGrantProposalInput
NewLeaveRequestInput
Re-exports NewLeaveRequestInput
NewNotificationInput
Re-exports NewNotificationInput
NewPasswordResetTokenInput
Re-exports NewPasswordResetTokenInput
NewPunchEvent
Re-exports NewPunchEvent
NewUserInput
Re-exports NewUserInput
Notification
Re-exports Notification
notifications
Re-exports notifications
ObservabilityCounts
Re-exports ObservabilityCounts
PasswordResetToken
Re-exports PasswordResetToken
passwordResetTokens
Re-exports passwordResetTokens
PermissionPreset
Re-exports PermissionPreset
permissionPresets
Re-exports permissionPresets
presetAssignments
Re-exports presetAssignments
publishShiftPlan
Re-exports publishShiftPlan
PunchEvent
Re-exports PunchEvent
punchEvents
Re-exports punchEvents
PushSubscription
Re-exports PushSubscription
pushSubscriptions
Re-exports pushSubscriptions
RawPermissionGrant
Re-exports RawPermissionGrant
RawPresetPermissions
Re-exports RawPresetPermissions
reactivateUser
Re-exports reactivateUser
recordWorkerHeartbeat
Re-exports recordWorkerHeartbeat
RecordWorkerHeartbeatParams
Re-exports RecordWorkerHeartbeatParams
replacePresetAssignmentsForUser
Re-exports replacePresetAssignmentsForUser
ReplacePresetAssignmentsInput
Re-exports ReplacePresetAssignmentsInput
replaceRecoveryCodes
Re-exports replaceRecoveryCodes
resolveDialect
Re-exports resolveDialect
revokeAllPasswordResetTokensForUser
Re-exports revokeAllPasswordResetTokensForUser
revokeAllSessionsForUser
Re-exports revokeAllSessionsForUser
revokeApiKey
Re-exports revokeApiKey
RevokeApiKeyParams
Re-exports RevokeApiKeyParams
revokeInvitation
Re-exports revokeInvitation
RevokeInvitationParams
Re-exports RevokeInvitationParams
revokePasswordResetToken
Re-exports revokePasswordResetToken
RevokePasswordResetTokenParams
Re-exports RevokePasswordResetTokenParams
revokePendingInvitationForUser
Re-exports revokePendingInvitationForUser
saveClosingSnapshots
Re-exports saveClosingSnapshots
schema
Re-exports schema
sessions
Re-exports sessions
ShiftDayFields
Re-exports ShiftDayFields
ShiftDayRow
Re-exports ShiftDayRow
shiftDays
Re-exports shiftDays
ShiftPattern
Re-exports ShiftPattern
shiftPatterns
Re-exports shiftPatterns
ShiftPlan
Re-exports ShiftPlan
shiftPlans
Re-exports shiftPlans
SlackLinkToken
Re-exports SlackLinkToken
slackLinkTokens
Re-exports slackLinkTokens
SlackUserLink
Re-exports SlackUserLink
slackUserLinks
Re-exports slackUserLinks
supersedeProposedLeaveGrantProposals
Re-exports supersedeProposedLeaveGrantProposals
Tenant
Re-exports Tenant
tenantLeaveSettings
Re-exports tenantLeaveSettings
TenantLeaveSettings
Re-exports TenantLeaveSettings
tenantNotificationSettings
Re-exports tenantNotificationSettings
TenantNotificationSettings
Re-exports TenantNotificationSettings
tenantOidcSettings
Re-exports tenantOidcSettings
TenantOidcSettings
Re-exports TenantOidcSettings
TenantPresetAssignmentRow
Re-exports TenantPresetAssignmentRow
tenants
Re-exports tenants
TenantSettingVersion
Re-exports TenantSettingVersion
tenantSettingVersions
Re-exports tenantSettingVersions
tenantSlackSettings
Re-exports tenantSlackSettings
TenantSlackSettings
Re-exports TenantSlackSettings
tombstoneEmail
Re-exports tombstoneEmail
touchApiKeyLastUsed
Re-exports touchApiKeyLastUsed
TouchApiKeyLastUsedParams
Re-exports TouchApiKeyLastUsedParams
touchPushSubscription
Re-exports touchPushSubscription
Transaction
Re-exports Transaction
updateCorrectionStatus
Re-exports updateCorrectionStatus
UpdateCorrectionStatusParams
Re-exports UpdateCorrectionStatusParams
updateDepartment
Re-exports updateDepartment
UpdateDepartmentInput
Re-exports UpdateDepartmentInput
updateLeaveGrantProposalStatus
Re-exports updateLeaveGrantProposalStatus
UpdateLeaveGrantProposalStatusParams
Re-exports UpdateLeaveGrantProposalStatusParams
updateLeaveRequestStatus
Re-exports updateLeaveRequestStatus
UpdateLeaveRequestStatusParams
Re-exports UpdateLeaveRequestStatusParams
updatePreset
Re-exports updatePreset
UpdatePresetInput
Re-exports UpdatePresetInput
updateTenantLawProfile
Re-exports updateTenantLawProfile
UpdateTenantLawProfileParams
Re-exports UpdateTenantLawProfileParams
updateTenantPersonalDataRetentionYears
Re-exports updateTenantPersonalDataRetentionYears
updateTenantPrivacyContact
Re-exports updateTenantPrivacyContact
UpdateTenantPrivacyContactParams
Re-exports UpdateTenantPrivacyContactParams
updateTenantWorkRulesUrl
Re-exports updateTenantWorkRulesUrl
updateUserHireDate
Re-exports updateUserHireDate
updateUserLeaveGrantClass
Re-exports updateUserLeaveGrantClass
updateUserTotpLastUsedCounter
Re-exports updateUserTotpLastUsedCounter
upsertApprovalFlowSettings
Re-exports upsertApprovalFlowSettings
UpsertApprovalFlowSettingsInput
Re-exports UpsertApprovalFlowSettingsInput
upsertHelpOverride
Re-exports upsertHelpOverride
UpsertHelpOverrideInput
Re-exports UpsertHelpOverrideInput
upsertMembership
Re-exports upsertMembership
UpsertMembershipInput
Re-exports UpsertMembershipInput
upsertNotificationSettings
Re-exports upsertNotificationSettings
UpsertNotificationSettingsInput
Re-exports UpsertNotificationSettingsInput
upsertPendingUserTotp
Re-exports upsertPendingUserTotp
upsertPushSubscription
Re-exports upsertPushSubscription
UpsertPushSubscriptionInput
Re-exports UpsertPushSubscriptionInput
upsertShiftDaysForPlan
Re-exports upsertShiftDaysForPlan
upsertTenantLeaveSettings
Re-exports upsertTenantLeaveSettings
UpsertTenantLeaveSettingsInput
Re-exports UpsertTenantLeaveSettingsInput
upsertTenantOidcSettings
Re-exports upsertTenantOidcSettings
UpsertTenantOidcSettingsInput
Re-exports UpsertTenantOidcSettingsInput
upsertTenantSlackSettings
Re-exports upsertTenantSlackSettings
UpsertTenantSlackSettingsInput
Re-exports UpsertTenantSlackSettingsInput
upsertUserNotificationSettings
Re-exports upsertUserNotificationSettings
UpsertUserNotificationSettingsInput
Re-exports UpsertUserNotificationSettingsInput
UsedPasswordResetToken
Re-exports UsedPasswordResetToken
usePasswordResetToken
Re-exports usePasswordResetToken
UsePasswordResetTokenInput
Re-exports UsePasswordResetTokenInput
userHasCredential
Re-exports userHasCredential
userNotificationSettings
Re-exports userNotificationSettings
UserNotificationSettings
Re-exports UserNotificationSettings
UserPolicyAssignmentHistoryRow
Re-exports UserPolicyAssignmentHistoryRow
userPolicyAssignments
Re-exports userPolicyAssignments
users
Re-exports users
userTotp
Re-exports userTotp
UserTotp
Re-exports UserTotp
UserTotpRecoveryCode
Re-exports UserTotpRecoveryCode
userTotpRecoveryCodes
Re-exports userTotpRecoveryCodes
uuidv7
Re-exports uuidv7
withdrawAutoBreakWaiver
Re-exports withdrawAutoBreakWaiver
WithdrawAutoBreakWaiverParams
Re-exports WithdrawAutoBreakWaiverParams
WorkerHeartbeat
Re-exports WorkerHeartbeat
workerHeartbeats
Re-exports workerHeartbeats
workPolicies
Re-exports workPolicies
WorkPolicy
Re-exports WorkPolicy
WorkPolicyVersion
Re-exports WorkPolicyVersion
workPolicyVersions
Re-exports workPolicyVersions