package org.sagebionetworks.dashboard;

import javax.annotation.Resource;

import org.sagebionetworks.dashboard.dao.AccessRecordDao;
import org.sagebionetworks.dashboard.dao.AccessRecordEntityDao;
import org.sagebionetworks.dashboard.dao.LogFileDao;
import org.sagebionetworks.dashboard.dao.RawAccessRecordDao;
import org.sagebionetworks.dashboard.service.AccessRecordWorker;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

@Component("accessRecordScheduler")
public class AccessRecordScheduler {

    private final Logger logger = LoggerFactory.getLogger(AccessRecordScheduler.class);

    @Resource
    private RawAccessRecordDao rawAccessRecordDao;

    @Resource
    private LogFileDao logFileDao;

    @Resource
    private AccessRecordWorker accessRecordWorker;

    @Resource
    private AccessRecordDao accessRecordDao;

    @Resource
    private AccessRecordEntityDao accessRecordEntityDao;

    /**
     * Copy the access record log files in S3 buckets to raw_access_record.
     * Initial delay of 0 minutes. Updates every 1.5 minutes.
     */
    @Scheduled(initialDelay=(0L * 60L * 1000L), fixedRate=(90L * 1000L))
    public void runRawRecordWorker() {
        logger.info(rawAccessRecordDao.count() + " raw access records, " +
                logFileDao.count() + " log files.");
        accessRecordWorker.copy();
    }

    /**
     * Update the access_record table.
     * Initial delay of 1.5 minutes. Updates every 3 minutes.
     */
    @Scheduled(initialDelay=(90L * 1000L), fixedRate=(3L * 60L * 1000L))
    public void runRecordWorker() {
        logger.info(accessRecordDao.count() + " access records.");
        accessRecordWorker.update();
    }

    /**
     * Update the access_record_entity table.
     * Initial delay of 3 minutes. Updates every 3 minutes.
     */
    @Scheduled(initialDelay=(3L * 60L * 1000L), fixedRate=(3L * 60L * 1000L))
    public void updateEntityLookupTable() {
        logger.info(accessRecordEntityDao.count() + " entity lookup records.");
        accessRecordWorker.updateEntityLookupTable();
    }

    /**
     * Clean up the access_record table.
     * Initial delay of 30 minutes. Updates every 4 hours.
     */
    @Scheduled(initialDelay=(30L * 60L * 1000L), fixedRate=(4* 60L * 60L * 1000L))
    public void vacuumAccessRecord() {
        accessRecordWorker.vacuumAccessRecord();
    }

    /**
     * Clean up the raw_access_record table.
     * Initial delay of 30 minutes. Updates every 4 hours.
     */
    @Scheduled(initialDelay=(30L * 60L * 1000L), fixedRate=(4* 60L * 60L * 1000L))
    public void vacuumRawAccessRecord() {
        accessRecordWorker.vacuumRawAccessRecord();
    }

    /**
     * Clean up the access_record_entity table.
     * Initial delay of 30 minutes. Updates every 4 hours.
     */
    @Scheduled(initialDelay=(30L * 60L * 1000L), fixedRate=(4* 60L * 60L * 1000L))
    public void vacuumEntityLookupTable() {
        accessRecordWorker.vacuumEntityLookupTable();
    }

    /**
     * Clean up the log_file table.
     * Initial delay of 30 minutes. Updates every 4 hours.
     */
    @Scheduled(initialDelay=(30L * 60L * 1000L), fixedRate=(4* 60L * 60L * 1000L))
    public void vacuumLogFile() {
        accessRecordWorker.vacuumLogFile();
    }
}

@@ -1440,37 +1440,41 @@
 r.copy();%0A    %7D%0A
+/*
 %0A    
+*/
 /**%0A     * Updat
@@ -1561,32 +1561,34 @@
 minutes.%0A     */
+/*
 %0A    @Scheduled(
@@ -1788,32 +1788,34 @@
 e();%0A    %7D%0A%0A    
+*/
 /**%0A     * Updat
@@ -1907,32 +1907,34 @@
 minutes.%0A     */
+/*
 %0A    @Scheduled(
@@ -2177,32 +2177,34 @@
 e();%0A    %7D%0A%0A    
+*/
 /**%0A     * Clean
@@ -2290,32 +2290,34 @@
 4 hours.%0A     */
+/*
 %0A    @Scheduled(
@@ -2475,32 +2475,34 @@
 d();%0A    %7D%0A%0A    
+*/
 /**%0A     * Clean
@@ -2592,32 +2592,34 @@
 4 hours.%0A     */
+/*
 %0A    @Scheduled(
@@ -2783,32 +2783,34 @@
 d();%0A    %7D%0A%0A    
+*/
 /**%0A     * Clean
@@ -2903,32 +2903,34 @@
 4 hours.%0A     */
+/*
 %0A    @Scheduled(
@@ -3102,24 +3102,26 @@
 %0A    %7D%0A%0A    
+*/
 /**%0A     * C
@@ -3206,32 +3206,34 @@
 4 hours.%0A     */
+/*
 %0A    @Scheduled(
@@ -3378,16 +3378,18 @@
 File();%0A
-
     %7D
+*/
 %0A%7D%0A

version 1 - only copy access record from s3 to redshift