appstruct-codegen 0.2.0

Deterministic Rust, SQL, OpenAPI, TypeScript, and React generation for AppStruct
Documentation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
use crate::{ApiError, AppState};
use axum::body::Bytes;
use axum::extract::{DefaultBodyLimit, Path, Query, State};
use axum::http::{HeaderMap, StatusCode};
use axum::routing::{get, post};
use axum::{Json, Router};
use hmac::{Hmac, KeyInit, Mac};
use sqlx::Row as _;
use crate::database::{DatabaseExecutor,  Sql};
use serde::{Deserialize, Serialize};
use serde_json::{Value, json};
use sha2::Sha256;
use std::time::Duration;

const TRIALS_ENABLED: bool = __TRIALS__;
const CUSTOMER_PORTAL_ENABLED: bool = __CUSTOMER_PORTAL__;
const STRIPE_API: &str = "https://api.stripe.com/v1";
const PLANS: &[Plan] = &[
    __PLANS__
];

struct Plan {
    id: &'static str,
    price_env: &'static str,
    trial_days: Option<u16>,
    entitlements: &'static [&'static str],
}

struct BillingConfig {
    secret_key: String,
    webhook_secret: String,
    prices: Vec<(&'static str, String)>,
}

#[derive(Serialize)]
struct PlanView {
    id: &'static str,
    trial_days: Option<u16>,
    entitlements: &'static [&'static str],
}

#[derive(Serialize)]
struct SubscriptionView {
    plan_id: String,
    status: String,
    current_period_end: Option<chrono::DateTime<chrono::Utc>>,
    cancel_at_period_end: bool,
}

#[derive(Serialize)]
struct BillingOverview {
    plans: Vec<PlanView>,
    subscription: Option<SubscriptionView>,
    entitlements: Vec<&'static str>,
    customer_portal: bool,
}

#[derive(Deserialize)]
struct CheckoutInput { plan_id: String }

#[derive(Serialize)]
struct RedirectUrl { url: String }

#[derive(Deserialize)]
struct BillingEventQuery { page: Option<u64>, page_size: Option<u64> }

#[derive(Serialize)]
struct BillingEvent {
    event_id: String,
    event_type: String,
    payload: Value,
    created_at: chrono::DateTime<chrono::Utc>,
}

#[derive(Serialize)]
struct BillingEventList { data: Vec<BillingEvent>, meta: BillingEventMeta }

#[derive(Serialize)]
struct BillingEventMeta { page: u64, page_size: u64, total: u64 }

pub fn router() -> Router<AppState> {
    Router::new()
        .route("/api/billing", get(overview))
        .route("/api/billing/checkout", post(checkout))
        .route("/api/billing/portal", post(portal))
        .route("/api/billing/stripe/webhook", post(webhook))
        .route("/api/admin/billing/events", get(list_admin_billing_events))
        .route("/api/admin/billing/events/{event_id}/replay", post(replay_admin_billing_event))
        .layer(DefaultBodyLimit::max(65_536))
}

async fn require_billing_admin(
    state: &AppState,
    headers: &HeaderMap,
    mutation: bool,
) -> Result<(), ApiError> {
    let actor = if mutation {
        state.auth.actor_for_mutation(&state.database, headers).await?
    } else {
        state.auth.actor(&state.database, headers).await?
    }
    .ok_or(ApiError::Unauthorized)?;
    if actor.has_role("admin") { Ok(()) } else { Err(ApiError::Forbidden) }
}

