TestClocks

Represents test clocks used to simulate the passage of time in test mode, including the frozen time and current status details.

Table-Specific Information

SELECT

The driver uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the driver.


Column	Supported Operators
Id	=
AccountId	=

You can select from the TestClocks table with the following queries:

SELECT * FROM TestClocks WHERE Id = 'clock_1PYNnU2eZvKYlo2CNSmVfWJP'
SELECT * FROM TestClocks WHERE AccountId = 'acct_1TjaVhHcQfMnD4eS'

INSERT

To create a new test clock, the FrozenTime column is required:

INSERT INTO TestClocks (FrozenTime, Name) VALUES ('2024-07-03', 'TestName')

DELETE

To delete a test clock, specify the Id:

DELETE FROM TestClocks WHERE Id = 'clock_1PYNnU2eZvKYlo2CNSmVfWJP'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the test clock.
Name	String	False		The custom name supplied at creation.
Status	String	True		The status of the test clock.
Created	Datetime	True		The time at which the test clock was created, measured in seconds since the Unix epoch.
DeletesAfter	Datetime	True		The time at which this clock is scheduled to be automatically deleted, measured in seconds since the Unix epoch.
FrozenTime	Datetime	False		The initial frozen time for this test clock.
Livemode	Boolean	True		Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists in test mode.
StatusDetailsAdvancingTargetFrozenTime	Datetime	True		The frozen time that the test clock is advancing toward.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
AccountId	String	The Id of the connected account to get test clocks for.