Batch_insert problems

$activities = new ColumnFamily($conn, 'Activities');

$i = 0; $rows = array();

while ($i++ < 101) {

$uuid = CassandraUtil::import(CassandraUtil::uuid1())->string;

$rows[] = array($uuid, array('account_id' => $i, 'type' => $i % 9));

}

$activities->batch_insert($rows);

What's wrong with it?

shouldn't your code within the while loop be:

 

$rows[$i] = array($uuid, array('account_id' => $i; 'type' => $i % 9));

 

?

$rows[$uuid] = array('account_id' => $i, 'type' => $i % 9);

Hi Tyler,

I have similar problems inserting values in cassandra with phpcassa. I am trying to insert following array / Map in PHP to cassandra

Array
(
    [aacb277d-4a80-4bf4-a16b-95bc33309346-Accounts] => Array
        (
            [Zü §aÏC´œµ  ¯^§†] => Zü §aÏC´œµ  ¯^§†
            [³´$ÅD/K½˜› »]ÛL.] => ³´$ÅD/K½˜› »]ÛL.
            [’²mãµÑC]¢ ×5|Â# ] => ’²mãµÑC]¢ ×5|Â# 
        )

    [aacb277d-4a80-4bf4-a16b-95bc33309346-Groups] => Array
        (
            [V«¹À ÓI¨­ ¯n ‘/‚] => V«¹À ÓI¨­ ¯n ‘/‚
            [‚ÈÕSR¼M÷½ XãqÎÕÌ] => ‚ÈÕSR¼M÷½ XãqÎÕÌ
        )

)

It gives me following error

EXCEPTION :: exception 'phpcassa\UUID\UUIDException' with message 'A UUID object or a string representation of a UUID was expected, but '' was found' in
/var/www/osp/Vendor/phpcassa/lib/phpcassa/Schema/DataType/UUIDType.php:27 Stack trace: #0 /var/www/osp/Vendor/phpcassa/lib/phpcassa/AbstractColumnFamily.php(938):
phpcassa\Schema\DataType\UUIDType->pack('Z???a?C??????^?...', true, 0, true) #1 /var/www/osp/Vendor/phpcassa/lib/phpcassa/AbstractColumnFamily.php(1129):
phpcassa\AbstractColumnFamily->pack_name('Z???a?C??????^?...', false, 0, true) #2 /var/www/osp/Vendor/phpcassa/lib/phpcassa/AbstractColumnFamily.php(1106):
phpcassa\AbstractColumnFamily->dict_to_coscs(Array, 1392205635147067, NULL) #3 /var/www/osp/Vendor/phpcassa/lib/phpcassa/AbstractColumnFamily.php(1091):
phpcassa\AbstractColumnFamily->pack_data(Array, 1392205635147067, NULL) #4 /var/www/osp/Vendor/phpcassa/lib/phpcassa/AbstractColumnFamily.php(713):
phpcassa\AbstractColumnFamily->make_mutation(Array, 1392205635147067, NULL) #5 /var/www/osp/app_admin/Model/Myphpcassa.php(141):
phpcassa\AbstractColumnFamily->batch_insert(Array, NULL, NULL, 1) #6 /var/www/osp/app_admin/Model/AdminModel.php(844):
Myphpcassa->batch_insert('AccessControlLi...', Array) #7 /var/www/osp/app_admin/Model/AdminModel.php(663):
AdminModel->linkUserToOtherEntities(Object(phpcassa\UUID), Array) #8 /var/www/osp/app_admin/Controller/AdminController.php(216):
AdminModel->addUpdateUser(Array, 'add') #9 /var/www/osp/app_admin/Controller/AdminController.php(120): AdminController->addUserInfoToDB() #10 [internal
function]: AdminController->adduser() #11 /var/www/osp/cake/lib/Cake/Controller/Controller.php(490): ReflectionMethod->invokeArgs(Object(AdminController),
Array) #12 /var/www/osp/cake/lib/Cake/Routing/Dispatcher.php(185): Controller->invokeAction(Object(CakeRequest)) #13
/var/www/osp/cake/lib/Cake/Routing/Dispatcher.php(160): Dispatcher->_invoke(Object(AdminController), Object(CakeRequest), Object(CakeResponse)) #14
/var/www/osp/app_admin/webroot/index.php(108): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse)) #15 {main}

Any help will be appreciated.

Thanks
Manish

What is your schema?

I suspect the problem is that "aacb277d-4a80-4bf4-a16b-95bc33309346-Accounts" is not a valid UUID string.