async fn list_admin_billing_events(
    State(state): State<AppState>, headers: HeaderMap, Query(input): Query<BillingEventQuery>,
) -> Result<Json<BillingEventList>, ApiError> {
    require_billing_admin(&state, &headers, false).await?;
    let page = input.page.unwrap_or(1);
    let page_size = input.page_size.unwrap_or(25);
    if !(1..=10_000).contains(&page) || !(1..=100).contains(&page_size) {
        return Err(ApiError::InvalidQuery("page must be between 1 and 10000 and page_size between 1 and 100".to_owned()));
    }
    let offset = (page - 1).checked_mul(page_size).ok_or_else(|| ApiError::InvalidQuery("pagination is too large".to_owned()))?;
    let count = state.database.fetch_optional(Sql::bind("SELECT COUNT(*) AS total FROM \"_appstruct_billing_events\"",
        [],
    )).await?.ok_or(ApiError::Internal)?.try_get::<i64, _>("total")?;
    let rows = state.database.fetch_all(Sql::bind("SELECT event_id, event_type, payload, created_at FROM \"_appstruct_billing_events\" ORDER BY created_at DESC, event_id DESC LIMIT $1 OFFSET $2",
        [i64::try_from(page_size).unwrap_or(100).into(), i64::try_from(offset).unwrap_or(i64::MAX).into()],
    )).await?;
    let data = rows.into_iter().map(|row| Ok(BillingEvent {
        event_id: row.try_get("event_id")?,
        event_type: row.try_get("event_type")?,
        payload: row.try_get("payload")?,
        created_at: row.try_get("created_at")?,
    })).collect::<Result<Vec<_>, sqlx::Error>>()?;
    Ok(Json(BillingEventList { data, meta: BillingEventMeta { page, page_size, total: u64::try_from(count).unwrap_or(0) } }))
}

async fn replay_admin_billing_event(
    State(state): State<AppState>, headers: HeaderMap, Path(event_id): Path<String>,
) -> Result<Json<BillingEvent>, ApiError> {
    require_billing_admin(&state, &headers, true).await?;
    let row = state.database.fetch_optional(Sql::bind("SELECT event_type, payload FROM \"_appstruct_billing_events\" WHERE event_id = $1",
        [event_id.clone().into()],
    )).await?.ok_or(ApiError::NotFound)?;
    let event_type: String = row.try_get("event_type")?;
    let event: Value = row.try_get("payload")?;
    let subscription_id = event.pointer("/data/object/id").and_then(Value::as_str)
        .or_else(|| event.pointer("/data/object/subscription").and_then(Value::as_str))
        .filter(|id| id.starts_with("sub_")).ok_or_else(|| ApiError::InvalidQuery("Billing event has no replayable subscription".to_owned()))?;
    let replay_id = format!("{event_id}:replay:{}", uuid::Uuid::now_v7());
    reconcile_subscription(&state, &config()?, &replay_id, &event_type, subscription_id, &event).await?;
    let replay = state.database.fetch_optional(Sql::bind("SELECT event_id, event_type, payload, created_at FROM \"_appstruct_billing_events\" WHERE event_id = $1",
        [replay_id.into()],
    )).await?.ok_or(ApiError::Internal)?;
    Ok(Json(BillingEvent {
        event_id: replay.try_get("event_id")?,
        event_type: replay.try_get("event_type")?,
        payload: replay.try_get("payload")?,
        created_at: replay.try_get("created_at")?,
    }))
}

pub fn validate_env() -> Result<(), String> {
    let _ = config_from_env()?;
    Ok(())
}

fn config_from_env() -> Result<BillingConfig, String> {
    let required = |name| {
        std::env::var(name)
            .ok()
            .filter(|value| !value.trim().is_empty())
            .ok_or_else(|| format!("{name} is required when Stripe Billing is enabled"))
    };
    let secret_key = required("APPSTRUCT_STRIPE_SECRET_KEY")?;
    let webhook_secret = required("APPSTRUCT_STRIPE_WEBHOOK_SECRET")?;
    if !secret_key.starts_with("sk_") || !webhook_secret.starts_with("whsec_") {
        return Err("Stripe Billing credentials have invalid prefixes".to_owned());
    }
    let prices = PLANS
        .iter()
        .map(|plan| {
            let price = required(plan.price_env)?;
            if !price.starts_with("price_") {
                return Err(format!("{} must be a Stripe Price ID", plan.price_env));
            }
            Ok((plan.id, price))
        })
        .collect::<Result<Vec<_>, String>>()?;
    Ok(BillingConfig { secret_key, webhook_secret, prices })
}

