docs.rs failed to build permesi-genesis-0.1.14
Please check the build logs for more information.
See Builds for ideas on how to fix a failed build, or Metadata for how to configure docs.rs builds.
If you believe this is docs.rs' fault, open an issue.
Please check the build logs for more information.
See Builds for ideas on how to fix a failed build, or Metadata for how to configure docs.rs builds.
If you believe this is docs.rs' fault, open an issue.
Visit the last successful build:
permesi-genesis-0.1.8
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;