aboutsummaryrefslogblamecommitdiffstats
path: root/test/leagues.sql
blob: fc7c46566c4c3483133386b8d4fee7c6e54bbea7 (plain) (tree) 
8d018d9





















1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21





















                                                                                                                           
BEGIN;
SELECT plan(4);

SELECT has_table('leagues');

SELECT columns_are('leagues', ARRAY[ 'league_id', 'name', 'user_id', 'modified_at', 'created_at']);

SELECT has_sequence('leagues_league_id_seq');

SELECT has_index('teamdraft', 'leagues', 'leagues_pk', 'league_id');

\set new_user_id 5 
INSERT INTO users(user_id, username) OVERRIDING SYSTEM VALUE VALUES (5, 'test'); 
\set new_league_id 5 
INSERT INTO leagues(league_id, name, user_id) OVERRIDING SYSTEM VALUE VALUES (:new_league_id, 'test league', :new_user_id);

CALL new_league_season(:new_league_id);

SELECT * FROM finish();
ROLLBACK;