Mix Task to perform cleanup of Database using ecto 2.x
Add mix_db_cleanup to your list of dependencies in mix.exs:
def deps do
[{:mix_db_cleanup, github: "techgaun/mix_db_cleanup"}]
endThe db.cleanup mix task can be used to cleanup the database table. The intended use was originally for cleaning up older data in devices_data in one of our rapidly growing table but can be used for any table. The mix task is known to work with ecto 1.x only.
$ mix help db.cleanup
mix db.cleanup
The db.cleanup task deletes old rows from a table. By default, it deletes
data from events that are older than 7 days.
Examples
┃ mix db.cleanup
┃ mix db.cleanup -t devices -n 30
Command Line Options
• --repo / -r - the repo to use (defaults to current app repo)
• --table / -t - the table to cleanup
• --num / -n - day count. data before (current date - n) will be deleted
• --count / -c - number of first rows to delete (overrides day based deletion)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent