Semantic MediaWiki/data/smw di wikipage - Revision history

Woozle: /* relationships */ improved query

2020-07-09T21:11:40Z

relationships: improved query

← Older revision		Revision as of 21:11, 9 July 2020
Line 32:		Line 32:
	</syntaxhighlight>		</syntaxhighlight>
	====relationships====		====relationships====
	<~~syntaxhighlight~~ lang=mysql>		<source lang=mysql>
	SELECT s_id~~,p_id,o_id~~		SELECT
	, s.smw_namespace AS ~~s_namespace~~		s_id
			, s.smw_namespace AS s_ns
	, CAST(s.smw_title AS char) AS s_title		, CAST(s.smw_title AS char) AS s_title
	, p.smw_namespace AS ~~p_namespace~~		, p_id
			, p.smw_namespace AS p_ns
	, CAST(p.smw_title AS char) AS p_title		, CAST(p.smw_title AS char) AS p_title
	, o.smw_namespace AS ~~o_namespace~~		, o_id
			, o.smw_namespace AS o_ns
	, CAST(o.smw_title AS char) AS o_title		, CAST(o.smw_title AS char) AS o_title
	FROM		FROM
Line 45:		Line 48:
	LEFT JOIN smw_object_ids AS p ON r.p_id=p.smw_id)		LEFT JOIN smw_object_ids AS p ON r.p_id=p.smw_id)
	LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id		LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id
	ORDER BY s_id, p_title, o_title		ORDER BY s.smw_title, s_id, p_title, o_title</source>
	</~~syntaxhighlight~~>
	* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)		* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)

Woozle: wrong table for "simple", and anyway this one has to be a join if we want to look up values, so let's call it "values"

2018-02-02T11:11:39Z

wrong table for "simple", and anyway this one has to be a join if we want to look up values, so let's call it "values"

← Older revision		Revision as of 11:11, 2 February 2018
Line 18:		Line 18:
	</syntaxhighlight>		</syntaxhighlight>
	===Example===		===Example===
	====~~simple~~====		====values====
	<syntaxhighlight lang=mysql>		<syntaxhighlight lang=mysql>
	SELECT		SELECT
	~~smw_id~~,		s_id,
	~~smw_namespace~~,		p_id,
	~~CAST(smw_title AS CHAR) AS title~~,		o_id,
	~~CAST(smw_iw AS CHAR)~~ AS iw,		o.smw_namespace AS o_namespace,
	CAST(~~smw_subobject AS CHAR) AS subobject,~~		CAST(o.smw_title AS CHAR) AS o_title
	~~CAST(smw_sortkey AS CHAR) AS sortkey,~~
	~~CAST(smw_proptable_hash~~ AS CHAR) AS ~~proptable_hash~~
	FROM		FROM
	smw_object_ids;		smw_di_wikipage AS r
			LEFT JOIN
			smw_object_ids AS o ON r.o_id = o.smw_id;
	</syntaxhighlight>		</syntaxhighlight>
	====relationships====		====relationships====

Woozle: simple example

2018-01-28T17:22:27Z

simple example

@@ Line 18: / Line 18: @@
 </syntaxhighlight>
 ===Example===
 <syntaxhighlight lang=mysql>
 SELECT s_id,p_id,o_id

Woozle: fields

2018-01-26T19:39:12Z

fields

← Older revision		Revision as of 19:39, 26 January 2018
Line 2:		Line 2:
	* '''Purpose''': specifications for all SMW Objects where the value is a possible wiki page title (existing or not)		* '''Purpose''': specifications for all SMW Objects where the value is a possible wiki page title (existing or not)
	* '''Refers to''': {{l/same\|smw_object_ids}}		* '''Refers to''': {{l/same\|smw_object_ids}}
			==Fields==
			* '''p_id''': page on which the property appears
			* '''s_id''': page for property name
			* '''o_od''': page for property value
	==SQL==		==SQL==
	<syntaxhighlight lang=mysql>		<syntaxhighlight lang=mysql>

Woozle: slightly improved explanation; example tweak

2018-01-26T19:22:09Z

slightly improved explanation; example tweak

