PHP moodle_database::insert_record方法代码示例

 /**
  * This function generates the unique index for a specific lock key.
  * Once an index is assigned to a key, it never changes - so this is
  * statically cached.
  *
  * @param string $key
  * @return int
  * @throws \moodle_exception
  */
 protected function get_index_from_key($key)
 {
     if (isset(self::$lockidcache[$key])) {
         return self::$lockidcache[$key];
     }
     $index = 0;
     $record = $this->db->get_record('lock_db', array('resourcekey' => $key));
     if ($record) {
         $index = $record->id;
     }
     if (!$index) {
         $record = new \stdClass();
         $record->resourcekey = $key;
         try {
             $index = $this->db->insert_record('lock_db', $record);
         } catch (\dml_exception $de) {
             // Race condition - never mind - now the value is guaranteed to exist.
             $record = $this->db->get_record('lock_db', array('resourcekey' => $key));
             if ($record) {
                 $index = $record->id;
             }
         }
     }
     if (!$index) {
         throw new \moodle_exception('Could not generate unique index for key');
     }
     self::$lockidcache[$key] = $index;
     return $index;
 }

 /**
  * Commit new records.
  *
  * @return void
  */
 public function commit()
 {
     $request = (object) array('pid' => getmypid(), 'threadid' => ZEND_THREAD_SAFE ? zend_thread_id() : null, 'uid' => getmyuid(), 'url' => $this->url->out_as_local_url(false), 'hostname' => gethostname(), 'memory' => memory_get_usage(), 'peakmemory' => memory_get_peak_usage());
     // Not supported on Windows until PHP 7
     if (function_exists('getrusage')) {
         $resourceusage = getrusage();
         $request->numswaps = $resourceusage['ru_nswap'];
         $request->numpagefaults = $resourceusage['ru_majflt'];
         $request->usertime = $resourceusage['ru_utime.tv_usec'];
     }
     $request->id = $this->db->insert_record('telemetry_request', $request);
     foreach ($this->additionalstate as $collector) {
         $table = $collector->get_table();
         $records = $collector->get_records();
         foreach ($records as $record) {
             $record->requestid = $request->id;
         }
         $this->db->insert_records($table, $records);
     }
 }

 /**
  * Create and get a lock
  * @param string $resource - The identifier for the lock. Should use frankenstyle prefix.
  * @param int $timeout - The number of seconds to wait for a lock before giving up.
  * @param int $maxlifetime - Unused by this lock type.
  * @return boolean - true if a lock was obtained.
  */
 public function get_lock($resource, $timeout, $maxlifetime = 86400)
 {
     $token = $this->generate_unique_token();
     $now = time();
     $giveuptime = $now + $timeout;
     $expires = $now + $maxlifetime;
     if (!$this->db->record_exists('lock_db', array('resourcekey' => $resource))) {
         $record = new \stdClass();
         $record->resourcekey = $resource;
         $result = $this->db->insert_record('lock_db', $record);
     }
     $params = array('expires' => $expires, 'token' => $token, 'resourcekey' => $resource, 'now' => $now);
     $sql = 'UPDATE {lock_db}
                SET
                    expires = :expires,
                    owner = :token
              WHERE
                    resourcekey = :resourcekey AND
                    (owner IS NULL OR expires < :now)';
     do {
         $now = time();
         $params['now'] = $now;
         $this->db->execute($sql, $params);
         $countparams = array('owner' => $token, 'resourcekey' => $resource);
         $result = $this->db->count_records('lock_db', $countparams);
         $locked = $result === 1;
         if (!$locked) {
             usleep(rand(10000, 250000));
             // Sleep between 10 and 250 milliseconds.
         }
         // Try until the giveup time.
     } while (!$locked && $now < $giveuptime);
     if ($locked) {
         $this->openlocks[$token] = 1;
         return new lock($token, $this);
     }
     return false;
 }

 public function test_limits_and_offsets()
 {
     $DB = $this->tdb;
     $dbman = $DB->get_manager();
     if (false) {
         $DB = new moodle_database();
     }
     $table = $this->get_test_table();
     $tablename = $table->getName();
     $table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
     $table->add_field('name', XMLDB_TYPE_CHAR, '255', null, null, null, null);
     $table->add_field('content', XMLDB_TYPE_TEXT, 'big', XMLDB_UNSIGNED, XMLDB_NOTNULL);
     $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
     $dbman->create_table($table);
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'a', 'content' => 'one')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'b', 'content' => 'two')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'c', 'content' => 'three')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'd', 'content' => 'four')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'e', 'content' => 'five')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'f', 'content' => 'six')));
     $sqlqm = "SELECT *\n                    FROM {{$tablename}}";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 4));
     $this->assertEquals(2, count($records));
     $this->assertEquals('e', reset($records)->name);
     $this->assertEquals('f', end($records)->name);
     $sqlqm = "SELECT *\n                    FROM {{$tablename}}";
     $this->assertEmpty($records = $DB->get_records_sql($sqlqm, null, 8));
     $sqlqm = "SELECT *\n                    FROM {{$tablename}}";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 0, 4));
     $this->assertEquals(4, count($records));
     $this->assertEquals('a', reset($records)->name);
     $this->assertEquals('d', end($records)->name);
     $sqlqm = "SELECT *\n                    FROM {{$tablename}}";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 0, 8));
     $this->assertEquals(6, count($records));
     $this->assertEquals('a', reset($records)->name);
     $this->assertEquals('f', end($records)->name);
     $sqlqm = "SELECT *\n                    FROM {{$tablename}}";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 1, 4));
     $this->assertEquals(4, count($records));
     $this->assertEquals('b', reset($records)->name);
     $this->assertEquals('e', end($records)->name);
     $sqlqm = "SELECT *\n                    FROM {{$tablename}}";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 4, 4));
     $this->assertEquals(2, count($records));
     $this->assertEquals('e', reset($records)->name);
     $this->assertEquals('f', end($records)->name);
     $sqlqm = "SELECT t.*, t.name AS test\n                    FROM {{$tablename}} t\n                    ORDER BY t.id ASC";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 4, 4));
     $this->assertEquals(2, count($records));
     $this->assertEquals('e', reset($records)->name);
     $this->assertEquals('f', end($records)->name);
     $sqlqm = "SELECT DISTINCT t.name, t.name AS test\n                    FROM {{$tablename}} t\n                    ORDER BY t.name DESC";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 4, 4));
     $this->assertEquals(2, count($records));
     $this->assertEquals('b', reset($records)->name);
     $this->assertEquals('a', end($records)->name);
     $sqlqm = "SELECT 1\n                    FROM {{$tablename}} t\n                    WHERE t.name = 'a'";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 0, 1));
     $this->assertEquals(1, count($records));
     $sqlqm = "SELECT 'constant'\n                    FROM {{$tablename}} t\n                    WHERE t.name = 'a'";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 0, 8));
     $this->assertEquals(1, count($records));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'a', 'content' => 'one')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'b', 'content' => 'two')));
     $this->assertNotEmpty($DB->insert_record($tablename, array('name' => 'c', 'content' => 'three')));
     $sqlqm = "SELECT t.name, COUNT(DISTINCT t2.id) AS count, 'Test' AS teststring\n                    FROM {{$tablename}} t\n                    LEFT JOIN (\n                        SELECT t.id, t.name\n                        FROM {{$tablename}} t\n                    ) t2 ON t2.name = t.name\n                    GROUP BY t.name\n                    ORDER BY t.name ASC";
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm));
     $this->assertEquals(6, count($records));
     // a,b,c,d,e,f
     $this->assertEquals(2, reset($records)->count);
     // a has 2 records now
     $this->assertEquals(1, end($records)->count);
     // f has 1 record still
     $this->assertNotEmpty($records = $DB->get_records_sql($sqlqm, null, 0, 2));
     $this->assertEquals(2, count($records));
     $this->assertEquals(2, reset($records)->count);
     $this->assertEquals(2, end($records)->count);
 }