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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
|
# This file is part of rhizi, a collaborative knowledge graph editor.
# Copyright (C) 2014-2015 Rhizi
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published
# by the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
"""
Neo4j DB object
"""
from enum import Enum
import logging
from neo4j_cypher_parser import Cypher_Parser, e_clause__where, e_keyword, \
e_value
import neo4j_cypher_parser
import neo4j_schema
log = logging.getLogger('rhizi')
class Query_Struct_Type(Enum):
unknown = 1
r = 2
w = 3
rw = 4
def __add__(self, other):
if self == other or self == Query_Struct_Type.rw:
return self
if self == Query_Struct_Type.unknown:
return other
if self == Query_Struct_Type.r and other != Query_Struct_Type.r:
return Query_Struct_Type.rw
if self == Query_Struct_Type.w and other != Query_Struct_Type.w:
return Query_Struct_Type.rw
def __str__(self):
if self == Query_Struct_Type.unknown: return 'unknown'
if self == Query_Struct_Type.r: return 'r'
if self == Query_Struct_Type.w: return 'w'
if self == Query_Struct_Type.rw: return 'rw'
assert False
def __eq__(self, other): # allow comparing against r/w/rw strings
mappings = {'r': Query_Struct_Type.r, 'w':Query_Struct_Type.w , 'rw':Query_Struct_Type.rw}
if other in mappings.keys():
other = mappings[other]
if not isinstance(other, Query_Struct_Type): return False
return super(Query_Struct_Type, self).__eq__(other)
class DB_Query(object):
"""
DB query object
"""
def __init__(self, q_arr, param_set={}):
"""
@param q_str_or_array: cypher query to add - if passed as an array ' '.join(q_str_or_array)
is used to convert it to string type
"""
assert type(q_arr) is list
# establish query type
self.q_str = ' '.join(q_arr) # FIXME: rm
self.pt_root = Cypher_Parser().parse_expression(self.q_str)
self.param_set = param_set
def __str__(self):
return self.pt_root.str__cypher_query()
def __repr__(self):
return 'q: %s, params: %s\n%s' % (self.pt_root.str__cypher_query(),
self.param_set,
self.pt_root.str__struct_tree())
def __iter__(self):
for keyword, clause_set in self.pt_root.index__kw_to_clause_set().items():
yield keyword, clause_set
def t__add_node_filter__meta_label(self):
if Query_Struct_Type.w == self.query_struct_type:
return
meta_label_cond = '0 = length(filter(_lbl in labels(n) where _lbl in {meta_label_set}))' # filter nodes with meta labels
c_set__where = self.pt_root.clause_set_by_kw('where')
if not c_set__where:
c_set__match = self.pt_root.clause_set_by_kw('match')
first_match_clause = c_set__match.pop()
wc = first_match_clause.spawn_sibling__adjacent(e_clause__where)
wc.spawn_child(e_keyword, 'where')
wc.spawn_child(e_value).value = meta_label_cond
else: # where clause present
assert len(c_set__where) == 1, 't__add_node_filter__meta_label: no support for multi-where clauses query transformation'
wc = c_set__where[0]
wc_cond = wc.condition_value
wc.set_condition(meta_label_cond + ' and ' + wc_cond)
self.param_set['meta_label_set'] = neo4j_schema.meta_label_set
@property
def query_struct_type(self):
"""
calc query_structure_type: read|write|read-write
"""
r = False
w = False
for kw, _clause_set in self.pt_root.index__kw_to_clause_set().items():
if kw in neo4j_cypher_parser.tok_set__kw__write:
w = True
if kw == 'match':
r = True
if r and w: return Query_Struct_Type.rw
if r and not w: return Query_Struct_Type.r
if w and not r: return Query_Struct_Type.w
return Query_Struct_Type.unknown
def str__cypher_query(self):
return self.pt_root.str__cypher_query()
class DB_Raw_Query(object):
"""
Raw DB query object which does not undergo parsing
"""
def __init__(self, q_arr, param_set={}):
self.q_arr = q_arr
self.param_set = param_set
def __iter__(self):
for keyword, clause_set in self.pt_root.index__kw_to_clause_set().items():
yield keyword, clause_set
def str__cypher_query(self):
return ' '.join(self.q_arr)
class DB_row(object):
def __init__(self, data):
self.data = data
def __iter__(self):
for column_val in self.data:
yield column_val
def items(self):
return [x for x in self]
def __str__(self):
return str(self.items())
def __repr__(self):
return repr(self.items())
class DB_result_set(object):
def __init__(self, data):
self.data = data
def __iter__(self):
for db_row_dict in self.data['data']:
# example: dict: {u'row': [{u'title': u'foo'}]}
assert None != db_row_dict['row']
yield DB_row(db_row_dict['row'])
def items(self):
return [x for x in self]
|
