World Cup Scoreboard - new version

[elmortero]

Hi all,

Not a real football fan myself but with the World Cup I make a little exception.
For that reason - and because I am always looking for data sources to play with the asynchronous http requests - I wrote this script.

The data are fetched from http://worldcup.sfg.io/ and they offer other data sets. I was only interested in the status of the current game.

changed: now using the /today endpoint. This way at the end of the game the winner is displayed


In the code below I check if one of the teams is a team I want notifications about. If you don't want to use that remove line 30 to 32 and 47 to 49

Code: Select all

return {
	on = {
		timer = { 'every 2 minutes' },
		httpResponses = { 'scoreboard2' } -- matches callback string below
	},
	
	execute = function(domoticz, triggerItem)
    local board = domoticz.devices('Scoreboard2')    --a virtual text sensor
    local prevboard = tostring(board.text)          --get current value of text sensor

		if (triggerItem.isTimer) then
			domoticz.openURL({
				url = 'http://worldcup.sfg.io/matches/today',
				method = 'GET',
				callback = 'scoreboard2'
			})
			
		elseif (triggerItem.isHTTPResponse) then

	local response = triggerItem
			if (response.ok and response.isJSON) then
			tl = #response.json
			tc = 1
			repeat
				local status = tostring(response.json[tc].status)
				local home = tostring(response.json[tc].home_team.country)
				local away = tostring(response.json[tc].away_team.country)
				local hgoal = tostring(response.json[tc].home_team.goals)
				local agoal = tostring(response.json[tc].away_team.goals)
					if away == 'Spain' or away == 'Belgium' or home == 'Spain' or home == 'Belgium' then
					 sender = true
					end
				show = (home..' '..hgoal..' - '..agoal..' '..away)

					if status == 'in progress' then tc = tl + 1 end
					if status == 'completed' then
						local score = (hgoal..' - '..agoal)
						local winner = tostring(response.json[tc].winner)
						show = ('Match won by '..winner..' with '..score)
						tc = tc + 1						
					end
					if status == 'future' then tc = tl + 1 end
				until tc > tl
					if show ~= prevboard then
					    print ('result '..show)
						board.updateText(show)
							if sender then
							 --put your notification method here (mine is telegram)
							end
					end			
			else
					print('**scoreboard2 failed to fetch info')
		end
		end
	end
}

The attachment Capture.JPG is no longer available

[jia175891641]

good work!

[ulisesrdg]

Very useful!!!, Thank you for sharing!

[elmortero]

Found an error (needed a match in progress to test)
it should be: if #response.json > 0 then and not > 1

[EdwinK]

Screen Shot 2018-06-16 at 13.23.44.png (41.87 KiB) Viewed 3272 times

Thanks. I don't like soccer/football but this things are funny to play with.

[corederoma82]

Hi,
how is the procedure for installation?

Thanks

[EdwinK]

Copy the lines of the scripts in the events editor, make sure to select dzVents.

Make a text device and name it scoreboard.

That's all

[corederoma82]

Copy the lines of the scripts in the events editor, make sure to select dzVents.

Make a text device and name it scoreboard.

That's all

Ok
Thanks

[CaesarPL]

Thank you very much. Just curious - as I am still on last stable - will it work on old dzVents?

[MikeF]

I've just set this up as described, but I'm getting this dzVents error:

Code: Select all

Error: dzVents: Error: ...omoticz/scripts/dzVents/generated_scripts/scoreboard.lua:11: attempt to index local 'triggerItem' (a nil value)

[elmortero]

I've just set this up as described, but I'm getting this dzVents error:

Code: Select all

Error: dzVents: Error: ...omoticz/scripts/dzVents/generated_scripts/scoreboard.lua:11: attempt to index local 'triggerItem' (a nil value)

That means that you are on a dzVents version prior to 2.4

[MikeF]

Well, that's a shame - yes, I'm on version 2.2, with Domoticz stable 3.8153. I believe I would need to upgrade to Domoticz beta in order to get dzVents 2.4.

[elmortero]

Well, that's a shame - yes, I'm on version 2.2, with Domoticz stable 3.8153. I believe I would need to upgrade to Domoticz beta in order to get dzVents 2.4.

You should, there are some nice features in the later versions of dzVents.

Meanwhile, I took the time to make a pre-httpresponse version of the script. Should work, have not domoticz running on an older version to check all functions.

