FilesExpand file tree

develop

/

sqlite-raw.rs

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

52 lines (36 loc) · 1.25 KB

develop

/

sqlite-raw.rs

Copy path

Top

File metadata and controls

• Code
• Blame

52 lines (36 loc) · 1.25 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

//! Tests for the raw (unprepared) query API for Sqlite.

use sqlx::{Cursor, Executor, Row, Sqlite};

use sqlx_test::new;

#[cfg_attr(feature = "runtime-async-std", async_std::test)]

#[cfg_attr(feature = "runtime-tokio", tokio::test)]

async fn test_select_expression() -> anyhow::Result<()> {

let mut conn = new::<Sqlite>().await?;

let mut cursor = conn.fetch("SELECT 5");

let row = cursor.next().await?.unwrap();

assert!(5i32 == row.try_get::<i32, _>(0)?);

Ok(())

}

#[cfg_attr(feature = "runtime-async-std", async_std::test)]

#[cfg_attr(feature = "runtime-tokio", tokio::test)]

async fn test_multi_read_write() -> anyhow::Result<()> {

let mut conn = new::<Sqlite>().await?;

let mut cursor = conn.fetch(

"

CREATE TABLE IF NOT EXISTS _sqlx_test (

id INT PRIMARY KEY,

text TEXT NOT NULL

);

SELECT 'Hello World' as _1;

INSERT INTO _sqlx_test (text) VALUES ('this is a test');

SELECT id, text FROM _sqlx_test;

",

);

let row = cursor.next().await?.unwrap();

assert!("Hello World" == row.try_get::<&str, _>("_1")?);

let row = cursor.next().await?.unwrap();

let id: i64 = row.try_get("id")?;

let text: &str = row.try_get("text")?;

assert_eq!(0, id);

assert_eq!("this is a test", text);

Ok(())

}