-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathloading-current-offers.sql
129 lines (70 loc) · 9.83 KB
/
loading-current-offers.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
-- Manually Loads Offers and Related Data for Shop System
-- This is the Offers Inventory [Merchandising] aspect of the system
log_enable(1);
SPARQL CLEAR GRAPH <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/data/turtle/licenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/data/turtle/products.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/data/turtle/software.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Generic Glossaries --
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/DAV/data/turtle/general/GlossaryOfTerms.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/data/turtle/general/ShopPricingGlossary.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Benefits ---
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/DAV/data/turtle/general/benefits-depiction-mapping.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Features & Benefits Mappings
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/notes/Virtuoso-Features-and-Benefits-Note.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Product Families --
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/DAV/data/turtle/oplweb/ProductFamilies.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/DAV/data/turtle/oplweb/ProductBenefits.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://www.openlinksw.com/DAV/data/turtle/oplweb/ProductFormats.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Virtuoso 7 --
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7BuyServices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso7Actions.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7Licenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7Modules.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7Offers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7OffersPrices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7Products.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2014/Virtuoso7ProductsReleases.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Virtuoso 8 --
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8Actions.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso7/2017/Virtuoso8BuyServices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8Modules.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8Products.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8ProductsReleases.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8Licenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8Offers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso8OffersPrices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Virtuoso 8.2 Special Offers, Licenses [Products], Price Specifications --
-- SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso82Offers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/virtuoso8/2019/Virtuoso-Offers-Licenses-Prices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- LOD Connectivity --
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODBuyServices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODActions.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODProducts.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODLicenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODOffers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODProductsReleases.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://virtuoso.openlinksw.com/data/turtle/lod-connectivity/2019/LODOffersPrices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- UDA MT --
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2016/UDAMTCategorizedBrokerLicenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2016/UDAMTCategorizedDBAgentsLicenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2016/UDAMTCategorizedOffers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2016/UDAMTCategorizedOffersPrices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2016/UDAMTProducts.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2016/UDAMTProductsReleases.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/multi-tier/2019/UDAEnterpriseOffers-Licenses-Prices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- UDA ST --
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTCategorizedLicenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTCategorizedLicenses.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTCategorizedOffers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTCategorizedOffers.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTCategorizedOffersPrices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTCategorizedOffersPrices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Express Edition Offers, Licenses, Prices
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTExpressOffers-Licenses-Prices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Lite Edition Offers, Licenses, Prices
SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDALiteOffers-Licenses-Prices.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDASTProducts.ttl> INTO <urn:data:openlink:products> ;
SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDALiteProducts.ttl> INTO <urn:data:openlink:products> ;
SPARQL define get:soft "no-sponge" LOAD <http://uda.openlinksw.com/data/turtle/single-tier/2019/UDALiteProductsReleases.ttl> INTO <urn:opl:shop:offering:sponging:cache:official> ;
-- Troubleshooting and Cleanup ---