Emmanuel BENOîT
b49bc1a44f
* Added missing table that should store a planet's resources data (income and upkeep for each type of resource). * Modified resource definition functions and universe generator to initialise planet resource records as well * Heavy clean-up in resource definition function unit tests
28 lines
No EOL
764 B
PL/PgSQL
28 lines
No EOL
764 B
PL/PgSQL
/*
|
|
* Test privileges on verse.planet_resources
|
|
*/
|
|
BEGIN;
|
|
SELECT plan( 4 );
|
|
|
|
SELECT diag_test_name( 'verse.planet_resources - INSERT privileges' );
|
|
SELECT throws_ok(
|
|
$$ INSERT INTO verse.planet_resources( resource_name_id ) VALUES ( 1 ); $$ ,
|
|
42501 );
|
|
|
|
SELECT diag_test_name( 'verse.resource_providers - UPDATE privileges' );
|
|
SELECT throws_ok(
|
|
$$ UPDATE verse.planet_resources SET pres_income = 42; $$ ,
|
|
42501 );
|
|
|
|
SELECT diag_test_name( 'verse.planet_resources - SELECT privileges' );
|
|
SELECT throws_ok(
|
|
$$ SELECT * FROM verse.planet_resources; $$ ,
|
|
42501 );
|
|
|
|
SELECT diag_test_name( 'verse.planet_resources - DELETE privileges' );
|
|
SELECT throws_ok(
|
|
$$ DELETE FROM verse.planet_resources; $$ ,
|
|
42501 );
|
|
|
|
SELECT * FROM finish( );
|
|
ROLLBACK; |