Try it if you want and let me know if it gives issues (the first time it runs you might get an error about the /tmp file not being available, on the second run it should be ok.

Code: Select all

local scorefile = '/tmp/score.json'
local fetchIntervalMins = 3     -- interval to check the info (don't set to lower than 3)
return {
active = true,
on = {
	timer = { 'every minute' },
		},
execute = function(domoticz, device)
local callUrl = false
	if (os.date('*t').min % fetchIntervalMins) == 0 then
	callUrl = true
	elseif ((os.date('*t').min -1) % fetchIntervalMins) ~= 0 then
	return
	end
local board = domoticz.devices('Scoreboard')
local prevboard = tostring(board.text)
local linker = tostring('http://worldcup.sfg.io/matches/today')
	if callUrl then
	os.execute('curl -s "'..linker..'" > '..scorefile..'&')
	 print('json written to file')
	return -- Nothing more to do for now, we'll be back in a minute to read the data!
	end	
		local function readLuaFromJsonFile(fileName)
		local file = io.open(fileName, 'r')
				if file then
				package.path = './scripts/lua/?.lua;'..package.path
				local jsonParser = require('JSON')
				local _json = file:read('*a')
				local json = jsonParser:decode(_json)
				io.close(file)
				return json
				end
		return nil
		end
local scoreData = readLuaFromJsonFile(scorefile)

	if not scoreData then
	print('** Scoreboard// Could not read scoreData from file: '.. scorefile)
	return
	end
--
	tl = #scoreData
	if tl > 0  then
			tc = 1
			repeat
				local status = tostring(scoreData[tc].status)
				local home = tostring(scoreData[tc].home_team.country)
				local away = tostring(scoreData[tc].away_team.country)
				local hgoal = tostring(scoreData[tc].home_team.goals)
				local agoal = tostring(scoreData[tc].away_team.goals)

				show = (home..' '..hgoal..' - '..agoal..' '..away)

					if status == 'in progress' then tc = tl + 1 end
					if status == 'completed' then
						local score = (hgoal..' - '..agoal)
						local winner = tostring(scoreData[tc].winner)
						if winner == 'Draw' then 
						   show = ('Draw '..home..' '..hgoal..' - '..agoal..' '..away)
						   else 
						   show = ('Match won by '..winner..' with '..score)
						 end
						tc = tc + 1						
					end
					if status == 'future' then tc = tl + 1 end
				until tc > tl
					if show ~= prevboard then
					    print ('result '..show)
						board.updateText(show)
					end			

    end
end
}

[LennartIsHigh]

Try it if you want and let me know if it gives issues (the first time it runs you might get an error about the /tmp file not being available, on the second run it should be ok.

I don't have a clue about what version I've got running but this version of yours works for me.
Thanks!

[MikeF]

Meanwhile, I took the time to make a pre-httpresponse version of the script. Should work, have not domoticz running on an older version to check all functions.

Try it if you want and let me know if it gives issues

Thanks for taking the time to do this - works well for me.

[MikeF]

I've made a change (to the pre-HTTPresponse version) to show kick-off time for future matches:

Spoiler: show

Code: Select all

local scorefile = '/tmp/score.json'
local fetchIntervalMins = 3     -- interval to check the info (don't set to lower than 3)
return {
active = true,
on = {
	timer = { 'every minute' },
		},
execute = function(domoticz, device)
local callUrl = false
	if (os.date('*t').min % fetchIntervalMins) == 0 then
	callUrl = true
	elseif ((os.date('*t').min -1) % fetchIntervalMins) ~= 0 then
	return
	end
local board = domoticz.devices('Scoreboard')
local prevboard = tostring(board.text)
local linker = tostring('http://worldcup.sfg.io/matches/today')
	if callUrl then
	os.execute('curl -s "'..linker..'" > '..scorefile..'&')
	 print('json written to file')
	return -- Nothing more to do for now, we'll be back in a minute to read the data!
	end	
		local function readLuaFromJsonFile(fileName)
		local file = io.open(fileName, 'r')
				if file then
				package.path = './scripts/lua/?.lua;'..package.path
				local jsonParser = require('JSON')
				local _json = file:read('*a')
				local json = jsonParser:decode(_json)
				io.close(file)
				return json
				end
		return nil
		end
local scoreData = readLuaFromJsonFile(scorefile)

	if not scoreData then
	print('** Scoreboard// Could not read scoreData from file: '.. scorefile)
	return
	end
--
	tl = #scoreData
	if tl > 0  then
			tc = 1
			repeat
				local status = tostring(scoreData[tc].status)
				local date = tostring(scoreData[tc].datetime)
				local home = tostring(scoreData[tc].home_team.country)
				local away = tostring(scoreData[tc].away_team.country)
				local hgoal = tostring(scoreData[tc].home_team.goals)
				local agoal = tostring(scoreData[tc].away_team.goals)
				
				local pattern = "(%d+)%-(%d+)%-(%d+)T(%d+):(%d+):(%d+)"
				local year, month, day, hour, minute, seconds = date:match(pattern)
				hour = hour + 1

				show = (home..' '..hgoal..' - '..agoal..' '..away)

					if status == 'in progress' then tc = tl + 1 end
					if status == 'completed' then
						local score = (hgoal..' - '..agoal)
						local winner = tostring(scoreData[tc].winner)
						if winner == 'Draw' then 
						   show = ('Draw '..home..' '..hgoal..' - '..agoal..' '..away)
						   else 
						   show = ('Match won by '..winner..' with '..score)
						 end
						tc = tc + 1						
					end
					if status == 'future' then 
					    show = (show..' KO '..hour..':'..minute)
					    tc = tl + 1 
					end
				until tc > tl
					if show ~= prevboard then
					    print ('result '..show)
						board.updateText(show)
					end			

    end
end
}

Line 56 (hour = hour + 1) should be changed for different timezones (mine is UK BST).

[MikeF]

I've added the elapsed match time - although this will lag, as the script runs every 3 minutes:

Spoiler: show

Code: Select all

local scorefile = '/tmp/score.json'
local fetchIntervalMins = 3     -- interval to check the info (don't set to lower than 3)
return {
active = true,
on = {
	timer = { 'every minute' },
		},
execute = function(domoticz, device)
local callUrl = false
	if (os.date('*t').min % fetchIntervalMins) == 0 then
	callUrl = true
	elseif ((os.date('*t').min -1) % fetchIntervalMins) ~= 0 then
	return
	end
local board = domoticz.devices('Scoreboard')
local prevboard = tostring(board.text)
local linker = tostring('http://worldcup.sfg.io/matches/today')
	if callUrl then
	os.execute('curl -s "'..linker..'" > '..scorefile..'&')
	 print('json written to file')
	return -- Nothing more to do for now, we'll be back in a minute to read the data!
	end	
		local function readLuaFromJsonFile(fileName)
		local file = io.open(fileName, 'r')
				if file then
				package.path = './scripts/lua/?.lua;'..package.path
				local jsonParser = require('JSON')
				local _json = file:read('*a')
				local json = jsonParser:decode(_json)
				io.close(file)
				return json
				end
		return nil
		end
local scoreData = readLuaFromJsonFile(scorefile)

	if not scoreData then
	print('** Scoreboard// Could not read scoreData from file: '.. scorefile)
	return
	end
--
	tl = #scoreData
	if tl > 0  then
			tc = 1
			repeat
				local status = tostring(scoreData[tc].status)
				local date = tostring(scoreData[tc].datetime)
				local time = tostring(scoreData[tc].time)
				local home = tostring(scoreData[tc].home_team.country)
				local away = tostring(scoreData[tc].away_team.country)
				local hgoal = tostring(scoreData[tc].home_team.goals)
				local agoal = tostring(scoreData[tc].away_team.goals)
				
				local pattern = "(%d+)%-(%d+)%-(%d+)T(%d+):(%d+):(%d+)"
				local year, month, day, hour, minute, seconds = date:match(pattern)
				hour = hour + 1

				show = (home..' '..hgoal..' - '..agoal..' '..away)

					if status == 'in progress' then 
					    show = (show..' '..time)
					    tc = tl + 1 
					    end
					if status == 'completed' then
						local score = (hgoal..' - '..agoal)
						local winner = tostring(scoreData[tc].winner)
						if winner == 'Draw' then 
						   show = ('Draw '..home..' '..hgoal..' - '..agoal..' '..away)
						   else 
						   show = ('Match won by '..winner..' with '..score)
						 end
						tc = tc + 1						
					end
					if status == 'future' then 
					    show = (show..' KO '..hour..':'..minute)
					    tc = tl + 1 
					end
				until tc > tl
					if show ~= prevboard then
					    print ('result '..show)
						board.updateText(show)
					end			

    end
end
}

[freakshock]

Thanks for the scripts elmortero & mike!

[MikeF]

I'm now getting this error when I run this (the pre-HTTPresponses version):

Code: Select all

2018-06-22 18:01:04.516 Error: dzVents: Error: An error occured when calling event handler scoreboarrd
2018-06-22 18:01:04.516 Error: dzVents: Error: Lua script execution exceeds maximum number of lines 

Any clues? Is it looping (more than it should!)?

[MikeF]

There are problems with the feed today. The matches are in the wrong order, with the wrong times, and the 3rd match (which appears second) is showing a status of 'pending correction' - which the dzVents script doesn't recognise.