Delete entries over a year ago

Question

I save twitter tweets to my database using JPA spring repositories. The tweet date is stored as Datetime in MySQL db. Now I want to delete all tweets that are older than one year. I saw that there is a function CURRENT_TIME, and I thought of something like CURRENT_TIME - 360. I know this is not the correct syntax, but I have no idea how to do this. Here is what I have:

@Modifying
@Transactional
@Query("DELETE FROM Tweetpost t WHERE t.createdAt > ")
int removeOlderThan();

EDIT DECISION:

Repository:

@Modifying
    @Transactional
    @Query("DELETE FROM Tweetpost m WHERE m.createdAt < :date")
    int removeOlderThan(@Param("date") java.sql.Date date);

Services:

public void removeOldItems() {
        Calendar cal = Calendar.getInstance();
        cal.add(Calendar.DATE, -360);

        java.sql.Date oneYear = new java.sql.Date(cal.getTimeInMillis());

        tweetRepository.removeOlderThan(oneYear);


    }

Answer 1

For this you need 2 steps. First of all, you need a method that will take as a parameter, the date when you want to delete messages, and you do not need an annotation at all .

, -

    @Modifying
    public void deleteByCreatedAtBefore(Date expiryDate);

:

    public void performTweetCleanup(){
       //calculate date
       Calendar cal = Calendar.getInstance();
       Date today = cal.getTime();
       cal.add(Calendar.YEAR, -1);
       Date previousYear = cal.getTime();

       //call the method
       MyTweeterRepository.deleteByCreatedAtBefore(previousYear);
     }

Answer 2

:

Repository:

@Modifying
    @Transactional
    @Query("DELETE FROM Tweetpost m WHERE m.createdAt < :date")
    int removeOlderThan(@Param("date") java.sql.Date date);

:

public void removeOldItems() {
        Calendar cal = Calendar.getInstance();
        cal.add(Calendar.DATE, -360);

        java.sql.Date oneYear = new java.sql.Date(cal.getTimeInMillis());

        tweetRepository.removeOlderThan(oneYear);


    }

Answer 3

Java, :

DELETE FROM Tweetpost t WHERE t.createdAt < :nowMinusOneYear

Answer 4

,

System.getCurrentTimeMillis()

, . , - .