Usage documentation #3

Activity

1. shish commented on Jun 15, 2019

   

   shish

   on Jun 15, 2019

   More actions

   I think I got at least part of it working - for anybody else who ends up here by google:

   First, as of this writing, this crate only works with rust-postgres 0.15 -- 0.16 seems to be a complete rewrite based on top of tokio and is not compatible

   With the right versions in place, this is how I run a query which returns a set of (str, array[int]) rows

   use postgres::{Connection, TlsMode};
   use postgres_array::array::Array;
   
   ...
   
       let client = Connection::connect(dsn, TlsMode::None).expect("Failed to connect");
   
   ...
   
           for row in &client.query("\
               SELECT tag, array_agg(post_id)
               FROM post_tags
               GROUP BY tag
           ", &[]).unwrap() {
               let tag: String = row.get(0);
               let post_ids: Array<i32> = row.get(1);
               let post_ids_vec: Vec<i32> = post_ids.iter().cloned().collect();
               ...
           }
   
   

   👍React with 👍4Reacted by Stuart C. Robinson, Divy, Joris De Ridder and Bhattarapong Somwong

   🎉React with 🎉3Reacted by Stuart C. Robinson, Divy and Joris De Ridder

   ❤️React with ❤️2Reacted by Joris De Ridder and Alex Pearson