Anthrove/otter-space-sdk
5
0
Fork 0
Code Issues Pull Requests Actions Projects Releases 9 Activity

FEATURE Scrape History #13

New Issue
Closed
opened 2024-10-14 19:53:13 +00:00 by Alphyron · 1 comment
Alphyron commented 2024-10-14 19:53:13 +00:00
Owner
Copy Link

It would be fancy to have a scrape history

CREATE TABLE ScrapeHistory(
  `user_source_id` CHAR(25) NOT NULL REFERENCES UserSource(id),
  `scrape_task_id` CHAR(25) PRIMARY_KEY,
  `created_at` TIMESTAMPT NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `finished_at` TIMESTAMP NULL,
  `error` TEXT NULL,
  `added_posts` INT NOT NULL,
  `deleted_posts` INT NOT NULL

And as always basic CRUD

It would be fancy to have a scrape history ```sql CREATE TABLE ScrapeHistory( `user_source_id` CHAR(25) NOT NULL REFERENCES UserSource(id), `scrape_task_id` CHAR(25) PRIMARY_KEY, `created_at` TIMESTAMPT NOT NULL DEFAULT CURRENT_TIMESTAMP, `finished_at` TIMESTAMP NULL, `error` TEXT NULL, `added_posts` INT NOT NULL, `deleted_posts` INT NOT NULL ``` And as always basic CRUD
SoXX was assigned by Alphyron 2024-10-14 19:53:13 +00:00
SoXX closed this issue 2024-10-15 08:14:04 +00:00
SoXX reopened this issue 2024-10-15 08:14:06 +00:00
SoXX added reference dev/scrape-history 2024-10-15 09:24:27 +00:00
SoXX commented 2024-10-15 10:46:49 +00:00
Owner
Copy Link

merged

merged
SoXX closed this issue 2024-10-15 10:46:49 +00:00
Sign in to join this conversation.
dev/scrape-history
Branches Tags
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
SoXX
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: Anthrove/otter-space-sdk#13
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?