This repository has been archived on 2025-01-04. You can view files and clone it, but cannot push or open issues or pull requests.
lwb6/legacyworlds-server-data/db-structure/tests/admin/050-updates/020-empire-research/010-gu-research-get-empires.sql
Emmanuel BENOîT c7949e41cc Research update
* Implemented new research update. Old research system no longer
updates.

* Fixed a major bug in the constants registrar

* Added game.research.vacation constant (determines the rate of
research when players are in vacation mode)
2012-04-02 13:29:43 +02:00

24 lines
No EOL
638 B
PL/PgSQL

/*
* Test the sys.gu_research_get_empires() function
*/
BEGIN;
\i utils/common-setup/setup-gu-research-get-empires-test.sql
SELECT plan( 2 );
SELECT diag_test_name( 'gu_research_get_empires() - Selected empires and vacation state' );
SELECT set_eq( $$
SELECT * FROM sys.gu_research_get_empires( 0::BIGINT );
$$ , $$ VALUES (
_get_emp_name( 'emp4') , FALSE
) , (
_get_emp_name( 'emp5') , TRUE
) $$ );
SELECT diag_test_name( 'gu_research_get_empires() - No results with "bad" update identifier' );
SELECT is_empty( $$
SELECT * FROM sys.gu_research_get_empires( 12::BIGINT );
$$ );
SELECT * FROM finish( );
ROLLBACK;