diff options
| author | iximeow <me@iximeow.net> | 2023-07-02 16:26:19 -0700 |
|---|---|---|
| committer | iximeow <me@iximeow.net> | 2023-07-02 16:26:19 -0700 |
| commit | e02825d34f1a0a905141ea0680358119f970e455 (patch) | |
| tree | e7fd7828ca3156f60ce8a869fc81cae0b624c001 | |
| parent | 44f5b5360c8f5cc00ea445da5df238749fe389a1 (diff) | |
better sql i think
| -rw-r--r-- | src/dbctx.rs | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/src/dbctx.rs b/src/dbctx.rs index fb72cc2..05910f1 100644 --- a/src/dbctx.rs +++ b/src/dbctx.rs @@ -563,8 +563,8 @@ impl DbCtx { .query_row( "select id from hosts where \ ( \ - hostname=?1, cpu_vendor_id=?2, cpu_model_name=?3, cpu_family=?4, \ - cpu_model=?5, cpu_cores=?6, mem_total=?7, \ + hostname=?1 and cpu_vendor_id=?2 and cpu_model_name=?3 and cpu_family=?4 and \ + cpu_model=?5 and cpu_cores=?6 and mem_total=?7 and \ arch=?10 \ );", ( @@ -618,10 +618,9 @@ impl DbCtx { conn .query_row( "select id from hosts where \ - ( \ - hostname=?1, cpu_vendor_id=?2, cpu_model_name=?3, cpu_family=?4, \ - cpu_model=?5, cpu_microcode=?6, cpu_cores=?7, mem_total=?8, \ - arch=?9, family=?10, os=?11 \ + hostname=?1 and cpu_vendor_id=?2 and cpu_model_name=?3 and cpu_family=?4 and \ + cpu_model=?5 and cpu_microcode=?6 and cpu_cores=?7 and mem_total=?8 and \ + arch=?9 and family=?10 and os=?11 \ );", ( &host_info.hostname, |