# genesis
[](https://github.com/permesi/genesis/actions/workflows/deploy.yml)
[](https://github.com/permesi/genesis/actions/workflows/build.yml)
[](https://codecov.io/gh/permesi/genesis)
Token Zero generator
## Why Ulid?
Helps find(group) tokens for the same period of time but still unique.
```sql
> select id, id::timestamp from tokens;
+----------------------------+-------------------------+
| id | id |
|----------------------------+-------------------------|
| 01HQAS6A6SGD3Z1V7VF86Q0B6P | 2024-02-23 10:46:47.769 |
| 01HQAS6A6SV2A93NMKH0S03CD1 | 2024-02-23 10:46:47.769 |
| 01HQAS6A6S8ZRMC0RZP8DEQ1Q5 | 2024-02-23 10:46:47.769 |
| 01HQAS6A6S1Q8TT1E8XE1J7JS8 | 2024-02-23 10:46:47.769 |
+----------------------------+-------------------------+
```
Expire tokens by time using `pg_cron`
```sql
SELECT cron.schedule('*/30 * * * *', $$DELETE
FROM tokens
WHERE id::timestamp < NOW() - INTERVAL '120 seconds'$$);
```
Update the database of the cron job with the following SQL command:
```sql
UPDATE cron.job SET database='genesis' WHERE jobid=5;
```
Check the cron.job table with the following SQL command:
```sql
SELECT * FROM cron.job;
+-------+--------------+------------------------------------------------------+-----------+----------+----------+----------+--------+---------+
| jobid | schedule | command | nodename | nodeport | database | username | active | jobname |
|-------+--------------+------------------------------------------------------+-----------+----------+----------+----------+--------+---------|
| 2 | 0 0 * * * | DELETE | localhost | 5432 | postgres | postgres | True | |
| | | FROM cron.job_run_details | | | | | | |
| | | WHERE end_time < now() - interval '7 days' | | | | | | |
| 5 | */30 * * * * | DELETE | localhost | 5432 | genesis | postgres | True | |
| | | FROM tokens | | | | | | |
| | | WHERE id::timestamp < NOW() - INTERVAL '120 seconds' | | | | | | |
+-------+--------------+------------------------------------------------------+-----------+----------+----------+----------+--------+---------+
```
Check the status of the cron job with the following SQL command:
```sql
SELECT * FROM cron.job_run_details order by start_time DESC limit 5;
```