Discussion:
[castor-dev] [GSoC 2010] refactoring OQL to SQL project - student introduction
Adam Witkowski
2010-04-07 00:50:50 UTC
Permalink
Hi,
My name is Adam Witkowski and I'm interested in working on Castor JDO
project for Google Summer of Code this year.
I'm studying computer science and physics at University of Warsaw in Poland
(currently 4th year).

I'm interested in working on "Refactor transformation of OQL to SQL queries"
project.

Project description:
Aim of this project is to improve SQL generation from OQL queries. Current
parser is not easily extendable,
new parser for CastorQL and EJBQL queries has been created, along with
classes representing the queries (like Condition,

What is already done:
OQL queries are parsed and represented as objects from org.castor.cpa.query
package

What needs to be done:
1. Query validation :
a) Checking if all fields are defined in the mapping
b) Type checking
2. SQL generation
I think this is the main part of the project and it will require most work.

of course I'll provide javadoc and tests for created code.

Possible extensions:
1. Adding sub-queries to supported OQL syntax
2. 'Filtering' QueryResults using query conditions/limits, which would allow
to execute queries independently of underlying RDBMS

During the GSoC period, besides the main part of the project, I'd like to
implement at least one of those extensions.

What I want to learn from this project:
I'd like to gain experience in open software development
and learn more on object-to-relational mapping issues.

Transforming OQL to SQL looks like a potentially challenging problem,
requiring not only good coding skills, but also good deal of problem-solving

which is something I enjoy.

I'll gladly welcome any comments/feedback
Best regards,
Adam Witkowski

Loading...