Val Town Code SearchReturn to Val Town

37          username: user.username,
38          bio: user.bio,
39          profile_image_url: user.profileImageUrl,
40          url: user.url,
41          updated_at: new Date().toISOString(), // Using current time as the API doesn't provide updated_at
55      name: project.name,
56      description: project.description,
57      image_url: project.imageUrl,
58      username: project.author.username || "",
59      updated_at: mainBranch?.updatedAt || new Date().toISOString(),

119  fileCount: number;
120  url: string;
121  profile_image_url: string | null;
122  updated_at: string;
123}[]> {
128      COUNT(DISTINCT f.id) as file_count,
129      'https://val.town/u/' || p.username as url,
130      u.profile_image_url,
131      MAX(p.updated_at) as updated_at
132     FROM ${tablePrefix}_projects p
144    fileCount: Number(row.file_count),
145    url: String(row.url),
146    profile_image_url: row.profile_image_url ? String(row.profile_image_url) : null,
147    updated_at: String(row.updated_at)
148  }));
158  description: string | null;
159  url: string;
160  image_url: string | null;
161  updated_at: string;
162}[]> {
168      p.description,
169      p.url,
170      p.image_url,
171      p.updated_at
172     FROM ${tablePrefix}_projects p
184    description: row.description ? String(row.description) : null,
185    url: String(row.url),
186    image_url: row.image_url ? String(row.image_url) : null,
187    updated_at: String(row.updated_at)
188  }));
204    fileCount: number;
205    url: string;
206    profile_image_url: string | null;
207    updated_at: string;
208  }[];
213    description: string | null;
214    url: string;
215    image_url: string | null;
216    updated_at: string;
217  }[];
314      username TEXT,
315      bio TEXT,
316      profile_image_url TEXT,
317      url TEXT NOT NULL,
318      updated_at TIMESTAMP NOT NULL
328      forked_branch_id TEXT,
329      description TEXT,
330      image_url TEXT,
331      user_id TEXT,
332      FOREIGN KEY (user_id) REFERENCES ${tablePrefix}_users(id)
359  username: z.string().nullable(),
360  bio: z.string().nullable(),
361  profile_image_url: z.string().nullable(),
362  url: z.string(),
363  updated_at: z.string().datetime(),
370  username: z.string(),
371  description: z.string().nullable(),
372  image_url: z.string().nullable(),
373  forked_branch_id: z.string().nullable(),
374  updated_at: z.string().datetime(),
433    // Insert new user
434    await sqlite.execute(
435      `INSERT INTO ${tablePrefix}_users (id, username, bio, profile_image_url, url, updated_at)
436       VALUES (?, ?, ?, ?, ?, ?)`,
437      [
439        user.username,
440        user.bio,
441        user.profile_image_url,
442        user.url,
443        user.updated_at,
449    await sqlite.execute(
450      `UPDATE ${tablePrefix}_users
451       SET username = ?, bio = ?, profile_image_url = ?, url = ?, updated_at = ?
452       WHERE id = ?`,
453      [
454        user.username,
455        user.bio,
456        user.profile_image_url,
457        user.url,
458        user.updated_at,
498    // Insert new project
499    await sqlite.execute(
500      `INSERT INTO ${tablePrefix}_projects (id, url, name, username, updated_at, forked_branch_id, description, image_url, user_id)
501       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,
502      [
508        project.forked_branch_id,
509        project.description,
510        project.image_url,
511        project.user_id
512      ],
517    await sqlite.execute(
518      `UPDATE ${tablePrefix}_projects
519       SET url = ?, name = ?, username = ?, updated_at = ?, forked_branch_id = ?, description = ?, image_url = ?, user_id = ?
520       WHERE id = ?`,
521      [
526        project.forked_branch_id,
527        project.description,
528        project.image_url,
529        project.user_id,
530        project.id
812
813  const result = await sqlite.execute(
814    `SELECT u.id, u.username, u.bio, u.profile_image_url, u.url, u.updated_at,
815      (SELECT COUNT(*) FROM ${tablePrefix}_projects p
816       WHERE p.user_id = u.id) as matchCount
827    username: z.string().nullable(),
828    bio: z.string().nullable(),
829    profile_image_url: z.string().nullable(),
830    url: z.string(),
831    updated_at: z.string().datetime(),
889      // Always launch the files query for the active type or for samples
890      const result = await sqlite.execute(
891        `SELECT f.*, p.name as project_name, p.url as project_url, p.username, p.description, p.image_url
892          FROM ${tablePrefix}_files f
893          JOIN ${tablePrefix}_projects p ON f.project_id = p.id
904        username: z.string(),
905        description: z.string().nullable(),
906        image_url: z.string().nullable(),
907      });
908
1062  project_url: string;
1063  project_description: string | null;
1064  user_profile_image_url: string | null;
1065  update_count: number;
1066}[]> {
1081      p.url as project_url,
1082      p.description as project_description,
1083      u.profile_image_url as user_profile_image_url,
1084      -- Use updated_at as a proxy for edit frequency
1085      1 as update_count
1103    project_url: String(row.project_url),
1104    project_description: row.project_description ? String(row.project_description) : null,
1105    user_profile_image_url: row.user_profile_image_url ? String(row.user_profile_image_url) : null,
1106    update_count: Number(row.update_count)
1107  }));
1122  url: string;
1123  description: string | null;
1124  image_url: string | null;
1125  user_profile_image_url: string | null;
1126  edit_sessions: number;
1127  file_count: number;
1140      p.url,
1141      p.description,
1142      p.image_url,
1143      u.profile_image_url as user_profile_image_url,
1144      COUNT(DISTINCT strftime('%Y-%m-%d %H:%M', f.updated_at)) as edit_sessions,
1145      COUNT(f.id) as file_count,
1163    url: String(row.url),
1164    description: row.description ? String(row.description) : null,
1165    image_url: row.image_url ? String(row.image_url) : null,
1166    user_profile_image_url: row.user_profile_image_url ? String(row.user_profile_image_url) : null,
1167    edit_sessions: Number(row.edit_sessions),
1168    file_count: Number(row.file_count),

228      <div className="result-header">
229        <div className="result-header-content">
230          {result.image_url && (
231            <div className="project-image">
232              <img src={result.image_url} alt={result.project_name} />
233            </div>
234          )}
292      <div className="result-header">
293        <div className="result-header-content">
294          {result.image_url && (
295            <div className="project-image">
296              <img src={result.image_url} alt={result.name} />
297            </div>
298          )}
351      <div className="result-header">
352        <div className="user-header">
353          {result.profile_image_url && (
354            <div className="user-avatar">
355              <img src={result.profile_image_url} alt={result.username || "User"} />
356            </div>
357          )}
1224                          <a href="?q=api" className="example-link">api</a>
1225                          <a href="?q=database" className="example-link">database</a>
1226                          <a href="?q=image" className="example-link">image</a>
1227                          <a href="?q=function" className="example-link">function</a>
1228                          <a href="?q=discord" className="example-link">discord</a>
1289                                  <div className="contributor-header">
1290                                    <div className="contributor-avatar">
1291                                      {contributor.profile_image_url
1292                                        ? <img src={contributor.profile_image_url} alt={contributor.username} />
1293                                        : (
1294                                          <div
1337                                  rel="noopener noreferrer"
1338                                >
1339                                  <div className="project-image">
1340                                    {project.image_url
1341                                      ? <img src={project.image_url} alt={project.name} />
1342                                      : (
1343                                        <div
1378                        <a href="?q=api" className="example-link">api</a>
1379                        <a href="?q=database" className="example-link">database</a>
1380                        <a href="?q=image" className="example-link">image</a>
1381                        <a href="?q=function" className="example-link">function</a>
1382                        <a href="?q=discord" className="example-link">discord</a>
1419          <div className="val-meta">
1420            <span className="username">
1421              {val.user_profile_image_url && (
1422                <img 
1423                  src={val.user_profile_image_url} 
1424                  alt={val.username} 
1425                  className="profile-image"
1426                />
1427              )}
1472            <div className="project-meta">
1473              <div className="username">
1474                {project.user_profile_image_url && (
1475                  <img 
1476                    src={project.user_profile_image_url} 
1477                    alt="Profile" 
1478                    className="profile-image"
1479                  />
1480                )}
1824  }
1825  
1826  .profile-image {
1827    width: 20px;
1828    height: 20px;

GitHub-PR-AutomationREADME.md2 matches

@charmaine•Updated 7 hours ago

12
13See all 3 in action👇
14![Assignee_Label.gif](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/d46f0781-8f79-4e93-cb1b-c1ac72cc4000/public)
15
16### 1. PR Auto-Assign
51
52See this in action👇
53![GitHubSlack.gif](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/fc444d1e-4954-4e2d-b508-920bdac55d00/public)
54
55

22      useShareButton: false,
23      useAiEditText: true,
24      useAiEditImage: true,
25      useAiTranslate: true,
26      useAdServing: true,

75          targetDate: travelDate,
76          category: 'travel',
77          imageUrl: selectedDestination.imageUrl
78        }),
79      });

19    targetDate: '',
20    category: '',
21    imageUrl: ''
22  });
23  const [addingMoney, setAddingMoney] = useState<{ goalId: number; amount: string } | null>(null);
91          targetDate: '',
92          category: '',
93          imageUrl: ''
94        });
95        setShowForm(false);

8    <script src="https://esm.town/v/std/catch"></script>
9    <link rel="stylesheet" href="/frontend/style.css">
10    <link rel="icon" href="data:image/svg+xml,<svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'><text y='.9em' font-size='90'>💰</text></svg>">
11    <style>
12        /* Custom animations and styles */

24  try {
25    const body = await c.req.json();
26    const { title, description, targetAmount, targetDate, category, imageUrl } = body;
27    
28    if (!title || !targetAmount || !targetDate || !category) {
48      targetDate,
49      category,
50      imageUrl: imageUrl || null
51    });
52    

98export async function addGoal(goal: Omit<Goal, 'id' | 'createdAt' | 'isCompleted'>): Promise<number> {
99  const result = await sqlite.execute(`
100    INSERT INTO goals_v1 (user_id, title, description, target_amount, current_amount, target_date, category, image_url)
101    VALUES (?, ?, ?, ?, ?, ?, ?, ?)
102  `, [goal.userId, goal.title, goal.description, goal.targetAmount, goal.currentAmount, goal.targetDate, goal.category, goal.imageUrl]);
103  
104  return result.lastInsertRowId;
121    targetDate: row.target_date,
122    category: row.category,
123    imageUrl: row.image_url,
124    isCompleted: Boolean(row.is_completed),
125    createdAt: row.created_at
183    },
184    description: row.description,
185    imageUrl: row.image_url || '',
186    popularMonths: row.popular_months ? row.popular_months.split(',') : []
187  }));