glombard / sbql4j Goto Github PK

any plan/roadmap of having groovy language support 
(http://groovy.codehaus.org) 

As far as I know the current version of SBQLJ does't make it possible to query 
relational databases. Of course, I'am aware of the technical difficulties in 
making a reasonable translator between SBQL and SQL (not to mention HQL), but I 
think I have a simple solution. The solution isn't perfect, but it's probably 
better than no database access at all.

The idea is based on two assumptions:
1) Developers should keep all their SQL code in stored procedures (database 
side). For example, below is a simple script for MySQL:

DELIMITER $$$

CREATE PROCEDURE get_events_for_category(categoryid int)
begin
    select * from event where eventcategoryid = categoryid;
end $$$

CREATE PROCEDURE get_services()
begin
    select * from services;
end $$$

DELIMITER ;

2) You develop a code generator which connects to the database using JDBC, 
reads metadata (names of procedures, names and types of their formal 
parameters, names and types of columns in the result). Based on this 
information you could generate stubs (in the form of classes or interfaces) for 
the Java compiler. The stubs would probably have to be stored on the disk prior 
to compilation, but you could also try to experiment with a more transparent 
solution. For example, store them (the stubs) in memory and perhaps adjust the 
class loader.

In this way you would be able to write something like this:

List<Product> expensiveInStockProducts = #{
    get_products() where unitsInStock > 0 and unitPrice > 3.00
};

Of course, this is rather lame, because selection ("where") would be evaluated 
on the client side, but the programmer should be aware of that (maybe that's 
what he wants). If server-side selection is necessary, the stored procedure 
would look like this:

CREATE PROCEDURE get_products_by_stock_and_price(unitinstock int, unitprice int)
begin
    select * from products where units > unitinstock and price > unitprice;
end;

and the client side accordingly:

List<Product> expensiveInStockProducts = #{ get_products_by_stock_and_price(0, 
3.00) };


It's just brainstorming, but I feel it has some potential. It's simple, quite 
powerful, easy to implement and doesn't compromise performance. Personally, I 
would prefer something like this to ORM. 


Regards

What steps will reproduce the problem?
1. Compare the .s4j file with the .cs file
2. Substantiate this claim stated at the top of the file: "Some advanced 
queries which are difficult (or even impossible) to write in LINQ"

The provided examples of advanced queries are easy to implement in LINQ,
even without leveraging its more advanced operators such as joining on
synthesized keys.  

What steps will reproduce the problem?
1. svn checkout http://sbql4j.googlecode.com/svn/trunk/ sbql4j 
2. sbql4j/SBQL4J/make
3. ant build

What is the expected output? What do you see instead?

It should build. Instead, I get the following error:
BUILD FAILED
/Users/afeng/libs/sbql4j/SBQL4J/make/build.xml:377: The following error 
occurred while executing this line:
/Users/afeng/libs/sbql4j/SBQL4J/make/build.xml:746: Cannot locate bootstrap 
java: please set boot.java.home to its location

What version of the product are you using? On what operating system?
I just check out the code, and was trying to build it on MacOS with JDK 1.6:
JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Versions/1.6/Home

Please provide any additional information below.

Could you please add your library to global maven2 repo?