Publish SQL queries for Zed
ClosedPublic
Actions

Authored by dereckson on Jun 6 2023, 22:46.

Tags

None

Referenced Files

	Unknown Object (File)
	Wed, Sep 3, 16:58

	Unknown Object (File)
	Fri, Aug 29, 15:40

	Unknown Object (File)
	Fri, Aug 29, 08:52

	Unknown Object (File)
	Wed, Aug 27, 02:07

	Unknown Object (File)
	Tue, Aug 26, 22:51

	Unknown Object (File)
	Sun, Aug 24, 12:18

	Unknown Object (File)
	Thu, Aug 21, 15:15

	Unknown Object (File)
	Tue, Aug 19, 11:16

View All Files

Subscribers

None

Details

Reviewers

dereckson

Commits

rRPRTb2f5454953c8: Publish SQL queries for Zed

Summary

Determine where (or where not) there is artwork.

Tower locations, from T1C1 to TxC6, are generated using WITH RECURSIVE queries.

Test Plan

Run queries, compare with Zed content

Diff Detail

Repository

rRPRT Nasqueron internal reports

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

dereckson requested review of this revision.Jun 6 2023, 22:46

dereckson created this revision.

Harbormaster completed remote builds in B5013: Diff 8110.Jun 6 2023, 22:46

dereckson accepted this revision.Jun 6 2023, 22:46

This revision is now accepted and ready to land.Jun 6 2023, 22:46

Closed by commit rRPRTb2f5454953c8: Publish SQL queries for Zed (authored by dereckson). · Explain WhyJun 6 2023, 22:46

This revision was automatically updated to reflect the committed changes.

dereckson added a commit: rRPRTb2f5454953c8: Publish SQL queries for Zed.

Revision Contents
Changeset List

Path

Size

sql/

db-A/

zed/

hypership-tower-art-locations-free.sql

35 lines

hypership-tower-art-locations.sql

12 lines

Diff 8111

View Options

sql/db-A/zed/hypership-tower-art-locations-free.sql