fn config() -> Result<BillingConfig, ApiError> {
    config_from_env().map_err(|error| {
        tracing::error!(%error, "billing configuration is invalid");
        ApiError::Internal
    })
}

async fn overview(
    State(state): State<AppState>, headers: HeaderMap,
) -> Result<Json<BillingOverview>, ApiError> {
    let context = state.context(&headers).await?;
    context.actor().ok_or(ApiError::Unauthorized)?;
    let organization_id = context.require_tenant()?;
    let subscription = current_subscription(&state, organization_id).await?;
    let entitlements = subscription.as_ref().and_then(|subscription| {
        if matches!(subscription.status.as_str(), "active" | "trialing") {
            PLANS.iter().find(|plan| plan.id == subscription.plan_id)
        } else {
            None
        }
    }).map_or_else(Vec::new, |plan| plan.entitlements.to_vec());
    Ok(Json(BillingOverview {
        plans: PLANS.iter().map(|plan| PlanView {
            id: plan.id, trial_days: plan.trial_days, entitlements: plan.entitlements,
        }).collect(),
        subscription,
        entitlements,
        customer_portal: CUSTOMER_PORTAL_ENABLED,
    }))
}

async fn checkout(
    State(state): State<AppState>, headers: HeaderMap, Json(input): Json<CheckoutInput>,
) -> Result<Json<RedirectUrl>, ApiError> {
    let (organization_id, email) = require_owner(&state, &headers).await?;
    if let Some(subscription) = current_subscription(&state, organization_id).await?
        && matches!(subscription.status.as_str(), "active" | "trialing" | "past_due")
    {
        return Err(ApiError::Conflict(
            "An active subscription must be changed through the customer portal".to_owned(),
        ));
    }
    let plan = PLANS.iter().find(|plan| plan.id == input.plan_id)
        .ok_or_else(|| ApiError::InvalidQuery("Unknown billing plan".to_owned()))?;
    let config = config()?;
    let price = config.prices.iter().find(|(id, _)| *id == plan.id)
        .map(|(_, price)| price.as_str()).ok_or(ApiError::Internal)?;
    let customer = customer_id(&state, organization_id).await?;
    let customer = match customer {
        Some(id) => id,
        None => create_customer(&state, &config, organization_id, &email).await?,
    };
    let base_url = state.auth.config.frontend_url.trim_end_matches('/');
    let mut form = vec![
        ("mode", "subscription".to_owned()),
        ("customer", customer),
        ("line_items[0][price]", price.to_owned()),
        ("line_items[0][quantity]", "1".to_owned()),
        ("success_url", format!("{base_url}/billing?checkout=success")),
        ("cancel_url", format!("{base_url}/billing?checkout=cancel")),
        ("client_reference_id", organization_id.to_string()),
        ("subscription_data[metadata][appstruct_organization_id]", organization_id.to_string()),
        ("subscription_data[metadata][appstruct_plan_id]", plan.id.to_owned()),
    ];
    if TRIALS_ENABLED {
        if let Some(days) = plan.trial_days {
            form.push(("subscription_data[trial_period_days]", days.to_string()));
        }
    }
    let request_key = headers
        .get("Idempotency-Key")
        .and_then(|value| value.to_str().ok())
        .filter(|value| !value.is_empty() && value.len() <= 255)
        .map(str::to_owned)
        .unwrap_or_else(|| format!("appstruct-checkout-{organization_id}-{}", uuid::Uuid::now_v7()));
    let result = stripe_post(&config, "/checkout/sessions", &form, Some(&request_key)).await?;
    let url = result.get("url").and_then(Value::as_str).ok_or(ApiError::Internal)?;
    Ok(Json(RedirectUrl { url: url.to_owned() }))
}

