[ https://issues.apache.org/jira/browse/CASSANDRA-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13088865#comment-13088865 ]
Jonathan Ellis commented on CASSANDRA-3025: ------------------------------------------- Thanks, Mikko. I'd like to see a few more tests: - one demonstrating introspection of default_validation_class - one demonstrating sparse columns across rows in a single resultset (e.g. row 1 has columns A, B, row 2 has columns A, C) [could be the same test as the d_v_c one] - one using UUID column names - one using long column names - one using Counters - one showing all the CQL 1.1 data types in resultset values (Ascii, Boolean, Bytes, Date, Double, Float, Long, UUID, UTF8) (we can leave out [big]integer if there is no reasonable PHP data type corresponding to that) > 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, pdo_cassandra-0.1.1.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