コード例 #1
0
ファイル: Storage.php プロジェクト: rdohms/aggregatein
 /**
  * Store an Aggregation in DB
  *
  * @param \Agg\Entity\Aggregation $aggregation
  */
 public function storeAggregation($aggregation)
 {
     //Generate unique slug
     $slug = $this->getUniqueSlug($this->slugify($aggregation->getTitle()));
     $aggregation->setSlug($slug);
     $entity = new Entity();
     $entity->setPartitionKey("talk");
     $entity->setRowKey($slug);
     $entity->addProperty("slug", EdmType::STRING, $aggregation->getSlug());
     $entity->addProperty("title", EdmType::STRING, $aggregation->getTitle());
     $entity->addProperty("talks", EdmType::STRING, serialize($aggregation->getTalks()));
     $entity->addProperty("speakerName", EdmType::STRING, $aggregation->getSpeakerName());
     $entity->addProperty("speakerUrl", EdmType::STRING, $aggregation->getSpeakerUrl());
     try {
         $this->tableProxy->insertEntity(self::TABLE_AGGREGATION, $entity);
     } catch (ServiceException $e) {
         $code = $e->getCode();
         $error_message = $e->getMessage();
         echo $code . ": " . $error_message . "<br />";
     }
 }
コード例 #2
0
 public static function setSettings($tenant, $settings)
 {
     $entity = new Entity();
     $entity->setPartitionKey($tenant);
     $entity->setRowKey("settings");
     foreach ($settings as $name => $value) {
         $entity->addProperty($name, null, $value);
     }
     try {
         self::$tableRestProxy->insertOrMergeEntity(self::$table, $entity);
     } catch (ServiceException $e) {
         $code = $e->getCode();
         $error_message = $e->getMessage();
         $app->error("Something went wrong when trying to save your configuration. Please try again later.");
     }
 }
コード例 #3
0
 public static function getTestEntity($partitionKey, $rowKey)
 {
     $entity = new Entity();
     $entity->setPartitionKey($partitionKey);
     $entity->setRowKey($rowKey);
     $entity->addProperty('CustomerId', EdmType::INT32, 890);
     $entity->addProperty('CustomerName', null, 'John');
     $entity->addProperty('IsNew', EdmType::BOOLEAN, true);
     $entity->addProperty('JoinDate', EdmType::DATETIME, Utilities::convertToDateTime('2012-01-26T18:26:19.0000473Z'));
     return $entity;
 }
コード例 #4
0
//rowkey를 위해 guid 생성
function getGUID()
{
    if (function_exists('com_create_guid')) {
        return com_create_guid();
    } else {
        mt_srand((double) microtime() * 10000);
        //optional for php 4.2.0 and up.
        $charid = strtoupper(md5(uniqid(rand(), true)));
        $hyphen = chr(45);
        // "-"
        $uuid = chr(123) . substr($charid, 0, 8) . $hyphen . substr($charid, 8, 4) . $hyphen . substr($charid, 12, 4) . $hyphen . substr($charid, 16, 4) . $hyphen . substr($charid, 20, 12) . chr(125);
        // "}"
        return $uuid;
    }
}
$dwguid = getGUID();
//guid 처리
$entity = new Entity();
$entity->setPartitionKey("VSTechUp");
$entity->setRowKey($dwguid);
$entity->addProperty("Description", null, "VS가 쵝오에요~");
$entity->addProperty("DueDate", EdmType::DATETIME, new DateTime("2015-11-14T08:15:00-08:00"));
$entity->addProperty("Location", EdmType::STRING, "광화문");
try {
    $tableRestProxy->insertEntity("phptable", $entity);
    //테이블명
} catch (ServiceException $e) {
    $code = $e->getCode();
    $error_message = $e->getMessage();
}
 /**
  * @covers WindowsAzure\Table\TableRestProxy::insertEntity
  */
 public function testInsertStringWithAllAsciiCharacters()
 {
     $table = TableServiceFunctionalTestData::$TEST_TABLE_NAMES[0];
     $e = new Entity();
     $e->setPartitionKey('foo');
     $e->setRowKey(TableServiceFunctionalTestData::getNewKey());
     // ASCII code points in the following ranges are valid in XML 1.0 documents
     // - 0x09, 0x0A, 0x0D, 0x20-0x7F
     // Note: 0x0D gets mapped to 0x0A by the server.
     $k = '';
     for ($b = 0x20; $b < 0x30; $b++) {
         $k .= chr($b);
     }
     $k .= chr(0x9);
     for ($b = 0x30; $b < 0x40; $b++) {
         $k .= chr($b);
     }
     $k .= chr(0xa);
     for ($b = 0x40; $b < 0x50; $b++) {
         $k .= chr($b);
     }
     $k .= chr(0xa);
     for ($b = 0x50; $b < 0x80; $b++) {
         $k .= chr($b);
     }
     $e->addProperty('foo', EdmType::STRING, $k);
     $ret = $this->restProxy->insertEntity($table, $e);
     $this->assertNotNull($ret, '$ret');
     $this->assertNotNull($ret->getEntity(), '$ret->getEntity');
     $l = $ret->getEntity()->getPropertyValue('foo');
     $this->assertEquals($k, $l, '$ret->getEntity()->getPropertyValue(\'foo\')');
     $this->clearTable($table);
 }
