11 releases
0.1.10 | Sep 3, 2024 |
---|---|
0.1.9 | Aug 27, 2024 |
0.1.8 | Mar 18, 2024 |
0.1.7 | Feb 21, 2024 |
0.1.3 | Jan 31, 2024 |
#312 in HTTP server
24 downloads per month
59KB
1K
SLoC
genesis
Token Zero generator
Why Ulid?
Helps find(group) tokens for the same period of time but still unique.
> 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
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:
UPDATE cron.job SET database='genesis' WHERE jobid=5;
Check the cron.job table with the following SQL command:
SELECT * FROM cron.job;
+-------+--------------+------------------------------------------------------+-----------+----------+----------+----------+--------+---------+
| jobid | schedule | command | nodename | nodeport | database | username | active | jobname |
|-------+--------------+------------------------------------------------------+-----------+----------+----------+----------+--------+---------|
| 2 | 0 0 * * * | DELETE | localhost | 5432 | postgres | postgres | True | <null> |
| | | FROM cron.job_run_details | | | | | | |
| | | WHERE end_time < now() - interval '7 days' | | | | | | |
| 5 | */30 * * * * | DELETE | localhost | 5432 | genesis | postgres | True | <null> |
| | | FROM tokens | | | | | | |
| | | WHERE id::timestamp < NOW() - INTERVAL '120 seconds' | | | | | | |
+-------+--------------+------------------------------------------------------+-----------+----------+----------+----------+--------+---------+
Check the status of the cron job with the following SQL command:
SELECT * FROM cron.job_run_details order by start_time DESC limit 5;
Dependencies
~73MB
~1.5M SLoC