Val Town Code SearchReturn to Val Town

1import { Hono } from "npm:hono";
2import Stripe from "npm:stripe";
3import { getUser } from "../database/queries.tsx";
4import { getEnvVarName } from "../../shared/is-prod-branch.ts";
5

198```
199├── backend/
200│   ├── database/
201│   │   ├── migrations.ts    # Schema definitions
202│   │   ├── queries.ts       # DB query functions
257  ```
258
259### Database Patterns
260- Run migrations on startup or comment out for performance
261- Change table names when modifying schemas rather than altering

1import { Hono } from "npm:hono";
2import { getUser, getCreditBalance } from "../database/queries.tsx";
3
4const app = new Hono();

14**Goal**: Replace limit checking with credit checking
15
16**Database Changes:**
17
18*   Added credit\_additions table with indexes for performance
21    
22
23**New Functions in /backend/database/queries.tsx:**
24
25*   getCreditBalance(userId) - calculates balance with 50% markup on usage
145--------------------------
146
147**Database Schema:**
148
149Plain textANTLR4BashCC#CSSCoffeeScriptCMakeDartDjangoDockerEJSErlangGitGoGraphQLGroovyHTMLJavaJavaScriptJSONJSXKotlinLaTeXLessLuaMakefileMarkdownMATLABMarkupObjective-CPerlPHPPowerShell.propertiesProtocol BuffersPythonRRubySass (Sass)Sass (Scss)SchemeSQLShellSwiftSVGTSXTypeScriptWebAssemblyYAMLXML`   credit_additions (    id, user_id, created_at, stripe_payment_intent_id, amount, note  )  -- Indexes on user_id for both credit_additions and townie_usage   `
169**Backend:**
170
171*   backend/database/schema.tsx - Added credit\_additions table
172    
173*   backend/database/queries.tsx - New credit functions, removed old limits
174    
175*   backend/routes/send-message.ts - Updated to use credit checking

189```
190├── backend/
191│   ├── database/
192│   │   ├── migrations.ts    # Schema definitions
193│   │   ├── queries.ts       # DB query functions
248  ```
249
250### Database Patterns
251- Run migrations on startup or comment out for performance
252- Change table names when modifying schemas rather than altering
315
316### SQL Operations
317- **execute-sql** / **sqlite-query**: Execute a SQL query against a SQLite database
318- **execute-sql-batch** / **sqlite-exec**: Execute multiple SQL statements against a SQLite database
319
320## Creating Val Town Projects

97```
98├── backend/
99│   ├── database/
100│   │   ├── migrations.ts
101│   │   └── queries.ts
229#### SQL Operations
23021. **execute-sql** / **sqlite-query**
231    - Description: Execute a SQL query against a SQLite database
232    - Arguments: `statement` (string)
233    - Returns: Query results
234
23522. **execute-sql-batch** / **sqlite-exec**
236    - Description: Execute multiple SQL statements against a SQLite database
237    - Arguments: `statements` (array of strings), Optional: `mode` (string: "read" or "write", default: "read")
238    - Returns: Results of the batch execution

9  server.tool(
10    "execute-sql",
11    "Execute a SQL query against a SQLite database",
12    {
13      statement: z.string().describe("SQL statement to execute"),
36  server.tool(
37    "execute-sql-batch",
38    "Execute multiple SQL statements against a SQLite database",
39    {
40      statements: z.array(z.string()).describe("Array of SQL statements to execute"),
67  server.tool(
68    "sqlite-query",
69    "Execute a SQL query against a SQLite database",
70    {
71      statement: z.string().describe("SQL statement to execute"),
94  server.tool(
95    "sqlite-exec",
96    "Execute multiple SQL statements against a SQLite database",
97    {
98      statements: z.array(z.string()).describe("Array of SQL statements to execute"),

172```
173├── backend/
174│   ├── database/
175│   │   ├── migrations.ts    # Schema definitions
176│   │   ├── queries.ts       # DB query functions
234- Handle API calls properly with proper error catching
235
236### Database Patterns
237- Run migrations on startup or comment out for performance
238- Change table names when modifying schemas rather than altering

179```
180├── backend/
181│   ├── database/
182│   │   ├── migrations.ts    # Schema definitions
183│   │   ├── queries.ts       # DB query functions
239  ```
240
241### Database Patterns
242- Run migrations on startup or comment out for performance
243- Change table names when modifying schemas rather than altering

83          </a>
84          <div class="dropdown-content" id="departmentsDropdown">
85            <!-- Dynamically populated from database -->
86          </div>
87        </div>
117      </div>
118      <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6" id="webinarsContainer">
119        <!-- Dynamically populated from database -->
120      </div>
121    </section>
131          <h3 class="text-xl font-semibold mb-4 text-blue-800">Featured Publications</h3>
132          <div class="space-y-6" id="featuredResearch">
133            <!-- Dynamically populated from database -->
134          </div>
135        </div>
137          <h3 class="text-xl font-semibold mb-4 text-blue-800">Recent Additions</h3>
138          <ul class="space-y-3" id="recentResearch">
139            <!-- Dynamically populated from database -->
140          </ul>
141        </div>
150      </div>
151      <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6" id="innovationsContainer">
152        <!-- Dynamically populated from database -->
153      </div>
154    </section>
161      </div>
162      <div class="space-y-6" id="conferencesContainer">
163        <!-- Dynamically populated from database -->
164      </div>
165    </section>
172      </div>
173      <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6" id="departmentsContainer">
174        <!-- Dynamically populated from database -->
175      </div>
176    </section>
186          <h3 class="text-xl font-semibold text-blue-800 mb-4">Optimization Reports</h3>
187          <div class="space-y-4" id="supplyChainReports">
188            <!-- Dynamically populated from database -->
189          </div>
190        </div>
192          <h3 class="text-xl font-semibold text-blue-800 mb-4">Key Metrics</h3>
193          <div class="space-y-6" id="supplyChainMetrics">
194            <!-- Dynamically populated from database -->
195          </div>
196        </div>
209            <h3 class="text-xl font-semibold text-blue-800 mb-4">Upcoming Events</h3>
210            <div class="space-y-4" id="upcomingEvents">
211              <!-- Dynamically populated from database -->
212            </div>
213          </div>
231            <h3 class="text-lg font-semibold text-blue-800 mb-4">This Week</h3>
232            <div class="space-y-2 text-sm" id="weekSummary">
233              <!-- Dynamically populated from database -->
234            </div>
235          </div>