{"header":{"message":"refine relations, add group permissions, and allow permissions to have subjects","description":null,"timestamp":"2024-02-02T19:51:07.893309202Z","authors":[{}]},"hash":"JTHUFYTDQHWNQV5EVGIDMLSNA7OOPBHD52LHHCDYOMLIIWHD7AUAC","authors":[{"login":"Jengamon","key":"47a75hR6eVaawZfVGBs2CqZUKZbcNz5Ago5CubrCkWvZ"}],"deps":{"hashes":[["JTHUFYTDQHWNQV5EVGIDMLSNA7OOPBHD52LHHCDYOMLIIWHD7AUAC","refine relations, add group permissions, and allow permissions to have subjects"],["AA",null],["Z2GITYCX4GLFIH2NUNPMWNPJXKMNRLSL4FAN7YTDIFRSH6DJU2JAC","soooo much progress"],["DJF3AQJNNKWGV7XTOFOHK4YUSQF5YEDAVMXATVMT6RU6DWP2ETYQC","fix some stuff, add some stuff"],["W6W6YBQ6VLEPWLG6GG5VJIJ3LGDISF42HAEC5KV3G5CAMCHIHXAQC","updating to use ulids n stuff"]],"deps":["Z2GITYCX4GLFIH2NUNPMWNPJXKMNRLSL4FAN7YTDIFRSH6DJU2JAC"],"known":["W6W6YBQ6VLEPWLG6GG5VJIJ3LGDISF42HAEC5KV3G5CAMCHIHXAQC","DJF3AQJNNKWGV7XTOFOHK4YUSQF5YEDAVMXATVMT6RU6DWP2ETYQC"]},"hunks":[{"Edit":{"inode":{"change":2,"pos":32},"path":"server/src/user.rs","line":123,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":3136}],"down_context":[{"change":2,"pos":3136}],"flag":"BLOCK","start":0,"end":127,"inode":{"change":2,"pos":32}}},"contents":[{"Add":"}"},{"Add":""},{"Add":"#[derive(Debug, Deserialize, Hash, PartialEq, Eq, Clone, Serialize)]"},{"Add":"struct Record {"},{"Add":" #[allow(dead_code)]"},{"Add":" id: Thing,"}]}},{"Replacement":{"inode":{"change":2,"pos":32},"path":"server/src/user.rs","line":133,"ins":{"up_context":[{"change":2,"pos":3232}],"down_context":[{"change":2,"pos":3248}],"flag":"BLOCK","start":128,"end":143,"inode":{"change":2,"pos":32}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3232},"to":{"change":2,"start":3232,"end":3248},"introduced_by":2}],"inode":{"change":2,"pos":32}},"ins_contents":[{"Add":" id: Thing,"}],"del_contents":[{"Del":" id: String,\n"}]}},{"Edit":{"inode":{"change":2,"pos":32},"path":"server/src/user.rs","line":135,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":3268}],"down_context":[{"change":2,"pos":3268}],"flag":"BLOCK","start":144,"end":173,"inode":{"change":2,"pos":32}}},"contents":[{"Add":" subject: Option,"}]}},{"Replacement":{"inode":{"change":2,"pos":32},"path":"server/src/user.rs","line":146,"ins":{"up_context":[{"change":2,"pos":3482}],"down_context":[{"change":2,"pos":3681}],"flag":"BLOCK","start":174,"end":423,"inode":{"change":2,"pos":32}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3482},"to":{"change":2,"start":3482,"end":3681},"introduced_by":2}],"inode":{"change":2,"pos":32}},"ins_contents":[{"Add":" let user_permissions: Vec = self"},{"Add":" .db"},{"Add":" .query(r#\"SELECT id, aspect, ->granted->user FROM permission WHERE user == $id\"#)"},{"Add":" .bind((\"id\", user.id.clone()))"},{"Add":" .await?"},{"Add":" .take(0)?;"}],"del_contents":[{"Del":" let user_permissions: Vec = self.db.query(r#\"SELECT id, aspect FROM permission WHERE ->granted->user == type::thing(\"user\", $id)\"#).bind((\"id\", user.id.clone())).await?.take(0)?;\n"}]}},{"Replacement":{"inode":{"change":2,"pos":32},"path":"server/src/user.rs","line":157,"ins":{"up_context":[{"change":2,"pos":3790}],"down_context":[{"change":2,"pos":3818}],"flag":"BLOCK","start":424,"end":451,"inode":{"change":2,"pos":32}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3790},"to":{"change":2,"start":3790,"end":3818},"introduced_by":2}],"inode":{"change":2,"pos":32}},"ins_contents":[{"Add":" user: &Self::User,"}],"del_contents":[{"Del":" _user: &Self::User,\n"}]}},{"Replacement":{"inode":{"change":2,"pos":32},"path":"server/src/user.rs","line":159,"ins":{"up_context":[{"change":2,"pos":3870}],"down_context":[{"change":2,"pos":3897}],"flag":"BLOCK","start":452,"end":707,"inode":{"change":2,"pos":32}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3870},"to":{"change":2,"start":3870,"end":3897},"introduced_by":2}],"inode":{"change":2,"pos":32}},"ins_contents":[{"Add":" let group_permissions: Vec = self.db.query(r#\"SELECT id, aspect, ->granted->group<-member_of<-user FROM permission WHERE user == $id\"#).bind((\"id\", user.id.clone())).await?.take(0)?;"},{"Add":" Ok(group_permissions.into_iter().collect())"}],"del_contents":[{"Del":" Ok(HashSet::new())\n"}]}},{"Replacement":{"inode":{"change":2,"pos":14218},"path":"server/migrations/20240201_000001_create_user_and_permission_table.surql","line":5,"ins":{"up_context":[{"change":2,"pos":14297}],"down_context":[{"change":2,"pos":14376}],"flag":"BLOCK","start":708,"end":819,"inode":{"change":2,"pos":14218}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":14297},"to":{"change":2,"start":14297,"end":14376},"introduced_by":2}],"inode":{"change":2,"pos":14218}},"ins_contents":[{"Add":"DEFINE FIELD email ON TABLE user TYPE string VALUE string::lowercase($value) ASSERT string::is::email($value);"}],"del_contents":[{"Del":"DEFINE FIELD email ON TABLE user TYPE string ASSERT string::is::email($value);\n"}]}},{"Edit":{"inode":{"change":2,"pos":14218},"path":"server/migrations/20240201_000001_create_user_and_permission_table.surql","line":12,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":14743}],"down_context":[{"change":2,"pos":14743}],"flag":"BLOCK","start":820,"end":1113,"inode":{"change":2,"pos":14218}}},"contents":[{"Add":"DEFINE FIELD subject ON TABLE permission TYPE option;"},{"Add":""},{"Add":"DEFINE TABLE group SCHEMAFULL;"},{"Add":"DEFINE FIELD description ON TABLE group TYPE string;"},{"Add":""},{"Add":"DEFINE TABLE member_of SCHEMAFULL;"},{"Add":"DEFINE FIELD in ON TABLE member_of TYPE record;"},{"Add":"DEFINE FIELD out ON TABLE member_of TYPE record;"}]}},{"Replacement":{"inode":{"change":2,"pos":14218},"path":"server/migrations/20240201_000001_create_user_and_permission_table.surql","line":22,"ins":{"up_context":[{"change":2,"pos":14777}],"down_context":[{"change":2,"pos":14829}],"flag":"BLOCK","start":1114,"end":1174,"inode":{"change":2,"pos":14218}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":14777},"to":{"change":2,"start":14777,"end":14829},"introduced_by":2}],"inode":{"change":2,"pos":14218}},"ins_contents":[{"Add":"DEFINE FIELD in ON TABLE granted TYPE record;"}],"del_contents":[{"Del":"DEFINE FIELD in ON TABLE granted TYPE record;\n"}]}},{"Edit":{"inode":{"change":2,"pos":14218},"path":"server/migrations/20240201_000001_create_user_and_permission_table.surql","line":24,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":14888},"to":{"change":2,"start":14888,"end":15034},"introduced_by":2}],"inode":{"change":2,"pos":14218}}},"contents":[{"Del":"DEFINE FIELD granted ON TABLE granted TYPE datetime DEFAULT time::now();\nDEFINE INDEX unique_permissions ON TABLE granted COLUMNS in, out UNIQUE;\n"}]}}],"owner":"Jengamon","repo":"noteboek","token":"YwtY0Gh07b++UDGZP3mVbqoVIEpjJnpVxy+buCUn6xQ=","login":null}

…

Dependencies

Change contents