skills.rest
chuangkevin
chuangkevinCOMMUNITY
Explore all skills by this author →
GitHub

houseprice-object-sync

Documents Hangfire jobs syncing data from MySQL-like sources to AWS S3 targets.

Updated Mar 16, 2026
Search Tags:#elasticsearch#mssql#job-scheduling#hangfire#houseprice#ai-image-processing#click-count
One-click install
npx skills add https://github.com/chuangkevin/project-bridge --skill houseprice-object-sync
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: houseprice-object-sync
Source: https://github.com/chuangkevin/project-bridge/tree/main/skill/houseprice/business/houseprice-object-sync
Command: npx skills add https://github.com/chuangkevin/project-bridge --skill houseprice-object-sync

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill documents and clarifies the end-to-end HousePrice object synchronization workflows so engineers can confidently develop, debug, and operate the background jobs that move data from MSSQL to Elasticsearch and the C-side display layer.

Core Features & Use Cases

  • Job inventory and schedules: Lists all recurring and manual Hangfire jobs (AdaptedWebCaseJob, BuyBusinessCaseViewDataJob, AIPictureJob, ClickCount tasks, etc.) and their typical triggers and timings.
  • Data flow mapping: Describes how AdaptedWebCase and related tables are assembled, how SP15 and other stored procedures participate in grouping, and how documents are written into the buy_business_case ES index.
  • Operational rules and error handling: Explains expiration vs advertisement flows, orphan image cleanup, retry and batching strategies, queueing patterns, and common anomalous states and fixes.
  • Real-world use: Useful for Hangfire job development, troubleshooting MSSQL→ES sync issues, validating ES mappings, implementing AI image pipelines, and reproducing production anomalies.

Quick Start

Ask for a concise runbook: Describe how buy_business_case documents are constructed from AdaptedWebCase tables, list the jobs that touch those records, and outline the checkpoints to verify a successful MSSQL-to-ES sync.

Frequently Asked Questions about houseprice-object-sync

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I sync data from MSSQL to Elasticsearch using Hangfire jobs?▼

MSSQL to Elasticsearch sync is handled by Hangfire jobs like AdaptedWebCaseJob that assemble AdaptedWebCase tables and write documents into the buy_business_case ES index. You can use the job inventory and data flow mappings to implement the pipeline and verify successful synchronization.

What is the data flow for building buy_business_case Elasticsearch documents?▼

The buy_business_case documents are built by assembling AdaptedWebCase and related tables, using SP15 and other stored procedures for grouping, then writing the final records into the Elasticsearch index. This data flow mapping clarifies how table-to-index transformations occur.

How do I troubleshoot a failed HousePrice object synchronization job?▼

Troubleshooting a failed HousePrice object synchronization job involves checking the operational rules and error handling patterns for retry strategies, batching, and queueing. You can reproduce production anomalies using the provided event handler listings and operational checks.

Can I use this to debug AI image processing and click count tasks in Hangfire?▼

Yes, this documents the AIPictureJob and ClickCount tasks alongside their triggers and timings. It provides operational checks and error handling patterns for orphan image cleanup and anomalous states needed to debug these specific Hangfire jobs.

What are the limitations when handling advertisement expiry versus object expiration in sync workflows?▼

Limitations involve navigating the distinct operational rules for advertisement expiry versus object expiration flows. The documentation explains these specific constraints, orphan image cleanup behaviors, and common anomalous states to help you avoid sync errors.

Does this Skill provide stored procedure mappings for MSSQL to ES pipelines?▼

Yes, it details how SP15 and other stored procedures participate in grouping AdaptedWebCase table data before it is written to the Elasticsearch index. These table-to-index mappings are essential for validating your MSSQL to ES pipeline.

Related Skills

Explore More Software Engineering Skills→
chuangkevinchuangkevin

houseprice-backend-architecture

Document MSSQL to Elasticsearch sync architecture with Hangfire jobs and cache strategies.

Community
Intermediate
chambear2809chambear2809
36

splunk-enterprise-security-config

Configure and validate Splunk Enterprise Security deployments with declarative YAML workflows.

Community
Advanced
desibarradesibarra

replicate-integration

Deploy and run AI models on Replicate with polling and webhook workflows.

Community
Advanced
EmmanuelkwaaEmmanuelkwaa
1

add-background-job

Schedule recurring and one-time background jobs in .NET with Hangfire.

Community
Intermediate