コード例 #6
0
//rowkey를 위해 guid 생성
function getGUID()
{
    if (function_exists('com_create_guid')) {
        return com_create_guid();
    } else {
        mt_srand((double) microtime() * 10000);
        //optional for php 4.2.0 and up.
        $charid = strtoupper(md5(uniqid(rand(), true)));
        $hyphen = chr(45);
        // "-"
        $uuid = chr(123) . substr($charid, 0, 8) . $hyphen . substr($charid, 8, 4) . $hyphen . substr($charid, 12, 4) . $hyphen . substr($charid, 16, 4) . $hyphen . substr($charid, 20, 12) . chr(125);
        // "}"
        return $uuid;
    }
}
$dwguid = getGUID();
//guid 처리
$entity = new Entity();
$entity->setPartitionKey("KCD");
$entity->setRowKey($dwguid);
$entity->addProperty("Description", null, "질문을 하시면 선물이!!!");
$entity->addProperty("DueDate", EdmType::DATETIME, new DateTime("2016-01-23T08:15:00-08:00"));
$entity->addProperty("Location", EdmType::STRING, "광화문");
try {
    $tableRestProxy->insertEntity("phptable", $entity);
    //테이블명
} catch (ServiceException $e) {
    $code = $e->getCode();
    $error_message = $e->getMessage();
}
コード例 #7
0
ファイル: WindowsAzure.php プロジェクト: CFLOVEYR/hook
 /**
  * Callback function for session handler. It's invoked while the session data is being written.
  *
  * @param $sessionId The session ID.
  * @param $sessionData The data to be written in session.
  *
  * @return boolean If the write operation success.
  */
 public function write($sessionId, $sessionData)
 {
     // serialize and encode the session data.
     $serializedData = base64_encode(serialize($sessionData));
     try {
         // try to retrive the stored session entity and update it.
         $result = $this->_tableRestProxy->getEntity($this->_sessionContainer, $this->_sessionContainerPartition, $sessionId);
         $entity = $result->getEntity();
         // update data and expiry time
         $entity->setPropertyValue('data', $serializedData);
         $entity->setPropertyValue('expires', time());
         // update entity
         $this->_tableRestProxy->updateEntity($this->_sessionContainer, $entity);
     } catch (ServiceException $e) {
         // otherwise, create a new session entity to store the data.
         $entity = new Entity();
         // set partition key and use session id as the row key.
         $entity->setPartitionKey($this->_sessionContainerPartition);
         $entity->setRowKey($sessionId);
         // set data and expiry time
         $entity->addProperty('data', EdmType::STRING, $serializedData);
         $entity->addProperty('expires', EdmType::INT32, time());
         // insert the entity
         $this->_tableRestProxy->insertEntity($this->_sessionContainer, $entity);
     }
     return TRUE;
 }
コード例 #8
0
 /**
  * @covers WindowsAzure\Table\TableRestProxy::insertEntity
  * @covers WindowsAzure\Table\TableRestProxy::queryEntities
  */
 public function testInsertEntityString()
 {
     foreach (TableServiceFunctionalTestData::getInterestingGoodStrings() as $o) {
         $ent = new Entity();
         $ent->setPartitionKey(TableServiceFunctionalTestData::getNewKey());
         $ent->setRowKey(TableServiceFunctionalTestData::getNewKey());
         $ent->addProperty('STRING', EdmType::STRING, $o);
         $this->insertEntityWorker($ent, true, null, $o);
     }
 }
