fMijjXsz

1private static final String CREATE_TB_EVENT = "CREATE TABLE IF NOT EXISTS "+TABLE_EVENT+" ( GAME INTEGER NOT NULL, " +
2        "PLAYER INTEGER NOT NULL, TYPE INTEGER NOT NULL, MINUTE INTEGER NOT NULL, PRIMARY KEY ( GAME, PLAYER, TYPE, MINUTE ), " +
3        "FOREIGN KEY ( GAME ) REFERENCES "+TABLE_GAME+" ( IDGAME ), " +
4        "FOREIGN KEY ( PLAYER ) REFERENCES "+TABLE_PLAYER+" ( IDPLAYER ) )";
5	
6public boolean saveEvents(ArrayList<Event> events, int gameID) {
7    if(events == null)
8        return false;
9    try {
10        SQLiteDatabase db = getWritableDatabase();
11        Log.v(TAG, getTableAsString(db, TABLE_EVENT));
12        ContentValues cv = new ContentValues();
13        for(Event e : events) {
14            cv.put("GAME",gameID);
15            cv.put("PLAYER",e.getIdPlayer());
16            cv.put("TYPE",e.getType());
17            cv.put("MINUTE",e.getMinute());
18            db.insert(TABLE_EVENT, null, cv);
19            Log.v(TAG, getTableAsString(db, TABLE_EVENT));
20        }
21        db.close();
22        return true;
23    } catch (SQLiteException | NullPointerException ex) {
24        Log.e(TAG, ex.getMessage());
25        return false;
26    }
27}
28	
29Table Event: empty
30
31Table Event: GAME: 54 PLAYER: 4 TYPE: 1 MINUTE: 23
32
33Table Event: GAME: 54 PLAYER: 4 TYPE: 1 MINUTE: 23
34             GAME: 54 PLAYER: 5 TYPE: 2 MINUTE: 45
35
36Table Event: GAME: 54 PLAYER: 4 TYPE: 1 MINUTE: 23
37             GAME: 54 PLAYER: 5 TYPE: 2 MINUTE: 45
38             GAME: 54 PLAYER: 10 TYPE: 1 MINUTE: 23
39
40Table Event: GAME: 54 PLAYER: 4 TYPE: 1 MINUTE: 23
41             GAME: 54 PLAYER: 5 TYPE: 2 MINUTE: 45
42             GAME: 54 PLAYER: 10 TYPE: 1 MINUTE: 23