1use crate::sqlite::StoreSql;
5use crate::{store_state::DeviceState, DbError};
6use coven_format::admin::{MemberPublicKeys, MemberRole};
7use coven_foundation::id_source::{CircleId, DeviceId, MemberId};
8
9#[derive(Clone, Debug, PartialEq, Eq)]
11pub struct MemberInfo {
12 pub id: MemberId,
14 pub keys: MemberPublicKeys,
16 pub role: MemberRole,
18 pub access: Option<coven_format::MemberAccess>,
22 pub devices: Vec<DeviceInfo>,
24 pub is_self: bool,
26}
27
28#[derive(Clone, Debug, PartialEq, Eq)]
30pub struct DeviceInfo {
31 pub id: DeviceId,
33 pub name: String,
35 pub state: DeviceState,
37 pub is_self: bool,
39}
40
41#[derive(Clone, Debug, PartialEq, Eq)]
43pub struct Circle {
44 pub id: CircleId,
46 pub name: String,
48}
49
50#[derive(Clone, Debug, PartialEq, Eq)]
52pub struct CircleMemberInfo {
53 pub member: MemberId,
55 pub is_self: bool,
57}
58
59use crate::store_state_tables::{circle, device_member, member};
60
61pub(crate) fn members(db: &StoreSql, device: DeviceId) -> Result<Vec<MemberInfo>, DbError> {
62 let me = device_member(db, device)?;
63 let members = db.query(
64 "SELECT member,signing,sealing,role,removed,access,joined_circle,joined_person FROM _coven_members WHERE removed=0
65 ORDER BY member",
66 [],
67 crate::store_state_tables::stored_member,
68 )?;
69 members
70 .into_iter()
71 .map(|(id, crate::StoreMember { keys, access, role, .. })| {
72 let devices = db.query(
73 "SELECT device,name,state FROM _coven_devices WHERE member=?1 ORDER BY device",
74 [id],
75 |r| {
76 let id = r.get::<_, DeviceId>(0)?;
77 Ok(DeviceInfo {
78 id,
79 is_self: id == device,
80 name: r.get(1)?,
81 state: crate::write_encoding::stored(
82 r,
83 2,
84 sqlive::rusqlite::types::Type::Text,
85 )?,
86 })
87 },
88 )?;
89 Ok(MemberInfo { is_self: me.as_ref() == Some(&id), keys, id, role, access, devices })
90 })
91 .collect()
92}
93
94pub(crate) fn circles(db: &StoreSql, device: DeviceId) -> Result<Vec<Circle>, DbError> {
95 let Some(me) = device_member(db, device)? else {
96 return Ok(Vec::new());
97 };
98 let circles = db.query(
101 "SELECT c.circle,c.name FROM _coven_circle_members m JOIN _coven_circles c ON c.circle=m.circle
102 WHERE m.member=?1 AND NOT EXISTS(SELECT 1 FROM _coven_circle_deletions d WHERE d.circle=c.circle)
103 ORDER BY m.circle",
104 [me],
105 |r| {
106 Ok(Circle {
107 id: circle(r, 0)?,
108 name: r.get(1)?,
109 })
110 },
111 )?;
112 Ok(circles)
113}
114
115pub(crate) fn circle_members(
117 db: &StoreSql,
118 device: DeviceId,
119 circle: CircleId,
120) -> Result<Vec<CircleMemberInfo>, DbError> {
121 let me = device_member(db, device)?;
122 let members = db.query(
123 "SELECT m.member FROM _coven_circle_members m JOIN _coven_members s ON s.member=m.member
124 WHERE m.circle=?1 AND s.removed=0
125 AND NOT EXISTS(SELECT 1 FROM _coven_circle_deletions d WHERE d.circle=m.circle)
126 ORDER BY m.member",
127 [circle],
128 |r| member(r, 0),
129 )?;
130 Ok(members
131 .into_iter()
132 .map(|member| CircleMemberInfo { is_self: me.as_ref() == Some(&member), member })
133 .collect())
134}
135
136#[cfg(test)]
137#[path = "members_tests.rs"]
138mod tests;