[INFO] cloning repository https://github.com/shyetang/zincbloom [INFO] running `Command { std: "git" "-c" "credential.helper=" "-c" "credential.helper=/workspace/cargo-home/bin/git-credential-null" "clone" "--bare" "https://github.com/shyetang/zincbloom" "/workspace/cache/git-repos/https%3A%2F%2Fgithub.com%2Fshyetang%2Fzincbloom", kill_on_drop: false }` [INFO] [stderr] Cloning into bare repository '/workspace/cache/git-repos/https%3A%2F%2Fgithub.com%2Fshyetang%2Fzincbloom'... [INFO] running `Command { std: "git" "rev-parse" "HEAD", kill_on_drop: false }` [INFO] [stdout] 0caba97fb2ead8c56efbda210fb066c7d9c782ab [INFO] checking shyetang/zincbloom against try#53f0b05ecbcf011a1f77f1c627304e87ebd05801 for pr-154492-1 [INFO] running `Command { std: "git" "clone" "/workspace/cache/git-repos/https%3A%2F%2Fgithub.com%2Fshyetang%2Fzincbloom" "/workspace/builds/worker-5-tc2/source", kill_on_drop: false }` [INFO] [stderr] Cloning into '/workspace/builds/worker-5-tc2/source'... [INFO] [stderr] done. [INFO] started tweaking git repo https://github.com/shyetang/zincbloom [INFO] finished tweaking git repo https://github.com/shyetang/zincbloom [INFO] tweaked toml for git repo https://github.com/shyetang/zincbloom written to /workspace/builds/worker-5-tc2/source/Cargo.toml [INFO] validating manifest of git repo https://github.com/shyetang/zincbloom on toolchain 53f0b05ecbcf011a1f77f1c627304e87ebd05801 [INFO] running `Command { std: CARGO_HOME="/workspace/cargo-home" RUSTUP_HOME="/workspace/rustup-home" "/workspace/cargo-home/bin/cargo" "+53f0b05ecbcf011a1f77f1c627304e87ebd05801" "metadata" "--manifest-path" "Cargo.toml" "--no-deps", kill_on_drop: false }` [INFO] crate git repo https://github.com/shyetang/zincbloom already has a lockfile, it will not be regenerated [INFO] running `Command { std: CARGO_HOME="/workspace/cargo-home" RUSTUP_HOME="/workspace/rustup-home" "/workspace/cargo-home/bin/cargo" "+53f0b05ecbcf011a1f77f1c627304e87ebd05801" "fetch" "--manifest-path" "Cargo.toml", kill_on_drop: false }` [INFO] running `Command { std: "docker" "create" "-v" "/var/lib/crater-agent-workspace/builds/worker-5-tc2/target:/opt/rustwide/target:rw,Z" "-v" "/var/lib/crater-agent-workspace/builds/worker-5-tc2/source:/opt/rustwide/workdir:ro,Z" "-v" "/var/lib/crater-agent-workspace/cargo-home:/opt/rustwide/cargo-home:ro,Z" "-v" "/var/lib/crater-agent-workspace/rustup-home:/opt/rustwide/rustup-home:ro,Z" "-e" "SOURCE_DIR=/opt/rustwide/workdir" "-e" "CARGO_TARGET_DIR=/opt/rustwide/target" "-e" "CARGO_HOME=/opt/rustwide/cargo-home" "-e" "RUSTUP_HOME=/opt/rustwide/rustup-home" "-w" "/opt/rustwide/workdir" "-m" "1610612736" "--user" "0:0" "--network" "none" "ghcr.io/rust-lang/crates-build-env/linux@sha256:d429b63d4308055ea97f60fb1d3dfca48854a00942f1bd2ad806beaf015945ec" "/opt/rustwide/cargo-home/bin/cargo" "+53f0b05ecbcf011a1f77f1c627304e87ebd05801" "metadata" "--no-deps" "--format-version=1", kill_on_drop: false }` [INFO] [stdout] f5aa8d0bba0d0b2d781c68e0396fe8da56db6096a3caa20ee8dfbf5c767d3e13 [INFO] running `Command { std: "docker" "start" "-a" "f5aa8d0bba0d0b2d781c68e0396fe8da56db6096a3caa20ee8dfbf5c767d3e13", kill_on_drop: false }` [INFO] running `Command { std: "docker" "inspect" "f5aa8d0bba0d0b2d781c68e0396fe8da56db6096a3caa20ee8dfbf5c767d3e13", kill_on_drop: false }` [INFO] running `Command { std: "docker" "rm" "-f" "f5aa8d0bba0d0b2d781c68e0396fe8da56db6096a3caa20ee8dfbf5c767d3e13", kill_on_drop: false }` [INFO] [stdout] f5aa8d0bba0d0b2d781c68e0396fe8da56db6096a3caa20ee8dfbf5c767d3e13 [INFO] running `Command { std: "docker" "create" "-v" "/var/lib/crater-agent-workspace/builds/worker-5-tc2/target:/opt/rustwide/target:rw,Z" "-v" "/var/lib/crater-agent-workspace/builds/worker-5-tc2/source:/opt/rustwide/workdir:ro,Z" "-v" "/var/lib/crater-agent-workspace/cargo-home:/opt/rustwide/cargo-home:ro,Z" "-v" "/var/lib/crater-agent-workspace/rustup-home:/opt/rustwide/rustup-home:ro,Z" "-e" "SOURCE_DIR=/opt/rustwide/workdir" "-e" "CARGO_TARGET_DIR=/opt/rustwide/target" "-e" "CARGO_INCREMENTAL=0" "-e" "RUST_BACKTRACE=full" "-e" "RUSTFLAGS=--cap-lints=forbid" "-e" "RUSTDOCFLAGS=--cap-lints=forbid" "-e" "CARGO_HOME=/opt/rustwide/cargo-home" "-e" "RUSTUP_HOME=/opt/rustwide/rustup-home" "-w" "/opt/rustwide/workdir" "-m" "1610612736" "--user" "0:0" "--network" "none" "ghcr.io/rust-lang/crates-build-env/linux@sha256:d429b63d4308055ea97f60fb1d3dfca48854a00942f1bd2ad806beaf015945ec" "/opt/rustwide/cargo-home/bin/cargo" "+53f0b05ecbcf011a1f77f1c627304e87ebd05801" "check" "--frozen" "--all" "--all-targets" "--message-format=json", kill_on_drop: false }` [INFO] [stdout] c7e91bf486eef1f860380d3cbac555209b0b4c24d9c93a1968637685a52c1b51 [INFO] running `Command { std: "docker" "start" "-a" "c7e91bf486eef1f860380d3cbac555209b0b4c24d9c93a1968637685a52c1b51", kill_on_drop: false }` [INFO] [stderr] Compiling proc-macro2 v1.0.95 [INFO] [stderr] Compiling unicode-ident v1.0.18 [INFO] [stderr] Compiling libc v0.2.172 [INFO] [stderr] Compiling serde v1.0.219 [INFO] [stderr] Compiling autocfg v1.4.0 [INFO] [stderr] Compiling version_check v0.9.5 [INFO] [stderr] Compiling typenum v1.18.0 [INFO] [stderr] Compiling shlex v1.3.0 [INFO] [stderr] Checking once_cell v1.21.3 [INFO] [stderr] Compiling cc v1.2.22 [INFO] [stderr] Checking itoa v1.0.15 [INFO] [stderr] Compiling zerocopy v0.8.25 [INFO] [stderr] Compiling generic-array v0.14.7 [INFO] [stderr] Compiling lock_api v0.4.12 [INFO] [stderr] Checking bytes v1.10.1 [INFO] [stderr] Compiling icu_properties_data v2.0.0 [INFO] [stderr] Checking pin-project-lite v0.2.16 [INFO] [stderr] Compiling icu_normalizer_data v2.0.0 [INFO] [stderr] Compiling thiserror v2.0.12 [INFO] [stderr] Compiling slab v0.4.9 [INFO] [stderr] Compiling stable_deref_trait v1.2.0 [INFO] [stderr] Compiling quote v1.0.40 [INFO] [stderr] Compiling crossbeam-utils v0.8.21 [INFO] [stderr] Compiling serde_json v1.0.140 [INFO] [stderr] Compiling pkg-config v0.3.32 [INFO] [stderr] Compiling syn v2.0.101 [INFO] [stderr] Checking allocator-api2 v0.2.21 [INFO] [stderr] Checking futures-core v0.3.31 [INFO] [stderr] Checking subtle v2.6.1 [INFO] [stderr] Compiling getrandom v0.2.16 [INFO] [stderr] Checking log v0.4.27 [INFO] [stderr] Checking mio v1.0.3 [INFO] [stderr] Checking signal-hook-registry v1.4.5 [INFO] [stderr] Checking socket2 v0.5.9 [INFO] [stderr] Compiling litemap v0.8.0 [INFO] [stderr] Compiling writeable v0.6.1 [INFO] [stderr] Compiling num-traits v0.2.19 [INFO] [stderr] Checking ryu v1.0.20 [INFO] [stderr] Checking crypto-common v0.1.6 [INFO] [stderr] Checking block-buffer v0.10.4 [INFO] [stderr] Checking futures-sink v0.3.31 [INFO] [stderr] Checking digest v0.10.7 [INFO] [stderr] Checking http v1.3.1 [INFO] [stderr] Checking tracing-core v0.1.33 [INFO] [stderr] Checking futures-io v0.3.31 [INFO] [stderr] Checking futures-task v0.3.31 [INFO] [stderr] Checking foldhash v0.1.5 [INFO] [stderr] Checking equivalent v1.0.2 [INFO] [stderr] Checking hashbrown v0.15.3 [INFO] [stderr] Checking futures-util v0.3.31 [INFO] [stderr] Compiling getrandom v0.3.3 [INFO] [stderr] Compiling crunchy v0.2.3 [INFO] [stderr] Compiling openssl-sys v0.9.109 [INFO] [stderr] Compiling ahash v0.8.12 [INFO] [stderr] Compiling tiny-keccak v2.0.2 [INFO] [stderr] Compiling scopeguard v1.2.0 [INFO] [stderr] Checking cpufeatures v0.2.17 [INFO] [stderr] Compiling rustversion v1.0.20 [INFO] [stderr] Compiling utf8_iter v1.0.4 [INFO] [stderr] Compiling tinyvec_macros v0.1.1 [INFO] [stderr] Compiling percent-encoding v2.3.1 [INFO] [stderr] Checking tinyvec v1.9.0 [INFO] [stderr] Compiling tokio v1.45.0 [INFO] [stderr] Compiling form_urlencoded v1.2.1 [INFO] [stderr] Compiling concurrent-queue v2.5.0 [INFO] [stderr] Checking ppv-lite86 v0.2.21 [INFO] [stderr] Checking indexmap v2.9.0 [INFO] [stderr] Checking rand_core v0.6.4 [INFO] [stderr] Checking http-body v1.0.1 [INFO] [stderr] Checking futures-channel v0.3.31 [INFO] [stderr] Compiling synstructure v0.13.2 [INFO] [stderr] Compiling crc-catalog v2.4.0 [INFO] [stderr] Checking anstyle v1.0.11 [INFO] [stderr] Compiling rustix v1.0.7 [INFO] [stderr] Compiling httparse v1.10.1 [INFO] [stderr] Compiling pin-utils v0.1.0 [INFO] [stderr] Compiling bitflags v2.9.0 [INFO] [stderr] Checking tower-service v0.3.3 [INFO] [stderr] Compiling ucd-trie v0.1.7 [INFO] [stderr] Compiling iana-time-zone v0.1.63 [INFO] [stderr] Compiling parking v2.2.1 [INFO] [stderr] Compiling darling_core v0.20.11 [INFO] [stderr] Compiling event-listener v5.4.0 [INFO] [stderr] Compiling rand_chacha v0.3.1 [INFO] [stderr] Compiling chrono v0.4.41 [INFO] [stderr] Compiling sha2 v0.10.9 [INFO] [stderr] Compiling crc v3.3.0 [INFO] [stderr] Checking unicode-normalization v0.1.24 [INFO] [stderr] Checking hashbrown v0.14.5 [INFO] [stderr] Compiling const-random-macro v0.1.16 [INFO] [stderr] Compiling hashlink v0.10.0 [INFO] [stderr] Compiling serde_derive v1.0.219 [INFO] [stderr] Compiling zerofrom-derive v0.1.6 [INFO] [stderr] Compiling yoke-derive v0.8.0 [INFO] [stderr] Compiling zerovec-derive v0.11.1 [INFO] [stderr] Compiling displaydoc v0.2.5 [INFO] [stderr] Compiling thiserror-impl v2.0.12 [INFO] [stderr] Compiling tracing-attributes v0.1.28 [INFO] [stderr] Compiling tokio-macros v2.5.0 [INFO] [stderr] Compiling tokio-stream v0.1.17 [INFO] [stderr] Compiling zerofrom v0.1.6 [INFO] [stderr] Compiling yoke v0.8.0 [INFO] [stderr] Compiling crossbeam-queue v0.3.12 [INFO] [stderr] Compiling zerovec v0.11.2 [INFO] [stderr] Compiling zerotrie v0.2.2 [INFO] [stderr] Checking tracing v0.1.41 [INFO] [stderr] Compiling pest v2.8.0 [INFO] [stderr] Compiling hmac v0.12.1 [INFO] [stderr] Compiling psm v0.1.26 [INFO] [stderr] Compiling onig_sys v69.9.1 [INFO] [stderr] Compiling prettyplease v0.2.34 [INFO] [stderr] Checking tower-layer v0.3.3 [INFO] [stderr] Compiling time-core v0.1.4 [INFO] [stderr] Compiling openssl v0.10.73 [INFO] [stderr] Checking linux-raw-sys v0.9.4 [INFO] [stderr] Compiling base64 v0.22.1 [INFO] [stderr] Compiling uuid v1.16.0 [INFO] [stderr] Checking regex-syntax v0.8.5 [INFO] [stderr] Compiling unicode-bidi v0.3.18 [INFO] [stderr] Compiling tinystr v0.8.1 [INFO] [stderr] Compiling potential_utf v0.1.2 [INFO] [stderr] Compiling icu_locale_core v2.0.0 [INFO] [stderr] Compiling icu_collections v2.0.0 [INFO] [stderr] Compiling unicode-properties v0.1.3 [INFO] [stderr] Compiling pest_meta v2.8.0 [INFO] [stderr] Checking icu_provider v2.0.0 [INFO] [stderr] Compiling stringprep v0.1.5 [INFO] [stderr] Checking icu_properties v2.0.0 [INFO] [stderr] Compiling time-macros v0.2.22 [INFO] [stderr] Checking deranged v0.4.0 [INFO] [stderr] Checking anstyle-parse v0.2.7 [INFO] [stderr] Checking smallvec v1.15.0 [INFO] [stderr] Checking parking_lot_core v0.9.10 [INFO] [stderr] Checking icu_normalizer v2.0.0 [INFO] [stderr] Checking parking_lot v0.12.3 [INFO] [stderr] Compiling hkdf v0.12.4 [INFO] [stderr] Checking idna_adapter v1.2.1 [INFO] [stderr] Checking idna v1.0.3 [INFO] [stderr] Compiling darling_macro v0.20.11 [INFO] [stderr] Checking const-random v0.1.18 [INFO] [stderr] Compiling openssl-macros v0.1.1 [INFO] [stderr] Checking url v2.5.4 [INFO] [stderr] Compiling rand v0.8.5 [INFO] [stderr] Compiling either v1.15.0 [INFO] [stderr] Compiling atoi v2.0.0 [INFO] [stderr] Compiling md-5 v0.10.6 [INFO] [stderr] Compiling stacker v0.1.21 [INFO] [stderr] Checking num_threads v0.1.7 [INFO] [stderr] Compiling fastrand v2.3.0 [INFO] [stderr] Compiling thiserror v1.0.69 [INFO] [stderr] Compiling hex v0.4.3 [INFO] [stderr] Checking anstyle-query v1.1.3 [INFO] [stderr] Compiling futures-intrusive v0.5.0 [INFO] [stderr] Checking is_terminal_polyfill v1.70.1 [INFO] [stderr] Checking adler2 v2.0.0 [INFO] [stderr] Compiling dotenvy v0.15.7 [INFO] [stderr] Checking sync_wrapper v1.0.2 [INFO] [stderr] Checking colorchoice v1.0.4 [INFO] [stderr] Compiling byteorder v1.5.0 [INFO] [stderr] Compiling native-tls v0.2.14 [INFO] [stderr] Compiling home v0.5.11 [INFO] [stderr] Compiling whoami v1.6.0 [INFO] [stderr] Checking anstream v0.6.19 [INFO] [stderr] Compiling sqlx-core v0.8.5 [INFO] [stderr] Checking time v0.3.41 [INFO] [stderr] Checking miniz_oxide v0.8.8 [INFO] [stderr] Compiling tempfile v3.20.0 [INFO] [stderr] Checking terminal_size v0.4.2 [INFO] [stderr] Compiling darling v0.20.11 [INFO] [stderr] Checking dlv-list v0.5.2 [INFO] [stderr] Checking hyper v1.6.0 [INFO] [stderr] Checking toml_datetime v0.6.9 [INFO] [stderr] Checking serde_spanned v0.6.8 [INFO] [stderr] Compiling pest_generator v2.8.0 [INFO] [stderr] Compiling thiserror-impl v1.0.69 [INFO] [stderr] Checking http-body-util v0.1.3 [INFO] [stderr] Checking num-integer v0.1.46 [INFO] [stderr] Compiling ring v0.17.14 [INFO] [stderr] Checking clap_lex v0.7.5 [INFO] [stderr] Checking openssl-probe v0.1.6 [INFO] [stderr] Checking regex-syntax v0.6.29 [INFO] [stderr] Checking strsim v0.11.1 [INFO] [stderr] Checking winnow v0.7.10 [INFO] [stderr] Compiling pest_derive v2.8.0 [INFO] [stderr] Checking clap_builder v4.5.40 [INFO] [stderr] Compiling sqlx-postgres v0.8.5 [INFO] [stderr] Checking regex-automata v0.1.10 [INFO] [stderr] Checking num-bigint v0.4.6 [INFO] [stderr] Checking flate2 v1.1.2 [INFO] [stderr] Checking axum-core v0.5.2 [INFO] [stderr] Compiling bon-macros v3.6.4 [INFO] [stderr] Checking toml_edit v0.22.26 [INFO] [stderr] Checking hyper-util v0.1.11 [INFO] [stderr] Checking ordered-multimap v0.7.3 [INFO] [stderr] Checking tower v0.5.2 [INFO] [stderr] Checking onig v6.5.1 [INFO] [stderr] Checking serde_path_to_error v0.1.17 [INFO] [stderr] Checking serde_urlencoded v0.7.1 [INFO] [stderr] Checking bincode v1.3.3 [INFO] [stderr] Checking regex-automata v0.4.9 [INFO] [stderr] Compiling axum-macros v0.5.0 [INFO] [stderr] Compiling clap_derive v4.5.40 [INFO] [stderr] Compiling async-trait v0.1.88 [INFO] [stderr] Checking rand_core v0.9.3 [INFO] [stderr] Checking sha1 v0.10.6 [INFO] [stderr] Checking headers-core v0.3.0 [INFO] [stderr] Compiling blake3 v1.8.2 [INFO] [stderr] Checking encoding_rs v0.8.35 [INFO] [stderr] Checking unicode-segmentation v1.12.0 [INFO] [stderr] Checking overload v0.1.1 [INFO] [stderr] Compiling sqlx-macros-core v0.8.5 [INFO] [stderr] Checking base64ct v1.7.3 [INFO] [stderr] Checking trim-in-place v0.1.7 [INFO] [stderr] Checking lazy_static v1.5.0 [INFO] [stderr] Checking matchit v0.8.4 [INFO] [stderr] Checking arraydeque v0.5.1 [INFO] [stderr] Compiling anyhow v1.0.98 [INFO] [stderr] Checking deunicode v1.6.2 [INFO] [stderr] Checking slug v0.1.6 [INFO] [stderr] Checking yaml-rust2 v0.10.1 [INFO] [stderr] Checking clap v4.5.40 [INFO] [stderr] Checking axum v0.8.4 [INFO] [stderr] Checking sharded-slab v0.1.7 [INFO] [stderr] Checking syntect v5.2.0 [INFO] [stderr] Checking rust-ini v0.21.1 [INFO] [stderr] Checking password-hash v0.5.0 [INFO] [stderr] Checking regex v1.11.1 [INFO] [stderr] Checking ron v0.8.1 [INFO] [stderr] Checking bon v3.6.4 [INFO] [stderr] Checking nu-ansi-term v0.46.0 [INFO] [stderr] Checking convert_case v0.6.0 [INFO] [stderr] Checking headers v0.4.1 [INFO] [stderr] Checking rand_chacha v0.9.0 [INFO] [stderr] Checking toml v0.8.22 [INFO] [stderr] Checking chumsky v0.9.3 [INFO] [stderr] Checking simple_asn1 v0.6.3 [INFO] [stderr] Checking json5 v0.4.1 [INFO] [stderr] Checking matchers v0.1.0 [INFO] [stderr] Checking tokio-native-tls v0.3.1 [INFO] [stderr] Checking caseless v0.2.2 [INFO] [stderr] Checking pem v3.0.5 [INFO] [stderr] Checking email-encoding v0.4.1 [INFO] [stderr] Checking tracing-log v0.2.0 [INFO] [stderr] Compiling sqlx-macros v0.8.5 [INFO] [stderr] Checking blake2 v0.10.6 [INFO] [stderr] Checking hostname v0.4.1 [INFO] [stderr] Checking nom v8.0.0 [INFO] [stderr] Checking thread_local v1.1.8 [INFO] [stderr] Checking predicates-core v1.0.9 [INFO] [stderr] Checking email_address v0.2.9 [INFO] [stderr] Checking xdg v2.5.2 [INFO] [stderr] Checking arrayref v0.3.9 [INFO] [stderr] Checking constant_time_eq v0.3.1 [INFO] [stderr] Checking entities v1.0.1 [INFO] [stderr] Checking unicode_categories v0.1.1 [INFO] [stderr] Compiling mockall_derive v0.13.1 [INFO] [stderr] Checking pathdiff v0.2.3 [INFO] [stderr] Checking arrayvec v0.7.6 [INFO] [stderr] Checking shell-words v1.1.0 [INFO] [stderr] Checking typed-arena v2.0.2 [INFO] [stderr] Checking config v0.15.11 [INFO] [stderr] Checking comrak v0.39.0 [INFO] [stderr] Checking tracing-subscriber v0.3.19 [INFO] [stderr] Checking argon2 v0.5.3 [INFO] [stderr] Checking jsonwebtoken v9.3.1 [INFO] [stderr] Checking axum-extra v0.10.1 [INFO] [stderr] Checking rand v0.9.1 [INFO] [stderr] Checking sqlx v0.8.5 [INFO] [stderr] Checking tower-http v0.6.6 [INFO] [stderr] Checking termtree v0.5.1 [INFO] [stderr] Checking predicates-tree v1.0.12 [INFO] [stderr] Checking predicates v3.1.3 [INFO] [stderr] Checking fragile v2.0.1 [INFO] [stderr] Checking lettre v0.11.17 [INFO] [stderr] Checking mockall v0.13.1 [INFO] [stderr] Checking backend v0.1.0 (/opt/rustwide/workdir/backend) [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:172:26 [INFO] [stdout] | [INFO] [stdout] 172 | let categories = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 173 | | Category, [INFO] [stdout] 174 | | r#" [INFO] [stdout] 175 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 178 | | "# [INFO] [stdout] 179 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:258:13 [INFO] [stdout] | [INFO] [stdout] 258 | / sqlx::query!( [INFO] [stdout] 259 | | r#" [INFO] [stdout] 260 | | UPDATE post_categories [INFO] [stdout] 261 | | SET category_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 269 | | source_id [INFO] [stdout] 270 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:276:13 [INFO] [stdout] | [INFO] [stdout] 276 | / sqlx::query!( [INFO] [stdout] 277 | | "DELETE FROM post_categories WHERE category_id = $1", [INFO] [stdout] 278 | | source_id [INFO] [stdout] 279 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:285:13 [INFO] [stdout] | [INFO] [stdout] 285 | sqlx::query!("DELETE FROM categories WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:309:34 [INFO] [stdout] | [INFO] [stdout] 309 | let affected_posts = sqlx::query_scalar!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 310 | | r#" [INFO] [stdout] 311 | | SELECT COUNT(*)::int as count [INFO] [stdout] 312 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 315 | | source_id [INFO] [stdout] 316 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:325:36 [INFO] [stdout] | [INFO] [stdout] 325 | let transferred_rows = sqlx::query!( [INFO] [stdout] | ____________________________________^ [INFO] [stdout] 326 | | r#" [INFO] [stdout] 327 | | UPDATE post_categories [INFO] [stdout] 328 | | SET category_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 336 | | source_id [INFO] [stdout] 337 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:343:32 [INFO] [stdout] | [INFO] [stdout] 343 | let deleted_rows = sqlx::query!( [INFO] [stdout] | ________________________________^ [INFO] [stdout] 344 | | "DELETE FROM post_categories WHERE category_id = $1", [INFO] [stdout] 345 | | source_id [INFO] [stdout] 346 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:366:13 [INFO] [stdout] | [INFO] [stdout] 366 | sqlx::query!("DELETE FROM categories WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:375:13 [INFO] [stdout] | [INFO] [stdout] 375 | / sqlx::query!( [INFO] [stdout] 376 | | "UPDATE categories SET name = $1, slug = $2 WHERE id = $3", [INFO] [stdout] 377 | | new_name, [INFO] [stdout] 378 | | new_slug, [INFO] [stdout] 379 | | target_category_id [INFO] [stdout] 380 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:404:26 [INFO] [stdout] | [INFO] [stdout] 404 | let categories = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 405 | | Category, [INFO] [stdout] 406 | | r#" [INFO] [stdout] 407 | | SELECT id, name, slug, created_at, updated_at [INFO] [stdout] ... | [INFO] [stdout] 411 | | &all_category_ids [INFO] [stdout] 412 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:418:30 [INFO] [stdout] | [INFO] [stdout] 418 | let total_affected = sqlx::query_scalar!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 419 | | r#" [INFO] [stdout] 420 | | SELECT COUNT(DISTINCT post_id)::int as count [INFO] [stdout] 421 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 424 | | source_category_ids [INFO] [stdout] 425 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:432:26 [INFO] [stdout] | [INFO] [stdout] 432 | let duplicates = sqlx::query_scalar!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 433 | | r#" [INFO] [stdout] 434 | | SELECT COUNT(*)::int as count [INFO] [stdout] 435 | | FROM post_categories pc1 [INFO] [stdout] ... | [INFO] [stdout] 443 | | target_category_id [INFO] [stdout] 444 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:454:22 [INFO] [stdout] | [INFO] [stdout] 454 | let result = sqlx::query!("DELETE FROM categories WHERE id = ANY($1)", category_ids) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:470:30 [INFO] [stdout] | [INFO] [stdout] 470 | let affected_posts = sqlx::query_scalar!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 471 | | r#" [INFO] [stdout] 472 | | SELECT COUNT(DISTINCT post_id)::int as count [INFO] [stdout] 473 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 476 | | category_ids [INFO] [stdout] 477 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:487:13 [INFO] [stdout] | [INFO] [stdout] 487 | / sqlx::query!( [INFO] [stdout] 488 | | "DELETE FROM post_categories WHERE category_id = ANY($1)", [INFO] [stdout] 489 | | category_ids [INFO] [stdout] 490 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:496:48 [INFO] [stdout] | [INFO] [stdout] 496 | let orphaned_post_ids: Vec = sqlx::query_scalar!( [INFO] [stdout] | ________________________________________________^ [INFO] [stdout] 497 | | r#" [INFO] [stdout] 498 | | SELECT p.id [INFO] [stdout] 499 | | FROM posts p [INFO] [stdout] ... | [INFO] [stdout] 503 | | "# [INFO] [stdout] 504 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:513:46 [INFO] [stdout] | [INFO] [stdout] 513 | let uncategorized_category = sqlx::query!( [INFO] [stdout] | ______________________________________________^ [INFO] [stdout] 514 | | r#" [INFO] [stdout] 515 | | INSERT INTO categories (id, name, slug, created_at, updated_at) [INFO] [stdout] 516 | | VALUES (gen_random_uuid(), '未分类', 'uncategorized', NOW(), NOW()) [INFO] [stdout] ... | [INFO] [stdout] 519 | | "# [INFO] [stdout] 520 | | ) [INFO] [stdout] | |_________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:527:21 [INFO] [stdout] | [INFO] [stdout] 527 | / sqlx::query!( [INFO] [stdout] 528 | | "INSERT INTO post_categories (post_id, category_id) VALUES ($1, $2)", [INFO] [stdout] 529 | | post_id, [INFO] [stdout] 530 | | uncategorized_category.id [INFO] [stdout] 531 | | ) [INFO] [stdout] | |_____________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:541:13 [INFO] [stdout] | [INFO] [stdout] 541 | / sqlx::query!( [INFO] [stdout] 542 | | "DELETE FROM post_categories WHERE category_id = ANY($1)", [INFO] [stdout] 543 | | category_ids [INFO] [stdout] 544 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:551:22 [INFO] [stdout] | [INFO] [stdout] 551 | let result = sqlx::query!("DELETE FROM categories WHERE id = ANY($1)", category_ids) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:564:21 [INFO] [stdout] | [INFO] [stdout] 564 | let stats = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 565 | | r#" [INFO] [stdout] 566 | | SELECT [INFO] [stdout] 567 | | c.id, c.name, c.slug, c.created_at, c.updated_at, [INFO] [stdout] ... | [INFO] [stdout] 573 | | "# [INFO] [stdout] 574 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:616:26 [INFO] [stdout] | [INFO] [stdout] 616 | let post_count = sqlx::query_scalar!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 617 | | r#" [INFO] [stdout] 618 | | SELECT COUNT(*)::int as count [INFO] [stdout] 619 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 622 | | category_id [INFO] [stdout] 623 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:629:42 [INFO] [stdout] | [INFO] [stdout] 629 | let sample_titles: Vec = sqlx::query_scalar!( [INFO] [stdout] | __________________________________________^ [INFO] [stdout] 630 | | r#" [INFO] [stdout] 631 | | SELECT p.title [INFO] [stdout] 632 | | FROM posts p [INFO] [stdout] ... | [INFO] [stdout] 638 | | category_id [INFO] [stdout] 639 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:35:26 [INFO] [stdout] | [INFO] [stdout] 35 | let permission = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 36 | | Permission, [INFO] [stdout] 37 | | r#" [INFO] [stdout] 38 | | select id,name,description,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 42 | | permission_id [INFO] [stdout] 43 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:51:26 [INFO] [stdout] | [INFO] [stdout] 51 | let permission = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 52 | | Permission, [INFO] [stdout] 53 | | r#" [INFO] [stdout] 54 | | insert into permissions (id, name, description) [INFO] [stdout] ... | [INFO] [stdout] 60 | | payload.description [INFO] [stdout] 61 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:79:34 [INFO] [stdout] | [INFO] [stdout] 79 | let updated_permission = sqlx::query_as!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 80 | | Permission, [INFO] [stdout] 81 | | r#" [INFO] [stdout] 82 | | update permissions [INFO] [stdout] ... | [INFO] [stdout] 89 | | permission_id [INFO] [stdout] 90 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:97:22 [INFO] [stdout] | [INFO] [stdout] 97 | let result = sqlx::query!("DELETE FROM permissions WHERE id = $1", permission_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:108:27 [INFO] [stdout] | [INFO] [stdout] 108 | let permissions = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 109 | | Permission, [INFO] [stdout] 110 | | r#" [INFO] [stdout] 111 | | select id,name,description,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 114 | | "# [INFO] [stdout] 115 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:151:13 [INFO] [stdout] | [INFO] [stdout] 151 | sqlx::query!("delete from post_categories where post_id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:164:21 [INFO] [stdout] | [INFO] [stdout] 164 | / sqlx::query!( [INFO] [stdout] 165 | | "insert into post_categories (post_id, category_id) values ($1,$2) on conflict do nothing", [INFO] [stdout] 166 | | post_id, [INFO] [stdout] 167 | | category_id [INFO] [stdout] 168 | | ) [INFO] [stdout] | |_____________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:186:13 [INFO] [stdout] | [INFO] [stdout] 186 | sqlx::query!("delete from post_tags where post_id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:194:21 [INFO] [stdout] | [INFO] [stdout] 194 | / sqlx::query!( [INFO] [stdout] 195 | | "insert into post_tags (post_id, tag_id) values ($1,$2) on conflict do nothing", [INFO] [stdout] 196 | | post_id, [INFO] [stdout] 197 | | tag_id [INFO] [stdout] 198 | | ) [INFO] [stdout] | |_____________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:228:20 [INFO] [stdout] | [INFO] [stdout] 228 | ... let post = sqlx::query_as!( [INFO] [stdout] | __________________^ [INFO] [stdout] 229 | | ... Post, [INFO] [stdout] 230 | | ... r#" [INFO] [stdout] 231 | | ... insert into posts (id,slug,title,content,created_at,updated_at,published_at,author_id,draft_shared_with,is_draft_public... [INFO] [stdout] ... | [INFO] [stdout] 245 | | ... false // 默认不封禁 [INFO] [stdout] 246 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:273:20 [INFO] [stdout] | [INFO] [stdout] 273 | ... let post = sqlx::query_as!( [INFO] [stdout] | __________________^ [INFO] [stdout] 274 | | ... Post, [INFO] [stdout] 275 | | ... r#" [INFO] [stdout] 276 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] 277 | | ... "#, [INFO] [stdout] 278 | | ... id [INFO] [stdout] 279 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:287:20 [INFO] [stdout] | [INFO] [stdout] 287 | ... let post = sqlx::query_as!( [INFO] [stdout] | __________________^ [INFO] [stdout] 288 | | ... Post, [INFO] [stdout] 289 | | ... r#" [INFO] [stdout] 290 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 294 | | ... slug [INFO] [stdout] 295 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:304:21 [INFO] [stdout] | [INFO] [stdout] 304 | ... let posts = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 305 | | ... Post, [INFO] [stdout] 306 | | ... r#" [INFO] [stdout] 307 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at,author_id,draft... [INFO] [stdout] ... | [INFO] [stdout] 314 | | ... offset [INFO] [stdout] 315 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:347:21 [INFO] [stdout] | [INFO] [stdout] 347 | ... let posts = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 348 | | ... Post, [INFO] [stdout] 349 | | ... r#" [INFO] [stdout] 350 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at, author_id,draf... [INFO] [stdout] ... | [INFO] [stdout] 359 | | ... offset [INFO] [stdout] 360 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:366:34 [INFO] [stdout] | [INFO] [stdout] 366 | let total_count_result = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 367 | | r#" [INFO] [stdout] 368 | | select count(*) as "count!" from posts [INFO] [stdout] 369 | | WHERE author_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 372 | | author_id [INFO] [stdout] 373 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:392:13 [INFO] [stdout] | [INFO] [stdout] 392 | / ... sqlx::query_as!( [INFO] [stdout] 393 | | ... Post, [INFO] [stdout] 394 | | ... r#" [INFO] [stdout] 395 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at, author_id,draf... [INFO] [stdout] ... | [INFO] [stdout] 402 | | ... offset [INFO] [stdout] 403 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:409:13 [INFO] [stdout] | [INFO] [stdout] 409 | / ... sqlx::query_as!( [INFO] [stdout] 410 | | ... Post, [INFO] [stdout] 411 | | ... r#" [INFO] [stdout] 412 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at, author_id,draf... [INFO] [stdout] ... | [INFO] [stdout] 419 | | ... offset [INFO] [stdout] 420 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:428:13 [INFO] [stdout] | [INFO] [stdout] 428 | / sqlx::query_scalar!( [INFO] [stdout] 429 | | r#" [INFO] [stdout] 430 | | select count(*) from posts [INFO] [stdout] 431 | | WHERE published_at IS NOT NULL AND published_at <= NOW() [INFO] [stdout] 432 | | "# [INFO] [stdout] 433 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:438:13 [INFO] [stdout] | [INFO] [stdout] 438 | / sqlx::query_scalar!( [INFO] [stdout] 439 | | r#" [INFO] [stdout] 440 | | select count(*) from posts [INFO] [stdout] 441 | | WHERE published_at IS NOT NULL AND published_at <= NOW() AND (is_banned = false OR is_banned IS NULL) [INFO] [stdout] 442 | | "# [INFO] [stdout] 443 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:456:13 [INFO] [stdout] | [INFO] [stdout] 456 | / ... sqlx::query_as!( [INFO] [stdout] 457 | | ... Post, [INFO] [stdout] 458 | | ... r#" [INFO] [stdout] 459 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 463 | | ... id [INFO] [stdout] 464 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:469:13 [INFO] [stdout] | [INFO] [stdout] 469 | / ... sqlx::query_as!( [INFO] [stdout] 470 | | ... Post, [INFO] [stdout] 471 | | ... r#" [INFO] [stdout] 472 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 476 | | ... id [INFO] [stdout] 477 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:491:13 [INFO] [stdout] | [INFO] [stdout] 491 | / ... sqlx::query_as!( [INFO] [stdout] 492 | | ... Post, [INFO] [stdout] 493 | | ... r#" [INFO] [stdout] 494 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 498 | | ... slug [INFO] [stdout] 499 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:504:13 [INFO] [stdout] | [INFO] [stdout] 504 | / ... sqlx::query_as!( [INFO] [stdout] 505 | | ... Post, [INFO] [stdout] 506 | | ... r#" [INFO] [stdout] 507 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 511 | | ... slug [INFO] [stdout] 512 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:577:36 [INFO] [stdout] | [INFO] [stdout] 577 | let updated_post_from_db = sqlx::query_as!( [INFO] [stdout] | ____________________________________^ [INFO] [stdout] 578 | | Post, [INFO] [stdout] 579 | | r#" [INFO] [stdout] 580 | | update posts [INFO] [stdout] ... | [INFO] [stdout] 592 | | id [INFO] [stdout] 593 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:645:26 [INFO] [stdout] | [INFO] [stdout] 645 | let categories = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 646 | | CategoryDto, [INFO] [stdout] 647 | | r#" [INFO] [stdout] 648 | | select c.id,c.name,c.slug [INFO] [stdout] ... | [INFO] [stdout] 654 | | post_id [INFO] [stdout] 655 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:664:20 [INFO] [stdout] | [INFO] [stdout] 664 | let tags = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 665 | | TagDto, [INFO] [stdout] 666 | | r#" [INFO] [stdout] 667 | | select t.id,t.name,t.slug [INFO] [stdout] ... | [INFO] [stdout] 673 | | post_id [INFO] [stdout] 674 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:683:22 [INFO] [stdout] | [INFO] [stdout] 683 | let result = sqlx::query!("select author_id from posts where id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:696:22 [INFO] [stdout] | [INFO] [stdout] 696 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 697 | | "UPDATE posts SET published_at = $1, updated_at = $1 WHERE id = $2", [INFO] [stdout] 698 | | now, [INFO] [stdout] 699 | | id [INFO] [stdout] 700 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:716:22 [INFO] [stdout] | [INFO] [stdout] 716 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 717 | | "UPDATE posts SET published_at = NULL, updated_at = $1 WHERE id = $2", [INFO] [stdout] 718 | | now, [INFO] [stdout] 719 | | id [INFO] [stdout] 720 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:735:22 [INFO] [stdout] | [INFO] [stdout] 735 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 736 | | r#" [INFO] [stdout] 737 | | SELECT [INFO] [stdout] 738 | | author_id, [INFO] [stdout] ... | [INFO] [stdout] 745 | | post_id [INFO] [stdout] 746 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:789:22 [INFO] [stdout] | [INFO] [stdout] 789 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 790 | | r#" [INFO] [stdout] 791 | | UPDATE posts [INFO] [stdout] 792 | | SET [INFO] [stdout] ... | [INFO] [stdout] 801 | | post_id [INFO] [stdout] 802 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:830:21 [INFO] [stdout] | [INFO] [stdout] 830 | let posts = sqlx::query_as!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 831 | | Post, [INFO] [stdout] 832 | | r#" [INFO] [stdout] 833 | | SELECT [INFO] [stdout] ... | [INFO] [stdout] 848 | | offset [INFO] [stdout] 849 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:855:21 [INFO] [stdout] | [INFO] [stdout] 855 | let total = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 856 | | r#" [INFO] [stdout] 857 | | SELECT COUNT(*) as count [INFO] [stdout] 858 | | FROM posts [INFO] [stdout] ... | [INFO] [stdout] 866 | | user_id [INFO] [stdout] 867 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:883:9 [INFO] [stdout] | [INFO] [stdout] 883 | / sqlx::query!( [INFO] [stdout] 884 | | r#" [INFO] [stdout] 885 | | INSERT INTO draft_access_logs (post_id, accessed_by, access_type, access_reason) [INFO] [stdout] 886 | | VALUES ($1, $2, $3, $4) [INFO] [stdout] ... | [INFO] [stdout] 891 | | reason [INFO] [stdout] 892 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:915:13 [INFO] [stdout] | [INFO] [stdout] 915 | / sqlx::query_as!( [INFO] [stdout] 916 | | DraftAccessLogDto, [INFO] [stdout] 917 | | r#" [INFO] [stdout] 918 | | SELECT [INFO] [stdout] ... | [INFO] [stdout] 936 | | offset [INFO] [stdout] 937 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:943:13 [INFO] [stdout] | [INFO] [stdout] 943 | / sqlx::query_as!( [INFO] [stdout] 944 | | DraftAccessLogDto, [INFO] [stdout] 945 | | r#" [INFO] [stdout] 946 | | SELECT [INFO] [stdout] ... | [INFO] [stdout] 962 | | offset [INFO] [stdout] 963 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:172:26 [INFO] [stdout] | [INFO] [stdout] 172 | let categories = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 173 | | Category, [INFO] [stdout] 174 | | r#" [INFO] [stdout] 175 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 178 | | "# [INFO] [stdout] 179 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:974:22 [INFO] [stdout] | [INFO] [stdout] 974 | let result = sqlx::query!("SELECT published_at FROM posts WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:258:13 [INFO] [stdout] | [INFO] [stdout] 258 | / sqlx::query!( [INFO] [stdout] 259 | | r#" [INFO] [stdout] 260 | | UPDATE post_categories [INFO] [stdout] 261 | | SET category_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 269 | | source_id [INFO] [stdout] 270 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1003:21 [INFO] [stdout] | [INFO] [stdout] 1003 | let posts = sqlx::query_as!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 1004 | | Post, [INFO] [stdout] 1005 | | r#" [INFO] [stdout] 1006 | | SELECT DISTINCT [INFO] [stdout] ... | [INFO] [stdout] 1020 | | offset [INFO] [stdout] 1021 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:276:13 [INFO] [stdout] | [INFO] [stdout] 276 | / sqlx::query!( [INFO] [stdout] 277 | | "DELETE FROM post_categories WHERE category_id = $1", [INFO] [stdout] 278 | | source_id [INFO] [stdout] 279 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1027:34 [INFO] [stdout] | [INFO] [stdout] 1027 | let total_count_result = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 1028 | | r#" [INFO] [stdout] 1029 | | SELECT COUNT(DISTINCT id) as "count!" [INFO] [stdout] 1030 | | FROM posts [INFO] [stdout] ... | [INFO] [stdout] 1037 | | user_id [INFO] [stdout] 1038 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1050:9 [INFO] [stdout] | [INFO] [stdout] 1050 | sqlx::query!("UPDATE posts SET is_banned = true WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:285:13 [INFO] [stdout] | [INFO] [stdout] 285 | sqlx::query!("DELETE FROM categories WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:309:34 [INFO] [stdout] | [INFO] [stdout] 309 | let affected_posts = sqlx::query_scalar!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 310 | | r#" [INFO] [stdout] 311 | | SELECT COUNT(*)::int as count [INFO] [stdout] 312 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 315 | | source_id [INFO] [stdout] 316 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:325:36 [INFO] [stdout] | [INFO] [stdout] 325 | let transferred_rows = sqlx::query!( [INFO] [stdout] | ____________________________________^ [INFO] [stdout] 326 | | r#" [INFO] [stdout] 327 | | UPDATE post_categories [INFO] [stdout] 328 | | SET category_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 336 | | source_id [INFO] [stdout] 337 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:343:32 [INFO] [stdout] | [INFO] [stdout] 343 | let deleted_rows = sqlx::query!( [INFO] [stdout] | ________________________________^ [INFO] [stdout] 344 | | "DELETE FROM post_categories WHERE category_id = $1", [INFO] [stdout] 345 | | source_id [INFO] [stdout] 346 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1061:9 [INFO] [stdout] | [INFO] [stdout] 1061 | sqlx::query!("UPDATE posts SET is_banned = false WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:366:13 [INFO] [stdout] | [INFO] [stdout] 366 | sqlx::query!("DELETE FROM categories WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:375:13 [INFO] [stdout] | [INFO] [stdout] 375 | / sqlx::query!( [INFO] [stdout] 376 | | "UPDATE categories SET name = $1, slug = $2 WHERE id = $3", [INFO] [stdout] 377 | | new_name, [INFO] [stdout] 378 | | new_slug, [INFO] [stdout] 379 | | target_category_id [INFO] [stdout] 380 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:404:26 [INFO] [stdout] | [INFO] [stdout] 404 | let categories = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 405 | | Category, [INFO] [stdout] 406 | | r#" [INFO] [stdout] 407 | | SELECT id, name, slug, created_at, updated_at [INFO] [stdout] ... | [INFO] [stdout] 411 | | &all_category_ids [INFO] [stdout] 412 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1072:22 [INFO] [stdout] | [INFO] [stdout] 1072 | let result = sqlx::query!("SELECT is_banned FROM posts WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:418:30 [INFO] [stdout] | [INFO] [stdout] 418 | let total_affected = sqlx::query_scalar!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 419 | | r#" [INFO] [stdout] 420 | | SELECT COUNT(DISTINCT post_id)::int as count [INFO] [stdout] 421 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 424 | | source_category_ids [INFO] [stdout] 425 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:432:26 [INFO] [stdout] | [INFO] [stdout] 432 | let duplicates = sqlx::query_scalar!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 433 | | r#" [INFO] [stdout] 434 | | SELECT COUNT(*)::int as count [INFO] [stdout] 435 | | FROM post_categories pc1 [INFO] [stdout] ... | [INFO] [stdout] 443 | | target_category_id [INFO] [stdout] 444 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:454:22 [INFO] [stdout] | [INFO] [stdout] 454 | let result = sqlx::query!("DELETE FROM categories WHERE id = ANY($1)", category_ids) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:470:30 [INFO] [stdout] | [INFO] [stdout] 470 | let affected_posts = sqlx::query_scalar!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 471 | | r#" [INFO] [stdout] 472 | | SELECT COUNT(DISTINCT post_id)::int as count [INFO] [stdout] 473 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 476 | | category_ids [INFO] [stdout] 477 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:487:13 [INFO] [stdout] | [INFO] [stdout] 487 | / sqlx::query!( [INFO] [stdout] 488 | | "DELETE FROM post_categories WHERE category_id = ANY($1)", [INFO] [stdout] 489 | | category_ids [INFO] [stdout] 490 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:496:48 [INFO] [stdout] | [INFO] [stdout] 496 | let orphaned_post_ids: Vec = sqlx::query_scalar!( [INFO] [stdout] | ________________________________________________^ [INFO] [stdout] 497 | | r#" [INFO] [stdout] 498 | | SELECT p.id [INFO] [stdout] 499 | | FROM posts p [INFO] [stdout] ... | [INFO] [stdout] 503 | | "# [INFO] [stdout] 504 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:513:46 [INFO] [stdout] | [INFO] [stdout] 513 | let uncategorized_category = sqlx::query!( [INFO] [stdout] | ______________________________________________^ [INFO] [stdout] 514 | | r#" [INFO] [stdout] 515 | | INSERT INTO categories (id, name, slug, created_at, updated_at) [INFO] [stdout] 516 | | VALUES (gen_random_uuid(), '未分类', 'uncategorized', NOW(), NOW()) [INFO] [stdout] ... | [INFO] [stdout] 519 | | "# [INFO] [stdout] 520 | | ) [INFO] [stdout] | |_________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:527:21 [INFO] [stdout] | [INFO] [stdout] 527 | / sqlx::query!( [INFO] [stdout] 528 | | "INSERT INTO post_categories (post_id, category_id) VALUES ($1, $2)", [INFO] [stdout] 529 | | post_id, [INFO] [stdout] 530 | | uncategorized_category.id [INFO] [stdout] 531 | | ) [INFO] [stdout] | |_____________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:541:13 [INFO] [stdout] | [INFO] [stdout] 541 | / sqlx::query!( [INFO] [stdout] 542 | | "DELETE FROM post_categories WHERE category_id = ANY($1)", [INFO] [stdout] 543 | | category_ids [INFO] [stdout] 544 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:551:22 [INFO] [stdout] | [INFO] [stdout] 551 | let result = sqlx::query!("DELETE FROM categories WHERE id = ANY($1)", category_ids) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:564:21 [INFO] [stdout] | [INFO] [stdout] 564 | let stats = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 565 | | r#" [INFO] [stdout] 566 | | SELECT [INFO] [stdout] 567 | | c.id, c.name, c.slug, c.created_at, c.updated_at, [INFO] [stdout] ... | [INFO] [stdout] 573 | | "# [INFO] [stdout] 574 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:616:26 [INFO] [stdout] | [INFO] [stdout] 616 | let post_count = sqlx::query_scalar!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 617 | | r#" [INFO] [stdout] 618 | | SELECT COUNT(*)::int as count [INFO] [stdout] 619 | | FROM post_categories [INFO] [stdout] ... | [INFO] [stdout] 622 | | category_id [INFO] [stdout] 623 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/category.rs:629:42 [INFO] [stdout] | [INFO] [stdout] 629 | let sample_titles: Vec = sqlx::query_scalar!( [INFO] [stdout] | __________________________________________^ [INFO] [stdout] 630 | | r#" [INFO] [stdout] 631 | | SELECT p.title [INFO] [stdout] 632 | | FROM posts p [INFO] [stdout] ... | [INFO] [stdout] 638 | | category_id [INFO] [stdout] 639 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:35:26 [INFO] [stdout] | [INFO] [stdout] 35 | let permission = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 36 | | Permission, [INFO] [stdout] 37 | | r#" [INFO] [stdout] 38 | | select id,name,description,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 42 | | permission_id [INFO] [stdout] 43 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:51:26 [INFO] [stdout] | [INFO] [stdout] 51 | let permission = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 52 | | Permission, [INFO] [stdout] 53 | | r#" [INFO] [stdout] 54 | | insert into permissions (id, name, description) [INFO] [stdout] ... | [INFO] [stdout] 60 | | payload.description [INFO] [stdout] 61 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:79:34 [INFO] [stdout] | [INFO] [stdout] 79 | let updated_permission = sqlx::query_as!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 80 | | Permission, [INFO] [stdout] 81 | | r#" [INFO] [stdout] 82 | | update permissions [INFO] [stdout] ... | [INFO] [stdout] 89 | | permission_id [INFO] [stdout] 90 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:51:20 [INFO] [stdout] | [INFO] [stdout] 51 | let role = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 52 | | Role, [INFO] [stdout] 53 | | r#" [INFO] [stdout] 54 | | insert into roles (id, name, description) VALUES ($1,$2,$3) [INFO] [stdout] ... | [INFO] [stdout] 59 | | description [INFO] [stdout] 60 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:97:22 [INFO] [stdout] | [INFO] [stdout] 97 | let result = sqlx::query!("DELETE FROM permissions WHERE id = $1", permission_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:69:20 [INFO] [stdout] | [INFO] [stdout] 69 | let role = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 70 | | Role, [INFO] [stdout] 71 | | r#" [INFO] [stdout] 72 | | select id,name,description,created_at,updated_at from roles where id = $1 [INFO] [stdout] 73 | | "#, [INFO] [stdout] 74 | | role_id [INFO] [stdout] 75 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:82:20 [INFO] [stdout] | [INFO] [stdout] 82 | let role = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 83 | | Role, [INFO] [stdout] 84 | | r#" [INFO] [stdout] 85 | | select id,name,description,created_at,updated_at from roles [INFO] [stdout] ... | [INFO] [stdout] 88 | | name [INFO] [stdout] 89 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/permission.rs:108:27 [INFO] [stdout] | [INFO] [stdout] 108 | let permissions = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 109 | | Permission, [INFO] [stdout] 110 | | r#" [INFO] [stdout] 111 | | select id,name,description,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 114 | | "# [INFO] [stdout] 115 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:113:22 [INFO] [stdout] | [INFO] [stdout] 113 | let _roles = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 114 | | r#" [INFO] [stdout] 115 | | insert into role_permissions (role_id, permission_id) [INFO] [stdout] 116 | | select $1,permission_id from unnest($2::uuid[]) as t(permission_id) [INFO] [stdout] ... | [INFO] [stdout] 120 | | permission_ids [INFO] [stdout] 121 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:130:27 [INFO] [stdout] | [INFO] [stdout] 130 | let permissions = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 131 | | Permission, [INFO] [stdout] 132 | | r#" [INFO] [stdout] 133 | | select p.id,p.name,p.description,p.created_at,p.updated_at [INFO] [stdout] ... | [INFO] [stdout] 138 | | role_id [INFO] [stdout] 139 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:148:9 [INFO] [stdout] | [INFO] [stdout] 148 | / sqlx::query_as!( [INFO] [stdout] 149 | | Role, [INFO] [stdout] 150 | | "select id,name,description,created_at,updated_at from roles order by name" [INFO] [stdout] 151 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:191:28 [INFO] [stdout] | [INFO] [stdout] 191 | let updated_role = sqlx::query_as!( [INFO] [stdout] | ____________________________^ [INFO] [stdout] 192 | | Role, [INFO] [stdout] 193 | | r#" [INFO] [stdout] 194 | | update roles [INFO] [stdout] ... | [INFO] [stdout] 201 | | role_id [INFO] [stdout] 202 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:209:22 [INFO] [stdout] | [INFO] [stdout] 209 | let result = sqlx::query!("delete from roles where id = $1", role_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:151:13 [INFO] [stdout] | [INFO] [stdout] 151 | sqlx::query!("delete from post_categories where post_id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:164:21 [INFO] [stdout] | [INFO] [stdout] 164 | / sqlx::query!( [INFO] [stdout] 165 | | "insert into post_categories (post_id, category_id) values ($1,$2) on conflict do nothing", [INFO] [stdout] 166 | | post_id, [INFO] [stdout] 167 | | category_id [INFO] [stdout] 168 | | ) [INFO] [stdout] | |_____________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:186:13 [INFO] [stdout] | [INFO] [stdout] 186 | sqlx::query!("delete from post_tags where post_id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:194:21 [INFO] [stdout] | [INFO] [stdout] 194 | / sqlx::query!( [INFO] [stdout] 195 | | "insert into post_tags (post_id, tag_id) values ($1,$2) on conflict do nothing", [INFO] [stdout] 196 | | post_id, [INFO] [stdout] 197 | | tag_id [INFO] [stdout] 198 | | ) [INFO] [stdout] | |_____________________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:134:19 [INFO] [stdout] | [INFO] [stdout] 134 | let tag = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 135 | | // sqlx::query_as! 宏在编译时检查 SQL 查询并映射结果到 Tag 结构体 [INFO] [stdout] 136 | | Tag, // 目标结构体 [INFO] [stdout] 137 | | r#" -- SQL查询语句,returning 子句返回插入的行 [INFO] [stdout] ... | [INFO] [stdout] 144 | | slug [INFO] [stdout] 145 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:154:19 [INFO] [stdout] | [INFO] [stdout] 154 | let tag = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 155 | | Tag, [INFO] [stdout] 156 | | r#" [INFO] [stdout] 157 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 161 | | id [INFO] [stdout] 162 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:171:19 [INFO] [stdout] | [INFO] [stdout] 171 | let tag = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 172 | | Tag, [INFO] [stdout] 173 | | r#" [INFO] [stdout] 174 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 178 | | slug [INFO] [stdout] 179 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:188:20 [INFO] [stdout] | [INFO] [stdout] 188 | let tags = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 189 | | Tag, [INFO] [stdout] 190 | | r#" [INFO] [stdout] 191 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 194 | | "# [INFO] [stdout] 195 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:224:27 [INFO] [stdout] | [INFO] [stdout] 224 | let updated_tag = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 225 | | Tag, [INFO] [stdout] 226 | | r#" [INFO] [stdout] 227 | | update tags [INFO] [stdout] ... | [INFO] [stdout] 234 | | id [INFO] [stdout] 235 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:244:22 [INFO] [stdout] | [INFO] [stdout] 244 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 245 | | r#" [INFO] [stdout] 246 | | delete from tags [INFO] [stdout] 247 | | where id = $1 [INFO] [stdout] 248 | | "#, [INFO] [stdout] 249 | | id [INFO] [stdout] 250 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:272:13 [INFO] [stdout] | [INFO] [stdout] 272 | / sqlx::query!( [INFO] [stdout] 273 | | r#" [INFO] [stdout] 274 | | UPDATE post_tags [INFO] [stdout] 275 | | SET tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 283 | | source_id [INFO] [stdout] 284 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:290:13 [INFO] [stdout] | [INFO] [stdout] 290 | sqlx::query!("DELETE FROM post_tags WHERE tag_id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:298:13 [INFO] [stdout] | [INFO] [stdout] 298 | sqlx::query!("DELETE FROM tags WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:326:34 [INFO] [stdout] | [INFO] [stdout] 326 | let affected_posts = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 327 | | "SELECT COUNT(DISTINCT post_id) as count FROM post_tags WHERE tag_id = $1", [INFO] [stdout] 328 | | source_id [INFO] [stdout] 329 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:335:30 [INFO] [stdout] | [INFO] [stdout] 335 | let duplicates = sqlx::query!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 336 | | r#" [INFO] [stdout] 337 | | SELECT COUNT(*) as count FROM post_tags pt1 [INFO] [stdout] 338 | | WHERE pt1.tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 345 | | target_tag_id [INFO] [stdout] 346 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:355:32 [INFO] [stdout] | [INFO] [stdout] 355 | let source_posts = sqlx::query!( [INFO] [stdout] | ________________________________^ [INFO] [stdout] 356 | | "SELECT COUNT(*) as count FROM post_tags WHERE tag_id = $1", [INFO] [stdout] 357 | | source_id [INFO] [stdout] 358 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:364:36 [INFO] [stdout] | [INFO] [stdout] 364 | let transferred_rows = sqlx::query!( [INFO] [stdout] | ____________________________________^ [INFO] [stdout] 365 | | r#" [INFO] [stdout] 366 | | UPDATE post_tags [INFO] [stdout] 367 | | SET tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 375 | | source_id [INFO] [stdout] 376 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:381:32 [INFO] [stdout] | [INFO] [stdout] 381 | let deleted_rows = sqlx::query!("DELETE FROM post_tags WHERE tag_id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:400:13 [INFO] [stdout] | [INFO] [stdout] 400 | / sqlx::query!( [INFO] [stdout] 401 | | "UPDATE tags SET name = $1, slug = $2 WHERE id = $3", [INFO] [stdout] 402 | | new_name, [INFO] [stdout] 403 | | new_slug, [INFO] [stdout] 404 | | target_tag_id [INFO] [stdout] 405 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:412:13 [INFO] [stdout] | [INFO] [stdout] 412 | sqlx::query!("DELETE FROM tags WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:455:30 [INFO] [stdout] | [INFO] [stdout] 455 | let duplicates = sqlx::query!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 456 | | r#" [INFO] [stdout] 457 | | SELECT COUNT(*) as count FROM post_tags pt1 [INFO] [stdout] 458 | | WHERE pt1.tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 465 | | target_tag_id [INFO] [stdout] 466 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:482:26 [INFO] [stdout] | [INFO] [stdout] 482 | let result = sqlx::query!("DELETE FROM tags WHERE id = $1", tag_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:519:13 [INFO] [stdout] | [INFO] [stdout] 519 | sqlx::query!("DELETE FROM post_tags WHERE tag_id = $1", tag_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:526:34 [INFO] [stdout] | [INFO] [stdout] 526 | let orphaned_count = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 527 | | r#" [INFO] [stdout] 528 | | SELECT COUNT(*) as count FROM posts p [INFO] [stdout] 529 | | WHERE NOT EXISTS (SELECT 1 FROM post_tags pt WHERE pt.post_id = p.id) [INFO] [stdout] 530 | | "# [INFO] [stdout] 531 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:542:26 [INFO] [stdout] | [INFO] [stdout] 542 | let result = sqlx::query!("DELETE FROM tags WHERE id = $1", tag_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:555:21 [INFO] [stdout] | [INFO] [stdout] 555 | let stats = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 556 | | r#" [INFO] [stdout] 557 | | SELECT [INFO] [stdout] 558 | | t.id, t.name, t.slug, t.created_at, t.updated_at, [INFO] [stdout] ... | [INFO] [stdout] 564 | | "# [INFO] [stdout] 565 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:614:26 [INFO] [stdout] | [INFO] [stdout] 614 | let post_count = sqlx::query!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 615 | | "SELECT COUNT(*) as count FROM post_tags WHERE tag_id = $1", [INFO] [stdout] 616 | | tag_id [INFO] [stdout] 617 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:622:29 [INFO] [stdout] | [INFO] [stdout] 622 | let sample_titles = sqlx::query!( [INFO] [stdout] | _____________________________^ [INFO] [stdout] 623 | | r#" [INFO] [stdout] 624 | | SELECT p.title [INFO] [stdout] 625 | | FROM posts p [INFO] [stdout] ... | [INFO] [stdout] 631 | | tag_id [INFO] [stdout] 632 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:228:20 [INFO] [stdout] | [INFO] [stdout] 228 | ... let post = sqlx::query_as!( [INFO] [stdout] | __________________^ [INFO] [stdout] 229 | | ... Post, [INFO] [stdout] 230 | | ... r#" [INFO] [stdout] 231 | | ... insert into posts (id,slug,title,content,created_at,updated_at,published_at,author_id,draft_shared_with,is_draft_public... [INFO] [stdout] ... | [INFO] [stdout] 245 | | ... false // 默认不封禁 [INFO] [stdout] 246 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:273:20 [INFO] [stdout] | [INFO] [stdout] 273 | ... let post = sqlx::query_as!( [INFO] [stdout] | __________________^ [INFO] [stdout] 274 | | ... Post, [INFO] [stdout] 275 | | ... r#" [INFO] [stdout] 276 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] 277 | | ... "#, [INFO] [stdout] 278 | | ... id [INFO] [stdout] 279 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:287:20 [INFO] [stdout] | [INFO] [stdout] 287 | ... let post = sqlx::query_as!( [INFO] [stdout] | __________________^ [INFO] [stdout] 288 | | ... Post, [INFO] [stdout] 289 | | ... r#" [INFO] [stdout] 290 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 294 | | ... slug [INFO] [stdout] 295 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:304:21 [INFO] [stdout] | [INFO] [stdout] 304 | ... let posts = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 305 | | ... Post, [INFO] [stdout] 306 | | ... r#" [INFO] [stdout] 307 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at,author_id,draft... [INFO] [stdout] ... | [INFO] [stdout] 314 | | ... offset [INFO] [stdout] 315 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:347:21 [INFO] [stdout] | [INFO] [stdout] 347 | ... let posts = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 348 | | ... Post, [INFO] [stdout] 349 | | ... r#" [INFO] [stdout] 350 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at, author_id,draf... [INFO] [stdout] ... | [INFO] [stdout] 359 | | ... offset [INFO] [stdout] 360 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:366:34 [INFO] [stdout] | [INFO] [stdout] 366 | let total_count_result = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 367 | | r#" [INFO] [stdout] 368 | | select count(*) as "count!" from posts [INFO] [stdout] 369 | | WHERE author_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 372 | | author_id [INFO] [stdout] 373 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:392:13 [INFO] [stdout] | [INFO] [stdout] 392 | / ... sqlx::query_as!( [INFO] [stdout] 393 | | ... Post, [INFO] [stdout] 394 | | ... r#" [INFO] [stdout] 395 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at, author_id,draf... [INFO] [stdout] ... | [INFO] [stdout] 402 | | ... offset [INFO] [stdout] 403 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:409:13 [INFO] [stdout] | [INFO] [stdout] 409 | / ... sqlx::query_as!( [INFO] [stdout] 410 | | ... Post, [INFO] [stdout] 411 | | ... r#" [INFO] [stdout] 412 | | ... SELECT id, slug, title, content, created_at AS "created_at!", updated_at AS "updated_at!", published_at, author_id,draf... [INFO] [stdout] ... | [INFO] [stdout] 419 | | ... offset [INFO] [stdout] 420 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:428:13 [INFO] [stdout] | [INFO] [stdout] 428 | / sqlx::query_scalar!( [INFO] [stdout] 429 | | r#" [INFO] [stdout] 430 | | select count(*) from posts [INFO] [stdout] 431 | | WHERE published_at IS NOT NULL AND published_at <= NOW() [INFO] [stdout] 432 | | "# [INFO] [stdout] 433 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:438:13 [INFO] [stdout] | [INFO] [stdout] 438 | / sqlx::query_scalar!( [INFO] [stdout] 439 | | r#" [INFO] [stdout] 440 | | select count(*) from posts [INFO] [stdout] 441 | | WHERE published_at IS NOT NULL AND published_at <= NOW() AND (is_banned = false OR is_banned IS NULL) [INFO] [stdout] 442 | | "# [INFO] [stdout] 443 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_scalar` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:456:13 [INFO] [stdout] | [INFO] [stdout] 456 | / ... sqlx::query_as!( [INFO] [stdout] 457 | | ... Post, [INFO] [stdout] 458 | | ... r#" [INFO] [stdout] 459 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 463 | | ... id [INFO] [stdout] 464 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:469:13 [INFO] [stdout] | [INFO] [stdout] 469 | / ... sqlx::query_as!( [INFO] [stdout] 470 | | ... Post, [INFO] [stdout] 471 | | ... r#" [INFO] [stdout] 472 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 476 | | ... id [INFO] [stdout] 477 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:491:13 [INFO] [stdout] | [INFO] [stdout] 491 | / ... sqlx::query_as!( [INFO] [stdout] 492 | | ... Post, [INFO] [stdout] 493 | | ... r#" [INFO] [stdout] 494 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 498 | | ... slug [INFO] [stdout] 499 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:504:13 [INFO] [stdout] | [INFO] [stdout] 504 | / ... sqlx::query_as!( [INFO] [stdout] 505 | | ... Post, [INFO] [stdout] 506 | | ... r#" [INFO] [stdout] 507 | | ... select id,slug,title,content,created_at as "created_at!",updated_at as "updated_at!",published_at,author_id,draft_share... [INFO] [stdout] ... | [INFO] [stdout] 511 | | ... slug [INFO] [stdout] 512 | | ... ) [INFO] [stdout] | |_______^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:577:36 [INFO] [stdout] | [INFO] [stdout] 577 | let updated_post_from_db = sqlx::query_as!( [INFO] [stdout] | ____________________________________^ [INFO] [stdout] 578 | | Post, [INFO] [stdout] 579 | | r#" [INFO] [stdout] 580 | | update posts [INFO] [stdout] ... | [INFO] [stdout] 592 | | id [INFO] [stdout] 593 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:645:26 [INFO] [stdout] | [INFO] [stdout] 645 | let categories = sqlx::query_as!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 646 | | CategoryDto, [INFO] [stdout] 647 | | r#" [INFO] [stdout] 648 | | select c.id,c.name,c.slug [INFO] [stdout] ... | [INFO] [stdout] 654 | | post_id [INFO] [stdout] 655 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:664:20 [INFO] [stdout] | [INFO] [stdout] 664 | let tags = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 665 | | TagDto, [INFO] [stdout] 666 | | r#" [INFO] [stdout] 667 | | select t.id,t.name,t.slug [INFO] [stdout] ... | [INFO] [stdout] 673 | | post_id [INFO] [stdout] 674 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:683:22 [INFO] [stdout] | [INFO] [stdout] 683 | let result = sqlx::query!("select author_id from posts where id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:696:22 [INFO] [stdout] | [INFO] [stdout] 696 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 697 | | "UPDATE posts SET published_at = $1, updated_at = $1 WHERE id = $2", [INFO] [stdout] 698 | | now, [INFO] [stdout] 699 | | id [INFO] [stdout] 700 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:716:22 [INFO] [stdout] | [INFO] [stdout] 716 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 717 | | "UPDATE posts SET published_at = NULL, updated_at = $1 WHERE id = $2", [INFO] [stdout] 718 | | now, [INFO] [stdout] 719 | | id [INFO] [stdout] 720 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:735:22 [INFO] [stdout] | [INFO] [stdout] 735 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 736 | | r#" [INFO] [stdout] 737 | | SELECT [INFO] [stdout] 738 | | author_id, [INFO] [stdout] ... | [INFO] [stdout] 745 | | post_id [INFO] [stdout] 746 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:789:22 [INFO] [stdout] | [INFO] [stdout] 789 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 790 | | r#" [INFO] [stdout] 791 | | UPDATE posts [INFO] [stdout] 792 | | SET [INFO] [stdout] ... | [INFO] [stdout] 801 | | post_id [INFO] [stdout] 802 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:830:21 [INFO] [stdout] | [INFO] [stdout] 830 | let posts = sqlx::query_as!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 831 | | Post, [INFO] [stdout] 832 | | r#" [INFO] [stdout] 833 | | SELECT [INFO] [stdout] ... | [INFO] [stdout] 848 | | offset [INFO] [stdout] 849 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:855:21 [INFO] [stdout] | [INFO] [stdout] 855 | let total = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 856 | | r#" [INFO] [stdout] 857 | | SELECT COUNT(*) as count [INFO] [stdout] 858 | | FROM posts [INFO] [stdout] ... | [INFO] [stdout] 866 | | user_id [INFO] [stdout] 867 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:883:9 [INFO] [stdout] | [INFO] [stdout] 883 | / sqlx::query!( [INFO] [stdout] 884 | | r#" [INFO] [stdout] 885 | | INSERT INTO draft_access_logs (post_id, accessed_by, access_type, access_reason) [INFO] [stdout] 886 | | VALUES ($1, $2, $3, $4) [INFO] [stdout] ... | [INFO] [stdout] 891 | | reason [INFO] [stdout] 892 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:915:13 [INFO] [stdout] | [INFO] [stdout] 915 | / sqlx::query_as!( [INFO] [stdout] 916 | | DraftAccessLogDto, [INFO] [stdout] 917 | | r#" [INFO] [stdout] 918 | | SELECT [INFO] [stdout] ... | [INFO] [stdout] 936 | | offset [INFO] [stdout] 937 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:943:13 [INFO] [stdout] | [INFO] [stdout] 943 | / sqlx::query_as!( [INFO] [stdout] 944 | | DraftAccessLogDto, [INFO] [stdout] 945 | | r#" [INFO] [stdout] 946 | | SELECT [INFO] [stdout] ... | [INFO] [stdout] 962 | | offset [INFO] [stdout] 963 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:974:22 [INFO] [stdout] | [INFO] [stdout] 974 | let result = sqlx::query!("SELECT published_at FROM posts WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1003:21 [INFO] [stdout] | [INFO] [stdout] 1003 | let posts = sqlx::query_as!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 1004 | | Post, [INFO] [stdout] 1005 | | r#" [INFO] [stdout] 1006 | | SELECT DISTINCT [INFO] [stdout] ... | [INFO] [stdout] 1020 | | offset [INFO] [stdout] 1021 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1027:34 [INFO] [stdout] | [INFO] [stdout] 1027 | let total_count_result = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 1028 | | r#" [INFO] [stdout] 1029 | | SELECT COUNT(DISTINCT id) as "count!" [INFO] [stdout] 1030 | | FROM posts [INFO] [stdout] ... | [INFO] [stdout] 1037 | | user_id [INFO] [stdout] 1038 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1050:9 [INFO] [stdout] | [INFO] [stdout] 1050 | sqlx::query!("UPDATE posts SET is_banned = true WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1061:9 [INFO] [stdout] | [INFO] [stdout] 1061 | sqlx::query!("UPDATE posts SET is_banned = false WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/post.rs:1072:22 [INFO] [stdout] | [INFO] [stdout] 1072 | let result = sqlx::query!("SELECT is_banned FROM posts WHERE id = $1", post_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:51:20 [INFO] [stdout] | [INFO] [stdout] 51 | let role = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 52 | | Role, [INFO] [stdout] 53 | | r#" [INFO] [stdout] 54 | | insert into roles (id, name, description) VALUES ($1,$2,$3) [INFO] [stdout] ... | [INFO] [stdout] 59 | | description [INFO] [stdout] 60 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:69:20 [INFO] [stdout] | [INFO] [stdout] 69 | let role = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 70 | | Role, [INFO] [stdout] 71 | | r#" [INFO] [stdout] 72 | | select id,name,description,created_at,updated_at from roles where id = $1 [INFO] [stdout] 73 | | "#, [INFO] [stdout] 74 | | role_id [INFO] [stdout] 75 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:82:20 [INFO] [stdout] | [INFO] [stdout] 82 | let role = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 83 | | Role, [INFO] [stdout] 84 | | r#" [INFO] [stdout] 85 | | select id,name,description,created_at,updated_at from roles [INFO] [stdout] ... | [INFO] [stdout] 88 | | name [INFO] [stdout] 89 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:113:22 [INFO] [stdout] | [INFO] [stdout] 113 | let _roles = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 114 | | r#" [INFO] [stdout] 115 | | insert into role_permissions (role_id, permission_id) [INFO] [stdout] 116 | | select $1,permission_id from unnest($2::uuid[]) as t(permission_id) [INFO] [stdout] ... | [INFO] [stdout] 120 | | permission_ids [INFO] [stdout] 121 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:130:27 [INFO] [stdout] | [INFO] [stdout] 130 | let permissions = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 131 | | Permission, [INFO] [stdout] 132 | | r#" [INFO] [stdout] 133 | | select p.id,p.name,p.description,p.created_at,p.updated_at [INFO] [stdout] ... | [INFO] [stdout] 138 | | role_id [INFO] [stdout] 139 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:148:9 [INFO] [stdout] | [INFO] [stdout] 148 | / sqlx::query_as!( [INFO] [stdout] 149 | | Role, [INFO] [stdout] 150 | | "select id,name,description,created_at,updated_at from roles order by name" [INFO] [stdout] 151 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:191:28 [INFO] [stdout] | [INFO] [stdout] 191 | let updated_role = sqlx::query_as!( [INFO] [stdout] | ____________________________^ [INFO] [stdout] 192 | | Role, [INFO] [stdout] 193 | | r#" [INFO] [stdout] 194 | | update roles [INFO] [stdout] ... | [INFO] [stdout] 201 | | role_id [INFO] [stdout] 202 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/role.rs:209:22 [INFO] [stdout] | [INFO] [stdout] 209 | let result = sqlx::query!("delete from roles where id = $1", role_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:122:20 [INFO] [stdout] | [INFO] [stdout] 122 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 123 | | User, [INFO] [stdout] 124 | | r#" [INFO] [stdout] 125 | | insert into users (id, username, email, hashed_password) [INFO] [stdout] ... | [INFO] [stdout] 132 | | hashed_password [INFO] [stdout] 133 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:148:20 [INFO] [stdout] | [INFO] [stdout] 148 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 149 | | User, [INFO] [stdout] 150 | | r#" [INFO] [stdout] 151 | | insert into users (id, username, email, hashed_password) [INFO] [stdout] ... | [INFO] [stdout] 158 | | hashed_password [INFO] [stdout] 159 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:168:20 [INFO] [stdout] | [INFO] [stdout] 168 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 169 | | User, [INFO] [stdout] 170 | | r#" [INFO] [stdout] 171 | | select id,username,email,hashed_password,created_at,updated_at,email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 175 | | username [INFO] [stdout] 176 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:185:20 [INFO] [stdout] | [INFO] [stdout] 185 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 186 | | User, [INFO] [stdout] 187 | | r#" [INFO] [stdout] 188 | | select id,username,email,hashed_password,created_at,updated_at,email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 192 | | email [INFO] [stdout] 193 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:202:20 [INFO] [stdout] | [INFO] [stdout] 202 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 203 | | User, [INFO] [stdout] 204 | | r#" [INFO] [stdout] 205 | | select id,username,email,hashed_password,created_at,updated_at,email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 209 | | user_id [INFO] [stdout] 210 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:222:9 [INFO] [stdout] | [INFO] [stdout] 222 | / sqlx::query!( [INFO] [stdout] 223 | | r#"insert into user_roles (user_id, role_id) [INFO] [stdout] 224 | | select $1,role_id from unnest($2::uuid[]) as t(role_id) [INFO] [stdout] 225 | | on conflict (user_id,role_id) do nothing [INFO] [stdout] ... | [INFO] [stdout] 228 | | role_ids, [INFO] [stdout] 229 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:245:9 [INFO] [stdout] | [INFO] [stdout] 245 | / sqlx::query!( [INFO] [stdout] 246 | | r#"insert into user_roles (user_id, role_id) [INFO] [stdout] 247 | | select $1,role_id from unnest($2::uuid[]) as t(role_id) [INFO] [stdout] 248 | | on conflict (user_id,role_id) do nothing [INFO] [stdout] ... | [INFO] [stdout] 251 | | role_ids, [INFO] [stdout] 252 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:260:9 [INFO] [stdout] | [INFO] [stdout] 260 | / sqlx::query!( [INFO] [stdout] 261 | | "delete from user_roles where user_id = $1 and role_id = $2", [INFO] [stdout] 262 | | user_id, [INFO] [stdout] 263 | | role_id [INFO] [stdout] 264 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:276:9 [INFO] [stdout] | [INFO] [stdout] 276 | sqlx::query!("delete from user_roles where user_id = $1", user_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:283:13 [INFO] [stdout] | [INFO] [stdout] 283 | / sqlx::query!( [INFO] [stdout] 284 | | r#" [INFO] [stdout] 285 | | insert into user_roles (user_id, role_id) [INFO] [stdout] 286 | | select $1,role_id from unnest($2::uuid[]) as t(role_id) [INFO] [stdout] ... | [INFO] [stdout] 289 | | role_ids [INFO] [stdout] 290 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:303:21 [INFO] [stdout] | [INFO] [stdout] 303 | let roles = sqlx::query_as!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 304 | | Role, [INFO] [stdout] 305 | | r#" [INFO] [stdout] 306 | | select r.id,r.name,r.description,r.created_at,r.updated_at [INFO] [stdout] ... | [INFO] [stdout] 312 | | user_id [INFO] [stdout] 313 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:322:27 [INFO] [stdout] | [INFO] [stdout] 322 | let permissions = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 323 | | Permission, [INFO] [stdout] 324 | | r#" [INFO] [stdout] 325 | | select distinct p.id,p.name,p.description,p.created_at,p.updated_at [INFO] [stdout] ... | [INFO] [stdout] 332 | | user_id [INFO] [stdout] 333 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:347:9 [INFO] [stdout] | [INFO] [stdout] 347 | / sqlx::query!( [INFO] [stdout] 348 | | "insert into refresh_tokens (token_hash, user_id, expires_at) VALUES ($1,$2,$3)", [INFO] [stdout] 349 | | token_hash, [INFO] [stdout] 350 | | user_id, [INFO] [stdout] 351 | | expires_at [INFO] [stdout] 352 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:362:20 [INFO] [stdout] | [INFO] [stdout] 362 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 363 | | User, [INFO] [stdout] 364 | | r#" [INFO] [stdout] 365 | | select u.id,u.username,u.email,u.hashed_password,u.created_at,u.updated_at,u.email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 370 | | token_hash [INFO] [stdout] 371 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:379:22 [INFO] [stdout] | [INFO] [stdout] 379 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 380 | | "delete from refresh_tokens where token_hash = $1", [INFO] [stdout] 381 | | token_hash [INFO] [stdout] 382 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:396:9 [INFO] [stdout] | [INFO] [stdout] 396 | / sqlx::query_as!( [INFO] [stdout] 397 | | User, [INFO] [stdout] 398 | | r#" [INFO] [stdout] 399 | | select id,username,email,hashed_password, created_at,updated_at,email_verified_at [INFO] [stdout] 400 | | from users order by username [INFO] [stdout] 401 | | "# [INFO] [stdout] 402 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:409:31 [INFO] [stdout] | [INFO] [stdout] 409 | let user_with_roles = sqlx::query_as!( [INFO] [stdout] | _______________________________^ [INFO] [stdout] 410 | | UserPublic, [INFO] [stdout] 411 | | r#" [INFO] [stdout] 412 | | select [INFO] [stdout] ... | [INFO] [stdout] 433 | | "#, [INFO] [stdout] 434 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:454:28 [INFO] [stdout] | [INFO] [stdout] 454 | let updated_user = sqlx::query_as!( [INFO] [stdout] | ____________________________^ [INFO] [stdout] 455 | | User, [INFO] [stdout] 456 | | r#" [INFO] [stdout] 457 | | update users [INFO] [stdout] ... | [INFO] [stdout] 464 | | user_id, [INFO] [stdout] 465 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:475:22 [INFO] [stdout] | [INFO] [stdout] 475 | let result = sqlx::query!("DELETE FROM users WHERE id = $1", user_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:489:9 [INFO] [stdout] | [INFO] [stdout] 489 | / sqlx::query!( [INFO] [stdout] 490 | | "UPDATE users SET hashed_password = $1, updated_at = NOW() WHERE id = $2", [INFO] [stdout] 491 | | new_hashed_password, [INFO] [stdout] 492 | | user_id [INFO] [stdout] 493 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:501:9 [INFO] [stdout] | [INFO] [stdout] 501 | sqlx::query!("DELETE FROM refresh_tokens WHERE user_id = $1", user_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:508:9 [INFO] [stdout] | [INFO] [stdout] 508 | / sqlx::query!( [INFO] [stdout] 509 | | "update users set email_verified_at = now() where id = $1", [INFO] [stdout] 510 | | user_id [INFO] [stdout] 511 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:532:20 [INFO] [stdout] | [INFO] [stdout] 532 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 533 | | User, [INFO] [stdout] 534 | | r#" [INFO] [stdout] 535 | | INSERT INTO users (id, username, email, hashed_password, email_verified_at) [INFO] [stdout] ... | [INFO] [stdout] 543 | | email_verified_at [INFO] [stdout] 544 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:554:21 [INFO] [stdout] | [INFO] [stdout] 554 | let stats = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 555 | | r#" [INFO] [stdout] 556 | | SELECT [INFO] [stdout] 557 | | COUNT(*) as total, [INFO] [stdout] ... | [INFO] [stdout] 561 | | "# [INFO] [stdout] 562 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:568:26 [INFO] [stdout] | [INFO] [stdout] 568 | let role_stats = sqlx::query!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 569 | | r#" [INFO] [stdout] 570 | | SELECT [INFO] [stdout] 571 | | r.name as role_name, [INFO] [stdout] ... | [INFO] [stdout] 577 | | "# [INFO] [stdout] 578 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:600:22 [INFO] [stdout] | [INFO] [stdout] 600 | let result = sqlx::query!("SELECT COUNT(*) as count FROM posts") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:610:13 [INFO] [stdout] | [INFO] [stdout] 610 | sqlx::query!("SELECT COUNT(*) as count FROM posts WHERE published_at IS NOT NULL") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:619:22 [INFO] [stdout] | [INFO] [stdout] 619 | let result = sqlx::query!("SELECT COUNT(*) as count FROM posts WHERE published_at IS NULL") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:628:22 [INFO] [stdout] | [INFO] [stdout] 628 | let result = sqlx::query!("SELECT COUNT(*) as count FROM categories") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:637:22 [INFO] [stdout] | [INFO] [stdout] 637 | let result = sqlx::query!("SELECT COUNT(*) as count FROM tags") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:43:22 [INFO] [stdout] | [INFO] [stdout] 43 | let record = sqlx::query_as!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 44 | | LoginAttempt, [INFO] [stdout] 45 | | "select failure_count,lockout_expires_at from login_attempts where username = $1", [INFO] [stdout] 46 | | username [INFO] [stdout] 47 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:55:22 [INFO] [stdout] | [INFO] [stdout] 55 | let record = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 56 | | r#" [INFO] [stdout] 57 | | insert into login_attempts (username, failure_count) values ($1,1) [INFO] [stdout] 58 | | on conflict (username) do update [INFO] [stdout] ... | [INFO] [stdout] 62 | | username [INFO] [stdout] 63 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:71:9 [INFO] [stdout] | [INFO] [stdout] 71 | / sqlx::query!( [INFO] [stdout] 72 | | "update login_attempts set lockout_expires_at = $1 where username = $2", [INFO] [stdout] 73 | | expires_at, [INFO] [stdout] 74 | | username [INFO] [stdout] 75 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:82:9 [INFO] [stdout] | [INFO] [stdout] 82 | / sqlx::query!( [INFO] [stdout] 83 | | "delete from login_attempts where username = $1", [INFO] [stdout] 84 | | username [INFO] [stdout] 85 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:53:9 [INFO] [stdout] | [INFO] [stdout] 53 | / sqlx::query!( [INFO] [stdout] 54 | | "insert into one_time_tokens (token_hash, user_id, token_type, expires_at) values ($1,$2,$3,$4)", [INFO] [stdout] 55 | | token_hash, [INFO] [stdout] 56 | | user_id, [INFO] [stdout] 57 | | token_type, [INFO] [stdout] 58 | | expires_at [INFO] [stdout] 59 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:74:9 [INFO] [stdout] | [INFO] [stdout] 74 | / sqlx::query!( [INFO] [stdout] 75 | | "insert into one_time_tokens (token_hash, user_id, token_type, expires_at) values ($1,$2,$3,$4)", [INFO] [stdout] 76 | | token_hash, [INFO] [stdout] 77 | | user_id, [INFO] [stdout] 78 | | token_type, [INFO] [stdout] 79 | | expires_at [INFO] [stdout] 80 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:95:22 [INFO] [stdout] | [INFO] [stdout] 95 | let record = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 96 | | "select user_id from one_time_tokens where token_hash=$1 and token_type = $2 and expires_at > now()", [INFO] [stdout] 97 | | token_hash, [INFO] [stdout] 98 | | token_type [INFO] [stdout] 99 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:105:13 [INFO] [stdout] | [INFO] [stdout] 105 | / sqlx::query!( [INFO] [stdout] 106 | | "delete from one_time_tokens where token_hash = $1", [INFO] [stdout] 107 | | token_hash [INFO] [stdout] 108 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:134:19 [INFO] [stdout] | [INFO] [stdout] 134 | let tag = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 135 | | // sqlx::query_as! 宏在编译时检查 SQL 查询并映射结果到 Tag 结构体 [INFO] [stdout] 136 | | Tag, // 目标结构体 [INFO] [stdout] 137 | | r#" -- SQL查询语句,returning 子句返回插入的行 [INFO] [stdout] ... | [INFO] [stdout] 144 | | slug [INFO] [stdout] 145 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:154:19 [INFO] [stdout] | [INFO] [stdout] 154 | let tag = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 155 | | Tag, [INFO] [stdout] 156 | | r#" [INFO] [stdout] 157 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 161 | | id [INFO] [stdout] 162 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:171:19 [INFO] [stdout] | [INFO] [stdout] 171 | let tag = sqlx::query_as!( [INFO] [stdout] | ___________________^ [INFO] [stdout] 172 | | Tag, [INFO] [stdout] 173 | | r#" [INFO] [stdout] 174 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 178 | | slug [INFO] [stdout] 179 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:188:20 [INFO] [stdout] | [INFO] [stdout] 188 | let tags = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 189 | | Tag, [INFO] [stdout] 190 | | r#" [INFO] [stdout] 191 | | select id,name,slug,created_at,updated_at [INFO] [stdout] ... | [INFO] [stdout] 194 | | "# [INFO] [stdout] 195 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:224:27 [INFO] [stdout] | [INFO] [stdout] 224 | let updated_tag = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 225 | | Tag, [INFO] [stdout] 226 | | r#" [INFO] [stdout] 227 | | update tags [INFO] [stdout] ... | [INFO] [stdout] 234 | | id [INFO] [stdout] 235 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:244:22 [INFO] [stdout] | [INFO] [stdout] 244 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 245 | | r#" [INFO] [stdout] 246 | | delete from tags [INFO] [stdout] 247 | | where id = $1 [INFO] [stdout] 248 | | "#, [INFO] [stdout] 249 | | id [INFO] [stdout] 250 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:272:13 [INFO] [stdout] | [INFO] [stdout] 272 | / sqlx::query!( [INFO] [stdout] 273 | | r#" [INFO] [stdout] 274 | | UPDATE post_tags [INFO] [stdout] 275 | | SET tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 283 | | source_id [INFO] [stdout] 284 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:290:13 [INFO] [stdout] | [INFO] [stdout] 290 | sqlx::query!("DELETE FROM post_tags WHERE tag_id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:298:13 [INFO] [stdout] | [INFO] [stdout] 298 | sqlx::query!("DELETE FROM tags WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:326:34 [INFO] [stdout] | [INFO] [stdout] 326 | let affected_posts = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 327 | | "SELECT COUNT(DISTINCT post_id) as count FROM post_tags WHERE tag_id = $1", [INFO] [stdout] 328 | | source_id [INFO] [stdout] 329 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:335:30 [INFO] [stdout] | [INFO] [stdout] 335 | let duplicates = sqlx::query!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 336 | | r#" [INFO] [stdout] 337 | | SELECT COUNT(*) as count FROM post_tags pt1 [INFO] [stdout] 338 | | WHERE pt1.tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 345 | | target_tag_id [INFO] [stdout] 346 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:355:32 [INFO] [stdout] | [INFO] [stdout] 355 | let source_posts = sqlx::query!( [INFO] [stdout] | ________________________________^ [INFO] [stdout] 356 | | "SELECT COUNT(*) as count FROM post_tags WHERE tag_id = $1", [INFO] [stdout] 357 | | source_id [INFO] [stdout] 358 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:364:36 [INFO] [stdout] | [INFO] [stdout] 364 | let transferred_rows = sqlx::query!( [INFO] [stdout] | ____________________________________^ [INFO] [stdout] 365 | | r#" [INFO] [stdout] 366 | | UPDATE post_tags [INFO] [stdout] 367 | | SET tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 375 | | source_id [INFO] [stdout] 376 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:381:32 [INFO] [stdout] | [INFO] [stdout] 381 | let deleted_rows = sqlx::query!("DELETE FROM post_tags WHERE tag_id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:400:13 [INFO] [stdout] | [INFO] [stdout] 400 | / sqlx::query!( [INFO] [stdout] 401 | | "UPDATE tags SET name = $1, slug = $2 WHERE id = $3", [INFO] [stdout] 402 | | new_name, [INFO] [stdout] 403 | | new_slug, [INFO] [stdout] 404 | | target_tag_id [INFO] [stdout] 405 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:412:13 [INFO] [stdout] | [INFO] [stdout] 412 | sqlx::query!("DELETE FROM tags WHERE id = $1", source_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:455:30 [INFO] [stdout] | [INFO] [stdout] 455 | let duplicates = sqlx::query!( [INFO] [stdout] | ______________________________^ [INFO] [stdout] 456 | | r#" [INFO] [stdout] 457 | | SELECT COUNT(*) as count FROM post_tags pt1 [INFO] [stdout] 458 | | WHERE pt1.tag_id = $1 [INFO] [stdout] ... | [INFO] [stdout] 465 | | target_tag_id [INFO] [stdout] 466 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:482:26 [INFO] [stdout] | [INFO] [stdout] 482 | let result = sqlx::query!("DELETE FROM tags WHERE id = $1", tag_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:519:13 [INFO] [stdout] | [INFO] [stdout] 519 | sqlx::query!("DELETE FROM post_tags WHERE tag_id = $1", tag_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:526:34 [INFO] [stdout] | [INFO] [stdout] 526 | let orphaned_count = sqlx::query!( [INFO] [stdout] | __________________________________^ [INFO] [stdout] 527 | | r#" [INFO] [stdout] 528 | | SELECT COUNT(*) as count FROM posts p [INFO] [stdout] 529 | | WHERE NOT EXISTS (SELECT 1 FROM post_tags pt WHERE pt.post_id = p.id) [INFO] [stdout] 530 | | "# [INFO] [stdout] 531 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:542:26 [INFO] [stdout] | [INFO] [stdout] 542 | let result = sqlx::query!("DELETE FROM tags WHERE id = $1", tag_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:555:21 [INFO] [stdout] | [INFO] [stdout] 555 | let stats = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 556 | | r#" [INFO] [stdout] 557 | | SELECT [INFO] [stdout] 558 | | t.id, t.name, t.slug, t.created_at, t.updated_at, [INFO] [stdout] ... | [INFO] [stdout] 564 | | "# [INFO] [stdout] 565 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:614:26 [INFO] [stdout] | [INFO] [stdout] 614 | let post_count = sqlx::query!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 615 | | "SELECT COUNT(*) as count FROM post_tags WHERE tag_id = $1", [INFO] [stdout] 616 | | tag_id [INFO] [stdout] 617 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/tag.rs:622:29 [INFO] [stdout] | [INFO] [stdout] 622 | let sample_titles = sqlx::query!( [INFO] [stdout] | _____________________________^ [INFO] [stdout] 623 | | r#" [INFO] [stdout] 624 | | SELECT p.title [INFO] [stdout] 625 | | FROM posts p [INFO] [stdout] ... | [INFO] [stdout] 631 | | tag_id [INFO] [stdout] 632 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/services/user.rs:326:33 [INFO] [stdout] | [INFO] [stdout] 326 | let user_posts_result = sqlx::query!( [INFO] [stdout] | _________________________________^ [INFO] [stdout] 327 | | "SELECT [INFO] [stdout] 328 | | COUNT(*) as total_posts, [INFO] [stdout] 329 | | COUNT(CASE WHEN published_at IS NOT NULL THEN 1 END) as published_posts, [INFO] [stdout] ... | [INFO] [stdout] 332 | | user_id [INFO] [stdout] 333 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/services/user.rs:338:33 [INFO] [stdout] | [INFO] [stdout] 338 | let categories_result = sqlx::query!("SELECT COUNT(*) as count FROM categories") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/services/user.rs:342:27 [INFO] [stdout] | [INFO] [stdout] 342 | let tags_result = sqlx::query!("SELECT COUNT(*) as count FROM tags") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:122:20 [INFO] [stdout] | [INFO] [stdout] 122 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 123 | | User, [INFO] [stdout] 124 | | r#" [INFO] [stdout] 125 | | insert into users (id, username, email, hashed_password) [INFO] [stdout] ... | [INFO] [stdout] 132 | | hashed_password [INFO] [stdout] 133 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:148:20 [INFO] [stdout] | [INFO] [stdout] 148 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 149 | | User, [INFO] [stdout] 150 | | r#" [INFO] [stdout] 151 | | insert into users (id, username, email, hashed_password) [INFO] [stdout] ... | [INFO] [stdout] 158 | | hashed_password [INFO] [stdout] 159 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:168:20 [INFO] [stdout] | [INFO] [stdout] 168 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 169 | | User, [INFO] [stdout] 170 | | r#" [INFO] [stdout] 171 | | select id,username,email,hashed_password,created_at,updated_at,email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 175 | | username [INFO] [stdout] 176 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:185:20 [INFO] [stdout] | [INFO] [stdout] 185 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 186 | | User, [INFO] [stdout] 187 | | r#" [INFO] [stdout] 188 | | select id,username,email,hashed_password,created_at,updated_at,email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 192 | | email [INFO] [stdout] 193 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:202:20 [INFO] [stdout] | [INFO] [stdout] 202 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 203 | | User, [INFO] [stdout] 204 | | r#" [INFO] [stdout] 205 | | select id,username,email,hashed_password,created_at,updated_at,email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 209 | | user_id [INFO] [stdout] 210 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:222:9 [INFO] [stdout] | [INFO] [stdout] 222 | / sqlx::query!( [INFO] [stdout] 223 | | r#"insert into user_roles (user_id, role_id) [INFO] [stdout] 224 | | select $1,role_id from unnest($2::uuid[]) as t(role_id) [INFO] [stdout] 225 | | on conflict (user_id,role_id) do nothing [INFO] [stdout] ... | [INFO] [stdout] 228 | | role_ids, [INFO] [stdout] 229 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:245:9 [INFO] [stdout] | [INFO] [stdout] 245 | / sqlx::query!( [INFO] [stdout] 246 | | r#"insert into user_roles (user_id, role_id) [INFO] [stdout] 247 | | select $1,role_id from unnest($2::uuid[]) as t(role_id) [INFO] [stdout] 248 | | on conflict (user_id,role_id) do nothing [INFO] [stdout] ... | [INFO] [stdout] 251 | | role_ids, [INFO] [stdout] 252 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:260:9 [INFO] [stdout] | [INFO] [stdout] 260 | / sqlx::query!( [INFO] [stdout] 261 | | "delete from user_roles where user_id = $1 and role_id = $2", [INFO] [stdout] 262 | | user_id, [INFO] [stdout] 263 | | role_id [INFO] [stdout] 264 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:276:9 [INFO] [stdout] | [INFO] [stdout] 276 | sqlx::query!("delete from user_roles where user_id = $1", user_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:283:13 [INFO] [stdout] | [INFO] [stdout] 283 | / sqlx::query!( [INFO] [stdout] 284 | | r#" [INFO] [stdout] 285 | | insert into user_roles (user_id, role_id) [INFO] [stdout] 286 | | select $1,role_id from unnest($2::uuid[]) as t(role_id) [INFO] [stdout] ... | [INFO] [stdout] 289 | | role_ids [INFO] [stdout] 290 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:303:21 [INFO] [stdout] | [INFO] [stdout] 303 | let roles = sqlx::query_as!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 304 | | Role, [INFO] [stdout] 305 | | r#" [INFO] [stdout] 306 | | select r.id,r.name,r.description,r.created_at,r.updated_at [INFO] [stdout] ... | [INFO] [stdout] 312 | | user_id [INFO] [stdout] 313 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:322:27 [INFO] [stdout] | [INFO] [stdout] 322 | let permissions = sqlx::query_as!( [INFO] [stdout] | ___________________________^ [INFO] [stdout] 323 | | Permission, [INFO] [stdout] 324 | | r#" [INFO] [stdout] 325 | | select distinct p.id,p.name,p.description,p.created_at,p.updated_at [INFO] [stdout] ... | [INFO] [stdout] 332 | | user_id [INFO] [stdout] 333 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:347:9 [INFO] [stdout] | [INFO] [stdout] 347 | / sqlx::query!( [INFO] [stdout] 348 | | "insert into refresh_tokens (token_hash, user_id, expires_at) VALUES ($1,$2,$3)", [INFO] [stdout] 349 | | token_hash, [INFO] [stdout] 350 | | user_id, [INFO] [stdout] 351 | | expires_at [INFO] [stdout] 352 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:362:20 [INFO] [stdout] | [INFO] [stdout] 362 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 363 | | User, [INFO] [stdout] 364 | | r#" [INFO] [stdout] 365 | | select u.id,u.username,u.email,u.hashed_password,u.created_at,u.updated_at,u.email_verified_at [INFO] [stdout] ... | [INFO] [stdout] 370 | | token_hash [INFO] [stdout] 371 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:379:22 [INFO] [stdout] | [INFO] [stdout] 379 | let result = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 380 | | "delete from refresh_tokens where token_hash = $1", [INFO] [stdout] 381 | | token_hash [INFO] [stdout] 382 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:396:9 [INFO] [stdout] | [INFO] [stdout] 396 | / sqlx::query_as!( [INFO] [stdout] 397 | | User, [INFO] [stdout] 398 | | r#" [INFO] [stdout] 399 | | select id,username,email,hashed_password, created_at,updated_at,email_verified_at [INFO] [stdout] 400 | | from users order by username [INFO] [stdout] 401 | | "# [INFO] [stdout] 402 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:409:31 [INFO] [stdout] | [INFO] [stdout] 409 | let user_with_roles = sqlx::query_as!( [INFO] [stdout] | _______________________________^ [INFO] [stdout] 410 | | UserPublic, [INFO] [stdout] 411 | | r#" [INFO] [stdout] 412 | | select [INFO] [stdout] ... | [INFO] [stdout] 433 | | "#, [INFO] [stdout] 434 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:454:28 [INFO] [stdout] | [INFO] [stdout] 454 | let updated_user = sqlx::query_as!( [INFO] [stdout] | ____________________________^ [INFO] [stdout] 455 | | User, [INFO] [stdout] 456 | | r#" [INFO] [stdout] 457 | | update users [INFO] [stdout] ... | [INFO] [stdout] 464 | | user_id, [INFO] [stdout] 465 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:475:22 [INFO] [stdout] | [INFO] [stdout] 475 | let result = sqlx::query!("DELETE FROM users WHERE id = $1", user_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:489:9 [INFO] [stdout] | [INFO] [stdout] 489 | / sqlx::query!( [INFO] [stdout] 490 | | "UPDATE users SET hashed_password = $1, updated_at = NOW() WHERE id = $2", [INFO] [stdout] 491 | | new_hashed_password, [INFO] [stdout] 492 | | user_id [INFO] [stdout] 493 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:501:9 [INFO] [stdout] | [INFO] [stdout] 501 | sqlx::query!("DELETE FROM refresh_tokens WHERE user_id = $1", user_id) [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:508:9 [INFO] [stdout] | [INFO] [stdout] 508 | / sqlx::query!( [INFO] [stdout] 509 | | "update users set email_verified_at = now() where id = $1", [INFO] [stdout] 510 | | user_id [INFO] [stdout] 511 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:532:20 [INFO] [stdout] | [INFO] [stdout] 532 | let user = sqlx::query_as!( [INFO] [stdout] | ____________________^ [INFO] [stdout] 533 | | User, [INFO] [stdout] 534 | | r#" [INFO] [stdout] 535 | | INSERT INTO users (id, username, email, hashed_password, email_verified_at) [INFO] [stdout] ... | [INFO] [stdout] 543 | | email_verified_at [INFO] [stdout] 544 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:554:21 [INFO] [stdout] | [INFO] [stdout] 554 | let stats = sqlx::query!( [INFO] [stdout] | _____________________^ [INFO] [stdout] 555 | | r#" [INFO] [stdout] 556 | | SELECT [INFO] [stdout] 557 | | COUNT(*) as total, [INFO] [stdout] ... | [INFO] [stdout] 561 | | "# [INFO] [stdout] 562 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:568:26 [INFO] [stdout] | [INFO] [stdout] 568 | let role_stats = sqlx::query!( [INFO] [stdout] | __________________________^ [INFO] [stdout] 569 | | r#" [INFO] [stdout] 570 | | SELECT [INFO] [stdout] 571 | | r.name as role_name, [INFO] [stdout] ... | [INFO] [stdout] 577 | | "# [INFO] [stdout] 578 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:600:22 [INFO] [stdout] | [INFO] [stdout] 600 | let result = sqlx::query!("SELECT COUNT(*) as count FROM posts") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:610:13 [INFO] [stdout] | [INFO] [stdout] 610 | sqlx::query!("SELECT COUNT(*) as count FROM posts WHERE published_at IS NOT NULL") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:619:22 [INFO] [stdout] | [INFO] [stdout] 619 | let result = sqlx::query!("SELECT COUNT(*) as count FROM posts WHERE published_at IS NULL") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:628:22 [INFO] [stdout] | [INFO] [stdout] 628 | let result = sqlx::query!("SELECT COUNT(*) as count FROM categories") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/user.rs:637:22 [INFO] [stdout] | [INFO] [stdout] 637 | let result = sqlx::query!("SELECT COUNT(*) as count FROM tags") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:43:22 [INFO] [stdout] | [INFO] [stdout] 43 | let record = sqlx::query_as!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 44 | | LoginAttempt, [INFO] [stdout] 45 | | "select failure_count,lockout_expires_at from login_attempts where username = $1", [INFO] [stdout] 46 | | username [INFO] [stdout] 47 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:55:22 [INFO] [stdout] | [INFO] [stdout] 55 | let record = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 56 | | r#" [INFO] [stdout] 57 | | insert into login_attempts (username, failure_count) values ($1,1) [INFO] [stdout] 58 | | on conflict (username) do update [INFO] [stdout] ... | [INFO] [stdout] 62 | | username [INFO] [stdout] 63 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:71:9 [INFO] [stdout] | [INFO] [stdout] 71 | / sqlx::query!( [INFO] [stdout] 72 | | "update login_attempts set lockout_expires_at = $1 where username = $2", [INFO] [stdout] 73 | | expires_at, [INFO] [stdout] 74 | | username [INFO] [stdout] 75 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/login_attempt.rs:82:9 [INFO] [stdout] | [INFO] [stdout] 82 | / sqlx::query!( [INFO] [stdout] 83 | | "delete from login_attempts where username = $1", [INFO] [stdout] 84 | | username [INFO] [stdout] 85 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:53:9 [INFO] [stdout] | [INFO] [stdout] 53 | / sqlx::query!( [INFO] [stdout] 54 | | "insert into one_time_tokens (token_hash, user_id, token_type, expires_at) values ($1,$2,$3,$4)", [INFO] [stdout] 55 | | token_hash, [INFO] [stdout] 56 | | user_id, [INFO] [stdout] 57 | | token_type, [INFO] [stdout] 58 | | expires_at [INFO] [stdout] 59 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:74:9 [INFO] [stdout] | [INFO] [stdout] 74 | / sqlx::query!( [INFO] [stdout] 75 | | "insert into one_time_tokens (token_hash, user_id, token_type, expires_at) values ($1,$2,$3,$4)", [INFO] [stdout] 76 | | token_hash, [INFO] [stdout] 77 | | user_id, [INFO] [stdout] 78 | | token_type, [INFO] [stdout] 79 | | expires_at [INFO] [stdout] 80 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:95:22 [INFO] [stdout] | [INFO] [stdout] 95 | let record = sqlx::query!( [INFO] [stdout] | ______________________^ [INFO] [stdout] 96 | | "select user_id from one_time_tokens where token_hash=$1 and token_type = $2 and expires_at > now()", [INFO] [stdout] 97 | | token_hash, [INFO] [stdout] 98 | | token_type [INFO] [stdout] 99 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/repositories/one_time_token.rs:105:13 [INFO] [stdout] | [INFO] [stdout] 105 | / sqlx::query!( [INFO] [stdout] 106 | | "delete from one_time_tokens where token_hash = $1", [INFO] [stdout] 107 | | token_hash [INFO] [stdout] 108 | | ) [INFO] [stdout] | |_____________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/services/user.rs:326:33 [INFO] [stdout] | [INFO] [stdout] 326 | let user_posts_result = sqlx::query!( [INFO] [stdout] | _________________________________^ [INFO] [stdout] 327 | | "SELECT [INFO] [stdout] 328 | | COUNT(*) as total_posts, [INFO] [stdout] 329 | | COUNT(CASE WHEN published_at IS NOT NULL THEN 1 END) as published_posts, [INFO] [stdout] ... | [INFO] [stdout] 332 | | user_id [INFO] [stdout] 333 | | ) [INFO] [stdout] | |_________^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/services/user.rs:338:33 [INFO] [stdout] | [INFO] [stdout] 338 | let categories_result = sqlx::query!("SELECT COUNT(*) as count FROM categories") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] error: set `DATABASE_URL` to use query macros online, or run `cargo sqlx prepare` to update the query cache [INFO] [stdout] --> backend/src/services/user.rs:342:27 [INFO] [stdout] | [INFO] [stdout] 342 | let tags_result = sqlx::query!("SELECT COUNT(*) as count FROM tags") [INFO] [stdout] | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info) [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] warning: unused import: `DateTime` [INFO] [stdout] --> backend/src/repositories/post.rs:7:14 [INFO] [stdout] | [INFO] [stdout] 7 | use chrono::{DateTime, Utc}; [INFO] [stdout] | ^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: `#[warn(unused_imports)]` (part of `#[warn(unused)]`) on by default [INFO] [stdout] [INFO] [stdout] [INFO] [stdout] warning: unused import: `DateTime` [INFO] [stdout] --> backend/src/repositories/post.rs:7:14 [INFO] [stdout] | [INFO] [stdout] 7 | use chrono::{DateTime, Utc}; [INFO] [stdout] | ^^^^^^^^ [INFO] [stdout] | [INFO] [stdout] = note: `#[warn(unused_imports)]` (part of `#[warn(unused)]`) on by default [INFO] [stdout] [INFO] [stdout] [INFO] [stderr] error: could not compile `backend` (lib) due to 138 previous errors; 1 warning emitted [INFO] [stderr] warning: build failed, waiting for other jobs to finish... [INFO] [stderr] error: could not compile `backend` (lib test) due to 138 previous errors; 1 warning emitted [INFO] running `Command { std: "docker" "inspect" "c7e91bf486eef1f860380d3cbac555209b0b4c24d9c93a1968637685a52c1b51", kill_on_drop: false }` [INFO] running `Command { std: "docker" "rm" "-f" "c7e91bf486eef1f860380d3cbac555209b0b4c24d9c93a1968637685a52c1b51", kill_on_drop: false }` [INFO] [stdout] c7e91bf486eef1f860380d3cbac555209b0b4c24d9c93a1968637685a52c1b51