Maxime Posts - Answer Overflow

Maxime

Explore posts from servers

•Created by Maxime on 2/5/2024 in #support-community

Get the file content before uploading to convex

is there any way to get the file content before upload it to convex ? my upload is limited to json files but i want to validate the file content to prevent any issue with the json uploaded ( mal formatted or bad file ) thx

12 replies

DTDrizzle Team

•Created by Maxime on 11/21/2023 in #help

group by inside relations ?

i want use groupBy inside a relations

 const tire = await ctx.db.query.tire.findFirst({
                where: (tire, { eq }) => eq(tire.id, Number(input.id)),

                with: {
                    model: {
                        with: {
                            brand: true,
                        },
                    },
                    scanUrls: {
                        where: (scanUrls, { eq }) =>
                            eq(scanUrls.disabled, false),
                        with: {
                            website: true,
                            scanUrlHistory: {
                                extras: {
                                    day: sql`concat(day(${schema.scanUrlHistory.createdAt}),'/',month(${schema.scanUrlHistory.createdAt}),'/',year(${schema.scanUrlHistory.createdAt}))`.as(
                                        "day"
                                    ),
                                    avg_price:
                                        sql`AVG(${schema.scanUrlHistory.price})`.as(
                                            "avg_price"
                                        ),
                                },

                                where: and(
                                    gt(
                                        schema.scanUrlHistory.createdAt,
                                        dayjs().subtract(7, "day").format()
                                    ),
                                    isNull(schema.scanUrlHistory.error)
                                ),
                            },
                        },
                    },
                },
            });

 const tire = await ctx.db.query.tire.findFirst({
                where: (tire, { eq }) => eq(tire.id, Number(input.id)),

                with: {
                    model: {
                        with: {
                            brand: true,
                        },
                    },
                    scanUrls: {
                        where: (scanUrls, { eq }) =>
                            eq(scanUrls.disabled, false),
                        with: {
                            website: true,
                            scanUrlHistory: {
                                extras: {
                                    day: sql`concat(day(${schema.scanUrlHistory.createdAt}),'/',month(${schema.scanUrlHistory.createdAt}),'/',year(${schema.scanUrlHistory.createdAt}))`.as(
                                        "day"
                                    ),
                                    avg_price:
                                        sql`AVG(${schema.scanUrlHistory.price})`.as(
                                            "avg_price"
                                        ),
                                },

                                where: and(
                                    gt(
                                        schema.scanUrlHistory.createdAt,
                                        dayjs().subtract(7, "day").format()
                                    ),
                                    isNull(schema.scanUrlHistory.error)
                                ),
                            },
                        },
                    },
                },
            });

i want to group by scanUrlHistory on the field day from my extras fields

5 replies

Gaming

Programming