コード例 #9
0
 static function getSimpleEntities($count)
 {
     $ret = array();
     $e = new Entity();
     $e->setPartitionKey('singlePartition');
     $e->setRowKey(self::getNewKey());
     $e->addProperty('INT32', EdmType::INT32, 23);
     array_push($ret, $e);
     $booleans = self::getInterestingGoodBooleans();
     $dates = self::getInterestingGoodDates();
     $doubles = self::getInterestingGoodDoubles();
     $guids = self::getInterestingGoodGuids();
     $ints = self::getInterestingGoodInts();
     $longs = self::getInterestingGoodLongs();
     $binaries = self::getInterestingGoodBinaries();
     $strings = self::getInterestingGoodStrings();
     // The random here is not to generate random values, but to
     // get a good mix of values in the table entities.
     mt_srand(123);
     for ($i = 0; $i < $count - 1; $i++) {
         $e = new Entity();
         $e->setPartitionKey('singlePartition');
         $e->setRowKey(self::getNewKey());
         self::addProperty($e, 'BINARY', EdmType::BINARY, $binaries);
         self::addProperty($e, 'BOOLEAN', EdmType::BOOLEAN, $booleans);
         self::addProperty($e, 'DATETIME', EdmType::DATETIME, $dates);
         self::addProperty($e, 'DOUBLE', EdmType::DOUBLE, $doubles);
         self::addProperty($e, 'GUID', EdmType::GUID, $guids);
         self::addProperty($e, 'INT32', EdmType::INT32, $ints);
         self::addProperty($e, 'INT64', EdmType::INT64, $longs);
         self::addProperty($e, 'STRING', EdmType::STRING, $strings);
         array_push($ret, $e);
     }
     return $ret;
 }
コード例 #10
0
 public function testGc()
 {
     $client = $this->getMockClient();
     $client->shouldReceive('queryEntities')->andThrow(new ServiceException('404'));
     $sessionHandler = new SessionHandler($client);
     $this->assertFalse($sessionHandler->gc(0));
     $client = $this->getMockClient();
     $queryEntitiesResult = new QueryEntitiesResult();
     $entity = new Entity();
     $entity->setRowKey('id');
     $entity->addProperty('data', null, base64_encode('data'));
     $queryEntitiesResult->setEntities(array($entity));
     $client->shouldReceive('queryEntities')->andReturn($queryEntitiesResult);
     $client->shouldReceive('deleteEntity');
     $sessionHandler = new SessionHandler($client);
     $this->assertTrue($sessionHandler->gc(0));
 }
コード例 #11
0
ファイル: Table.php プロジェクト: rajeshpillai/df-azure
 /**
  * @param array       $record
  * @param null|Entity $entity
  * @param array       $exclude List of keys to exclude from adding to Entity
  *
  * @return Entity
  */
 protected static function parseRecordToEntity($record = [], $entity = null, $exclude = [])
 {
     if (empty($entity)) {
         $entity = new Entity();
     }
     foreach ($record as $key => $value) {
         if (false === array_search($key, $exclude)) {
             // valid types
             //				const DATETIME = 'Edm.DateTime';
             //				const BINARY   = 'Edm.Binary';
             //				const GUID     = 'Edm.Guid';
             $edmType = EdmType::STRING;
             switch (gettype($value)) {
                 case 'boolean':
                     $edmType = EdmType::BOOLEAN;
                     break;
                 case 'double':
                 case 'float':
                     $edmType = EdmType::DOUBLE;
                     break;
                 case 'integer':
                     $edmType = $value > 2147483647 ? EdmType::INT64 : EdmType::INT32;
                     break;
             }
             if ($entity->getProperty($key)) {
                 $prop = new Property();
                 $prop->setEdmType($edmType);
                 $prop->setValue($value);
                 $entity->setProperty($key, $prop);
             } else {
                 $entity->addProperty($key, $edmType, $value);
             }
         }
     }
     return $entity;
 }
コード例 #12
0
 /**
  * @covers WindowsAzure\Table\Models\Entity::isValid
  */
 public function testIsValidWithEmptyPartitionKey()
 {
     // Setup
     $entity = new Entity();
     $entity->addProperty('name', EdmType::STRING, 'string');
     // Assert
     $actual = $entity->isValid();
     // Assert
     $this->assertFalse($actual);
 }
コード例 #13
0
 /**
  * Parses an entity entry from given SimpleXML object.
  * 
  * @param \SimpleXML $result The SimpleXML object representing the entity.
  * 
  * @return \WindowsAzure\Table\Models\Entity
  */
 private function _parseOneEntity($result)
 {
     $prefix = $this->_dataServicesMetadataPrefix;
     $prop = $result->content->xpath(".//{$prefix}:properties");
     $prop = $prop[0]->children($this->_dataServicesNamespaceName);
     $entity = new Entity();
     // Set ETag
     $etag = $result->attributes($this->_dataServicesMetadataNamespaceName);
     $etag = $etag[Resources::ETAG];
     $entity->setETag((string) $etag);
     foreach ($prop as $key => $value) {
         $attributes = $value->attributes($this->_dataServicesMetadataNamespaceName);
         $type = $attributes['type'];
         $isnull = $attributes['null'];
         $value = EdmType::unserializeQueryValue((string) $type, $value);
         $entity->addProperty((string) $key, is_null($type) ? null : (string) $type, $isnull ? null : $value);
     }
     return $entity;
 }
