{\n const result = await sqlite.execute(\n `SELECT \n id, user_id as userId, name, street, city, state, \n postal_code as postalCode, country, is_default as isDefault\n FROM ${TABLES.ADDRESSES}\n WHERE id = ?`,\n [id]\n );\n \n return result.rows[0] as Address || null;\n}\n\nexport async function createAddress(address: {\n userId: number;\n name: string;\n street: string;\n city: string;\n state: string;\n postalCode: string;\n country: string;\n isDefault?: boolean;\n}): Promise {\n // If this is the default address, unset any existing default\n if (address.isDefault) {\n await sqlite.execute(\n `UPDATE ${TABLES.ADDRESSES}\n SET is_default = 0\n WHERE user_id = ?`,\n [address.userId]\n );\n }\n \n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.ADDRESSES} \n (user_id, name, street, city, state, postal_code, country, is_default)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n address.userId,\n address.name,\n address.street,\n address.city,\n address.state,\n address.postalCode,\n address.country,\n address.isDefault ? 1 : 0\n ]\n );\n \n return result.rows[0].id;\n}\n\n// Review queries\nexport async function getProductReviews(productId: number): Promise {\n const result = await sqlite.execute(\n `SELECT \n r.id, r.product_id as productId, r.user_id as userId, \n r.rating, r.comment, r.created_at as createdAt,\n u.first_name as userFirstName, u.last_name as userLastName\n FROM ${TABLES.REVIEWS} r\n JOIN ${TABLES.USERS} u ON r.user_id = u.id\n WHERE r.product_id = ?\n ORDER BY r.created_at DESC`,\n [productId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n productId: row.productId,\n userId: row.userId,\n rating: row.rating,\n comment: row.comment,\n createdAt: row.createdAt,\n userFirstName: row.userFirstName,\n userLastName: row.userLastName\n })) as Review[];\n}\n\nexport async function createReview(review: {\n productId: number;\n userId: number;\n rating: number;\n comment?: string;\n}): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.REVIEWS} (product_id, user_id, rating, comment)\n VALUES (?, ?, ?, ?)\n RETURNING id`,\n [\n review.productId,\n review.userId,\n review.rating,\n review.comment || null\n ]\n );\n \n return result.rows[0].id;\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/MuslimTechBro/Ecommerce/code/backend/database/queries.ts","extension","actionData","errors"]