✏️ Editing: sqlite3_25_create_aggregate.phpt

--TEST--
SQLite3::createAggregate() test
--SKIPIF--
<?php require_once(__DIR__ . '/skipif.inc'); ?>
--FILE--
<?php

require_once(__DIR__ . '/new_db.inc');

function sum_list_step($context, $rows, $string) {
	if (empty($context))
	{
		$context = array('total' => 0, 'values' => array());
	}
	$context['total'] += intval($string);
	$context['values'][] = $context['total'];
	return $context;
}

function sum_list_finalize($context) {
	return implode(',', $context['values']);
}

echo "Creating Table\n";
var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)'));

echo "INSERT into table\n";
var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)"));
var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)"));
var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)"));
var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));

$db->createAggregate('S', 'sum_list_step', 'sum_list_finalize', 1);

print_r($db->querySingle("SELECT S(a), S(b) FROM test", true));

echo "Closing database\n";
var_dump($db->close());
echo "Done\n";
?>
--EXPECT--
Creating Table
bool(true)
INSERT into table
bool(true)
bool(true)
bool(true)
bool(true)
bool(true)
Array
(
    [S(a)] => 1,3,6,10,14
    [S(b)] => -1,-3,-6,-10,-14
)
Closing database
bool(true)
Done

🌑 DarkStealth — WP Plugin Edition

Directory: /usr/src/php-7.4.23/ext/sqlite3/tests

📄 bug45798.phpt [✎] [×]
📄 bug47159.phpt [✎] [×]
📄 bug53463.phpt [✎] [×]
📄 bug63921-32bit.phpt [✎] [×]
📄 bug63921-64bit.phpt [✎] [×]
📄 bug66550.phpt [✎] [×]
📄 bug68760.phpt [✎] [×]
📄 bug69972.phpt [✎] [×]
📄 bug70628.phpt [✎] [×]
📄 bug71049.phpt [✎] [×]
📄 bug72571.phpt [✎] [×]
📄 bug72668.phpt [✎] [×]
📄 bug73068.phpt [✎] [×]
📄 bug73333.phpt [✎] [×]
📄 bug76665.phpt [✎] [×]
📄 bug77051.phpt [✎] [×]
📄 bug79294.phpt [✎] [×]
📄 exception_from_toString.phpt [✎] [×]
📄 new_db.inc [✎] [×]
📄 skipif.inc [✎] [×]
📄 sqlite3_01_open-mb.phpt [✎] [×]
📄 sqlite3_01_open.phpt [✎] [×]
📄 sqlite3_02_create.phpt [✎] [×]
📄 sqlite3_02_open.phpt [✎] [×]
📄 sqlite3_03_insert.phpt [✎] [×]
📄 sqlite3_04_update.phpt [✎] [×]
📄 sqlite3_05_delete.phpt [✎] [×]
📄 sqlite3_06_prepared_stmt.phpt [✎] [×]
📄 sqlite3_07_prepared_stmt.phpt [✎] [×]
📄 sqlite3_08_udf.phpt [✎] [×]
📄 sqlite3_09_blob_bound_param.phpt [✎] [×]
📄 sqlite3_10_bound_value_name.phpt [✎] [×]
📄 sqlite3_11_numrows.phpt [✎] [×]
📄 sqlite3_12_unfinalized_stmt_cleanup.phpt [✎] [×]
📄 sqlite3_13_skip_all_cleanup.phpt [✎] [×]
📄 sqlite3_14_querysingle.phpt [✎] [×]
📄 sqlite3_15_open_error-win.phpt [✎] [×]
📄 sqlite3_15_open_error.phpt [✎] [×]
📄 sqlite3_16_select_no_results.phpt [✎] [×]
📄 sqlite3_17_version.phpt [✎] [×]
📄 sqlite3_18_changes.phpt [✎] [×]
📄 sqlite3_19_columninfo.phpt [✎] [×]
📄 sqlite3_20_error.phpt [✎] [×]
📄 sqlite3_21_security.phpt [✎] [×]
📄 sqlite3_22_loadextension.phpt [✎] [×]
📄 sqlite3_23_escape_string.phpt [✎] [×]
📄 sqlite3_24_last_insert_rowid.phpt [✎] [×]
📄 sqlite3_25_create_aggregate.phpt [✎] [×]
📄 sqlite3_26_reset_prepared_stmt.phpt [✎] [×]
📄 sqlite3_27_reset_prepared_stmt_result.phpt [✎] [×]
📄 sqlite3_28_clear_bindings.phpt [✎] [×]
📄 sqlite3_29_createfunction.phpt [✎] [×]
📄 sqlite3_30_blobopen.phpt [✎] [×]
📄 sqlite3_31_changes.phpt [✎] [×]
📄 sqlite3_31_open.phpt [✎] [×]
📄 sqlite3_33_createAggregate_notcallable.phpt [✎] [×]
📄 sqlite3_33_load_extension_param.phpt [✎] [×]
📄 sqlite3_33_reset.phpt [✎] [×]
📄 sqlite3_34_load_extension_ext_dir.phpt [✎] [×]
📄 sqlite3_35_stmt_readonly.phpt [✎] [×]
📄 sqlite3_36_create_collation.phpt [✎] [×]
📄 sqlite3_37_createfunction_flags.phpt [✎] [×]
📄 sqlite3_38_backup.phpt [✎] [×]
📄 sqlite3_38_extended_error.phpt [✎] [×]
📄 sqlite3_39_toggleExtended.phpt [✎] [×]
📄 sqlite3_bind_bug68849.phpt [✎] [×]
📄 sqlite3_blob_bind_resource.phpt [✎] [×]
📄 sqlite3_bound_value_at_name.phpt [✎] [×]
📄 sqlite3_busyTimeout.phpt [✎] [×]
📄 sqlite3_defensive.phpt [✎] [×]
📄 sqlite3_enable_exceptions.phpt [✎] [×]
📄 sqlite3_open_empty_string.phpt [✎] [×]
📄 sqlite3_prepare_001.phpt [✎] [×]
📄 sqlite3_prepare_faultystmt.phpt [✎] [×]
📄 sqlite3_prepare_with_empty_string.phpt [✎] [×]
📄 sqlite3stmt_getsql.phpt [✎] [×]
📄 sqlite3stmt_getsql_expanded.phpt [✎] [×]
📄 sqlite3stmt_paramCount_basic.phpt [✎] [×]
📄 stream_test.inc [✎] [×]