Polypheny-DB icon indicating copy to clipboard operation
Polypheny-DB copied to clipboard

Cypher Quality Assurance

Open alyaa999 opened this issue 6 months ago • 0 comments

Final Report: GSoC '24

Student: Alyaa Mamoon
Organization: Polypheny
Mentors: Marc Hennemann, Marco Vogt
Project: Project Proposal

Project Overview

During the GSoC '24 program, I focused on improving the test coverage for the Cypher query language in Polypheny, covering as many features as possible as described in the Polypheny documentation. This enhancement ensures a more robust implementation of Cypher within Polypheny.

Features Covered in Testing

General Clauses

  • CALL procedure
  • CASE
  • FILTER
  • LIMIT
  • ORDER BY
  • SKIP
  • UNION
  • UNWIND
  • WITH

Read Clauses

  • MATCH

Write Clauses

  • DELETE
  • DETACH DELETE
  • INSERT
  • SET
  • FOR EACH
  • MERGE
  • REMOVE

Functions

  • Aggregate Functions (count, max , min , sum , collect , stdev)
  • List Functions(size , range , labels , nodes , relations )
  • Numeric Functions(abs , round , floor , ceil , sqrt )
  • Spatial Functions(cartesian2DPoint - WGS_843DPoint)
  • String Functions(upper , empty , lower , substring ,trim , replace, length)
  • Temporal Functions(date , datetime , time ,duration , duration between)
  • Scaler Functions ( type, id , coalesce)
  • Predicate Functions (exist)

Operators

  • Boolean Operators ( conjunction, disjunction, exclusive disjunction, negation )
  • Comparison Operators( is null , is not null , > , < , <= , >= , = , <>)
  • List Operators(In operator)
  • Mathematical Operators( + , - , * , / , % , ^)
  • String Operators(concatenate)

Subqueries

  • CALL Subqueries
  • COUNT Subqueries
  • EXISTS Subqueries
  • COLLECT Subqueries

I am incredibly grateful for the opportunity to contribute to Polypheny through the GSoC program. I've gained invaluable knowledge and experience.

alyaa999 avatar Aug 19 '24 02:08 alyaa999