コード例 #14
0
 /**
  * @covers WindowsAzure\Table\TableRestProxy::batch
  * @covers WindowsAzure\Table\TableRestProxy::insertEntity
  * @covers WindowsAzure\Table\TableRestProxy::updateEntity
  */
 public function testBatchNegativeWorks()
 {
     // Arrange
     $table = self::$testTable8;
     $partitionKey = '001';
     // Insert an entity the modify it outside of the batch
     $entity1 = new Entity();
     $entity1->setPartitionKey($partitionKey);
     $entity1->setRowKey('batchNegativeWorks1');
     $entity1->addProperty('test', EdmType::INT32, 1);
     $entity2 = new Entity();
     $entity2->setPartitionKey($partitionKey);
     $entity2->setRowKey('batchNegativeWorks2');
     $entity2->addProperty('test', EdmType::INT32, 2);
     $entity3 = new Entity();
     $entity3->setPartitionKey($partitionKey);
     $entity3->setRowKey('batchNegativeWorks3');
     $entity3->addProperty('test', EdmType::INT32, 3);
     $entity1 = $this->restProxy->insertEntity($table, $entity1)->getEntity();
     $entity2 = $this->restProxy->insertEntity($table, $entity2)->getEntity();
     $entity2->addProperty('test', EdmType::INT32, -2);
     $this->restProxy->updateEntity($table, $entity2);
     // Act
     $batchOperations = new BatchOperations();
     // The $entity1 still has the original etag from the first submit,
     // so this update should fail, because another update was already made.
     $entity1->addProperty('test', EdmType::INT32, 3);
     $batchOperations->addDeleteEntity($table, $entity1->getPartitionKey(), $entity1->getRowKey(), $entity1->getETag());
     $batchOperations->addUpdateEntity($table, $entity2);
     $batchOperations->addInsertEntity($table, $entity3);
     $result = $this->restProxy->batch($batchOperations);
     // Assert
     $this->assertNotNull($result, '$result');
     $entries = $result->getEntries();
     $this->assertEquals(1, count($entries), 'count($result->getEntries())');
     $this->assertNotNull($entries[0], 'First $result should not be null');
     $this->assertTrue($entries[0] instanceof BatchError, 'First $result type');
     $error = $entries[0];
     $this->assertEquals(412, $error->getError()->getCode(), 'First $result status code');
 }
コード例 #15
0
 /**
  * Create entity object with key and data values.
  *
  * @param array $key
  * @param array $data
  * @return \WindowsAzure\Table\Model\Entity
  */
 private function createEntity(array $key, array $data)
 {
     list($partitonKey, $rowKey) = array_values($key);
     $entity = new Entity();
     $entity->setPartitionKey((string) $partitonKey);
     $entity->setRowKey((string) $rowKey);
     foreach ($data as $variable => $value) {
         $type = $this->getPropertyType($value);
         $entity->addProperty($variable, $type, $value);
     }
     return $entity;
 }
コード例 #16
0
 /**
  * Inserts new entity to the table.
  * 
  * @param string                     $entries The entries values.
  * @param Models\TableServiceOptions $options The optional parameters.
  * 
  * @return none
  * 
  * @see http://msdn.microsoft.com/en-us/library/windowsazure/dd179433.aspx
  */
 public function insertTypelessEntity($entries, $options = null)
 {
     $entity = new Entity();
     $entity->setPartitionKey($this->_defaultParitionKey);
     $entity->setRowKey(uniqid());
     foreach ($entries as $columnName => $value) {
         $entity->addProperty($columnName, null, $value);
     }
     $this->_proxy->insertEntity($this->_name, $entity, $options);
 }
コード例 #17
0
 /**
  * Create or update a session by ID.
  *
  * @param string $sessionId
  * @param string $sessionData
  */
 public function write($sessionId, $sessionData)
 {
     $entity = new Entity();
     $entity->setPartitionKey($this->partitionKey);
     $entity->setRowKey($sessionId);
     $entity->addProperty('last_accessed', EdmType::INT32, time());
     $entity->addProperty('data', EdmType::STRING, base64_encode($sessionData));
     try {
         $this->client->insertOrReplaceEntity($this->table, $entity);
     } catch (Exception $e) {
         return;
     }
 }