Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 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 | 1x 1x 4x 4x 4x 3x 1x | // Pro Social Studio Music Routes - List available music tracks for reels
import { eq } from "drizzle-orm";
import { Hono } from "hono";
import type { Dal } from "../../dal";
import type { getDb } from "../../db";
import * as schema from "../../db/schema";
import { handleError, success } from "../../lib/response";
import { requireProAccess } from "../../middleware";
import type { Services } from "../../services";
type Env = {
Bindings: CloudflareBindings;
Variables: {
user: { id: string; name: string; email: string } | null;
session: unknown;
dal: Dal;
services: Services;
db: ReturnType<typeof getDb>;
proId: string;
proRole: string;
};
};
const socialStudioMusic = new Hono<Env>();
// GET /:proId/social-studio/music-tracks — list active music tracks
socialStudioMusic.get(
"/:proId/social-studio/music-tracks",
requireProAccess,
async (c) => {
try {
const db = c.get("db");
const tracks = await db
.select({
id: schema.socialStudioMusicTracks.id,
name: schema.socialStudioMusicTracks.name,
category: schema.socialStudioMusicTracks.category,
durationS: schema.socialStudioMusicTracks.durationS,
r2Key: schema.socialStudioMusicTracks.r2Key,
isActive: schema.socialStudioMusicTracks.isActive,
dateCreated: schema.socialStudioMusicTracks.dateCreated,
})
.from(schema.socialStudioMusicTracks)
.where(eq(schema.socialStudioMusicTracks.isActive, true))
.orderBy(
schema.socialStudioMusicTracks.category,
schema.socialStudioMusicTracks.name,
);
return success(c, { tracks });
} catch (err) {
return handleError(c, err);
}
},
);
export default socialStudioMusic;
|