1 | <?php |
||||
2 | |||||
3 | namespace Puerari\Cwp; |
||||
4 | |||||
5 | /** |
||||
6 | * @trait Mysql |
||||
7 | * @package Puerari\Cwp |
||||
8 | * @author Leandro Puerari <[email protected]> |
||||
9 | */ |
||||
10 | trait Mysql |
||||
11 | { |
||||
12 | /** |
||||
13 | * @param string $user : Account username |
||||
14 | * @param string $database : Data Base Name (Max 8 Characters) |
||||
15 | * @return string|bool: false on failure, result on success (JSON / XML) |
||||
16 | * status -> OK |
||||
17 | * status -> Error, msj -> Duplicate data base name |
||||
18 | * status -> Error, msj -> Mysql Package Exhausted |
||||
19 | */ |
||||
20 | public function createMysqlDatabase(string $user, string $database) |
||||
21 | { |
||||
22 | $this->data = compact('user', 'database'); |
||||
0 ignored issues
–
show
Bug
Best Practice
introduced
by
![]() |
|||||
23 | $this->data['debug'] = $this->debug; |
||||
24 | $this->data['action'] = 'add'; |
||||
25 | $this->cwpuri = 'databasemysql'; |
||||
0 ignored issues
–
show
|
|||||
26 | return $this->execCurl(); |
||||
0 ignored issues
–
show
It seems like
execCurl() must be provided by classes using this trait. How about adding it as abstract method to this trait?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() |
|||||
27 | } |
||||
28 | |||||
29 | /** |
||||
30 | * @param string $user : Account username |
||||
31 | * @param string $database : Data Base Name (Max 8 Characters) |
||||
32 | * @return string|bool: false on failure, result on success (JSON / XML) |
||||
33 | * status -> OK, msj -> Deleted database |
||||
34 | * status -> Error, can not delete database as root |
||||
35 | */ |
||||
36 | public function deleteMysqlDatabase(string $user, string $database) |
||||
37 | { |
||||
38 | $this->data = compact('user', 'database'); |
||||
0 ignored issues
–
show
|
|||||
39 | $this->data['debug'] = $this->debug; |
||||
40 | $this->data['action'] = 'del'; |
||||
41 | $this->cwpuri = 'databasemysql'; |
||||
0 ignored issues
–
show
|
|||||
42 | return $this->execCurl(); |
||||
43 | } |
||||
44 | |||||
45 | /** |
||||
46 | * @param string $user : Account username |
||||
47 | * @return string|bool: false on failure, result on success (JSON / XML) |
||||
48 | * status -> OK, msj -> array |
||||
49 | * status -> OK, msj -> No packages found |
||||
50 | */ |
||||
51 | public function listMysqlDatabases(string $user) |
||||
52 | { |
||||
53 | $this->data = compact('user'); |
||||
0 ignored issues
–
show
|
|||||
54 | $this->data['debug'] = $this->debug; |
||||
55 | $this->data['action'] = 'list'; |
||||
56 | $this->cwpuri = 'databasemysql'; |
||||
0 ignored issues
–
show
|
|||||
57 | return $this->execCurl(); |
||||
58 | } |
||||
59 | |||||
60 | /** |
||||
61 | * @param string $user : Account username |
||||
62 | * @param string $userdb : Database User |
||||
63 | * @param string $pass : Password for the database user |
||||
64 | * @param string $dbase : Data Base Name (Max 8 Characters) |
||||
65 | * @param string $host : Name Host (%, localhost, IP) |
||||
66 | * @return string|bool: false on failure, result on success (JSON / XML) |
||||
67 | * status -> OK |
||||
68 | * status -> Error, msj -> User already exists |
||||
69 | */ |
||||
70 | public function createMysqlUser(string $user, string $userdb, string $pass, string $dbase, string $host = 'localhost') |
||||
71 | { |
||||
72 | $this->data = compact('user', 'userdb', 'pass', 'dbase', 'host'); |
||||
0 ignored issues
–
show
|
|||||
73 | $this->data['debug'] = $this->debug; |
||||
74 | $this->data['action'] = 'add'; |
||||
75 | $this->cwpuri = 'usermysql'; |
||||
0 ignored issues
–
show
|
|||||
76 | return $this->execCurl(); |
||||
77 | } |
||||
78 | |||||
79 | /** |
||||
80 | * @param string $user : Account username |
||||
81 | * @param string $userdb : Database User |
||||
82 | * @param string $host : Name Host (%, Localhost, IP) |
||||
83 | * @return string|bool: false on failure, result on success (JSON / XML) |
||||
84 | * status -> OK |
||||
85 | */ |
||||
86 | public function deleteMysqlUser(string $user, string $userdb, string $host) |
||||
87 | { |
||||
88 | $this->data = compact('user', 'userdb', 'host'); |
||||
0 ignored issues
–
show
|
|||||
89 | $this->data['debug'] = $this->debug; |
||||
90 | $this->data['action'] = 'del'; |
||||
91 | $this->cwpuri = 'usermysql'; |
||||
0 ignored issues
–
show
|
|||||
92 | return $this->execCurl(); |
||||
93 | } |
||||
94 | |||||
95 | /** |
||||
96 | * @param string $user : Account username |
||||
97 | * @return string|bool: false on failure, result on success (JSON / XML) |
||||
98 | * status -> OK, msj -> Array of database users |
||||
99 | * status -> Error, msj -> User does not exist |
||||
100 | */ |
||||
101 | public function listMysqlUsers(string $user) |
||||
102 | { |
||||
103 | $this->data = compact('user'); |
||||
0 ignored issues
–
show
|
|||||
104 | $this->data['debug'] = $this->debug; |
||||
105 | $this->data['action'] = 'list'; |
||||
106 | $this->cwpuri = 'usermysql'; |
||||
0 ignored issues
–
show
|
|||||
107 | return $this->execCurl(); |
||||
108 | } |
||||
109 | } |
||||
110 |