Method removeWastedData

src/main/java/serviceRun.java:338–366

(long backupfilehistoryid,String backupfilefullpath)

    }

    private void removeWastedData(long backupfilehistoryid,String backupfilefullpath) {
        //get fileid
        try {
            ResultSet ret=mysqlHelper.querySql("select backupfileid from tb_backfilehistory where id="+backupfilehistoryid);
            if(ret!=null&&ret.next())
            {
                long backupfileid=ret.getLong("backupfileid");
                mysqlHelper.exeSql("delete from tb_backfilehistory where id="+backupfilehistoryid);
                File file=new File(backupfilefullpath);
                if(file.exists()) {
                    logger.info("delete broken file:"+backupfilefullpath);
                    file.delete();
                }
                ret=mysqlHelper.querySql("select count(*) from tb_backfilehistory where backupfileid="+backupfileid);
                if(ret!=null&&ret.next())
                {
                    int historycnt=ret.getInt("count(*)");
                    if(historycnt==0)
                    {
                        //delete parent
                        mysqlHelper.exeSql("delete from tb_backfiles where id="+backupfileid);
                    }
                }
            }
        } catch (Exception e)
        {
            logger.error(e.getMessage());
        }
    }

    private void checkdata(boolean withhash)
    {