Server-side CQL parameters substitution

2011-06-28 Thread Michal Augustýn
Hi all,

in most SQL implementations, it's possible to declare parameters in
SQL command text (i.e. SELECT * FROM T WHERE Id=@myId). Then the
client application sends this SQL command and parameters values
separately - the server is responsible for the parameters
substitution.

In CQL API (~the execute_cql_query method), we must compose the
command (~substitute the parameters) in client application, the same
code must be re-implemented in all drivers (Java, Python, Node.js,
.NET, ...) respectively. And that's IMHO tedious and error prone.

So do you/we plane to improve CQL API in this way?

Thanks!

Augi

P.S.: Yes, I'm working on .NET driver and I'm too lazy to implement
client-side parameters substitution ;-)


Re: Server-side CQL parameters substitution

2011-06-28 Thread aaron morton
see https://issues.apache.org/jira/browse/CASSANDRA-2475

-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 29 Jun 2011, at 08:45, Michal Augustýn wrote:

 Hi all,
 
 in most SQL implementations, it's possible to declare parameters in
 SQL command text (i.e. SELECT * FROM T WHERE Id=@myId). Then the
 client application sends this SQL command and parameters values
 separately - the server is responsible for the parameters
 substitution.
 
 In CQL API (~the execute_cql_query method), we must compose the
 command (~substitute the parameters) in client application, the same
 code must be re-implemented in all drivers (Java, Python, Node.js,
 .NET, ...) respectively. And that's IMHO tedious and error prone.
 
 So do you/we plane to improve CQL API in this way?
 
 Thanks!
 
 Augi
 
 P.S.: Yes, I'm working on .NET driver and I'm too lazy to implement
 client-side parameters substitution ;-)