DT
Drizzle Team•2mo ago
Avi0nic

String concatenation syntax

Is there a better a way to concatenate strings in the select of a query? I'm currently doing this: 
    const bucketUrl = `${env.MINIO_ENDPOINT}/${env.MINIO_BUCKET_NAME}/${RESOURCE_PREFIX}/`;

    const query = db
      .select({
        ...getTableColumns(resources),
        path: sql<string>`concat(${bucketUrl}::text, ${resources.id}, '/', ${resources.path})`,
      })
      .from(resources)
    const bucketUrl = `${env.MINIO_ENDPOINT}/${env.MINIO_BUCKET_NAME}/${RESOURCE_PREFIX}/`;

    const query = db
      .select({
        ...getTableColumns(resources),
        path: sql<string>`concat(${bucketUrl}::text, ${resources.id}, '/', ${resources.path})`,
      })
      .from(resources)
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?