Val Town Code SearchReturn to Val Town

7import { OpenAI } from "https://esm.town/v/std/openai?v=4";
8
9// --- DATABASE (Intentionally blank as requested) ---
10
11const db = {
179    { "id": 48, "onet_soc_code": "15-1211.00", "title": "Computer Systems Analysts", "cluster_id": 10 },
180
181    { "id": 49, "onet_soc_code": "15-1221.00", "title": "Database Administrators", "cluster_id": 10 },
182
183    { "id": 50, "onet_soc_code": "15-1251.00", "title": "Computer Programmers", "cluster_id": 10 },
970    { "onet_soc_code": "13-1161.00", "name": "Analytical or scientific software" },
971
972    { "onet_soc_code": "13-1161.00", "name": "Database user interface and query software" },
973
974    { "onet_soc_code": "11-2021.00", "name": "Web page creation and editing software" },
1081Given input for a Market Research Analyst whose task is to "Analyze data on market conditions to identify potential sales of a product or service," your output must be a JSON object like:
1082
1083{"refined_prompt":"You are a Senior Market Research Analyst. Your primary mandate is to conduct a rigorous, data-driven analysis of prevailing market conditions to identify and quantify potential sales opportunities for the product line known as {{product_or_service}}. This analysis is a cornerstone of the strategic planning for the upcoming {{fiscal_year_and_quarter}} and its accuracy will directly impact resource allocation and marketing strategy.\\n\\nTo successfully execute this directive, you must employ your highly developed skills in Critical Thinking to deconstruct ambiguous market signals and your refined capabilities in formal Analysis to model potential outcomes. Every conclusion and recommendation in your final report must be substantiated by your expert knowledge of foundational Sales and Marketing principles and a firm grasp of Economics and Accounting.\\n\\nYou are expected to operate with maximum proficiency using premier Analytical or scientific software to run predictive models, and you must leverage advanced Database user interface and query software to extract, segment, and aggregate raw data from our internal data warehouse. Your final deliverable is a comprehensive report addressed to {{stakeholder_or_department}}. This report must contain, at minimum, an executive summary, a detailed breakdown of key market segments, multi-quarter sales projections with confidence intervals, and a set of actionable strategic recommendations for the specified product. Begin by outlining your detailed project plan, including data sources and analytical methodologies."}
1084
1085

174```
175├── backend/
176│   ├── database/
177│   │   ├── migrations.ts    # Schema definitions
178│   │   ├── queries.ts       # DB query functions
232```
233
234### Database Patterns
235- Run migrations on startup or comment out for performance
236- Change table names when modifying schemas rather than altering