Class: Neo4j::Core::Query

Inherits:

Object

• Object
• Neo4j::Core::Query

show all

Includes:

Enumerable, QueryClauses, QueryFindInBatches

Defined in:

lib/neo4j-core/query.rb

Overview

Constant Summary

METHODS =

DELETE clause

Returns:

• (Query)

%w(with start match optional_match using where set create create_unique merge on_create_set on_match_set remove unwind delete return order skip limit)

CLAUSES =

METHODS.map { |method| const_get(method.split('_').map(&:capitalize).join + 'Clause') }

MEMOIZED_INSTANCE_VARIABLES =

[:response, :merge_params]

Instance Method Summary (collapse)

• - (Object) &(other)
• - (Object) break

  Allows what's been built of the query so far to be frozen and the rest built anew.

• - (Object) copy
• - (Query) create(*args)

  CREATE clause.

• - (Query) create_unique(*args)

  CREATE UNIQUE clause.

• - (Query) delete(*args)

  DELETE clause.

• - (Object) each
• - (Boolean) exec

  Executes a query without returning the result.

• - (Query) initialize(options = {}) constructor

  A new instance of Query.

• - (Query) limit(*args)

  LIMIT clause.

• - (Query) match(*args)

  MATCH clause.

• - (Query) merge(*args)

  MERGE clause.

• - (Query) on_create_set(*args)

  ON CREATE SET clause.

• - (Query) on_match_set(*args)

  ON MATCH SET clause.

• - (Query) optional_match(*args)

  OPTIONAL MATCH clause.

