The backend language
for the htmx era

config
  database: env DATABASE_URL default "sqlite://blog.db"
  port: env PORT default 8080
  secret: env SECRET_KEY default "dev-secret"

model user
  name: text required min 2 max 100
  email: email unique
  password: password required
  role: option [admin, author] default author
  created: timestamp auto

model post
  title: text required min 5
  body: richtext required
  status: option [draft, published] default draft
  author: user required
  created: timestamp auto

auth
  table: user
  identity: email
  password: password
  login: /login
  after login: /posts

page /
  query posts: SELECT p.title, p.created, u.name as author
               FROM post p
               LEFT JOIN user u ON u.id = p.author
               WHERE p.status = 'published'
               ORDER BY p.created DESC
               paginate 10
  html
    <h1>Blog</h1>
    {{each posts}}
    <article>
      <h2>{title}</h2>
      <span>by {author} on {created}</span>
    </article>
    {{end}}

page /posts requires auth
  query posts: SELECT id, title, status, created FROM post
               WHERE author = :current_user.id ORDER BY created DESC
  html
    <h1>My Posts</h1>
    <a href="/posts/new">New Post</a>
    {{each posts}}
    <div>
      <a href="/posts/{id}">{title}</a>
      <span>{status}</span>
    </div>
    {{end}}

action /posts/create method POST requires auth
  validate
    title: required min 5
    body: required
  query: INSERT INTO post (title, body, author, status)
         VALUES (:title, :body, :current_user.id, 'published')
  redirect /posts

action /posts/:id/delete method POST requires auth
  query: DELETE FROM post WHERE id = :id AND author = :current_user.id
  redirect /posts

fragment /posts/:id/preview
  query post: SELECT title, body, created FROM post WHERE id = :id
  html
    <article>
      <h2>{post.title}</h2>
      <p>{post.body}</p>
      <time>{post.created}</time>
    </article>

test "homepage loads"
  visit /
  expect page / contains "Blog"

test "create post requires auth"
  visit /posts/new
  expect page /login

# Models with relationships
model company
  name: text required min 2 max 100
  industry: text
  website: text
  created_at: timestamp auto

model contact
  name: text required min 2 max 100
  email: email unique
  phone: phone
  role: text
  company: company required
  created_at: timestamp auto

model deal
  title: text required
  value: float required
  stage: option [lead, proposal, negotiation, closed_won, closed_lost] default lead
  contact: contact required
  notes: richtext
  created_at: timestamp auto

# Dashboard with aggregate queries
page / layout main title "Dashboard"
  query stats: SELECT
    (SELECT COUNT(*) FROM contact) as contacts,
    (SELECT COUNT(*) FROM company) as companies,
    (SELECT COUNT(*) FROM deal WHERE stage NOT IN ('closed_won','closed_lost')) as active_deals,
    (SELECT COALESCE(SUM(value),0) FROM deal WHERE stage = 'closed_won') as revenue
  query recent_deals: SELECT d.title, d.value, d.stage, c.name as contact
    FROM deal d LEFT JOIN contact c ON c.id = d.contact
    ORDER BY d.created_at DESC LIMIT 5
  html
    <div class="grid grid-cols-4 gap-4">
      <div class="stat-card">{stats.contacts} Contacts</div>
      <div class="stat-card">{stats.companies} Companies</div>
      <div class="stat-card">{stats.active_deals} Active Deals</div>
      <div class="stat-card">${stats.revenue} Revenue</div>
    </div>
    {{each recent_deals}}
    <tr>
      <td>{title}</td>
      <td>{contact}</td>
      <td>${value}</td>
      <td><span class="badge-{stage}">{stage}</span></td>
    </tr>
    {{end}}

# CRUD actions with validation and htmx
action /contacts/create method POST
  validate
    name: required min 2
    email: required, is email
  query: INSERT INTO contact (name, email, phone, role, company)
         VALUES (:name, :email, :phone, :role, :company)
  redirect /contacts

action /contacts/:id/delete method POST
  query: DELETE FROM contact WHERE id = :id
  redirect /contacts