FilesExpand file tree

develop

/

Select.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

150 lines (132 loc) · 3.67 KB

develop

/

Select.php

Copy path

Top

File metadata and controls

• Code
• Blame

150 lines (132 loc) · 3.67 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

<?php

/*

* The MIT License (MIT)

*

* Copyright (c) 2015-2021 César Rodas

*

* Permission is hereby granted, free of charge, to any person obtaining a copy

* of this software and associated documentation files (the "Software"), to deal

* in the Software without restriction, including without limitation the rights

* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

* copies of the Software, and to permit persons to whom the Software is

* furnished to do so, subject to the following conditions:

* -

* The above copyright notice and this permission notice shall be included in

* all copies or substantial portions of the Software.

* -

* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR

* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,

* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE

* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER

* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN

* THE SOFTWARE.

*/

namespace SQL;

use SQLParser\Stmt\Expr;

use SQLParser\Stmt\Join;

/**

* Class Select.

*/

class Select extends Statement

{

/**

* @var array

*/

protected $tables = [];

/**

* @var array

*/

protected $columns;

public function __construct(array $expr = null)

{

foreach ($expr as $i => $e) {

if ('VALUE' === $e[0]->getType()) {

$parts = $e[0]->getMembers();

if (2 === \count($parts) && 2 === $parts[1]) {

$expr[$i][0] = new Expr('column', $parts[0]);

}

}

}

$this->columns = $expr;

}

/**

* Adds tables for the current SELECT.

*

* @return $this

*/

public function setTables(array $tables)

{

$this->tables = $tables;

return $this;

}

/**

* Returns whether the current statement has any table.

*

* @return bool

*/

public function hasTable()

{

return !empty($this->tables);

}

/**

* Returns the list of tables associated with this statement.

*

* @return array

*/

public function getTables()

{

return $this->tables;

}

/**

* Returns all the tables in the statement.

*

* This function will return all tables, including JOINs and

* sub-queries.

*

* @return array

*/

public function getAllTables()

{

$tables = $this->tables;

$this->iterate(function ($stmt) use (&$tables) {

if ($stmt instanceof self) {

$tables = array_merge($tables, $stmt->getAllTables());

} elseif ($stmt instanceof Join) {

$tables[] = $stmt->getTable();

}

});

foreach ($tables as $id => $table) {

if ($table instanceof self) {

unset($tables[$id]);

$tables = array_merge($tables, $table->getAllTables());

}

}

return array_unique(array_values($tables));

}

/**

* Adds a table to the current statement.

*

* @param string $table

* @param null|string $alias

*

* @return $this

*/

public function from($table, $alias = null)

{

if (null === $alias) {

$alias = \count($this->tables);

}

$this->tables[$alias] = $table;

return $this;

}

/**

* Returns the list of columns in this statement.

*

* @return null|array

*/

public function getColumns()

{

return $this->columns;

}

}