Delete Database Items automatically after certain time

Ask the community
,
1

Hey Wix Team, Wix Code Community,

How to delete a the items in a database automatically after a certain time of its creation .

Use Case:
When the user inputs the data to a form, he can choose when to delete the data from the database automatically using a date picker (maximum 3 months from current date). So that the database will be rid of old data and the user need not bother about it as after 3 months or after the user selected date, it gets automatically deleted.

Research:
I have read this post and comment from @Yisrael . But in that code, the admin must go to the page everyday to delete the contents (now the code is deleting all data but i know how to delete it based on date by comparing the dates ).

What I Want:
What I want is automatic deletion (from all the databases in my website )without admin doing anything. Is there any way to achieve this? Maybe using hooks? or any other way which removes the manual work and doesnā€™t impact on site load speed or database access speed.

Thanks !!!

1 Like
2

I suggest that you implement it using http functions .
Once you have a function that handles deletion, you can trigger it manually or using an automation service such as Zappier or IFTTT.

3

Hi Ohad,
Thanks for your suggestion. I will try to implement it using IFTTT. And If I am able to do it , I will post the code hereā€¦ Thanksā€¦

4

Hello Ohad, Everyone,

Here is the code if anyone is looking for the same function in their websiteā€¦

import {
    notFound,
    ok,
    serverError
} from 'wix-http-functions';
import wixData from 'wix-data';

export async function get_deleteEventsDatabaseOldData() {
 let itemsToDelete;
 let threeMonthAgoDate = new Date(
 new Date().getFullYear(),
 new Date().getMonth() - 3, // Add the month here(Change)
 new Date().getDate()
    );
 let returnoptions = {
 "headers": {
 "Content-Type": "application/json"
        }
    };

 let options = {
 "suppressAuth": true,
 "suppressHooks": true
    };

 return await wixData.query("Events")
        .lt("_createdDate", threeMonthAgoDate)
        .find(options)
        .then((results) => {
 if (results.items.length > 0) {
                itemsToDelete = results.items;
 for (let i in itemsToDelete) {
                    wixData.remove("Events", itemsToDelete[i]._id, options);
                }
                returnoptions.body = {
 "Status": "Items Deleted = " + results.items.length
                };
 return ok(returnoptions);
            }
            returnoptions.body = {
 "Status": "No Data To Delete"
            };
 return notFound(returnoptions);
        })
 // something went wrong
        .catch((error) => {
            returnoptions.body = {
 "Error": error
            };
 return serverError(returnoptions);
        });
}

You can call this function using this link (note that my website is not premium)
https://qqqqqqqqqqqqqqqq.wixsite.com/xxxxxxxxxxxxxxxxxxxx/_functions/deleteOldDatabaseData

5

sorry broo here a better code i have created and it work WOWW!!

const Today = new Date();
wixData.query(ā€˜subLibraryā€™)

    .le('expiredDate', Today) 

    .find() 

    .then(res => {

let items = res.items[0];
console.log(items)

        wixData.remove("subLibrary", items._id) 
            .then((results) => {

let item = results; //see item below
console.log(ā€œItem Removedā€)
})
. catch ((err) => {
let errorMsg = err;
console.log(ā€œkeep on brooā€)
});
})

6

I am trying to move items with dates before today, would this code apply similarly?

7

Hi, it worked but my live site stills showing those items as the deleted items still present in live database , i also tried syncing the database (sandbox) with live database still no luck its just copying those items to live but not to replacing the live database ? help me solve it , once the item is deleted in the database (sandbox) i want it to be deleted from live site also. how to do it.

8

@vamsi Make sure that you delete items when running the Live site. The sandbox and Live databases are completely separate. When you delete from a Preview, the item will only be deleted from the Sandbox database. If you delete from a Live site, the item will only be deleted from the Live database.

See the article Accessing Your Sandbox and Live Database Collections for more information.

9

@yisrael-wix Thanks for the heads up , but how to delete items from live database when the site is live ? in the same code replacing with live database name instead of sandbox database name works?

10

hi @ Ukaz Zaku , im able to delete only one item per page load does your code delete all the items in one go ? can we delete all items which expiry date is lesser than today in one go ?