Hi Sir,
We have one application with postgres DB and Java front end.Now we have
written some procedure by
*IN* and *OUT* parameter and the front team used to use that IN & OUT
parameter and fetch the data from DB .The requirement
is that, the same thing we have to implement by using Solr. We have to show
the IN parameter in the URL
so that the front end team can use that URL by using IN parameter and fetch
the data also the out parameter
should display through application. Please help me out. Thanks in advance.
Thanks !
<dataConfig>
<dataSource type="JdbcDataSource" driver="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/10kinfo_data" user="root" password="" batchSize="100" convertType="false" autoCommit="true" />
<document>
<entity name="items" transformer="TemplateTransformer" query="SELECT a.photo_name AS o_photo_name,
a.description AS o_description,
CASE WHEN EXISTS (SELECT 1 FROM cloud10k.txn_ds_favourite
WHERE photo_id = a.photo_id
AND upper(photo_name) = upper(a.photo_name)
AND member_id = 14193
AND fav_photo_typeid = 1
AND record_status = TRUE
)
THEN TRUE ELSE FALSE
END AS o_is_favorite,
NULL::varchar AS o_report_abuse,
NULL::varchar AS o_url,
1 AS o_page_cnt,
a.photo_id AS o_photo_id,
cloud10k.coalesce_emptystring(b.member_name,b.firstname) AS o_photo_owner_name,
b.image_name AS o_photo_owner_image,
a.page_id AS o_page_id,
CASE WHEN EXISTS (SELECT 1 FROM cloud10k.txn_dreamer_follow
WHERE entity_id = a.added_member_id
AND member_id = 14193
AND d_follow_type_id = 3
AND record_status = TRUE
)
THEN TRUE ELSE FALSE
END AS o_is_follow,
a.added_member_id AS o_photo_owner_id,
a.tags AS o_image_source,
CASE WHEN c.is_verified = 't' THEN FALSE ELSE TRUE
END AS o_website_flag,
d.page_name AS o_v_page_name,
ARRAY( SELECT photo_name
FROM cloud10k.txn_photos
WHERE page_id = a.page_id
AND record_status IS TRUE
ORDER BY gmt_logtime DESC
LIMIT 5
) AS o_v_photo_name,
ARRAY( SELECT photo_id
FROM cloud10k.txn_photos
WHERE page_id = a.page_id
AND record_status IS TRUE
ORDER BY gmt_logtime DESC
LIMIT 5
) AS o_v_photo_id,
g.added_member_id AS o_paste_mem_id,
g.usrname AS o_paste_mem_name,
g.image_name AS o_paste_mem_image,
g.follow AS o_follow,
COALESCE(
(SELECT m.media_value FROM cloud10k.txn_media m, (SELECT i.business_id FROM cloud10k.txn_pages i,
(SELECT k.page_id FROM cloud10k.txn_photos k
WHERE k.photo_name = a.photo_name
AND k.paste_photo_id IS NULL
LIMIT 1
) j
WHERE i.page_id = j.page_id
AND i.business_id IS NOT NULL
AND i.record_status IS TRUE
LIMIT 1
) n
WHERE m.business_id = n.business_id
AND m.media_id = 3
AND m.is_active IS TRUE
),
(SELECT m.media_value FROM cloud10k.txn_media m, (SELECT i.p_business_id FROM cloud10k.txn_pages i,
(SELECT k.page_id FROM cloud10k.txn_photos k
WHERE k.photo_name = a.photo_name
AND k.paste_photo_id IS NULL
LIMIT 1
) j
WHERE i.page_id = j.page_id
AND i.p_business_id IS NOT NULL
AND i.record_status IS TRUE
LIMIT 1
) n
WHERE m.business_id = n.p_business_id
AND m.media_id = 3
AND m.is_active IS TRUE
)
) AS o_bus_logo,
(SELECT m.publicname FROM cloud10k.mst_business m, (SELECT i.p_business_id FROM cloud10k.txn_pages i,
(SELECT k.page_id FROM cloud10k.txn_photos k
WHERE k.photo_name = a.photo_name
AND k.paste_photo_id IS NULL
LIMIT 1
) j
WHERE i.page_id = j.page_id
LIMIT 1
) n
WHERE m.business_id = n.p_business_id
) AS o_bus_name,
bus_photo_desc AS o_bus_photo_desc,
(SELECT COALESCE(seo_category,'')||'|'||COALESCE(seo_subcategory,'')||'|'||COALESCE(search_tokens,'') FROM cloud10k.txn_pages
WHERE page_id = a.page_id
AND record_status IS TRUE
)::VARCHAR AS o_seo_meta_keyword,
d.page_name AS o_page_name,
cloud10k.sp_ds_number_notations(a.view_count) as o_view_count,
a.cart_count::varchar AS o_cart_count,
(CASE WHEN LENGTH(cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description))>35
THEN d.page_name
ELSE SUBSTRING(cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description) FROM 1 FOR 35)
END)::VARCHAR AS o_alt_text,
a.is_buy_it_photo AS o_buy_it_now_flag,
a.fav_cnt AS o_fav_cnt,
a.paste_cnt AS o_paste_cnt,
(SELECT member_id FROM cloud10k.txn_pages
WHERE page_id IN ( SELECT page_id FROM cloud10k.txn_photos
WHERE photo_name = a.photo_name
AND paste_photo_id IS NULL
)
AND p_business_id IS NOT NULL
AND member_id IS NOT NULL
LIMIT 1
) AS o_bus_ownerid,
cloud10k.sp_ds_commemnt_ago(a.gmt_logtime) AS o_photo_age,
CASE WHEN EXISTS (SELECT 1 FROM cloud10k.txn_report_abuse
WHERE UPPER(entity_id) = LOWER(entity_id)
AND entity_id::BIGINT = a.photo_id
AND member_id = 14193
AND entity_type = 'OnematchPagePhoto'
AND apps_name = 'DS'
)
THEN TRUE ELSE FALSE
END AS o_is_report_abuse,
(CASE WHEN LENGTH(cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description))<=70
THEN cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description)||'.'||' Explore more on '||coalesce(cloud10k.coalesce_emptystring(b.member_name,b.firstname),'0')||'''s '||d.page_name||' page at Dreamstream.com - Find, share & save the Amazing!'
ELSE 'Find '||cloud10k.coalesce_emptystring(b.member_name,b.firstname)||'''s, '||d.page_name||' images & interests at Dreamstream.com. '||SUBSTRING(cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description) FROM 1 FOR 50)||'.. see more..'
END)::VARCHAR AS o_seo_meta_description,
html_desc AS o_html_desc,
html_bus_desc AS o_html_bus_desc,
buynow_keywords AS o_buynow_keywords,
(CASE WHEN LENGTH(cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description))>35
THEN 'Find, Share & Save The Amazing | '||coalesce(cloud10k.coalesce_emptystring(b.member_name,b.firstname),'0')||'''s Interests & Image at Dreamstream.com'
ELSE SUBSTRING(cloud10k.coalesce_emptystring(a.bus_photo_desc,a.description) FROM 1 FOR 35)||' | Find , Share & Save The Amazing at Dreamstream'
END)::VARCHAR AS o_seo_title,
(d.seo_page_url||'-'||a.page_id||'/pview')::VARCHAR AS o_seo_page_url
FROM cloud10k.txn_photos a LEFT JOIN cloud10k.mst_memberdetail b
ON(a.added_member_id = b.member_id)
LEFT JOIN cloud10k.txn_report_abuse c
ON( a.photo_id::VARCHAR= c.entity_id)
LEFT JOIN cloud10k.txn_pages d
ON(a.page_id = d.page_id)
LEFT JOIN (SELECT e.added_member_id,
image_name,
paste_photo_id,
cloud10k.coalesce_emptystring(member_name,firstname) AS usrname ,
CASE WHEN EXISTS (SELECT 1 FROM cloud10k.txn_dreamer_follow
WHERE member_id = 14193
AND entity_id = (SELECT added_member_id FROM cloud10k.txn_photos WHERE photo_id = e.paste_photo_id)
AND d_follow_type_id = 3
AND record_status = TRUE
)
THEN TRUE ELSE FALSE
END AS follow FROM cloud10k.txn_photos e ,cloud10k.mst_memberdetail f
WHERE e.added_member_id = f.member_id
AND paste_photo_id is not null
AND record_status IS TRUE
) g
ON(a.photo_id = g.paste_photo_id)
WHERE a.record_status IS TRUE; ">
<field column="o_photo_name" name="o_photo_name"/>
<field column="o_description" name="o_description"/>
<field column="o_is_favorite" name="o_is_favorite"/>
<field column="o_report_abuse" name="o_report_abuse"/>
<field column="o_url" name="o_url"/>
<field column="o_page_cnt" name="o_page_cnt"/>
<field column="o_photo_id" name="o_photo_id"/>
<field column="o_photo_owner_name" name="o_photo_owner_name"/>
<field column="o_photo_owner_image" name="o_photo_owner_image"/>
<field column="o_page_id" name="o_page_id"/>
<field column="o_is_follow" name="o_is_follow"/>
<field column="o_photo_owner_id" name="o_photo_owner_id"/>
<field column="o_image_source" name="o_image_source"/>
<field column="o_website_flag" name="o_website_flag"/>
<field column="o_v_page_name" name="o_v_page_name"/>
<field column="o_v_photo_name" name="o_v_photo_name"/>
<field column="o_v_photo_id" name="o_v_photo_id"/>
<field column="o_paste_mem_id" name="o_paste_mem_id"/>
<field column="o_paste_mem_name" name="o_paste_mem_name"/>
<field column="o_paste_mem_image" name="o_paste_mem_image"/>
<field column="o_follow" name="o_follow"/>
<field column="o_bus_logo" name="o_bus_logo"/>
<field column="o_bus_name" name="o_bus_name"/>
<field column="o_bus_photo_desc" name="o_bus_photo_desc"/>
<field column="o_seo_meta_keyword" name="o_seo_meta_keyword"/>
<field column="o_page_name" name="o_page_name"/>
<field column="o_view_count" name="o_view_count"/>
<field column="o_cart_count" name="o_cart_count"/>
<field column="o_alt_text" name="o_alt_text"/>
<field column="o_buy_it_now_flag" name="o_buy_it_now_flag"/>
<field column="o_fav_cnt" name="o_fav_cnt"/>
<field column="o_paste_cnt" name="o_paste_cnt"/>
<field column="o_bus_ownerid" name="o_bus_ownerid"/>
<field column="o_photo_age" name="o_photo_age"/>
<field column="o_is_report_abuse" name="o_is_report_abuse"/>
<field column="o_seo_meta_description" name="o_seo_meta_description"/>
<field column="o_html_desc" name="o_html_desc"/>
<field column="o_html_bus_desc" name="o_html_bus_desc"/>
<field column="o_buynow_keywords" name="o_buynow_keywords"/>
<field column="o_seo_title" name="o_seo_title"/>
<field column="o_seo_page_url" name="o_seo_page_url"/>
</entity>
</document>
</dataConfig>
