HarbormasterString.php
e81eff68e581master

HarbormasterString.php
View Options

			<?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');
			}

			}