Advertisement
Guest User

designClean

a guest
Aug 22nd, 2019
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.41 KB | None | 0 0
  1.     public static void main(String args[]) {
  2.         String CHECKIN_DATE = "1919-08-19 13:00:13.153";
  3.         boolean VERSION_WITH_STATUS = false;
  4.         String ACTUAL_DATE = VERSION_WITH_STATUS ? CHECKIN_DATE : "2019" + CHECKIN_DATE.substring(4);
  5.         int START_INDEX_OF_PCB = 1;
  6.         int START_INDEX_OF_SCHEMATIC = 11;
  7.  
  8.         // UPDATE OPENED LAST USAGE DATE FOR PCB
  9.         System.out.println("-- UPDATE STATUS TO OPENED AND UPDATE LAST USAGE DATA");
  10.         if (VERSION_WITH_STATUS) {
  11.             System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB));
  12.             System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 1));
  13.             System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 2));
  14.             System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 3));
  15.             System.out.println(getUpdateStatusSQL(START_INDEX_OF_PCB + 4));
  16.         }
  17.         else {
  18.             System.out.println(getUpdateLastUsageSQL(ACTUAL_DATE, START_INDEX_OF_PCB + 1));
  19.             System.out.println(getUpdateLastUsageSQL(ACTUAL_DATE, START_INDEX_OF_PCB + 3));
  20.         }
  21.         System.out.println(getUpdateLastUsageSQL(moveDataMonthBack(ACTUAL_DATE), START_INDEX_OF_PCB));
  22.         System.out.println(getUpdateLastUsageSQL(moveDataMonthBack(ACTUAL_DATE), START_INDEX_OF_PCB + 2));
  23.         System.out.println(getUpdateLastUsageSQL(moveDataMonthBack(ACTUAL_DATE), START_INDEX_OF_PCB + 4));
  24.         System.out.println();
  25.  
  26.         // UPDATE UNOPENED LAST USAGE DATE FOR PCB
  27.         System.out.println("-- UPDATE LAST USAGE DATA FOR UNOPENED");
  28.         if (!VERSION_WITH_STATUS) {
  29.             System.out.println(getUpdateLastUsageSQL(CHECKIN_DATE, START_INDEX_OF_PCB + 6));
  30.             System.out.println(getUpdateLastUsageSQL(CHECKIN_DATE, START_INDEX_OF_PCB + 8));
  31.         }
  32.         System.out.println(getUpdateLastUsageSQL(moveDataTenDaysBack(CHECKIN_DATE), START_INDEX_OF_PCB + 5));
  33.         System.out.println(getUpdateLastUsageSQL(moveDataTenDaysBack(CHECKIN_DATE), START_INDEX_OF_PCB + 7));
  34.         System.out.println(getUpdateLastUsageSQL(moveDataTenDaysBack(CHECKIN_DATE), START_INDEX_OF_PCB + 9));
  35.         System.out.println();
  36.  
  37.         // UPDATE OPENED LAST USAGE FOR SCHEMATIC
  38.         System.out.println("-- UPDATE STATUS TO OPENED");
  39.         for (int id = START_INDEX_OF_SCHEMATIC; id < START_INDEX_OF_SCHEMATIC + 20; id++) {
  40.             String updateSQL = VERSION_WITH_STATUS ? getUpdateStatusSQL(id) : getUpdateLastUsageSQL(ACTUAL_DATE.substring(0, 20) + id, id);
  41.             System.out.println(updateSQL);
  42.         }
  43.     }
  44.  
  45.     public static String getUpdateLastUsageSQL(String date, int id) {
  46.         return "UPDATE cc_design_version SET last_usage = \'" + date + "\' WHERE id=" + id + ";";
  47.     }
  48.  
  49.     public static String getUpdateStatusSQL(int id) {
  50.         return "UPDATE cc_design_version SET status = 0 WHERE id=" + id + ";";
  51.     }
  52.  
  53.     public static String moveDataMonthBack(String date) {
  54.         Integer month = Integer.parseInt(date.substring(5, 7)) - 1;
  55.         return date.substring(0, 5) + String.format("%02d", month) + date.substring(7);
  56.     }
  57.  
  58.     public static String moveDataTenDaysBack(String date) {
  59.         Integer day = Integer.parseInt(date.substring(8, 10));
  60.         return date.substring(0, 8) + String.format("%02d", getDayMinusTen(day)) + date.substring(10);
  61.     }
  62.  
  63.     public static int getDayMinusTen(int day) {
  64.         return day > 11 ? day - 10 : 28 - (10 - day);
  65.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement