How to ALTER column type? `ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT;` this code return `near "ALTE

How to ALTER column type?

ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT;

ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT;

ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT;

ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT; this code return

near "ALTER": syntax error

near "ALTER": syntax error

near "ALTER": syntax error

near "ALTER": syntax error not working

Ppiko How to ALTER column type? `ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT;` this cod...

Cyb3r-Jak3•5/28/23, 8:41 PM

I don't believe sqlite supports changing the column type

Dom Cogan•5/30/23, 7:30 PM

Has anyone successfully used the stackblitz code for the direct creator upload? I

mrmachine•5/31/23, 1:58 AM

I have a super simple stub worker that does nothing at all (literally) and fails to upload as soon as I add an import { AwsClient } from "aws4fetch"import { AwsClient } from "aws4fetch" at the top with this error: { code: 10068, message: "The uploaded script has no registered event handlers." }{ code: 10068, message: "The uploaded script has no registered event handlers." } ... I have another more complicated worker (provided by denoflare example) which does successfully publish fine and as far as I can tell it doesn't register any event handlers... what am I missing?

kian•5/31/23, 2:02 AM

How are you uploading it, Wrangler?

mrmachine•5/31/23, 2:05 AM

denoflare push

mrmachine•5/31/23, 2:06 AM

@kian it's actually a modified version of your s3-to-r2 script... and which actually tried to publish your unmodified version of the script and still got the same error... and a completely stripped back to almost nothing version... to find that it is the aws4fetch import that breaks things

kian•5/31/23, 2:07 AM

I’m not too familiar with Denoflare, but it sounds like it isn’t telling the API that it’s a Module Worker rather than a Service Worker

kian•5/31/23, 2:08 AM

That or the bundled output is a little wrong

mrmachine•5/31/23, 2:10 AM

this is the entire stripped back script... it deploys successfully without the aws4fetch import...

mrmachine•5/31/23, 2:14 AM

I wonder the build is using the wrong cjs version instead of the esm version of aws4fetch

mrmachine•5/31/23, 2:34 AM

I tried switching to wrangler and the stripped back script publishes... and your unmodified version works... but the modified version is importing some denoflare code from a URL

import r2PresignedUrlWorker from "https://raw.githubusercontent.com/skymethod/denoflare/v0.5.11/examples/r2-presigned-url-worker/worker.ts";

import r2PresignedUrlWorker from "https://raw.githubusercontent.com/skymethod/denoflare/v0.5.11/examples/r2-presigned-url-worker/worker.ts";

which wrangler complains about: Uncaught Error: No such moduleUncaught Error: No such module

kian•5/31/23, 2:37 AM

Cloudflare doesn't support URL imports, that's just a Deno thing

mrmachine•5/31/23, 2:45 AM

can I get wrangler to bundle it before publish?

mrmachine•5/31/23, 2:45 AM

(like denoflare push does)... but it seems denoflare push is building a bundle.js which is somehow messing up the registered event handler (fetch)... but I can't find the bundle.js to take a look at what it's doing...

kian•5/31/23, 2:48 AM

Wrangler wouldn't bundle URL imports, it just uses esbuild

kian•5/31/23, 2:48 AM

My code doesn't use Deno(flare) at all so it would work as-is with Wrangler

mrmachine•5/31/23, 2:48 AM

yes your code works as is with wrangler

mrmachine•5/31/23, 2:49 AM

but we are trying to combine your worker with the denoflare r2-presigned-url-worker example

Dom Cogan•5/31/23, 12:48 PM

Can anyone help me with the TUS direct creator upload?

Dom Cogan•5/31/23, 12:48 PM

I’ve read the documentation but I can’t figure out why it’s not working

James•5/31/23, 1:41 PM

Simply install them with npm and import them as you would normally.

Do note that axios won’t work natively though - it uses things like httphttp which don’t don’t exist in workers. Workers aren’t node.js and although they’re slowly getting a lot more nodejs APIs for compat, they don’t have them all yet.

I believe in the case of axios there’s a way to make it use

fetch

fetch

but I’d probably just use the fetch APIs directly

Murder Chicken•6/3/23, 7:52 PM

This is probably a really silly question but is there a simple way to group itty-routeritty-router routes into separate routing modules/files to unclutter my worker entry point jsjs ?

kian•6/3/23, 7:57 PM

Like grouping the .get(..., ...).get(..., ...) part or just the handlers?

Murder Chicken•6/3/23, 8:10 PM

For now, just the .get().get() stuff.

Murder Chicken•6/3/23, 8:10 PM

I feel like there's a better way to organize routing then just cramming it into the entry point js. Google has failed me thusfar.

kian•6/3/23, 8:34 PM

you can nest routers

kian•6/3/23, 8:35 PM

so you can have a router that handles everything under /api/pages//api/pages/

kian•6/3/23, 8:35 PM

and import that in main.js for /api/pages/*/api/pages/*

Murder Chicken•6/4/23, 1:08 AM

Ahhh, I see. Ok, I'm going to give that a whirl. Thanks @kian

Walshy•6/4/23, 10:17 PM

are you using

await

await

not in an asyncasync function?

Walshy•6/4/23, 10:19 PM

oh wait

Walshy•6/4/23, 10:19 PM

that's from Vite itself

Walshy•6/4/23, 10:19 PM

my guess is that it's a top level await

Walshy•6/4/23, 10:22 PM

ah that'll be why

Walshy•6/4/23, 10:22 PM

soooo

Walshy•6/4/23, 10:22 PM

you likely have a whitespace somewhere

Walshy•6/4/23, 10:22 PM

(if you copied from the docs, it loves to shove a tab at the start)

Walshy•6/4/23, 10:23 PM

I'd remove it and manually type out the

NODE_VERSION

NODE_VERSION

and 1414

Walshy•6/4/23, 10:23 PM

(We'll be trimming that next week - my fix is in just awaiting release)

How to ALTER column type? `ALTER TABLE SUBS ALTER COLUMN ID TYPE TEXT;` this code return `near "ALTE

Similar Threads

Similar Threads

Similar Threads