added watchlists

2 files changed, 27 insertions, 19 deletions

diff --git a/scripts/entry_limit_trigger.pgsql b/scripts/entry_limit_trigger.pgsql
deleted file mode 100644
index d7d99c2..0000000
--- a/scripts/entry_limit_trigger.pgsql
+++ /dev/null
@@ -1,19 +0,0 @@
-CREATE OR REPLACE FUNCTION milla.janitor ()
-    RETURNS TRIGGER
-    AS $$
-BEGIN
-    UPDATE
-        posts
-    SET
-        updated_at = now()
-    WHERE
-        id = NEW.id;
-    RETURN new;
-END;
-$$
-LANGUAGE plpgsql;
-
-CREATE TRIGGER janitor_trigger
-    AFTER INSERT ON milla.tables
-    EXECUTE PROCEDURE milla.janitor ();
-
diff --git a/scripts/entry_limit_trigger.sql b/scripts/entry_limit_trigger.sql
new file mode 100644
index 0000000..a3d4887
--- /dev/null
+++ b/scripts/entry_limit_trigger.sql
@@ -0,0 +1,27 @@
+create function remove_old_entries()
+    returns trigger
+    as $$
+begin
+    if(
+        select
+            COUNT(*)
+        from
+            table_name) > 10000 then
+        delete from table_name
+        where id in(
+                select
+                    id
+                from
+                    table_name
+                order by
+                    id asc
+                limit 1000);
+    end if;
+    return null;
+end;
+$$
+language plpgsql;
+
+create trigger remove_old_entries_trigger
+    after insert on table_name for each row
+    execute procedure remove_old_entries();