Semantic MediaWiki/data/smw di blob - Revision history

Woozle: another useful query

2018-02-02T12:04:13Z

another useful query

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

Woozle: fields

2018-01-26T19:38:57Z

fields

← Older revision		Revision as of 19:38, 26 January 2018
Line 2:		Line 2:
	* '''Purpose''': specifications for all SMW Objects that are text-blobs (i.e. long text which cannot be associated with a wiki page)		* '''Purpose''': specifications for all SMW Objects that are text-blobs (i.e. long text which cannot be associated with a wiki page)
	* '''Refers to''': {{l/same\|smw_object_ids}}		* '''Refers to''': {{l/same\|smw_object_ids}}
			==Fields==
			* '''s_id''': ID of wiki page on which the property appears
			* '''p_id''': ID of wiki page for the property name
			* '''o_blob''': value when text is too long for <code>o_hash</code>; otherwise NULL
			* '''o_hash''': exact value of text if <code>o_blob</code> is null; otherwise, truncated value with hash appended (purpose unclear)
	==SQL==		==SQL==
	<syntaxhighlight lang=mysql>		<syntaxhighlight lang=mysql>

Woozle: updated syntax highlight tags

2018-01-26T12:48:39Z

updated syntax highlight tags

← Older revision		Revision as of 12:48, 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_blob` (		CREATE TABLE `smw_di_blob` (
	`s_id` int(8) unsigned NOT NULL,		`s_id` int(8) unsigned NOT NULL,
Line 13:		Line 11:
	KEY `s_id` (`s_id`,`p_id`),		KEY `s_id` (`s_id`,`p_id`),
	KEY `p_id` (`p_id`,`o_hash`)		KEY `p_id` (`p_id`,`o_hash`)
	) ENGINE=InnoDB DEFAULT CHARSET=binary$$		) ENGINE=InnoDB DEFAULT CHARSET=binary
	</~~mysql~~>		</syntaxhighlight>
	===Example===		===Example===
	<mysql>		<syntaxhighlight lang=mysql>
	SELECT s_id, p_id		SELECT s_id, p_id
	, s.smw_namespace AS s_namespace		, s.smw_namespace AS s_namespace
Line 29:		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
	ORDER BY s_id		ORDER BY s_id
	</~~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 are text-blobs (i.e. long text which cannot be associated with a wiki page) * '''Refers to''': {{l/same|smw_..."

2013-02-14T15:25:01Z

Created page with "==About== * '''Purpose''': specifications for all SMW Objects that are text-blobs (i.e. long text which cannot be associated with a wiki page) * '''Refers to''': {{l/same|smw_..."

New page

==About==
* '''Purpose''': specifications for all SMW Objects that are text-blobs (i.e. long text which cannot be associated with a wiki page)
* '''Refers to''': {{l/same|smw_object_ids}}
==SQL==
<mysql>
delimiter $$

CREATE TABLE `smw_di_blob` (
`s_id` int(8) unsigned NOT NULL,
`p_id` int(8) unsigned NOT NULL,
`o_blob` mediumblob,
`o_hash` varbinary(255) DEFAULT NULL,
KEY `s_id` (`s_id`,`p_id`),
KEY `p_id` (`p_id`,`o_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=binary$$
</mysql>
===Example===
<mysql>
SELECT s_id, p_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
, CAST(o_blob AS CHAR) as text
, CAST(o_hash AS CHAR) as hash
FROM
(smw_di_blob 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
ORDER BY s_id
</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)