bevy_sqlx 0.1.9

A SQLx database plugin for Bevy's ECS
Documentation 
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

use bevy::prelude::*;
use sqlx::{Database, Pool};

/// A [`Resource`](bevy::prelude::Resource) holding a connection to the
/// underlying [`Pool`](sqlx::Pool)
///
/// ### Example
///
/// ```
/// use bevy::prelude::*;
/// use sqlx::Sqlite;
/// use bevy_sqlx::{SqlxPlugin, SqlxDatabase};
/// use bevy_sqlx::component::SqlxDummy;
///
/// let url = "sqlite:db/sqlite.db";
/// App::new()
///     .add_plugins(DefaultPlugins)
///     .add_plugins(SqlxPlugin::<Sqlite, SqlxDummy>::from_url(&url))
///     .add_systems(Startup, resource)
///     .run();
///
/// fn resource(db: Res<SqlxDatabase<Sqlite>>) {
///     let record = bevy::tasks::block_on(async {
///         sqlx::query!("SELECT (1) as id, 'test' as text")
///             .fetch_one(&db.pool)
///             .await.unwrap()
///     });
///
///     dbg!(record);
/// }
/// ```
#[derive(Resource, Debug)]
pub struct SqlxDatabase<DB: Database> {
    pub pool: Pool<DB>,
}