Êþº¾ E§
|
java/lang/Object <init> ()V inventory
|
backup clean java/util/Set of G(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/util/Set; contains (Ljava/lang/Object;)Z
|
java/lang/String equals "java/lang/IllegalArgumentException ;Usage: TempDbCleanup inventory|backup|clean <backup.sql.gz>
|
! " (Ljava/lang/String;)V $ 5yudao-server/src/main/resources/application-thzy.yaml & ' ( ) java/nio/file/Path ;(Ljava/lang/String;[Ljava/lang/String;)Ljava/nio/file/Path;
|
+ , - . / java/nio/file/Files
|
readString ((Ljava/nio/file/Path;)Ljava/lang/String; 1 master:
|
3 4 5 indexOf (Ljava/lang/String;)I
|
7 8 9 substring (I)Ljava/lang/String; ; \R
|
= > ? split '(Ljava/lang/String;)[Ljava/lang/String;
|
A B C trim ()Ljava/lang/String; E username:
|
G H I
|
startsWith (Ljava/lang/String;)Z
|
K L M N O TempDbCleanup value &(Ljava/lang/String;)Ljava/lang/String; Q password: S java/lang/IllegalStateException U Missing database credentials
|
R ! X jdbc:mysql://1.95.78.124:9000/mom-thzynew?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&useCursorFetch=true
|
Z [ \ ] ^ java/sql/DriverManager getConnection M(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection; ` mom-thzynew b c d e C java/sql/Connection
|
getCatalog g h O makeConcatWithConstants
|
K j k l targetTables '(Ljava/sql/Connection;)Ljava/util/List; n o p q r java/lang/System out Ljava/io/PrintStream; t u v w x java/util/List size ()I z h 9
|
| } ~ " java/io/PrintStream println
|
K ((Ljava/sql/Connection;Ljava/util/List;)V
|
K
|
|
K <(Ljava/sql/Connection;Ljava/util/List;Ljava/nio/file/Path;)V b close java/lang/Throwable
|
addSuppressed (Ljava/lang/Throwable;)V :
|
> ((Ljava/lang/String;I)[Ljava/lang/String; \s+# java/util/ArrayList
|
b createStatement ()Ljava/sql/Statement; SELECT table_name FROM information_schema.tables WHERE table_schema='mom-thzynew' AND table_type='BASE TABLE' ORDER BY table_name ¢ £ ¤ ¥ ¦ java/sql/Statement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; ¨ © ª « ¬ java/sql/ResultSet next ()Z ¨ ® ¯ 9 getString K ± ² ³ KEEP Ljava/util/Set; K µ ¶ ³
|
PRO_TABLES ¸ mes_qc_ º mes_wm_ ¼
|
mes_trace_ ¾ crm_ t À Á add ¨ ¢ g ¨ Æ Ç È getLong (I)J t Ê Ë Ì iterator ()Ljava/util/Iterator; Î Ï Ð Ñ ¬ java/util/Iterator hasNext Î Ó « Ô ()Ljava/lang/Object;
|
K Ö × Ø count *(Ljava/sql/Connection;Ljava/lang/String;)J Ú h Û '(Ljava/lang/String;J)Ljava/lang/String; Ê Ú ß |SELECT status, COUNT(*), SUM(total_count-finished_count) FROM mes_pro_qr_export_task WHERE status IN (10,20) GROUP BY status ¨ á â ã getInt (I)I å h æ (IJJ)Ljava/lang/String; è CSELECT COUNT(*) FROM mes_pro_qr_export_task WHERE status IN (10,20) ê %QR export task still active; aborting
|
K ì í î requireIdle (Ljava/sql/Connection;)V ð
|
db-backups ò %java/nio/file/attribute/FileAttribute
|
+ ô õ ö createDirectories R(Ljava/nio/file/Path;[Ljava/nio/file/attribute/FileAttribute;)Ljava/nio/file/Path;
|
ø ù ú û ü java/time/LocalDateTime now ()Ljava/time/LocalDateTime; þ yyyyMMdd-HHmmss
|
"java/time/format/DateTimeFormatter ofPattern 8(Ljava/lang/String;)Ljava/time/format/DateTimeFormatter;
|
ø format 8(Ljava/time/format/DateTimeFormatter;)Ljava/lang/String; g & resolve ((Ljava/lang/String;)Ljava/nio/file/Path; & getFileName ()Ljava/nio/file/Path;
|
valueOf &(Ljava/lang/Object;)Ljava/lang/String; g java/util/Properties
|
database
|
setProperty 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;! table.count
|
#$% & 9 java/lang/Integer toString b( )* setTransactionIsolation (I)V b, -. setAutoCommit (Z)V0 java/io/BufferedWriter2 java/io/OutputStreamWriter4 java/util/zip/GZIPOutputStream6 java/nio/file/OpenOption
|
+8 9: newOutputStream G(Ljava/nio/file/Path;[Ljava/nio/file/OpenOption;)Ljava/io/OutputStream;
|
3= > (Ljava/io/OutputStream;I)V @AB CD !java/nio/charset/StandardCharsets UTF_8 Ljava/nio/charset/Charset;
|
1F G 3(Ljava/io/OutputStream;Ljava/nio/charset/Charset;)V
|
/I J (Ljava/io/Writer;I)VL U-- mom-thzynew requested business-data backup; restore only to the intended database
|
|
/N O " writeQ $SET NAMES utf8mb4;
|
SET sql_mode='';
|
bS T (II)Ljava/sql/Statement; ¢V W* setFetchSize g ¨Z [\ getMetaData ()Ljava/sql/ResultSetMetaData; ^_` a x java/sql/ResultSetMetaData getColumnCountc java/util/StringJoinere ,
|
bg h (Ljava/lang/CharSequence;)V ^j k 9 getColumnName g
|
bn Áo 2(Ljava/lang/CharSequence;)Ljava/util/StringJoiner;
|
q hr 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
|
/t O*
|
Kv wx writeSqlValue D(Ljava/io/Writer;Ljava/sql/ResultSet;Ljava/sql/ResultSetMetaData;I)Vz );
|
g
|
}~ & java/lang/Long (J)Ljava/lang/String; Ú h b
rollback
|
/ java/lang/Exception
|
+ deleteIfExists (Ljava/nio/file/Path;)Z java/nio/file/CopyOption java/nio/file/StandardCopyOption ATOMIC_MOVE "Ljava/nio/file/StandardCopyOption;
|
+ move Y(Ljava/nio/file/Path;Ljava/nio/file/Path;[Ljava/nio/file/CopyOption;)Ljava/nio/file/Path; sha256
|
K /
|
rows.total g¢ )mom-thzynew business data backup manifest
|
¤ ¥¦ store +(Ljava/io/OutputStream;Ljava/lang/String;)V
|
¨ © java/io/OutputStream &« ¬ toAbsolutePath
|
+® w¯ (Ljava/nio/file/Path;)J ± h² ((Ljava/lang/String;JJ)Ljava/lang/String; ^´ µ ã getColumnType· java/sql/Types ¨¹ º» getBytes (I)[B½ NULL
|
¿NÀ java/io/Writer X'Ä %02X
|
#Æ Ç (I)Ljava/lang/Integer;
|
É Ê 9(Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/String;Ì '
|
¿t
|
Ï Ð x length
|
Ò ÓÔ charAt (I)CÖ \\Ø \'Ú \nÜ \rÞ \0à \Zâ SHA-256
|
äåæ çè java/security/MessageDigest getInstance 1(Ljava/lang/String;)Ljava/security/MessageDigest;
|
+ê ëì newInputStream F(Ljava/nio/file/Path;[Ljava/nio/file/OpenOption;)Ljava/io/InputStream;
|
îïð ñò java/io/InputStream read ([B)I
|
äô õö update ([BII)V
|
î
|
ùúû ü java/util/HexFormat ()Ljava/util/HexFormat;
|
äþ ÿ digest ()[B
|
ù formatHex ([B)Ljava/lang/String;
|
load (Ljava/io/InputStream;)V
|
|
O getProperty
|
# 5 parseInt #Backup integrity or target mismatch java/util/LinkedHashMap
|
g
|
} parseLong (Ljava/lang/String;)J ±
|
} (J)Ljava/lang/Long; !" java/util/Map put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;$ mes_pro_line& mes_wm_warehouse( mes_wm_warehouse_area* mes_wm_warehouse_location t, - Z(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/util/List; Ú 0 12 entrySet ()Ljava/util/Set;4 java/util/Map$Entry 36 7 Ô getValue
|
}9 :; longValue ()J 3= > Ô getKey g ¢A B 5 executeUpdate qE mes_pro_bag_codeG mes_pro_bag_code_replaceI mes_pro_batchK mes_pro_batch_workerM mes_pro_palletO mes_pro_qr_export_taskQ mes_pro_scan_event S T (Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/util/Set; V W Y(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/util/Set; DB Ljava/lang/String; ConstantValue Signature #Ljava/util/Set<Ljava/lang/String;>; Code LineNumberTable main ([Ljava/lang/String;)V StackMapTablec [Ljava/lang/String;
|
Exceptionsf java/sql/SQLException ;(Ljava/sql/Connection;)Ljava/util/List<Ljava/lang/String;>; <(Ljava/sql/Connection;Ljava/util/List<Ljava/lang/String;>;)Vj [B P(Ljava/sql/Connection;Ljava/util/List<Ljava/lang/String;>;Ljava/nio/file/Path;)V <clinit>
|
SourceFile TempDbCleanup.java BootstrapMethodsq Wrong database: s $DATABASE=mom-thzynew TARGET_TABLES=u SELECT COUNT(*) FROM ``w =y KEEP ={ *ACTIVE_EXPORT status= tasks= remaining=} %mom-thzynew-business-cleanup-.sql.gz .part SELECT * FROM `` ``
INSERT INTO `` () VALUES ( row. BACKED_UP = -- backup complete: rows
|
|
.manifest BACKUP_FILE= ROWS= BYTES= Missing backup count: 0Table changed since backup: backup= current= PRESERVE = TRUNCATE TABLE `` CLEARED =
|
h $java/lang/invoke/StringConcatFactory (Ljava/lang/invoke/MethodHandles$Lookup;Ljava/lang/String;Ljava/lang/invoke/MethodType;Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/invoke/CallSite; InnerClasses Entry£ %java/lang/invoke/MethodHandles$Lookup¥ java/lang/invoke/MethodHandles Lookup ! K XY Z _ ¶ ³ [ \ ² ³ [ \ ] *· ± ^ _` ] ` s*¾¡ 1 ¸ *2¹ *2 ¶ *¾ § *¾ » Y · ¿#½ ¸ %¸ *L++0¶ 2¶ 6MN:,:¶ <:¾66¢ :2:¶ @D¶ F ¸ JN¶ @P¶ F ¸ J:§ §ÿÅ-Æ Ç » RYT· V¿W:-¸ Y:_¹ a ¶ » RY¹ a º f · V¿¸ i:² m¹ s º y ¶ {*2¶
|
¸ *2 ¶
|
¸ *2 ¶ *2½ ¸ %¸
Æ *¹ § :Æ ¹ § :¶ ¿± ÊFU \cf ^ Z 4 > K V [ y £ © ! ¼ " À $ Ê % í & ô ' ( )* *F +U $r ,a k . ÿ , b b ü ú ø ý 0 bü * tú N ÿ b b ù d
|
N O ] 0 *¶ @¶ 2¶ @¶ 2° ^ /
|
k l ] Ê» Y· L*¹ M,¹ ¡ N-¹ § ]-¹ :² °¹ §ÿá² ´¹ +·¶ F !¹¶ F »¶ F ½¶ F +¹ ¿ W§ÿ -Æ '-¹  § :-Æ -¹  § :¶ ¿,Æ $,¹ à § N,Æ ,¹ à § :-¶ -¿+° { £ ° µ » ¾ ^ 6 3 4 7 ! 8 * 9 : : _ ; x < { = 4 £ = ° 4 È >a X þ t ¢ ¨ü ! 4ú L ÿ b t ¢ ¨ ù L ÿ b t ¢ ù d e[ g
|
× Ø ] + n*¹ M,+º Ä ¹ ¡ N-¹ § W-¹ Å 7-Æ -¹ Â ,Æ ,¹ Ã :-Æ -¹ Â § :¶ ¿N,Æ ,¹ Ã § :-¶ -¿ $ ; A G J . V ; V V [ a d ^ B C $ D 8 C ; Ba g þ . ¢ ¨ ÿ b ¢ ¨ ÿ b ¢ ¨ ÿ b ¢ ÿ b ¢ d e
|
] à ó+¹ É M,¹ Í ,,¹ Ò À N*-¸ Õ7 ² m-º Ù ¶ {§ÿѲ °¹ Ü M,¹ Í !,¹ Ò À N² m-*-¸ Õº Ý ¶ {§ÿÜ*¹ M,Þ¹ ¡ N-¹ § &² m-¹ à -¹ Å -¹ Å º ä ¶ {§ÿ×-Æ '-¹  § :-Æ -¹  § :¶ ¿,Æ $,¹ à § N,Æ ,¹ à § :-¶ -¿± y ¥ ² ¸ ¾ Á p Í Ú ß å è ^ : H I ! J 6 K 9 L i M y P Q P ¥ R ² M Í R Ú M ò Sa ^ ü Î.ú ü Îú &ý ¢ ¨+L ÿ b t ¢ ¨ ù L ÿ b t ¢ ù d e[ h
|
í î ] v*¹ L+ç¹ ¡ M,¹ § W,¹ Å » RYé· V¿,Æ $,¹ Â § N,Æ ,¹ Â § :-¶ -¿+Æ "+¹ Ã § M+Æ +¹ Ã § N,-¶ ,¿± - : ? E H R _ d j m ^ " V X Y - Z : V R Z _ V u [a D ý - ¢ ¨L ÿ b ¢ ¨ ù L ÿ b ¢ ù d e
|
|
] *¸ ëï½ ¸ %M,½ ñ¸ óW¸ ÷ý¸ ÿ¶N,-º ¹
|
:,¹ ¸º ¹
|
: 7»Y·:_¶ W +¹ s ¸"¶ W*¹' *¹+ »/Y»1Y»3Y½5¸7;·<²?·E;·H: K¶M P¶M+¹ É :
|
|
¹ Í ^
|
¹ Ò À : 7 *ëï¹R :è¹U ºX ¹ ¡ :¹Y :¹] 6»bYd·f:6£ ¹i ºl ¶mW§ÿâ ¸ºp :¹ § C ¶M6£ !¤
|
,¶s ¸u§ÿÞ y¶M
|
a7 §ÿ¹Æ *¹  § :Æ ¹  § :¶ ¿Æ *¹ à § :Æ ¹ à § :¶ ¿ a7 º{ ¸|¶ W ² m º ¶ {§þ º ¶M*¹ ¶§ :
|
¶§ :
|
¶
|
¿*¹+ § : *¹ ¸W ¿:*¹+ ¿½Y²S¸W¸¶ W¸|¶ W¸º ½ ¸ %½5¸7: ¡¶£ Æ & ¶§§ :
|
Æ ¶§§ :
|
¶
|
¿² m¹ª ¸¸º° ¶ {± ª ±¸» çÇÖ Ýäç ¨7? AFI U_ Up _rp ÄÎÛ âçê ^ A ^ _ ` a # b 1 c H d K e T f _ g q h x i j k ¨ l ° m ¸ n Ö o Ù p ç q ñ r s
|
t u vC wQ x[ yb zl {y | z ~ ª rÇ Ö pó ú
" % 1 7 ? jU \ _ a g m p y | ª Ä Î Û ö a ÿ À
|
b t & & &/ Î ÿ a b t & & &/ Î ¢ ¨^b ú ü ü ú ÿ b t & & &/ Î ¢ ¨ N ÿ b t & & &/ Î ¢ ¨ ù N ÿ b t & & &/ Î ¢ ù ù .ú Y ÿ
|
b t & & &/ ù IP ÿ ^ b t & & &¨ ÿ
|
b t & & &¨ ù d [ h
|
wx ] C
|
, ¹³ 6þ ý ü Ô
|
ù b+ ¹¸ :Ç *¼¶¾±*Á¶¾:¾66¢ *36 *ý Y ÿ~¸ÅS¸È¶¾§ÿÕ*˶¾±+ ¹ :Ç *¼¶¾± 8û 1 +ú $
|
|
*¶¾±*'¶Í6¶Î¢ ¶Ñ6« v b
|
N X l ' D \ :*Õ¶¾§ ;*׶¾§ 1*Ù¶¾§ '*Û¶¾§ *ݶ¾§ *߶¾§ *¶Í§ÿl*'¶Í± ^ j - 6 C J ¡ ¢ £ ¥ ¦ ¢ § Ý ª ä ¬ ê ÷ ® ¯< °F ±P ²Z ³d ´n µx ¶~ ¹ ºa 6 ü -ü iþ iø -ú ü :ü ü N ú ú d
|
/ ] Î Yá¸ãL*½5¸éM;¼N,-¶íY6 +-¶ó§ÿì,Æ ,¶÷§ N,Æ ,¶÷§ :-¶ -¿¸ø+¶ý¶° - 8 = A D ^ ½ ¾ ¿ Á -  8 ¾ N Ãa / þ äîiú J ÿ &äî ù d
|
] *¸ ë»Y·N,¸º ½ ¸ %½5¸é:-¶Æ &¶÷§ :Æ ¶÷§ :¶ ¿_-¶ ¶ '+¹ s - ¶ ¸ ,¸-¶ ¶ » RY· V¿»Y·:+¹ É :¹ Í l¹ Ò À :-º{ ¶ :Ç » RYº · V¿¸7*¸ Õ7
|
|
» RY
|
º · V¿¸¹ W§ÿ#%')¸+¹ É :¹ Í %¹ Ò À :² m*¸ Õº. ¶ {§ÿ×¹/ ¹ Ü :¹ Í ¹ Ò À3:¹5 À}¶8 §ÿØ*¸ ë*¹ :¹< À º? ¹@ WÆ *¹ à § :Æ ¹ à § : ¶ ¿² m¹< À ¹5 ¸ºC ¶ {§ÿg*+¸ ± % + 8 ? D G ³Â ÉÐÓ ^ z Ç È É S Ê c Ë v Ì Í Ð Ñ ¸ Ò Å Ó Ù Ô à Õ è Ö Ø Ù ÚA ÜT ÝW Þ{ ß à á â³ ã áß äþ å æ ça Í ÿ 8 b t &î ÿ b t &î ù 2
|
ý Îý 6 ý )ÿ b t & ü Îú +ü Îü *3ÿ 1 b t & Î3 ¢ ÿ b t & Î3 ¢ ù ù !d [ k l ] J .DFHJLNP¸R³ ´%')#¸U³ °± ^
|
m no p r t v x z | ~ 3 ¡ ¢¤¦
|
