Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void main(String args[]) {
- String CHECKIN_DATE = "1919-08-19 13:00:13.153";
- boolean VERSION_WITH_STATUS = false;
- String ACTUAL_DATE = VERSION_WITH_STATUS ? CHECKIN_DATE : "2019" + CHECKIN_DATE.substring(4);
- int START_INDEX_OF_PCB = 1;
- int START_INDEX_OF_SCHEMATIC = 11;
- // UPDATE OPENED LAST USAGE DATE FOR PCB
- System.out.println("-- UPDATE STATUS TO OPENED AND UPDATE LAST USAGE DATA");
- if (VERSION_WITH_STATUS) {
- System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB));
- System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 1));
- System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 2));
- System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 3));
- System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 4));
- }
- else {
- System.out.println(getUpdateLastUsageSQL(ACTUAL_DATE, START_INDEX_OF_PCB + 1));
- System.out.println(getUpdateLastUsageSQL(ACTUAL_DATE, START_INDEX_OF_PCB + 3));
- }
- System.out.println(getUpdateLastUsageSQL(moveDataMonthBack(ACTUAL_DATE), START_INDEX_OF_PCB));
- System.out.println(getUpdateLastUsageSQL(moveDataMonthBack(ACTUAL_DATE), START_INDEX_OF_PCB + 2));
- System.out.println(getUpdateLastUsageSQL(moveDataMonthBack(ACTUAL_DATE), START_INDEX_OF_PCB + 4));
- System.out.println();
- // UPDATE UNOPENED LAST USAGE DATE FOR PCB
- System.out.println("-- UPDATE LAST USAGE DATA FOR UNOPENED");
- if (!VERSION_WITH_STATUS) {
- System.out.println(getUpdateLastUsageSQL(CHECKIN_DATE, START_INDEX_OF_PCB + 6));
- System.out.println(getUpdateLastUsageSQL(CHECKIN_DATE, START_INDEX_OF_PCB + 8));
- }
- System.out.println(getUpdateLastUsageSQL(moveDataTenDaysBack(CHECKIN_DATE), START_INDEX_OF_PCB + 5));
- System.out.println(getUpdateLastUsageSQL(moveDataTenDaysBack(CHECKIN_DATE), START_INDEX_OF_PCB + 7));
- System.out.println(getUpdateLastUsageSQL(moveDataTenDaysBack(CHECKIN_DATE), START_INDEX_OF_PCB + 9));
- System.out.println();
- // UPDATE OPENED LAST USAGE FOR SCHEMATIC
- System.out.println("-- UPDATE STATUS TO OPENED");
- for (int id = START_INDEX_OF_SCHEMATIC; id < START_INDEX_OF_SCHEMATIC + 20; id++) {
- String updateSQL = VERSION_WITH_STATUS ? getUpdateStatusSQL(id) : getUpdateLastUsageSQL(ACTUAL_DATE.substring(0, 20) + id, id);
- System.out.println(updateSQL);
- }
- }
- public static String getUpdateLastUsageSQL(String date, int id) {
- return "UPDATE cc_design_version SET last_usage = \'" + date + "\' WHERE id=" + id + ";";
- }
- public static String getUpdateStatusSQL(int id) {
- return "UPDATE cc_design_version SET status = 0 WHERE id=" + id + ";";
- }
- public static String moveDataMonthBack(String date) {
- Integer month = Integer.parseInt(date.substring(5, 7)) - 1;
- return date.substring(0, 5) + String.format("%02d", month) + date.substring(7);
- }
- public static String moveDataTenDaysBack(String date) {
- Integer day = Integer.parseInt(date.substring(8, 10));
- return date.substring(0, 8) + String.format("%02d", getDayMinusTen(day)) + date.substring(10);
- }
- public static int getDayMinusTen(int day) {
- return day > 11 ? day - 10 : 28 - (10 - day);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement