Gecko [ ifk.uw.edu.pl ]

Name	Size	Permission
drupal_autoload_test	[ DIR ]	drwxr-xr-x
drupal_system_listing_compatib...	[ DIR ]	drwxr-xr-x
drupal_system_listing_incompat...	[ DIR ]	drwxr-xr-x
psr_0_test	[ DIR ]	drwxr-xr-x
psr_4_test	[ DIR ]	drwxr-xr-x
themes	[ DIR ]	drwxr-xr-x
upgrade	[ DIR ]	drwxr-xr-x
actions.test	5.7 KB	-rw-r--r--
actions_loop_test.info	268 B	-rw-r--r--
actions_loop_test.install	206 B	-rw-r--r--
actions_loop_test.module	2.54 KB	-rw-r--r--
ajax.test	26.15 KB	-rw-r--r--
ajax_forms_test.info	267 B	-rw-r--r--
ajax_forms_test.module	16.56 KB	-rw-r--r--
ajax_test.info	261 B	-rw-r--r--
ajax_test.module	1.84 KB	-rw-r--r--
batch.test	16.49 KB	-rw-r--r--
batch_test.callbacks.inc	3.92 KB	-rw-r--r--
batch_test.info	265 B	-rw-r--r--
batch_test.module	13.32 KB	-rw-r--r--
bootstrap.test	28.68 KB	-rw-r--r--
cache.test	15.38 KB	-rw-r--r--
common.test	130.72 KB	-rw-r--r--
common_test.css	79 B	-rw-r--r--
common_test.info	341 B	-rw-r--r--
common_test.module	7.25 KB	-rw-r--r--
common_test.print.css	79 B	-rw-r--r--
common_test_cron_helper.info	295 B	-rw-r--r--
common_test_cron_helper.module	362 B	-rw-r--r--
common_test_info.txt	334 B	-rw-r--r--
database_test.info	269 B	-rw-r--r--
database_test.install	5.72 KB	-rw-r--r--
database_test.module	6.51 KB	-rw-r--r--
database_test.test	144.13 KB	-rw-r--r--
entity_cache_test.info	319 B	-rw-r--r--
entity_cache_test.module	873 B	-rw-r--r--
entity_cache_test_dependency.i...	295 B	-rw-r--r--
entity_cache_test_dependency.m...	305 B	-rw-r--r--
entity_crud.test	1.86 KB	-rw-r--r--
entity_crud_hook_test.info	273 B	-rw-r--r--
entity_crud_hook_test.module	6 KB	-rw-r--r--
entity_crud_hook_test.test	12.47 KB	-rw-r--r--
entity_query.test	65.62 KB	-rw-r--r--
entity_query_access_test.info	289 B	-rw-r--r--
entity_query_access_test.modul...	1.5 KB	-rw-r--r--
error.test	4.58 KB	-rw-r--r--
error_test.info	273 B	-rw-r--r--
error_test.module	1.89 KB	-rw-r--r--
file.test	109.29 KB	-rw-r--r--
file_test.info	291 B	-rw-r--r--
file_test.module	12.23 KB	-rw-r--r--
filetransfer.test	4.44 KB	-rw-r--r--
filter_test.info	263 B	-rw-r--r--
filter_test.module	1.68 KB	-rw-r--r--
form.test	89.19 KB	-rw-r--r--
form_test.file.inc	1.4 KB	-rw-r--r--
form_test.info	262 B	-rw-r--r--
form_test.module	57.65 KB	-rw-r--r--
graph.test	6.23 KB	-rw-r--r--
http.php	897 B	-rw-r--r--
https.php	860 B	-rw-r--r--
image.test	18.89 KB	-rw-r--r--
image_test.info	265 B	-rw-r--r--
image_test.module	3.17 KB	-rw-r--r--
lock.test	2.56 KB	-rw-r--r--
mail.test	18.8 KB	-rw-r--r--
menu.test	71.63 KB	-rw-r--r--
menu_test.info	268 B	-rw-r--r--
menu_test.module	17.93 KB	-rw-r--r--
module.test	14.59 KB	-rw-r--r--
module_test.file.inc	203 B	-rw-r--r--
module_test.info	268 B	-rw-r--r--
module_test.install	930 B	-rw-r--r--
module_test.module	3.76 KB	-rw-r--r--
pager.test	5.36 KB	-rw-r--r--
password.test	3.44 KB	-rw-r--r--
path.test	13.27 KB	-rw-r--r--
path_test.info	268 B	-rw-r--r--
path_test.module	410 B	-rw-r--r--
registry.test	4.66 KB	-rw-r--r--
requirements1_test.info	313 B	-rw-r--r--
requirements1_test.install	505 B	-rw-r--r--
requirements1_test.module	111 B	-rw-r--r--
requirements2_test.info	392 B	-rw-r--r--
requirements2_test.module	130 B	-rw-r--r--
schema.test	13.45 KB	-rw-r--r--
session.test	22.8 KB	-rw-r--r--
session_test.info	268 B	-rw-r--r--
session_test.module	5.45 KB	-rw-r--r--
system.base.css	143 B	-rw-r--r--
system_dependencies_test.info	322 B	-rw-r--r--
system_dependencies_test.modul...	6 B	-rw-r--r--
system_incompatible_core_versi...	368 B	-rw-r--r--
system_incompatible_core_versi...	6 B	-rw-r--r--
system_incompatible_core_versi...	300 B	-rw-r--r--
system_incompatible_core_versi...	6 B	-rw-r--r--
system_incompatible_module_ver...	442 B	-rw-r--r--
system_incompatible_module_ver...	6 B	-rw-r--r--
system_incompatible_module_ver...	298 B	-rw-r--r--
system_incompatible_module_ver...	6 B	-rw-r--r--
system_test.info	286 B	-rw-r--r--
system_test.module	14.43 KB	-rw-r--r--
tablesort.test	4.67 KB	-rw-r--r--
taxonomy_test.info	305 B	-rw-r--r--
taxonomy_test.install	747 B	-rw-r--r--
taxonomy_test.module	2.65 KB	-rw-r--r--
theme.test	25.37 KB	-rw-r--r--
theme_test.inc	372 B	-rw-r--r--
theme_test.info	266 B	-rw-r--r--
theme_test.module	4.17 KB	-rw-r--r--
theme_test.template_test.tpl.p...	66 B	-rw-r--r--
unicode.test	10.89 KB	-rw-r--r--
update.test	4.69 KB	-rw-r--r--
update_script_test.info	275 B	-rw-r--r--
update_script_test.install	1.29 KB	-rw-r--r--
update_script_test.module	419 B	-rw-r--r--
update_test_1.info	261 B	-rw-r--r--
update_test_1.install	1.59 KB	-rw-r--r--
update_test_1.module	6 B	-rw-r--r--
update_test_2.info	261 B	-rw-r--r--
update_test_2.install	1.18 KB	-rw-r--r--
update_test_2.module	6 B	-rw-r--r--
update_test_3.info	261 B	-rw-r--r--
update_test_3.install	436 B	-rw-r--r--
update_test_3.module	6 B	-rw-r--r--
url_alter_test.info	272 B	-rw-r--r--
url_alter_test.install	267 B	-rw-r--r--
url_alter_test.module	1.75 KB	-rw-r--r--
xmlrpc.test	9.61 KB	-rw-r--r--
xmlrpc_test.info	303 B	-rw-r--r--
xmlrpc_test.module	3.1 KB	-rw-r--r--

