namespace Aegis.Repository.SQLite.Queries;

public static class DataStoreQueries
{
    public const string ListForUser = """
                                          SELECT
                                              ds.datastore_id,
                                              m.role,
                                              ds.name_enc,
                                              ds.name_nonce,
                                              ds.lk_kid,
                                              ds.lk_version
                                          FROM datastore_members m
                                          JOIN datastores ds ON ds.datastore_id = m.datastore_id
                                          WHERE m.user_id = $userId
                                            AND ds.deleted_at IS NULL
                                          ORDER BY ds.created_at ASC;
                                      """;
}