In reply to @obsoleszenz:gitter.im
had one conflict in diesel_compile_tests/Cargo.lock, basically the version. So kept it at 2.1.5, i guess you bump that when you cut a release?

I define a sql_function in the below code

sql_function!(fn is_enable(state:Nullable<Integer>) -> Nullable<Integer>);

type IsEnable<T> = Eq<is_enable::HelperType<T>, is_enable::HelperType<State>>;

fn is_state_enable<T>(field: T) -> IsEnable<T>
where
    T: diesel::Expression<SqlType = Nullable<Integer>>,
{
    is_enable(field).eq(is_enable(State::Enable))
}

but when I run the code, it said to me Function xxxx.is_enable does not exist

Well, then it's not surprising that your database complains that this function is missing. You need to define it there as well.

sql_function! merely defines that the database contains a function with that signature. Everything else needs to be handled by you at database level.

In reply to @weiznich-55bcb4c20fc9f982beabc3ad:gitter.im
Checkout the composing application guide for how to do that

In reply to @ethanhawthorne:gitter.im
Hi, I'm new to diesel and rust and I'm trying to install the diesel cli on my windows 11 machine with just sqllite. When I install it throws the error ""error: linking with x86_64-w64-mingw32-gcc failed: exit code: 1" with the note "note: ld: cannot find -lsqlite3: No such file or directory". I've tried to fix this by making the sqlite3.dll global but I'm still getting the same error. Where do I put the .dll file to let the install compile?

For diesel-cli there is a sqlite-bundled feature that just builds libsqlite3 as part of your cargo install command.

For building diesel itself later in your application you might want to add the libsqlite3-sys crate to you dependency list and enable the bundled feature (for libsqlite3-sys) there as well.

It’s hard to help you with that as these kind of errors are caused by your environment configuration. You can try the following things:

• the msvc rust target
• compiling your project using sql
• check in the vs code terminal whether or not you can execute gcc

That means I can't define a function to return an UpdateStatement like this ?

        use member_exchange_goods::dsl;
        diesel::update(dsl::member_exchange_goods.filter(dsl::goods_id.eq(id.to_string())))