• - (Query) order(*args) (also: #order_by)

  ORDER BY clause.

• - (Object) params(args)

  Allows for the specification of values for params specified in query.

• - (Object) pluck(*columns)

  Return the specified columns as an array.

• - (Query) remove(*args)

  REMOVE clause.

• - (Object) reorder(*args)

  Clears out previous order clauses and allows only for those specified by args.

• - (Object) response
• - (Query) return(*args)

  RETURN clause.

• - (Object) return_query(columns)
• - (Query) set(*args)

  SET clause.

• - (Object) set_props(*args)

  Works the same as the #set method, but when given a nested array it will set properties rather than setting entire objects.

• - (Query) skip(*args) (also: #offset)

  SKIP clause.

• - (Query) start(*args)

  START clause.

• - (Array) to_a

  Class is Enumerable.

• - (String) to_cypher

  Returns a CYPHER query string from the object query representation.

• - (String) union_cypher(other, options = {})

  Returns a CYPHER query specifying the union of the callee object's query and the argument's query.

• - (Query) unwind(*args)

  UNWIND clause.

• - (Query) using(*args)

  USING clause.

• - (Query) where(*args)

  WHERE clause.

• - (Query) with(*args)

  WITH clause.

Methods included from QueryFindInBatches

#find_each, #find_in_batches

18
19
20
21
22
23
24

# File 'lib/neo4j-core/query.rb', line 18

def initialize(options = {})
  @session = options[:session] || Neo4j::Session.current

  @options = options
  @clauses = []
  @_params = {}
end

274
275
276
277
278
279
280
281

# File 'lib/neo4j-core/query.rb', line 274

def &(other)
  fail "Sessions don't match!" if @session != other.session

  self.class.new(session: @session).tap do |new_query|
    new_query.options = options.merge(other.options)
    new_query.clauses = clauses + other.clauses
  end.params(other._params)
end

# Creates a query representing the cypher: MATCH (q:Person), r:Car MATCH (p: Person)-->q
Query.new.match(q: Person).match('r:Car').break.match('(p: Person)-->q')

138
139
140

# File 'lib/neo4j-core/query.rb', line 138

def break
  build_deeper_query(nil)
end

284
285
286
287
288
289
290

# File 'lib/neo4j-core/query.rb', line 284

def copy
  dup.tap do |query|
    MEMOIZED_INSTANCE_VARIABLES.each do |var|
      query.instance_variable_set("@#{var}", nil)
    end
  end
end

# File 'lib/neo4j-core/query.rb', line 78

# File 'lib/neo4j-core/query.rb', line 82

102

# File 'lib/neo4j-core/query.rb', line 102

METHODS = %w(with start match optional_match using where set create create_unique merge on_create_set on_match_set remove unwind delete return order skip limit)

170
171
172
173
174
175
176
177

# File 'lib/neo4j-core/query.rb', line 170

def each
  response = self.response
  if response.is_a?(Neo4j::Server::CypherResponse)
    response.to_node_enumeration
  else
    Neo4j::Embedded::ResultWrapper.new(response, to_cypher)
  end.each { |object| yield object }
end

188
189
190
191
192

# File 'lib/neo4j-core/query.rb', line 188

def exec
  response

  true
end

# File 'lib/neo4j-core/query.rb', line 54

# File 'lib/neo4j-core/query.rb', line 30

# File 'lib/neo4j-core/query.rb', line 86

# File 'lib/neo4j-core/query.rb', line 90

# File 'lib/neo4j-core/query.rb', line 94

# File 'lib/neo4j-core/query.rb', line 34

# File 'lib/neo4j-core/query.rb', line 50

# Creates a query representing the cypher: MATCH (q: Person {id: {id}})
# Calls to params don't affect the cypher query generated, but the params will be
# Passed down when the query is made
Query.new.match('(q: Person {id: {id}})').params(id: 12)

149
150
151
152
153

# File 'lib/neo4j-core/query.rb', line 149

def params(args)
  @_params = @_params.merge(args)

  self
end

Query.new.match(n: :Person).return(p: :name}.pluck(p: :name) # => Array of names

Query.new.match(n: :Person).return(p: :name}.pluck('p, DISTINCT p.name') # => Array of [node, name] pairs

203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220

# File 'lib/neo4j-core/query.rb', line 203

def pluck(*columns)
  query = return_query(columns)
  columns = query.response.columns

  case columns.size
  when 0
    fail ArgumentError, 'No columns specified for Query#pluck'
  when 1
    column = columns[0]
    query.map { |row| row[column] }
  else
    query.map do |row|
      columns.map do |column|
        row[column]
      end
    end
  end
end

# File 'lib/neo4j-core/query.rb', line 66

119
120
121
122
123
124

# File 'lib/neo4j-core/query.rb', line 119

def reorder(*args)
  query = copy

  query.remove_clause_class(OrderClause)
  query.order(*args)
end

155
156
157
158
159
160
161
162
163
164
165
166

# File 'lib/neo4j-core/query.rb', line 155

def response
  return @response if @response
  cypher = to_cypher
  @response = ActiveSupport::Notifications.instrument('neo4j.cypher_query', context: @options[:context] || 'CYPHER', cypher: cypher, params: merge_params) do
    @session._query(cypher, merge_params)
  end
  if !response.respond_to?(:error?) || !response.error?
    response
  else
    response.raise_cypher_error
  end
end

# File 'lib/neo4j-core/query.rb', line 74

222
223
224
225
226
227
228
229
230
231
232
233
234
235

# File 'lib/neo4j-core/query.rb', line 222

def return_query(columns)
  query = copy
  query.remove_clause_class(ReturnClause)

  columns = columns.map do |column_definition|
    if column_definition.is_a?(Hash)
      column_definition.map { |k, v| "#{k}.#{v}" }
    else
      column_definition
    end
  end.flatten.map(&:to_sym)

  query.return(columns)
end

# File 'lib/neo4j-core/query.rb', line 62

# Creates a query representing the cypher: MATCH (n:Person) SET n.age = 19
Query.new.match(n: :Person).set_props(n: {age: 19})

130
131
132

# File 'lib/neo4j-core/query.rb', line 130

def set_props(*args)
  build_deeper_query(SetClause, args, set_props: true)
end

# File 'lib/neo4j-core/query.rb', line 58

# File 'lib/neo4j-core/query.rb', line 26

# File 'lib/neo4j-core/query.rb', line 179

Query.new.match(p: :Person).where(p: {age: 30})  # => "MATCH (p:Person) WHERE p.age = 30

242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258

# File 'lib/neo4j-core/query.rb', line 242

def to_cypher
  cypher_string = partitioned_clauses.map do |clauses|
    clauses_by_class = clauses.group_by(&:class)

    cypher_parts = CLAUSES.map do |clause_class|
      clauses = clauses_by_class[clause_class]

      clause_class.to_cypher(clauses) if clauses
    end

    cypher_string = cypher_parts.compact.join(' ')
    cypher_string.strip
  end.join ' '

  cypher_string = "CYPHER #{@options[:parser]} #{cypher_string}" if @options[:parser]
  cypher_string.strip
end

# Generates cypher: MATCH (n:Person) UNION MATCH (o:Person) WHERE o.age = 10
q = Neo4j::Core::Query.new.match(o: :Person).where(o: {age: 10})
result = Neo4j::Core::Query.new.match(n: :Person).union_cypher(q)

270
271
272

# File 'lib/neo4j-core/query.rb', line 270

def union_cypher(other, options = {})
  "#{to_cypher} UNION#{options[:all] ? ' ALL' : ''} #{other.to_cypher}"
end

# File 'lib/neo4j-core/query.rb', line 70

# File 'lib/neo4j-core/query.rb', line 38

# File 'lib/neo4j-core/query.rb', line 42

# File 'lib/neo4j-core/query.rb', line 46