← Older revision		Revision as of 19:22, 26 January 2018
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': specifications for all SMW Objects ~~that point to~~ wiki ~~pages~~ (existing or not)		* '''Purpose''': specifications for all SMW Objects where the value is a possible wiki page title (existing or not)
	* '''Refers to''': {{l/same\|smw_object_ids}}		* '''Refers to''': {{l/same\|smw_object_ids}}
	==SQL==		==SQL==
Line 15:		Line 15:
	===Example===		===Example===
	<syntaxhighlight lang=mysql>		<syntaxhighlight lang=mysql>
	SELECT s_id		SELECT s_id,p_id,o_id
	, s.smw_namespace AS s_namespace		, s.smw_namespace AS s_namespace
	, CAST(s.smw_title AS char) AS s_title		, CAST(s.smw_title AS char) AS s_title
Line 27:		Line 27:
	LEFT JOIN smw_object_ids AS p ON r.p_id=p.smw_id)		LEFT JOIN smw_object_ids AS p ON r.p_id=p.smw_id)
	LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id		LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id
	ORDER BY s_id,p_title, o_title		ORDER BY s_id, p_title, o_title
	</syntaxhighlight>		</syntaxhighlight>
	* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)		* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)

Woozle: updated syntax highlight tags

2018-01-26T12:51:02Z

updated syntax highlight tags

← Older revision		Revision as of 12:51, 26 January 2018
Line 3:		Line 3:
	* '''Refers to''': {{l/same\|smw_object_ids}}		* '''Refers to''': {{l/same\|smw_object_ids}}
	==SQL==		==SQL==
	<mysql>		<syntaxhighlight lang=mysql>
	~~delimiter $$~~

	CREATE TABLE `smw_di_wikipage` (		CREATE TABLE `smw_di_wikipage` (
	`s_id` int(8) unsigned NOT NULL,		`s_id` int(8) unsigned NOT NULL,
Line 13:		Line 11:
	KEY `p_id` (`p_id`,`o_id`),		KEY `p_id` (`p_id`,`o_id`),
	KEY `o_id` (`o_id`)		KEY `o_id` (`o_id`)
	) ENGINE=InnoDB DEFAULT CHARSET=binary$$		) ENGINE=InnoDB DEFAULT CHARSET=binary
	</~~mysql~~>		</syntaxhighlight>
	===Example===		===Example===
	<mysql>		<syntaxhighlight lang=mysql>
	SELECT s_id		SELECT s_id
	, s.smw_namespace AS s_namespace		, s.smw_namespace AS s_namespace
Line 30:		Line 28:
	LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id		LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id
	ORDER BY s_id,p_title, o_title		ORDER BY s_id,p_title, o_title
	</~~mysql~~>		</syntaxhighlight>
	* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)		* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)

Woozle: Created page with "==About== * '''Purpose''': specifications for all SMW Objects that point to wiki pages (existing or not) * '''Refers to''': {{l/same|smw_object_ids}} ==SQL== delimiter..."

2013-02-14T15:21:38Z

Created page with "==About== * '''Purpose''': specifications for all SMW Objects that point to wiki pages (existing or not) * '''Refers to''': {{l/same|smw_object_ids}} ==SQL== <mysql> delimiter..."

New page

==About==
* '''Purpose''': specifications for all SMW Objects that point to wiki pages (existing or not)
* '''Refers to''': {{l/same|smw_object_ids}}
==SQL==
<mysql>
delimiter $$

CREATE TABLE `smw_di_wikipage` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary$$
</mysql>
===Example===
<mysql>
SELECT s_id
, s.smw_namespace AS s_namespace
, CAST(s.smw_title AS char) AS s_title
, p.smw_namespace AS p_namespace
, CAST(p.smw_title AS char) AS p_title
, o.smw_namespace AS o_namespace
, CAST(o.smw_title AS char) AS o_title
FROM
((smw_di_wikipage AS r
LEFT JOIN smw_object_ids AS s ON r.s_id=s.smw_id)
LEFT JOIN smw_object_ids AS p ON r.p_id=p.smw_id)
LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id
ORDER BY s_id,p_title, o_title
</mysql>
* p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)