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

use bevy::app::ScheduleRunnerPlugin;
use bevy::prelude::*;
use bevy_sqlx::{component::SqlxDummy, SqlxDatabase, SqlxPlugin};
use sqlx::{Row, Sqlite};

fn main() {
    App::new()
        .add_plugins(MinimalPlugins.set(ScheduleRunnerPlugin::run_once()))
        .add_plugins(SqlxPlugin::<Sqlite, SqlxDummy>::from_url(
            "sqlite:db/sqlite.db",
        ))
        .add_systems(Startup, select)
        .update();
}

fn select(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.columns());
}