UsIj0SSKJr SSKrSSKrSSKrSSKrSSKJrJr SSK J r \ "S5r \R"S5r SSjrSSjrSS jrSS jrSS jrSS jrSS jrSSjrSSjrSSjrSSjrg)) annotationsN) load_configConfig) get_loggerzactions.databasez^[a-zA-Z0-9_]+$cFURSS5RSS5$)z>   rc[X5nURS:wa([USURR 535eg)z2Run a SQL statement and raise OSError if it fails.rz: N)r) returncoderstderrstrip)r&r' error_msgress r run_mysql_stmtr00sA S )C ~~ 2cjj&6&6&8%9:;;rcSUS3n[X!5nURS:Xa URR5(agg)z0Check if a database schema exists on the server.zSHOW DATABASES LIKE '';rTFr)r+stdoutr-)db_namer'qr/s r db_existsr77s> y+A Q 'C ~~szz//11 rcSUSUS3n[X25nURS:Xa URR5(agg)z.Check if a database user exists on the server.z%SELECT 1 FROM mysql.user WHERE User='z ' AND Host='r2rTFr3)usernamehostr'r6r/s r user_existsr;@sD /zdV2NA Q 'C ~~szz//11 rcURS5nU(d [S5e[RU5(d [S5eSU3n[R SU5 [ 5n[X#5(a[SUS35eSUS 3n[XCS 5 [R S U5 S SUS 3US.$![a0n[U5n[RSU5 SUS.sSnA$SnAff=f)z6Create a new logical MySQL database with prefix wolf_.nameDatabase name is requiredAInvalid database name: must contain only alphanumeric/underscoreswolf_z!Attempting to create database: %s Database z already existszCREATE DATABASE z2 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;zFailed to create databasez Database %s created successfullyTz created successfullysuccessmessagedatabasezDatabase creation failed: %sFrCerrorN) get ValueErrorVALID_NAME_PATTERNmatchloginforr7r0 ExceptionstrrG)payloadr=r5r'r&excerr_msgs r handle_database_createrSIs {{6"89 9!''--`a a$. 4g> W % %y AB B  )[\s$?@ 3W="7)+@A   c( 0':   sB=C C: %C5/C:5C:c2URS5nU(d [S5eURS5(d [S5e[R U5(d [S5e[ R SU5 [5n[X5(d[SUS35eS US 3n[X2S 5 [ R S U5 S SUS3US.$![a0n[U5n[ RSU5 SUS.sSnA$SnAff=f)z0Drop a logical MySQL database with prefix wolf_.r=r>r@3Database name must start with 'wolf_' for isolationr?zAttempting to drop database: %srA does not existzDROP DATABASE ;zFailed to drop databasez Database %s dropped successfullyTz dropped successfullyrBzDatabase dropping failed: %sFrFN) rHrI startswithrJrKrLrMrr7r0rNrOrG)rPr=r'r&rQrRs r handle_database_droprYms! {{6"89 9w''RS S!''--`a a 2D9&&yo>? ?tfA&s$=> 3T:"4&(=>   c( 0':   sCC D&%D DDcURS5nURS5nURS5nU(aU(aU(d [S5eURS5(d [S5e[R U5(d [S5eURS5(d [S5e[R U5(d [S 5e[ R S X5 [5n[US U5(a[S US 35e[U5nSUSUS3nUSUSUS3- n[XdS5 [ R SU5 SSUSUS3US.$![aen[U5nSH/n URU 5n U (dMURU S5nM1 [ RSU5 SUS.sS nA$S nAff=f)!zKCreate a database user and assign all privileges on the specified database.r9passwordrEz-username, password, and database are requiredr@.Username must start with 'wolf_' for isolation2 |EF F""7++MN N!''11[\ \ ExP8[&99vhZ/KLM M.|<XJ&CDTCUUWXs$>? CXN4XJ>QR     c($C++c"Cs!//#v6% NPWX    s$DD E3&E.80E.(E3.E3c^ URS5nURS5nURS5nU(aU(aU(d [S5eURS5(d [S5e[R U5(d [S5eURS5(d [S5e[R U5(d [S 5eUR S 5Vs/sH oDR 5R5PM" nn1S km [U 4S jU55(d [S 5eSRU5n[RSXU5 [5n[USU5(d[SUS35e[X'5(d[SUS35eSUSUS3n[X5 SUSUSUS3n [!XS5 [RSXU5 SSUSUS U3US!.$s snf!["a0n [%U 5n [R'S"U 5 S#U S$.sS%n A $S%n A ff=f)&z8Update database user privileges on a specified database.r9rE privilegesz/username, database, and privileges are requiredr@r\r]z.Database must start with 'wolf_' for isolationr?,> ALLDROPALTERINDEXCREATEDELETEINSERTSELECTUPDATEEXECUTE LOCK TABLESALL PRIVILEGESCREATE TEMPORARY TABLESc3*># UH oT;v M g7f)N).0p valid_privss r 5handle_database_user_update_grants..:s7Y #YszInvalid privilege(s) specifiedz, z>Attempting to update grants for database user: %s on %s to: %sr^r_rkrArVzREVOKE ALL PRIVILEGES ON z .* FROM 'rbzGRANT z ON razFailed to update privilegesz3Privileges for %s on %s updated successfully to: %sTzPrivileges for z on database z updated successfully to: rdz*Database user privileges update failed: %sFrFN)rHrIrXrJrKsplitr-upperalljoinrLrMrr;r7r)r0rNrOrG) rPr9rErqr priv_listpriv_strr' revoke_sql grant_sqlrQrRrs @r "handle_database_user_update_grantsrs9< ;;z*;;z*[[. xzNO O""7++MN N!''11[\ \""7++MN N!''11`a a1;0@0@0EF0E1WWY__&0E F 7Y777=> >99Y' QS[gop8[&99vhZ/KLM M**y /BC C1 )H:^\ :.XJd8*GH:^T y*GH F\de( -zIcdlcmn   7GB  c( >H   s1C2H5&H C.H H I %I>I I )r rOreturnrO)r&rOr'rrzsubprocess.CompletedProcess)r&rOr'rr.rOrNone)r5rOr'rrbool)r9rOr:rOr'rrr)rPdictrr) __future__rrrerr$r'rrloggerrrLcompilerJr r)r0r7r;rSrYrirlrorrrr rss" &#$ZZ 238 4<! H# L4 n# L* Z> r