Update DB schema and insert data #54

bananahampster · 2023-12-21T20:06:39Z

Add DB insertion of individual events: change DB structure and insert into DB on parse.

On reparse, truncate event table and restart eventId increment.

Use the following DB schema;

EVENT table (table is new)

name	type	values	notes
eventId			auto-increment, NOT NULL
logId			log table id ref, NOT NULL
isFirstLog	bool		default true
eventType	enum	0-71	NOT NULL
rawLine	string		NOT NULL
lineNumber	number		NOT NULL
timestamp	datetime		NOT NULL
gameTime	number	seconds	NOT NULL
extraData	string		(prefer json format?)
playerFrom			player table id ref
playerFromClass	short	0-9
playerTo			player table id ref
playerToClass	short	0-9
withWeapon	short	0-39
playerFromFlag	bool		default false
playerToFlag	bool		default false

PLAYER table (table is new)

name	type	notes
playerId		auto-increment, NOT NULL
playerName	string	NOT NULL
playerAlias	string
steamId	number	see SteamID doc

LOGS table (* are new columns)

name	type	notes
* logId		auto-increment, NOT NULL
parsedlog	string	output URI slug
log_file1	string	matches name in uploads/
log_file2	string	matches name in uploads/
date_parsed	datetime	initial upload time
date_match	datetime	reported in local time
map	string	can be ""
server	string
num_players	int
* is_valid	bool	default false

PARSEDLOGS table (table is new)

name	type	values	notes
logId			auto-increment, NOT NULL
jsonSummary	varchar(MAX)		full json

The text was updated successfully, but these errors were encountered:

bananahampster added this to the Saving individual events to the DB to be queried milestone Dec 21, 2023

bananahampster linked a pull request Dec 28, 2023 that will close this issue

Add database calls for individual events #58

Open

4 tasks

Provide feedback