Does SQLDelight support the

IIF

function? I’m getting “Unknown function IIF” when trying to use it. If not, is any workaround available?

no doesnt look like its there https://github.com/cashapp/sqldelight/blob/master/sqldelight-compiler/src/main/kotlin/app/cash/sqldelight/core/lang/psi/FunctionExprMixin.kt

you can use

CASE WHEN X THEN Y ELSE Z END

instead

Thanks Alec I wasn’t aware of

CASE WHEN

. It seems to work fine

I am trying to create a custom Anvil CodeGenerator that binds my assisted worker factories onto a map, but the problem is that my WorkerFactory interface defines a method that has

android.content.Context

and

androidx.work.WorkerParameters

. I’m under the impression I cannot access these types from the CodeGenerator because it runs at build-time in JVM(

androidx.work:work-runtime

is in an AAR file as well) Is there any way to access these types from my code generation module? Thanks all

You don’t need access to these concrete types. You only need to know the fully qualified name and this string can be converted to an

FqName

or

ClassName

for KotlinPoet. If you need access for some reason, then I’d suggest creating stubs and put them on the compile classpath only.

Use ParameterizedTypeName

And STAR

there's a

parameterizedBy

extension function

Yep, I was writing my comment as you all replied. Thank you all very much

i saw there is a

2.0.0-SNAPSHOT

for sqlite on the maven now, is there any issue or readme for what big things to changes/breaks anywhere yet ? PS: i found the tasks: https://github.com/cashapp/sqldelight/issues/2694 (i was just a bit blind before)

yea that issue is where we’re tracking major changes

Hi team -- I am writing an Anvil CodeGenerator and trying to add an annotation with a member that has an array value i.e.

@Annotation(x=[a,b,c])

. Everything I've seen online is pretty roundabout, is there something in KotlinPoet or the like that will allow me to do this?

That’s certainly possible. Here’s a sample within Anvil itself. I’m unsure if there’s a better API, though: https://github.com/square/anvil/blob/main/compiler/src/main/java/com/squareup/anvil/compiler/codegen/ContributesSubcomponentHandlerGenerator.kt#L209-L213

that's basically right. We use

arrayOf()

in kotlinpoet itself for maximum portability https://github.com/square/kotlinpoet/blob/master/kotlinpoet/src/main/java/com/squareup/kotlinpoet/AnnotationSpec.kt#L172-L180

For SQL Delight - Is there a creative way that anyone knows of to remove the default value from a column?

ALTER TABLE products ALTER available DROP DEFAULT;

is valid sql, but doesn’t seem to work. I wonder if anyone knows a creative work around. https://github.com/AlecStrong/sql-psi/issues/312

One more question on the annotation front: I want to add a scope annotation to an interface like so:

@MyScope
interface MyInterface

I just added an annotation to a typespec interface, and i get this error:

This class does not have a constructor

. Any thoughts?

Does a retrofit 2.6.0 throw when there's no connection when using

suspend fun getFoo(): Response<Foo>

in the api interface?

I thought retrieving a

Response

won't throw in any case... which makes it easy to use an extension function on

Response

to transform the result to a domain error with a sealed class... if it throws when no connection, I'd also need to surround EACH call with a try/catch for that case and transform that to a result that the UI can deal with w/o crashing...

A Response encapsulates an HTTP response only

if one cannot be retrieved, there is no other mechanism in this API signature to report failure other than exception

So you surround each call with a try/catch? Or is there some better way...

I return a Call in some requests but that defeats the purpose of supporting `suspend fun`s...

There are

Either

adapters for retrofit

Yeah, but that means importing all of Arrow just for that...

You can write a Result adapter

We don't use the response form at all and our data layer catches exceptions

Do you also do that with an adapter? Or do you just catch each one?

Either sealed interface is really simple, you can create your own + the adapter

We usually wrap at slightly higher levels of abstraction such as the operation which is being performed rather than some individual call