NestedSets/DbMysql.interface.php at master · divampo/NestedSets · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?
/**
 * MySQL DB connection interface
 *
 * @author Willfred di Vampo <divampo@gmail.com>
 * @date 2012-04-02
 * @package MediaCore
 * @category Db
 * @namespace MediaCore\Lib\Db\connectors
 * @copyright Copyright (c), 2012
 */
namespace MediaCore\Lib\Db\connectors;

interface  DbMysql {
	/**
	 * DB connect
	 *
	 * @access public
	 *
	 * @return resource connection link
	 */
	public function connect();

	/**
	 * Disconnect from DB
	 *
	 * @access public
	 *
	 * @return viod
	 */
	public function disconnect();

	/**
	 * Free result
	 *
	 * @access public
	 * @param resource $result query resourse
	 *
	 * @return viod
	 */
	public function free($result);

	/**
	 * Execute simple query
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return resource|bool query result
	 */
	public function query($sql, array $args = array());

	/**
	 * Insert query method
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return int|false last insert id
	 */
	public function insert($sql, array $args = array());

	/**
	 * Update query method
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return int|false affected rows
	 */
	public function update($sql, array $args = array());

	/**
	 * Get all query result rows as associated array
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return array associated data array (two level array)
	 */
	public function getAll($sql, array $args = array());

	/**
	 * Get all query result rows as associated array with first field as row key
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return array associated data array (two level array)
	 */
	public function getAssoc($sql, array $args = array());

	/**
	 * Get only first row from query
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return array associated data array
	 */
	public function getRow($sql, array $args = array());

	/**
	 * Get first column of query result
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return array one level data array
	 */
	public function getCol($sql, array $args = array());

	/**
	 * Get one first field value from query result
	 *
	 * @access public
	 * @param string $sql SQL query
	 * @param array $args query arguments
	 *
	 * @return string field value
	 */
	public function getOne($sql, array $args = array());
}