async fn portal(
    State(state): State<AppState>, headers: HeaderMap,
) -> Result<Json<RedirectUrl>, ApiError> {
    if !CUSTOMER_PORTAL_ENABLED { return Err(ApiError::NotFound); }
    let (organization_id, _) = require_owner(&state, &headers).await?;
    let customer = customer_id(&state, organization_id).await?.ok_or(ApiError::NotFound)?;
    let base_url = state.auth.config.frontend_url.trim_end_matches('/');
    let result = stripe_post(&config()?, "/billing_portal/sessions", &[
        ("customer", customer),
        ("return_url", format!("{base_url}/billing")),
    ], None).await?;
    let url = result.get("url").and_then(Value::as_str).ok_or(ApiError::Internal)?;
    Ok(Json(RedirectUrl { url: url.to_owned() }))
}

async fn webhook(headers: HeaderMap, State(state): State<AppState>, body: Bytes) -> Result<StatusCode, ApiError> {
    let config = config()?;
    verify_signature(&headers, &body, &config.webhook_secret)?;
    let event: Value = serde_json::from_slice(&body).map_err(|_| ApiError::InvalidQuery("Invalid Stripe event".to_owned()))?;
    let event_id = event.get("id").and_then(Value::as_str).filter(|id| id.starts_with("evt_"))
        .ok_or_else(|| ApiError::InvalidQuery("Invalid Stripe event ID".to_owned()))?;
    let event_type = event.get("type").and_then(Value::as_str).unwrap_or("");
    let subscription_id = match event_type {
        "customer.subscription.created" | "customer.subscription.updated" | "customer.subscription.deleted" =>
            event.pointer("/data/object/id").and_then(Value::as_str),
        "checkout.session.completed" => event.pointer("/data/object/subscription").and_then(Value::as_str),
        _ => return Ok(StatusCode::NO_CONTENT),
    }.filter(|id| id.starts_with("sub_")).ok_or_else(|| ApiError::InvalidQuery("Missing Stripe subscription ID".to_owned()))?;
    reconcile_subscription(&state, &config, event_id, event_type, subscription_id, &event).await?;
    Ok(StatusCode::NO_CONTENT)
}

fn verify_signature(headers: &HeaderMap, body: &[u8], secret: &str) -> Result<(), ApiError> {
    let signature = headers.get("stripe-signature").and_then(|value| value.to_str().ok())
        .ok_or(ApiError::Forbidden)?;
    let timestamp = signature.split(',').find_map(|item| item.strip_prefix("t=")?.parse::<i64>().ok())
        .ok_or(ApiError::Forbidden)?;
    if (chrono::Utc::now().timestamp() - timestamp).abs() > 300 { return Err(ApiError::Forbidden); }
    let payload = format!("{timestamp}.{}", String::from_utf8_lossy(body));
    let verified = signature.split(',').filter_map(|item| item.strip_prefix("v1="))
        .filter_map(|hex| decode_hex(hex).ok())
        .any(|expected| {
            let mut mac = Hmac::<Sha256>::new_from_slice(secret.as_bytes()).expect("HMAC accepts any key length");
            mac.update(payload.as_bytes());
            mac.verify_slice(&expected).is_ok()
        });
    if verified { Ok(()) } else { Err(ApiError::Forbidden) }
}

fn decode_hex(value: &str) -> Result<Vec<u8>, ()> {
    if value.len() != 64 { return Err(()); }
    value.as_bytes().chunks_exact(2).map(|chunk| {
        let high = (chunk[0] as char).to_digit(16).ok_or(())?;
        let low = (chunk[1] as char).to_digit(16).ok_or(())?;
        Ok(((high << 4) | low) as u8)
    }).collect()
}

