cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "paul cannon (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-3025) PHP/PDO driver for Cassandra CQL
Date Thu, 18 Aug 2011 23:26:27 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

paul cannon updated CASSANDRA-3025:
-----------------------------------

    Attachment: php_test_results_20110818_2317.txt

So, I found it necessary to symlink pdo.so from my normal php extension dir into modules/,
and run "make test" hijacking the $TESTS variable in order to pass some extra arguments:

{noformat}
  make test TESTS='-d extension=pdo.so'
{noformat}

Not clear whether there's supposed to be an easier way to load a shared pdo lib. Anyway, once
I got the tests to run in what looks like the right way, 9 out of 16 fail. I'm attaching the
test results. Probably it's just some other dumb thing related to this Debian php setup. Or
maybe is this not meant to work against cassandra 0.8.x?

> PHP/PDO driver for Cassandra CQL
> --------------------------------
>
>                 Key: CASSANDRA-3025
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3025
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: API
>            Reporter: Mikko Koppanen
>              Labels: php
>         Attachments: pdo_cassandra-0.1.0.tgz, php_test_results_20110818_2317.txt
>
>
> Hello,
> attached is the initial version of the PDO driver for Cassandra CQL language. This is
a native PHP extension written in what I would call a combination of C and C++, due to PHP
being C. The thrift API used is the C++.
> The API looks roughly following:
> {code}
> <?php
> $db = new PDO('cassandra:host=127.0.0.1;port=9160');
> $db->exec ("CREATE KEYSPACE mytest with strategy_class = 'SimpleStrategy' and strategy_options:replication_factor=1;");
> $db->exec ("USE mytest");
> $db->exec ("CREATE COLUMNFAMILY users (
> 			my_key varchar PRIMARY KEY,
> 			full_name varchar );");
> 			
> $stmt = $db->prepare ("INSERT INTO users (my_key, full_name) VALUES (:key, :full_name);");
> $stmt->execute (array (':key' => 'mikko', ':full_name' => 'Mikko K' ));
> {code}
> Currently prepared statements are emulated on the client side but I understand that there
is a plan to add prepared statements to Cassandra CQL API as well. I will add this feature
in to the extension as soon as they are implemented.
> Additional documentation can be found in github https://github.com/mkoppanen/php-pdo_cassandra,
in the form of rendered MarkDown file. Tests are currently not included in the package file
and they can be found in the github for now as well.
> I have created documentation in docbook format as well, but have not yet rendered it.
> Comments and feedback are welcome.
> Thanks,
> Mikko

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message