4 releases
0.2.1 | Jan 23, 2020 |
---|---|
0.2.0 | Aug 28, 2019 |
0.1.1 | Aug 27, 2019 |
0.1.0 | Aug 16, 2019 |
#1984 in Database interfaces
35 downloads per month
Used in odbc-tools
40KB
724 lines
This Rust crate extends odbc-iter
crate functionality with ability to query Avro records and write entire ResultSet
as Avro "Object Container File" data.
Example usage
Write Avro object container file data from query.
use odbc_iter::Odbc;
use odbc_avro::{AvroConfiguration, AvroResultSet, Codec};
let mut connection = Odbc::connect(&std::env::var("DB_CONNECTION_STRING").expect("no DB_CONNECTION_STRING env set")).expect("connect to database");
// Configure handler with default `AvroConfiguration`.
let mut db = connection.handle_with_configuration(AvroConfiguration::default());
// For example query all table data from database.
let data = db.query(r#"SELECT * FROM sys.tables"#).expect("query failed");
// You can use `File` instead to write Avro object container file or any other `Write` type.
let mut buf = Vec::new();
// Write all rows as uncompressed Avro object container file where rows are represented as record object named "result_set".
data.write_avro(&mut buf, Codec::Null, "result_set").expect("write worked");
// Now `buf` contains all rows from `sys.tables` table serialized Avro object container file.
Dependencies
~5.5–8MB
~148K SLoC