async fn require_owner(state: &AppState, headers: &HeaderMap) -> Result<(uuid::Uuid, String), ApiError> {
    let context = state.mutation_context(headers).await?;
    let actor = context.actor().ok_or(ApiError::Unauthorized)?;
    let organization_id = context.require_tenant()?;
    let owner = state.database.fetch_optional(Sql::bind("SELECT 1 FROM \"_appstruct_tenant_memberships\" WHERE organization_id = $1 AND user_id = $2 AND role = 'owner'",
        [organization_id.into(), actor.id.into()],
    )).await?.is_some();
    if !owner { return Err(ApiError::Forbidden); }
    Ok((organization_id, actor.email.clone()))
}

async fn current_subscription(state: &AppState, organization_id: uuid::Uuid) -> Result<Option<SubscriptionView>, ApiError> {
    let row = state.database.fetch_optional(Sql::bind("SELECT plan_id, status, current_period_end, cancel_at_period_end FROM \"_appstruct_billing_subscriptions\" WHERE organization_id = $1 ORDER BY updated_at DESC, id DESC LIMIT 1",
        [organization_id.into()],
    )).await?;
    row.map(|row| -> Result<SubscriptionView, sqlx::Error> { Ok(SubscriptionView {
        plan_id: row.try_get("plan_id")?,
        status: row.try_get("status")?,
        current_period_end: row.try_get("current_period_end")?,
        cancel_at_period_end: row.try_get("cancel_at_period_end")?,
    }) }).transpose().map_err(Into::into)
}

async fn customer_id(state: &AppState, organization_id: uuid::Uuid) -> Result<Option<String>, ApiError> {
    let row = state.database.fetch_optional(Sql::bind("SELECT provider_customer_id FROM \"_appstruct_billing_customers\" WHERE organization_id = $1",
        [organization_id.into()],
    )).await?;
    row.map(|row| row.try_get("provider_customer_id")).transpose().map_err(Into::into)
}

async fn create_customer(state: &AppState, config: &BillingConfig, organization_id: uuid::Uuid, email: &str) -> Result<String, ApiError> {
    let result = stripe_post(config, "/customers", &[
        ("email", email.to_owned()),
        ("metadata[appstruct_organization_id]", organization_id.to_string()),
    ], Some(&format!("appstruct-customer-{organization_id}"))).await?;
    let customer = result.get("id").and_then(Value::as_str).filter(|id| id.starts_with("cus_"))
        .ok_or(ApiError::Internal)?;
    state.database.execute(Sql::bind("INSERT INTO \"_appstruct_billing_customers\" (id, organization_id, provider_customer_id, created_at) VALUES ($1, $2, $3, CURRENT_TIMESTAMP) ON CONFLICT (organization_id) DO NOTHING",
        [uuid::Uuid::now_v7().into(), organization_id.into(), customer.into()],
    )).await?;
    customer_id(state, organization_id).await?.ok_or(ApiError::Internal)
}

async fn stripe_post(config: &BillingConfig, path: &str, form: &[(&str, String)], idempotency_key: Option<&str>) -> Result<Value, ApiError> {
    let client = reqwest::Client::builder().timeout(Duration::from_secs(10)).build().map_err(|_| ApiError::Internal)?;
    let mut request = client.post(format!("{STRIPE_API}{path}"))
        .bearer_auth(&config.secret_key).form(form);
    if let Some(key) = idempotency_key { request = request.header("Idempotency-Key", key); }
    let response = request.send().await.map_err(|_| ApiError::Internal)?;
    if !response.status().is_success() { return Err(ApiError::Internal); }
    response.json().await.map_err(|_| ApiError::Internal)
}

