Issues (107)

src/Mysql.php (13 issues)

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
The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
23
        $this->data['debug'] = $this->debug;
24
        $this->data['action'] = 'add';
25
        $this->cwpuri = 'databasemysql';
0 ignored issues
show
Bug Best Practice introduced by
The property cwpuri does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
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 ignore-call  annotation

26
        return $this->/** @scrutinizer ignore-call */ execCurl();
Loading history...
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
Bug Best Practice introduced by
The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
39
        $this->data['debug'] = $this->debug;
40
        $this->data['action'] = 'del';
41
        $this->cwpuri = 'databasemysql';
0 ignored issues
show
Bug Best Practice introduced by
The property cwpuri does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
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
Bug Best Practice introduced by
The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
54
        $this->data['debug'] = $this->debug;
55
        $this->data['action'] = 'list';
56
        $this->cwpuri = 'databasemysql';
0 ignored issues
show
Bug Best Practice introduced by
The property cwpuri does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
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
Bug Best Practice introduced by
The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
73
        $this->data['debug'] = $this->debug;
74
        $this->data['action'] = 'add';
75
        $this->cwpuri = 'usermysql';
0 ignored issues
show
Bug Best Practice introduced by
The property cwpuri does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
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
Bug Best Practice introduced by
The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
89
        $this->data['debug'] = $this->debug;
90
        $this->data['action'] = 'del';
91
        $this->cwpuri = 'usermysql';
0 ignored issues
show
Bug Best Practice introduced by
The property cwpuri does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
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
Bug Best Practice introduced by
The property data does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
104
        $this->data['debug'] = $this->debug;
105
        $this->data['action'] = 'list';
106
        $this->cwpuri = 'usermysql';
0 ignored issues
show
Bug Best Practice introduced by
The property cwpuri does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.
Loading history...
107
        return $this->execCurl();
108
    }
109
}
110