Data.fs

namespace SqlFun.NpgSql.Tests

open System
open SqlFun
open Common

module Data = 

    type PostStatus = 
        | [<EnumValue("N")>] New = 0
        | [<EnumValue("P")>] Published = 1
        | [<EnumValue("A")>] Archived = 2

    
    type Comment = {
        commentId: int
        postId: int
        parentId: int option
        content: string
        author: string
        createdAt: DateOnly
        creationTime: TimeOnly
    }

    type Post = {
        postId: int
        blogId: int
        name: string
        title: string
        content: string
        author: string
        createdAt: DateOnly
        modifiedAt: DateOnly option
        modifiedBy: string option
        status: PostStatus
    }

    type Blog = {
        blogId: int
        name: string
        title: string
        description: string
        owner: string
        createdAt: DateOnly
        modifiedAt: DateOnly option
        modifiedBy: string option
        posts: Post list
    }

    type UserProfile = {
        id: string
        name: string
        email: string
        avatar: byte array
    }


module Tooling = 
    
    let getNumberOfBlogs: IDataContext -> int = 
        sql "select count(*) from blog"

    let deleteAllButFirstBlog: IDataContext -> unit = 
        sql "delete from blog where blogid > 1"

    let deleteAllUsers: IDataContext -> unit = 
        sql "delete from userprofile"

    let deleteAllComments: IDataContext -> unit = 
        sql "delete from comment"