async fn stripe_subscription(config: &BillingConfig, subscription_id: &str) -> Result<Value, ApiError> {
    let client = reqwest::Client::builder().timeout(Duration::from_secs(10)).build().map_err(|_| ApiError::Internal)?;
    let response = client.get(format!("{STRIPE_API}/subscriptions/{subscription_id}"))
        .bearer_auth(&config.secret_key).send().await.map_err(|_| ApiError::Internal)?;
    if !response.status().is_success() { return Err(ApiError::Internal); }
    response.json().await.map_err(|_| ApiError::Internal)
}

async fn reconcile_subscription(
    state: &AppState, config: &BillingConfig, event_id: &str, event_type: &str,
    subscription_id: &str, event: &Value,
) -> Result<(), ApiError> {
    let transaction = state.database.begin().await?;
    transaction.fetch_optional(Sql::bind("SELECT pg_advisory_xact_lock(77145, hashtext($1))",
        [subscription_id.into()],
    )).await?;
    let seen = transaction.fetch_optional(Sql::bind("SELECT 1 FROM \"_appstruct_billing_events\" WHERE event_id = $1",
        [event_id.into()],
    )).await?.is_some();
    if seen { transaction.commit().await?; return Ok(()); }
    let remote = stripe_subscription(config, subscription_id).await?;
    let customer = remote.get("customer").and_then(Value::as_str).ok_or(ApiError::Internal)?;
    let organization_id = remote.pointer("/metadata/appstruct_organization_id")
        .and_then(Value::as_str).and_then(|value| uuid::Uuid::parse_str(value).ok())
        .ok_or(ApiError::Internal)?;
    let plan_id = remote.pointer("/metadata/appstruct_plan_id").and_then(Value::as_str)
        .filter(|value| PLANS.iter().any(|plan| plan.id == *value)).ok_or(ApiError::Internal)?;
    let linked = transaction.fetch_optional(Sql::bind("SELECT 1 FROM \"_appstruct_billing_customers\" WHERE organization_id = $1 AND provider_customer_id = $2",
        [organization_id.into(), customer.into()],
    )).await?.is_some();
    if !linked { return Err(ApiError::Internal); }
    let status = remote.get("status").and_then(Value::as_str).ok_or(ApiError::Internal)?;
    let period_end = remote.get("current_period_end").and_then(Value::as_i64)
        .or_else(|| remote.pointer("/items/data/0/current_period_end").and_then(Value::as_i64))
        .and_then(|seconds| chrono::DateTime::<chrono::Utc>::from_timestamp(seconds, 0));
    let cancel_at_period_end = remote.get("cancel_at_period_end").and_then(Value::as_bool).unwrap_or(false);
    let event_created = event.get("created").and_then(Value::as_i64).ok_or(ApiError::Internal)?;
    transaction.execute(Sql::bind("INSERT INTO \"_appstruct_billing_subscriptions\" (id, organization_id, provider_subscription_id, plan_id, status, current_period_end, cancel_at_period_end, provider_event_created_at, created_at, updated_at) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP) ON CONFLICT (provider_subscription_id) DO UPDATE SET plan_id = EXCLUDED.plan_id, status = EXCLUDED.status, current_period_end = EXCLUDED.current_period_end, cancel_at_period_end = EXCLUDED.cancel_at_period_end, provider_event_created_at = EXCLUDED.provider_event_created_at, updated_at = CURRENT_TIMESTAMP WHERE \"_appstruct_billing_subscriptions\".provider_event_created_at <= EXCLUDED.provider_event_created_at",
        [uuid::Uuid::now_v7().into(), organization_id.into(), subscription_id.into(), plan_id.into(), status.into(), period_end.into(), cancel_at_period_end.into(), event_created.into()],
    )).await?;
    transaction.execute(Sql::bind("INSERT INTO \"_appstruct_billing_events\" (event_id, event_type, payload, created_at) VALUES ($1, $2, $3, CURRENT_TIMESTAMP)",
        [event_id.into(), event_type.into(), json!(event).into()],
    )).await?;
    transaction.commit().await?;
    Ok(())
}