Null The column doesn’t have a specified type. Bit A bit or boolean value. Int1 An 8-bit integer value. Int2 A 16-bit integer value. Int4 A 32-bit integer value. Int8 A 64-bit integer value. Datetime4 A 32-bit datetime value. Float4 A 32-bit floating point value. Float8 A 64-bit floating point value. Money Money value. Datetime A TDS 7.2 datetime value. Money4 A 32-bit money value. Guid A unique identifier, UUID. Intn N-bit integer value (variable). Bitn A bit value in a variable-length type. Decimaln A decimal value (same as Numericn). Numericn A numeric value (same as Decimaln). Floatn A n-bit floating point value. Datetimen A n-bit datetime value (TDS 7.2). Daten A n-bit date value (TDS 7.3). Timen A n-bit time value (TDS 7.3). Datetime2 A n-bit datetime2 value (TDS 7.3). DatetimeOffsetn A n-bit datetime value with an offset (TDS 7.3). BigVarBin A variable binary value. BigVarChar A large variable string value. BigBinary A binary value. BigChar A string value. NVarchar A variable string value with UTF-16 encoding. NChar A string value with UTF-16 encoding. Xml A XML value. Udt User-defined type. Text A text value (deprecated). Image A image value (deprecated). NText A text value with UTF-16 encoding (deprecated). SSVariant An SQL variant type.

https://docs.rs/tiberius/0.10.0/tiberius/enum.ColumnType.html

for row in rows { let mut rowtext: Vec<String> = Vec::new(); for item in row.into_iter() { let output = match item { ColumnData::Binary(_val) => "binary data".into(), ColumnData::Bit(val) => val.unwrap_or_default().to_string(), ColumnData::Date(_val) => "don't know how to implement".into(), ColumnData::DateTime(_val) => "don't know how to implement".into(), ColumnData::DateTime2(_val) => "don't know how to implement".into(), ColumnData::DateTimeOffset(_val) => "don't know how to implement".into(), ColumnData::F32(val) => val.unwrap_or_default().to_string(), ColumnData::F64(val) => val.unwrap_or_default().to_string(), ColumnData::Guid(val) => val.unwrap_or_default().to_string(), ColumnData::I16(val) => val.unwrap_or_default().to_string(), ColumnData::I32(val) => val.unwrap_or_default().to_string(), ColumnData::I64(val) => val.unwrap_or_default().to_string(), ColumnData::Numeric(val) => val.unwrap().to_string(), ColumnData::SmallDateTime(_val) => "don't know how to implement".into(), ColumnData::String(val) => val.unwrap_or_default().as_ref().into(), ColumnData::Time(_val) => "don't know how to implement".into(), ColumnData::U8(val) => val.unwrap_or_default().to_string(), ColumnData::Xml(val) => val.unwrap().as_ref().to_string(), _ => "nada".into() }; rowtext.push(output); } let data = format!("{}\n", rowtext.join(",")); file.write_all(data.as_ref())?; } 14.09.22

https://github.com/prisma/tiberius/issues/101

pub async fn get_vec_hashmap(sql:&str) ->anyhow::Result<Vec<HashMap<String,String>>> { let mut _config = config2().await; let _tcp = TcpStream::connect(_config.get_addr()).await?; _tcp.set_nodelay(true)?; let mut client = Client::connect(_config, _tcp).await?; let stream = client.query(sql, &[&"B%"]).await.unwrap(); let mut _vec = stream.into_results().await?; let mut mvec:Vec<HashMap<String,String>> = Vec::new(); for i in _vec.into_iter() { for row in i.into_iter() { let _cols = row.columns(); let mut h_hash: HashMap<String, String> = HashMap::new(); for i in _cols.into_iter() { let h_name = i.name().to_string(); let h_type = i.column_type(); //println!("{:?}", h_type); match h_type { ColumnType::BigVarChar => { let d: Option<&str> = row.get(&*h_name); match d { None => h_hash.insert(h_name, "".to_string()), Some(_) => h_hash.insert(h_name, d.unwrap().to_string()), };}, ColumnType::BigChar => { let d: Option<&str> = row.get(&*h_name); match d { None => h_hash.insert(h_name, "".to_string()), Some(_) => h_hash.insert(h_name, d.unwrap().to_string()), };}, ColumnType::NVarchar => { let d: Option<&str> = row.get(&*h_name); match d { None => h_hash.insert(h_name, "".to_string()), Some(_) => h_hash.insert(h_name, d.unwrap().to_string()), };}, ColumnType::Bit => { let d: Result<Option<bool>, tiberius::error::Error> = row.try_get(&*h_name); match d { Ok(None) => h_hash.insert(h_name, "0".to_string()), Ok(_v) => h_hash.insert(h_name, d.unwrap_or_default().unwrap_or_default().to_string()), Err(_e) => h_hash.insert(h_name, "0".to_string()), }; }, ColumnType::Intn => { let d: Result<Option<i32>, tiberius::error::Error> = row.try_get(&*h_name); //println!("{:?}",d); match d { Ok(None) => h_hash.insert(h_name, "0".to_string()), Ok(_v) => h_hash.insert(h_name, d.unwrap().unwrap().to_string()), Err(_e) => { let d2: Result<Option<i16>, tiberius::error::Error> = row.try_get(&*h_name); match d2 { Ok(None) => h_hash.insert(h_name, "0".to_string()), Ok(_v) => h_hash.insert(h_name, d2.unwrap().unwrap().to_string()), Err(_e) => h_hash.insert(h_name, "0".to_string()), } }, }; }, ColumnType::Int2 => { let d: Result<Option<i16>, tiberius::error::Error> = row.try_get(&*h_name); match d { Ok(None) => h_hash.insert(h_name, "0".to_string()), Ok(_v) => h_hash.insert(h_name, d.unwrap().unwrap().to_string()), Err(_e) => h_hash.insert(h_name, "0".to_string()), }; }, ColumnType::Int4 => { let d: Result<Option<i32>, tiberius::error::Error> = row.try_get(&*h_name); match d { Ok(None) => h_hash.insert(h_name, "0".to_string()), Ok(_v) => h_hash.insert(h_name, d.unwrap().unwrap().to_string()), Err(_e) => h_hash.insert(h_name, "0".to_string()), }; }, ColumnType::Float8 => { let d: Result<Option<f64>, tiberius::error::Error> = row.try_get(&*h_name); match d { Ok(_v) => h_hash.insert(h_name, d.unwrap().unwrap().to_string()), Err(_e) => h_hash.insert(h_name, "0".to_string()), };}, ColumnType::Floatn => { let d: Result<Option<f64>, tiberius::error::Error> = row.try_get(&*h_name); match d { Ok(_v) => h_hash.insert(h_name, d.unwrap().unwrap().to_string()), Err(_e) => h_hash.insert(h_name, "0".to_string()), };}, ColumnType::Decimaln => { let d: Option<tiberius::numeric::Numeric> = row.get(&*h_name); match d { None => h_hash.insert(h_name, "0".to_string()), Some(_v) => h_hash.insert(h_name, d.unwrap().to_string()), };}, _ => {let _d: Option<&str> = row.get(&*h_name); let h_val = "".to_string(); h_hash.insert(h_name, h_val); }, }; } mvec.push(h_hash); } } Ok(mvec) 14.09.22

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024