dh_demo

wiki_text.ts (983B)

---

 import { modelBehaviour } from '@/lib/model_helpers'
 import { OkPacket, RowDataPacket } from 'mysql2'
 
 export interface WikiText {
   id: number
   content: string
   encoding: 'utf-8' | 'gzip'
 }
 
 const SQL_GET_WIKI_TEXT = `
     select id, content, encoding
     from wiki_texts
     where id = ?
 `
 
 export const getWikiText = modelBehaviour<
   [id: number],
   WikiText | null
 >(async (conn, args) => {
   const [rows] = await conn.query<RowDataPacket[]>({
     sql: SQL_GET_WIKI_TEXT,
   }, args)
 
   if (rows.length === 0) {
     return null
   }
 
   const row = rows[0]
   return {
     id: row[0],
     content: row[1],
     encoding: row[2],
   }
 })
 
 const SQL_INSERT_WIKI_TEXT = `
     insert into wiki_texts (content, encoding)
     values (?, ?)
 `
 
 export const createWikiText = modelBehaviour<
   [content: string, encoding: 'utf-8' | 'gzip'],
   number
 >(async (conn, args) => {
   const [rows] = await conn.query<OkPacket>({
     sql: SQL_INSERT_WIKI_TEXT,
   }, args)
 
   return rows.insertId
 })