Woozle: /* Example */ slightly improved query

2020-07-09T21:16:18Z

Example: slightly improved query

← Older revision		Revision as of 21:16, 9 July 2020
Line 18:		Line 18:
	</syntaxhighlight>		</syntaxhighlight>
	===Example===		===Example===
	<~~syntaxhighlight~~ lang=mysql>		<source lang=mysql>
	SELECT		SELECT
	s_id,		s_id,
			CAST(s.smw_title AS CHAR) AS s_title,
	p_id,		p_id,
	~~CAST(s.smw_title AS CHAR) AS s_title,~~
	CAST(p.smw_title AS CHAR) AS p_title,		CAST(p.smw_title AS CHAR) AS p_title,
	CAST(o_serialized AS CHAR) AS value		CAST(o_serialized AS CHAR) AS value
Line 30:		Line 30:
	LEFT JOIN		LEFT JOIN
	smw_object_ids AS p ON t.p_id = p.smw_id		smw_object_ids AS p ON t.p_id = p.smw_id
	</~~syntaxhighlight~~>		</source>

Woozle: Created page with "==About== * '''Purpose''': specifications for all SMW Objects that are dates * '''Refers to''': {{l/same|smw_object_ids}} ==Fields== * '''o_serialized''' date value in a slash..."

2018-01-26T18:35:26Z

Created page with "==About== * '''Purpose''': specifications for all SMW Objects that are dates * '''Refers to''': {{l/same|smw_object_ids}} ==Fields== * '''o_serialized''' date value in a slash..."

New page

==About==
* '''Purpose''': specifications for all SMW Objects that are dates
* '''Refers to''': {{l/same|smw_object_ids}}
==Fields==
* '''o_serialized''' date value in a slash-separated format: <code>1/year/month/day/hour/minute/second</code>, e.g. "1/2012/3/21/14/15/0"
** The "1/" might be 0 for BC, but not sure how to test this.
==SQL==
===Definition===
<syntaxhighlight lang=mysql>
CREATE TABLE `smw_di_time` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
</syntaxhighlight>
===Example===
<syntaxhighlight lang=mysql>
SELECT
s_id,
p_id,
CAST(s.smw_title AS CHAR) AS s_title,
CAST(p.smw_title AS CHAR) AS p_title,
CAST(o_serialized AS CHAR) AS value
FROM
(smw_di_time AS t
LEFT JOIN smw_object_ids AS s ON t.s_id = s.smw_id)
LEFT JOIN
smw_object_ids AS p ON t.p_id = p.smw_id
</syntaxhighlight>

Semantic MediaWiki/data/smw di time - Revision history

Woozle: /* Example */ slightly improved query

Woozle: Created page with "==About== * '''Purpose''': specifications for all SMW Objects that are dates * '''Refers to''': {{l/same|smw_object_ids}} ==Fields== * '''o_serialized''' date value in a slash..."