Package com.art.anette.server.database

Examples of com.art.anette.server.database.ServerDB


        }


        //noinspection ConstantIfStatement
        if (false) {
            ServerDB sdb = ServerDB.getInstance();

            //         delta = dd * hh * mm * sec * msec
            final long delta = 90L * 24L * 60L * 60L * 1000L;
            //noinspection InfiniteLoopStatement
            while (true) {
                try {
                    long time = (System.currentTimeMillis() - delta) / -1000;
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", Employee.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", Employee.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", Project.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", Department.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", WorkPackage.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", EmployeeProjectRelation.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", EmployeeWorkPackageRelation.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", WorkPackageDependsRelation.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", Task.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("DELETE FROM %s WHERE timestamp > %d AND timestamp < 0", Duration.getTableName(), time));
                    sdb.execute(SQLFormatter.generateQuery("UPDATE %s SET dirty = 1 WHERE lastlogin < %d", Employee.getTableName(), -time));
                } catch (SQLException ex) {
                    logger.severe(null, ex);
                }

                Thread.sleep(delta);
View Full Code Here

TOP

Related Classes of com.art.anette.server.database.ServerDB

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.