/opt/dedrads/cms_tools/__pycache__
Edit: /opt/dedrads/cms_tools/__pycache__/db.cpython-313.pyc (21057B)
}jG S r SSKrSSKrSSKrSSKrSSKrSSKJr SSKJ r J
r
J r J r J
r
JrJrJrJrJrJr SSKJrJr \R. " \5 rS rS rSS jr S
r S r S r S
r S r!S r"S r#S r$g)z(Database functions for working with CMS. N)
prompt_y_n ) common_get_stringmake_valid_db_name import_dbdump_db db_existsdb_user_exists create_dbcreate_db_userchange_db_passassociate_db_user
get_mysql_err) CMSStatusCMSErrorc [ R SXR 5 U R nX R ; a [ U R
U R U R U R S5 nU( dE U R [ R SU R - 5 [ SU R - 5 e[ R SU5 X0R U' [ U R
U R U R U5 $ )zK
Import database, using known credentials.
Also, make backup if necessary.
z Attempting to import %s into %scms_tools_backupzUnable to backup %szModifying database %s)LOGGERdebugdb_name modified_dbsr db_userdb_passdirectory_root
set_statusr criticalr infor )the_cms
database_filedatabase dump_files /opt/dedrads/cms_tools/db.py
import_cms_dbr# ! s LL)=// H+++ OO OO OO " "
""$9GOO$K
07??BC C +X6)2 X& '//= c [ R S5 [ R " U R U R
U R U R S9 nUR 5 nUR S5 S:X a SSS5 SSS5 g SSS5 SSS5 g! , ( d f N= f! , ( d f g= f! [ R a! n[ R S5 Us SnA$ SnAff = f)z0
Test the database connection and return errors
zTesting db connectionhostuserpasswordr SHOW TABLESr NzConnection error) r r pymysqlconnectdb_hostr r r cursorexecuteError)r connr. errs r" test_db_connectionr3 C s LL()
__ __ __
&>>-0A5
6
== '(
s_ ?C B2'B!>B2C B2C !
B/ +B22
C <C C C8C3-C83C8c U R [ R : a! [ R SU R
5 gUS:X a US:w a [ R
S5 SnU R R SS5 nSU UR SS5 S3nSUR SS5 S3nUS:X a SU SU S 3nSn O%SUR SS5 S3n
U4n SU SU S
U
S 3n [ R " U R U R U R U R
S 9 n U R 5 n U R X5 n
U
S
: a SSS5 SSS5 gU R! 5 S sSSS5 sSSS5 $ ! , ( d f O= f SSS5 g! , ( d f g= f! [ R" a n[ R U5 SnAgSnAff = f)zJ
Search database returning specific field with optional search parameters
zBDatabase %s has not yet been confrmed working, but query attemptedN z(Search field given, but no pattern given`z``zSELECT z FROM ;z WHERE z LIKE %sr& r r )statusr db_has_matching_tablesr errorr warningdb_prefreplacer+ r, r- r r r. r/ fetchallr0 )r fieldtable search_fieldsearch_patternprefix
escaped_table
escaped_fieldqueryargsescaped_searchr1 r. resultr2 s r" simple_queryrJ X s
~~ 888
" OO
2 NNE F L
__
$
$S$
/Fx
c4 8 9;M
c4013M- }oQ? \ 1 1#t < =Q? m_F=/ :#$H
.
__ __ __
& 4A:
(+
== Ssf %?F0 $F 5FF F0 F1 F : F0
F F F0
F-)F0 -F0 0G#G G#c [ R " SU R S[ U R 5 -
4- U R 5 ( Gd [
R
SU R 5 [ U R U R U R SS9nSUL a [ SSU R S[ U R 5 -
4- 5 nSULaO U R SU5 ( d g U R S5 U l [
R
S
U R 5 O[
R S U R 5 g U R S : d [ S
U- 5 ( aO U R SU5 ( d g U R S5 U l [
R
S
U R 5 OZ[ SS5 nU R SU5 ( d g U R S5 U l [
R
S
U R 5 [ U R U R 5 ( d U R S : d [ SU R - 5 ( a [! U R U R U R" 5 [ U R U R 5 ( d. U R% [& R SU R - 5 g O.U R% [& R SU R - 5 g [) U 5 nUc [
R+ S5 gSUS :X a U R S : d [ SU R - 5 ( aQ [- U R U R U R" 5 ( d [
R SU R 5 g[
R SU R 5 g SUS :X a gUu p4[
R
SUU5 g) z9
Check whether the database user and password is correct
%s_[a-z0-9]{1,%d} z%Database username '%s' is not correctr( name_typeNz What new name would you like? r FzUsername set to %szUsername '%s' not reset!r zSet name to %s? z Use what database user name: r z-Database user '%s' does not exist. Create it?z#Failed to create database user '%s'zCould not create %szAuthorization fixedT r z/Password for user '%s' doesn't match. Reset it?z Could reset password for %s.z Could not fix password for %s. zLDatabase connection failing. Can't check username. Receiving error:
(%d): %s)rematchdbprefixlenr r r r cpuserr set_variable get_variabler: ilevelr r
r r r r r3 r r
r new_namerI errnosterrors r"
check_db_authr^ sK 88w / /c':J:J6K1K LL ;W__M% NNG , ,goo
8 )0###R#g.>.>*?%?@AH
8# ++Ix@@ ")"6"6y"A 0'//B 7 I
~~!Z0BX0M%N%N ++Ix@@ ")"6"6y"A 0'//B,3Z ++Ix@@ ")"6"6y"A 0'//B '..'// : : >>A ;goo M"
"
7>>7??GOO L "'..'//BB"" OO9GOOK C
!6 !H
(F
~ *+ vay >>A = O"
"
" ;W__M 5wG vay U
KK % r$ c [ R " SU R S[ U R 5 -
4- U R 5 ( Gd [
R
SU R 5 [ U R U R U R 5 nSUL a [ SSU R S[ U R 5 -
4- 5 nSULaO U R SU5 ( d gU R S5 U l [
R
SU R 5 OU R [ R S 5 gU R S
: d [! S U- 5 ( aO U R SU5 ( d gU R S5 U l [
R
SU R 5 OZ[ S S
5 nU R SU5 ( d gU R S5 U l [
R
SU R 5 [# U R U R 5 ( d U R S
: d [! SU R - 5 ( at [% U R U R 5 [# U R U R 5 ( d. U R [ R SU R - 5 gO!U R [ R S5 g[' U 5 nUc [
R) S5 g[+ U5 u p4US; a# [
R SU R UU5 g[
R) S5 U R S
: d- [! SU R, < SU R < S35 ( a, [/ U R U R U R, 5 gU R [ R S5 [
R1 S5 g)z?
Check whether the database exists and the user has privileges
rL rM z!Database name '%s' is not correctNz'What new database name would you like? r FzDatabase name set to %szDatabase name not correctr zSet name to %s?zUse what database name: r z(Database '%s' does not exist. Create it?z Failed to create database '%s'z Database could not be createdzDatabase connection fixed.TrQ i z2Still could not connect to '%s'. New error: %d: %sz=The database exists, but the user cannot access the database.zAssociate database user 'z' with database 'z'?z"Could not associate database user.)rR rS rT rU r r r r rV r rW rX r r r: rY r r r r3 r r r r r; rZ s r" check_db_accessra s: 88w / /c':J:J6K1K LL 7 I% NNG , ,goo
8 )9###R#g.>.>*?%?@AH
8# ++Ix@@ ")"6"6y"A 5wG""9??4OP
~~!Z0AH0L%M%M ++Ix@@ ")"6"6y"A 5wG,.
++Ix@@ ")"6"6y"A 5wG W^^W__ 5 5 >>A 6 H"
"
gnngoo 6 W^^W__=="" OO4wF >
y0O P
(F
~ 12"6*NE L @ OO
LLG
~~Z ??GOO - '..'//7??K
OO A
;<r$ c
U R [ R : a! [ R SU R
5 gSU R :w a [ R SU R 5 U R S: d [ S5 ( aC U R SS5 ( d gU R S5 U l [ R S5 [ U 5 nUc [ R S
5 g [ U5 S $ ) z`
Check for database connection errors.
Return None if no error or number if there was an errror
6Database credentials haven't been set. Last status: %s localhost Databse host is set to '%s'.r Set database host to localhost?r- Database host has been fixedNzDatabase connection workingr )r8 r db_is_setr r; reasonr- r rY r rW rX r r3 r )r rI s r" check_db_errorrk ] s ~~ +++ D NN
goo% 2GOOD >>A ,M!N!N'' ;?? % 2 29 =GO LL7 8
(F
~ 23 ##r$ c ~ Uc gUS:X a g[ R SU R 5 US:X a [ R S5 [ U 5 $ US; a [ R S5 [ U 5 $ US :X a [ R S
5 g[ R S 5 [ R U5 g) 2
Check whether the database connection is working
Trd Fz!There was a database error for %srP z%The username or password is incorrectr` z#The user cannot access the databasei z>MySQL server has gone away. May need to be researched manuallyzUnknown error.)r r r r^ ra r: )r error_numbers r" fix_db_errorro ~ s
r
KK3W__Et ;< W%%|# 9: w''t L
LL!"
LL r$ c U R [ R : a! [ R SU R
5 gSU R :w a [ R SU R 5 U R S: d [ S5 ( aC U R SS5 ( d gU R S5 U l [ R S5 [ U 5 nS nS
ULaZ [ X5 ( d [ R S U5 gUS-
nUS : a [ R S
5 g[ U 5 nS
ULa MZ U R! [ R" S5 g)rm rc Fre rf r rg r- rh r Nz#Could not resolve database error %s
z$Too many database errors. Giving up.z Database confirmed connectedT)r8 r ri r r; rj r- r rY r rW rX r rk ro r: r db_is_connecting)r db_errorcounts r" check_dbru s' ~~ +++ D NN
goo% 2GOOD >>A ,M!N!N'' ;?? % 2 29 =GO LL7 8 g&H
E
h
G.. KK=x H
2: LL? @!'* h
""$B r$ c . U R [ R : a& [ U 5 ( d [ R S5 g [ R " U R U R U R U R S9 nUR 5 nUR S5 S:X a= [ R SU R 5 [ U 5 sSSS5 sSSS5 $ U R! [ R" S5 UR S U R$ 45 nUS:X aH [ R S
U R U R$ 5 [ U 5 sSSS5 sSSS5 $ SSS5 SSS5 U R! [ R* S R- U R U R$ 5 5 g
! , ( d f N[= f! , ( d f Nd= f! [ R& a n[) S U 35 UeSnAff = f)zt
Check database to ensure that is not empty, and that it has tables
matching the prefix. If not, attempt to import.
zGDatabase has not been confirmed to connect. Cannot check database data.Fr& r* r zNo tables in '%s'NzDatabase has tableszSHOW TABLES LIKE %s%%z
>-0A5KK 3W__E'0
"" ++-B +goo-? A:KK= (0#
4 ((<CC OOW__
5
0 == @/u56C?@sn ?G, GA G
G G, )A8G
! G* G, 5G=G,
G G
G)%G, )G, ,H HHc [ U R U R U R 5 n[ U R U R U R
SS9nU R
SU5 U R
SU5 g)zQ
Set database name and database user names to proper names
which fit with cPanel
r( rN r r N)r rV rT r dbuserr rW )r new_db_name new_db_users r" fix_db_namesr sh %(('//K %(('//VK K0 K0r$ c
j U R [ R : a& [ U 5 ( d [ R S5 g/ nU R U R 4 H nU R H n[ R " [ R R USU- 5 5 H] nXA; a M
UR U5 U R S: d# [ SU SU R S35 ( d MN [! X5 s s s $ M M U R S: df [# SU R - S S
9nUbL [ R R% U5 ( a [! X5 $ [# S U R S 3S S
9nUb ML U R' [ R
S
U R 35 g)z%
Attempt to find and import database
z5Database not confirmed connecting. Cannot import dataFz*%s*.sqlr zImport z in to ?z-Please specify a database to import into %s: N)defaultz=File does no exist. Please specify a database to import into z: z%Could not find a database export for )r8 r rr ru r r; orig_db_namer db_file_search_pathglobospathjoinappendrY r r# r isfiler )r found_filesdbname
the_directorydb_files r" rw rw s
~~ 222 NNG
K'' 9 $ 8 8M 99 ]J,?@ ) ""7+>>A% gYggoo->a@* * ):: 9 : >>A #
"$+OO
4
!ww~~g&&$W66'++2??*;2? G !
//@A r$ )r5 r5 )%__doc__r rR loggingr r+ radsr helpersr r r r r r
r r r
r r cmsr r getLogger__name__r r# r3 rJ r^ ra rk ro ru rz r rw r$ r" r s .
%
8 $ D*-`eVdT$BB'Z/d1*/r$