Code Editor : database_test.module

<?php

/**
 * Implements hook_query_alter().
 */
function database_test_query_alter(QueryAlterableInterface $query) {

if ($query->hasTag('database_test_alter_add_range')) {
    $query->range(0, 2);
  }

if ($query->hasTag('database_test_alter_add_join')) {
    $people_alias = $query->join('test', 'people', "test_task.pid = %alias.id");
    $name_field = $query->addField($people_alias, 'name', 'name');
    $query->condition($people_alias . '.id', 2);
  }

if ($query->hasTag('database_test_alter_change_conditional')) {
    $conditions =& $query->conditions();
    $conditions[0]['value'] = 2;
  }

if ($query->hasTag('database_test_alter_change_fields')) {
    $fields =& $query->getFields();
    unset($fields['age']);
  }

if ($query->hasTag('database_test_alter_change_expressions')) {
    $expressions =& $query->getExpressions();
    $expressions['double_age']['expression'] = 'age*3';
  }
}

/**
 * Implements hook_query_TAG_alter().
 *
 * Called by DatabaseTestCase::testAlterRemoveRange.
 */
function database_test_query_database_test_alter_remove_range_alter(QueryAlterableInterface $query) {
  $query->range();
}

/**
 * Implements hook_menu().
 */
function database_test_menu() {
  $items['database_test/db_query_temporary'] = array(
    'access callback' => TRUE,
    'page callback' => 'database_test_db_query_temporary',
  );
  $items['database_test/pager_query_even'] = array(
    'access callback' => TRUE,
    'page callback' => 'database_test_even_pager_query',
  );
  $items['database_test/pager_query_odd'] = array(
    'access callback' => TRUE,
    'page callback' => 'database_test_odd_pager_query',
  );
  $items['database_test/tablesort'] = array(
    'access callback' => TRUE,
    'page callback' => 'database_test_tablesort',
  );
  $items['database_test/tablesort_first'] = array(
    'access callback' => TRUE,
    'page callback' => 'database_test_tablesort_first',
  );
  $items['database_test/tablesort_default_sort'] = array(
    'access callback' => TRUE,
    'page callback' => 'drupal_get_form',
    'page arguments' => array('database_test_theme_tablesort'),
  );
  return $items;
}

