Diary.db - Revision history

Sfws: Remove duplicated text

2021-06-11T10:01:39Z

Remove duplicated text

← Older revision		Revision as of 10:01, 11 June 2021
Line 1:		Line 1:
	'''This is the file where MX stores its [[Weather Diary]]'''		'''This is the file where MX stores its [[Weather Diary]]'''
	[[Category:Log Files]]

	=Introduction =		=Introduction =

Sfws: Update category

2021-06-11T09:59:58Z

Update category

← Older revision		Revision as of 09:59, 11 June 2021
Line 74:		Line 74:


	[[Category:~~Log~~ Files]]		[[Category:Cumulus Files]]
	[[Category:Cumulus MX]]		[[Category:Cumulus MX]]

Sfws: Text replacement - "[[Setting_up_Raspberry_Pi" to "[[MX_on_Linux"

2021-05-16T09:08:37Z

Text replacement - "[[Setting_up_Raspberry_Pi" to "[[MX_on_Linux"

← Older revision		Revision as of 09:08, 16 May 2021
Line 47:		Line 47:
	foreach($row as $key => $value )		foreach($row as $key => $value )
	{		{
	[[~~Setting_up_Raspberry_Pi~~#Editing_the_Weather_Diary]] if($key == 'Timestamp')		[[MX_on_Linux#Editing_the_Weather_Diary]] if($key == 'Timestamp')
	{		{
	$keyDate = substr($value, 0, 10);		$keyDate = substr($value, 0, 10);
Line 70:		Line 70:
	==Editing==		==Editing==

	Please see [[~~Setting_up_Raspberry_Pi~~#Editing_the_Weather_Diary]], although that applies to Linux devices a similar approach can be taken using Microsoft Windows.		Please see [[MX_on_Linux#Editing_the_Weather_Diary]], although that applies to Linux devices a similar approach can be taken using Microsoft Windows.

Sfws: /* Accessing MX diary outside MX */

2021-04-04T13:55:20Z

Accessing MX diary outside MX

← Older revision		Revision as of 13:55, 4 April 2021
Line 22:		Line 22:
	*Entry (a text field for storing comments)		*Entry (a text field for storing comments)

	== Accessing MX diary outside MX ==		= Accessing MX diary outside MX =

	The weather diary is stored in ~~[[diary.db\|~~a sqLite database]] and that can be easily accessed by any ODBC software e.g. Libre Office Base. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor.		The weather diary is stored in a sqLite database and that can be easily accessed by any ODBC software (e.g. Libre Office Base) and many other well known database software. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor.

	Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format):		Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format):
Line 47:		Line 47:
	foreach($row as $key => $value )		foreach($row as $key => $value )
	{		{
	if($key == 'Timestamp')		[[Setting_up_Raspberry_Pi#Editing_the_Weather_Diary]] if($key == 'Timestamp')
	{		{
	$keyDate = substr($value, 0, 10);		$keyDate = substr($value, 0, 10);
Line 67:		Line 67:
	}		}
	</pre>		</pre>

			==Editing==

			Please see [[Setting_up_Raspberry_Pi#Editing_the_Weather_Diary]], although that applies to Linux devices a similar approach can be taken using Microsoft Windows.

Sfws: /* Content */

2021-04-04T13:40:46Z

Content

← Older revision		Revision as of 13:40, 4 April 2021
Line 21:		Line 21:
	*Snow depth (unsigned decimal number)		*Snow depth (unsigned decimal number)
	*Entry (a text field for storing comments)		*Entry (a text field for storing comments)

			== Accessing MX diary outside MX ==

			The weather diary is stored in [[diary.db\|a sqLite database]] and that can be easily accessed by any ODBC software e.g. Libre Office Base. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor.

			Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format):
			<pre>$diary = 'sqlite:' . $snowDiary; // Parameter to identify a SQLite database puts a prefix in front of file path
			$dbhandle = new PDO($diary); // connect to db
			if($dbhandle === false)
			{
			$liteError = sqlite_last_error ($dbhandle );
			echo ' Error: ' . sqlite_error_string ($liteError);
			}else{
			if($debug) echo $lf . '============================' . $lf . 'Success, database ' . $diary . ' is open' . $lf;
			$queryRead = "SELECT ALL * FROM " . "'DiaryData'";
			$statement = $dbhandle -> query($queryRead);
			if($statement === false)
			{
			$liteError = sqlite_last_error ($dbhandle );
			echo ' Error: ' . sqlite_error_string ($liteError);
			}else{
			$jump = false;
			foreach ($statement as $row)
			{
			foreach($row as $key => $value )
			{
			if($key == 'Timestamp')
			{
			$keyDate = substr($value, 0, 10);
			}
			if($keyDate != $rowMetDayStamp) break;
			if($key == 'snowFalling') $falling = $value;
			if($key == 'snowLying') $lying = $value;
			if($key == 'snowDepth') $depth = $value;
			if($key == 'entry') $Entry = $value;
			$jump = true;
			}
			if($jump)
			{
			$snowKnown = true;
			goto snowDone;
			}
			}
			}
			}
			</pre>



			[[Category:Log Files]]
			[[Category:Cumulus MX]]

Sfws at 13:37, 4 April 2021

2021-04-04T13:37:16Z

← Older revision		Revision as of 13:37, 4 April 2021
Line 1:		Line 1:
	'''This is the file where MX stores its Weather Diary'''		'''This is the file where MX stores its [[Weather Diary]]'''
	[[Category:Log Files]]		[[Category:Log Files]]

Sfws at 13:35, 4 April 2021

2021-04-04T13:35:15Z

← Older revision		Revision as of 13:35, 4 April 2021
Line 5:		Line 5:

	The weather diary is created specifically to record any snowfall, but as you can store a comment with any content, a number of Cumulus users are using it to record other entries that can be specific to a day (e.g. hailstorms), or indeed anything that might be recorded in a diary.		The weather diary is created specifically to record any snowfall, but as you can store a comment with any content, a number of Cumulus users are using it to record other entries that can be specific to a day (e.g. hailstorms), or indeed anything that might be recorded in a diary.

			=Format=

	The database uses SQLite format and a script to read this can be found in [[Weather Diary\|Weather Diary article]].		The database uses SQLite format and a script to read this can be found in [[Weather Diary\|Weather Diary article]].

			==Content==

	Each record has the following content:		Each record has the following content:
	* Date		* Date
	*Time ~~(always 00:00:00)~~		*Time
			** (In early releases, Mark set this to 00:00:00)
			**In later releases, this is set to 01:00:00, to minimise time zone issues.
	*Snow Falling (boolean)		*Snow Falling (boolean)
	*Snow Lying (boolean)		*Snow Lying (boolean)

Sfws at 10:18, 10 August 2020

2020-08-10T10:18:13Z

← Older revision		Revision as of 10:18, 10 August 2020
Line 1:		Line 1:
	'''This is the file where MX stores its Weather Diary'''		'''This is the file where MX stores its Weather Diary'''
			[[Category:Log Files]]

	=Introduction =		=Introduction =

Sfws: /* Introduction */

2020-05-31T19:08:41Z

Introduction

← Older revision		Revision as of 19:08, 31 May 2020
Line 13:		Line 13:
	*Snow Lying (boolean)		*Snow Lying (boolean)
	*Snow depth (unsigned decimal number)		*Snow depth (unsigned decimal number)
	*Entry (a text field for storing comments		*Entry (a text field for storing comments)

Sfws: Created page with "'''This is the file where MX stores its Weather Diary''' =Introduction = The weather diary is created specifically to record any snowfall, but as you can store a comment wit..."

2020-05-31T19:08:31Z

Created page with "'''This is the file where MX stores its Weather Diary''' =Introduction = The weather diary is created specifically to record any snowfall, but as you can store a comment wit..."

New page

'''This is the file where MX stores its Weather Diary'''

=Introduction =

The weather diary is created specifically to record any snowfall, but as you can store a comment with any content, a number of Cumulus users are using it to record other entries that can be specific to a day (e.g. hailstorms), or indeed anything that might be recorded in a diary.

The database uses SQLite format and a script to read this can be found in [[Weather Diary|Weather Diary article]].

Each record has the following content:
* Date
*Time (always 00:00:00)
*Snow Falling (boolean)
*Snow Lying (boolean)
*Snow depth (unsigned decimal number)
*Entry (a text field for storing comments