Package com.art.anette.server.database

Examples of com.art.anette.server.database.ServerDB.execute()

78
79
80
81
82
83
84
85
86
87
88
            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));
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
            //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));
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
            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));
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
                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));
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
                    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));
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
                    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));
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
                    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) {
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
                    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);
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
                    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);
                }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
                    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);
                }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.