/**
 * Run a db_query_temporary and output the table name and its number of rows.
 *
 * We need to test that the table created is temporary, so we run it here, in a
 * separate menu callback request; After this request is done, the temporary
 * table should automatically dropped.
 */
function database_test_db_query_temporary() {
  $table_name = db_query_temporary('SELECT status FROM {system}', array());
  drupal_json_output(array(
    'table_name' => $table_name,
    'row_count' => db_select($table_name)->countQuery()->execute()->fetchField(),
  ));
  exit;
}

/**
 * Run a pager query and return the results.
 *
 * This function does care about the page GET parameter, as set by the
 * simpletest HTTP call.
 */
function database_test_even_pager_query($limit) {

$query = db_select('test', 't');
  $query
    ->fields('t', array('name'))
    ->orderBy('age');

// This should result in 2 pages of results.
  $query = $query->extend('PagerDefault')->limit($limit);

$names = $query->execute()->fetchCol();

drupal_json_output(array(
    'names' => $names,
  ));
  exit;
}

/**
 * Run a pager query and return the results.
 *
 * This function does care about the page GET parameter, as set by the
 * simpletest HTTP call.
 */
function database_test_odd_pager_query($limit) {

$query = db_select('test_task', 't');
  $query
    ->fields('t', array('task'))
    ->orderBy('pid');

// This should result in 4 pages of results.
  $query = $query->extend('PagerDefault')->limit($limit);

$names = $query->execute()->fetchCol();

drupal_json_output(array(
    'names' => $names,
  ));
  exit;
}

/**
 * Run a tablesort query and return the results.
 *
 * This function does care about the page GET parameter, as set by the
 * simpletest HTTP call.
 */
function database_test_tablesort() {
  $header = array(
    'tid' => array('data' => t('Task ID'), 'field' => 'tid', 'sort' => 'desc'),
    'pid' => array('data' => t('Person ID'), 'field' => 'pid'),
    'task' => array('data' => t('Task'), 'field' => 'task'),
    'priority' => array('data' => t('Priority'), 'field' => 'priority', ),
  );

$query = db_select('test_task', 't');
  $query
    ->fields('t', array('tid', 'pid', 'task', 'priority'));

$query = $query->extend('TableSort')->orderByHeader($header);

// We need all the results at once to check the sort.
  $tasks = $query->execute()->fetchAll();

drupal_json_output(array(
    'tasks' => $tasks,
  ));
  exit;
}

/**
 * Run a tablesort query with a second order_by after and return the results.
 *
 * This function does care about the page GET parameter, as set by the
 * simpletest HTTP call.
 */
function database_test_tablesort_first() {
  $header = array(
    'tid' => array('data' => t('Task ID'), 'field' => 'tid', 'sort' => 'desc'),
    'pid' => array('data' => t('Person ID'), 'field' => 'pid'),
    'task' => array('data' => t('Task'), 'field' => 'task'),
    'priority' => array('data' => t('Priority'), 'field' => 'priority', ),
  );

$query = db_select('test_task', 't');
  $query
    ->fields('t', array('tid', 'pid', 'task', 'priority'));

$query = $query->extend('TableSort')->orderByHeader($header)->orderBy('priority');

// We need all the results at once to check the sort.
  $tasks = $query->execute()->fetchAll();

drupal_json_output(array(
    'tasks' => $tasks,
  ));
  exit;
}

/**
 * Output a form without setting a header sort.
 */
function database_test_theme_tablesort($form, &$form_state) {
  $header = array(
    'username' => array('data' => t('Username'), 'field' => 'u.name'),
    'status' => array('data' => t('Status'), 'field' => 'u.status'),
  );

$query = db_select('users', 'u');
  $query->condition('u.uid', 0, '<>');
  user_build_filter_query($query);

$count_query = clone $query;
  $count_query->addExpression('COUNT(u.uid)');

$query = $query->extend('PagerDefault')->extend('TableSort');
  $query
    ->fields('u', array('uid', 'name', 'status', 'created', 'access'))
    ->limit(50)
    ->orderByHeader($header)
    ->setCountQuery($count_query);
  $result = $query->execute();

$options = array();

$status = array(t('blocked'), t('active'));
  $accounts = array();
  foreach ($result as $account) {
    $options[$account->uid] = array(
      'username' => check_plain($account->name),
      'status' =>  $status[$account->status],
    );
  }

$form['accounts'] = array(
    '#type' => 'tableselect',
    '#header' => $header,
    '#options' => $options,
    '#empty' => t('No people available.'),
  );

return $form;
}

${this.title}

Code Editor : database_test.module