Differential D20180 Diff 48209 src/applications/harbormaster/storage/HarbormasterString.php

Changeset View

Standalone View

				<?php

				final class HarbormasterString
				extends HarbormasterDAO {

				protected $stringIndex;
				protected $stringValue;

				protected function getConfiguration() {
				return array(
				self::CONFIG_TIMESTAMPS => false,
				self::CONFIG_COLUMN_SCHEMA => array(
				'stringIndex' => 'bytes12',
				'stringValue' => 'text',
				),
				self::CONFIG_KEY_SCHEMA => array(
				'key_string' => array(
				'columns' => array('stringIndex'),
				'unique' => true,
				),
				),
				) + parent::getConfiguration();
				}

				public static function newIndex($string) {
				$index = PhabricatorHash::digestForIndex($string);

				$table = new self();
				$conn = $table->establishConnection('w');

				queryfx(
				$conn,
				'INSERT IGNORE INTO %R (stringIndex, stringValue) VALUES (%s, %s)',
				$table,
				$index,
				$string);

				return $index;
				}

				public static function newIndexMap(array $indexes) {
				$table = new self();
				$conn = $table->establishConnection('r');

				$rows = queryfx_all(
				$conn,
				'SELECT stringIndex, stringValue FROM %R WHERE stringIndex IN (%Ls)',
				$table,
				$indexes);

				return ipull($rows, 'stringValue', 'stringIndex');
				}

				}