Location point - Revision history

Evinek at 08:33, 8 March 2017

2017-03-08T08:33:43Z

← Older revision		Revision as of 10:33, 8 March 2017
Line 2:		Line 2:
	<pre>		<pre>
	SELECT		SELECT
	~~"public".~~imsmaenum.enumvalue,		imsmaenum.enumvalue,
	Count(~~"public".~~geopoint.geopoint_guid)		Count(geopoint.geopoint_guid)
	FROM		FROM
	~~"public".~~imsmaenum		imsmaenum
	INNER JOIN ~~"public".~~geopoint ON ~~"public".~~geopoint.pointtypeenum_guid = ~~"public".~~imsmaenum.imsmaenum_guid		INNER JOIN geopoint ON geopoint.pointtypeenum_guid = imsmaenum.imsmaenum_guid
	GROUP BY		GROUP BY
	~~"public".~~imsmaenum.enumvalue		imsmaenum.enumvalue
	ORDER BY		ORDER BY
	~~"public".~~imsmaenum.enumvalue ASC		imsmaenum.enumvalue ASC
	</pre>		</pre>

Alnaucler at 18:14, 11 April 2015

2015-04-11T18:14:51Z

← Older revision		Revision as of 20:14, 11 April 2015
Line 1:		Line 1:
	Run this query ~~'''before''' the database upgrade starts and compare with the result '''after''' upgrade~~.		Run this query to check if there are any Location points.
	<pre>		<pre>
	SELECT		SELECT
Line 13:		Line 13:
	</pre>		</pre>

			If there are Location points this query will change them to Reference points.
			<pre>
			UPDATE geopoint
			SET
			geopoint.pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
			WHERE
			geopoint.pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'
			</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 03:43, 18 November 2014

2014-11-18T03:43:13Z

← Older revision		Revision as of 05:43, 18 November 2014
Line 1:		Line 1:
	~~{{Warning \| This page contains UPDATE and DELETE queries}}~~		Run this query '''before''' the database upgrade starts and compare with the result '''after''' upgrade.

	~~This~~ query ~~changes~~ '''~~Location point~~''' to '''~~Reference point~~'''
	<pre>		<pre>
	~~UPDATE~~ geopoint		SELECT
	~~SET~~		"public".imsmaenum.enumvalue,
	pointtypeenum_guid = ~~'{BaseData-PointType-00000000000-00001}'~~		Count("public".geopoint.geopoint_guid)
	~~WHERE~~		FROM
	~~pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'~~		"public".imsmaenum
			INNER JOIN "public".geopoint ON "public".geopoint.pointtypeenum_guid = "public".imsmaenum.imsmaenum_guid
			GROUP BY
			"public".imsmaenum.enumvalue
			ORDER BY
			"public".imsmaenum.enumvalue ASC
	</pre>		</pre>

	~~<pre>~~
	~~DELETE FROM imsmaenum~~
	~~WHERE~~
	~~imsmaenum.enumcategory = 'Point Type' AND~~
	~~imsmaenum.enumvalue = 'Location Point' AND~~
	~~imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'~~
	~~</pre>~~
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 03:12, 31 October 2014

2014-10-31T03:12:02Z

← Older revision		Revision as of 05:12, 31 October 2014
Line 17:		Line 17:
	imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'		imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'
	</pre>		</pre>
			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 10:53, 20 October 2014

2014-10-20T10:53:11Z

← Older revision		Revision as of 12:53, 20 October 2014
Line 5:		Line 5:
	UPDATE geopoint		UPDATE geopoint
	SET		SET
	~~geopoint.~~pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'		pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
	WHERE		WHERE
	~~geopoint.~~pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'		pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'
	</pre>		</pre>

Alnaucler: Created page with "{{Warning | This page contains UPDATE and DELETE queries}} This query changes '''Location point''' to '''Reference point'''

 UPDATE geopoint SET geopoint.pointtypeenum_g..."

2014-10-09T15:01:21Z

Created page with "{{Warning | This page contains UPDATE and DELETE queries}} This query changes '''Location point''' to '''Reference point''' <pre> UPDATE geopoint SET geopoint.pointtypeenum_g..."

New page

{{Warning | This page contains UPDATE and DELETE queries}}

This query changes '''Location point''' to '''Reference point'''
<pre>
UPDATE geopoint
SET
geopoint.pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
WHERE
geopoint.pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'
</pre>

<pre>
DELETE FROM imsmaenum
WHERE
imsmaenum.enumcategory = 'Point Type' AND
imsmaenum.enumvalue = 'Location Point' AND
imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'
</pre>

[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]