q_block(organization_id=Parameter("$1"), block_id=Parameter("$2")) .select( "deleted_on", q_user_can_read_vlob( user=q_user_internal_id(organization_id=Parameter("$1"), user_id=Parameter("$3")), realm=t_block.realm, ), ) .get_sql() ) _q_get_block_write_right_and_unicity = Query.select( q_user_can_write_vlob( user=q_user_internal_id(organization_id=Parameter("$1"), user_id=Parameter("$2")), realm=q_realm_internal_id(organization_id=Parameter("$1"), realm_id=Parameter("$3")), ), fn_exists(q_block(organization_id=Parameter("$1"), block_id=Parameter("$4"))), ).get_sql() _q_insert_block = ( Query.into(t_block) .columns("organization", "block_id", "realm", "author", "size", "created_on") .insert( q_organization_internal_id(Parameter("$1")), Parameter("$2"), q_realm_internal_id(organization_id=Parameter("$1"), realm_id=Parameter("$3")), q_device_internal_id(organization_id=Parameter("$1"), device_id=Parameter("$4")), Parameter("$5"), Parameter("$6"),
_q_get_organization = (q_organization(Parameter("$1")).select( "bootstrap_token", "root_verify_key", "expiration_date").get_sql()) _q_bootstrap_organization = (Query.update(t_organization).where( (t_organization.organization_id == Parameter("$1")) & (t_organization.bootstrap_token == Parameter("$2")) & (t_organization.root_verify_key.isnull())).set( t_organization.root_verify_key, Parameter("$3")).get_sql()) _q_get_stats = Query.select( Query.from_(t_user).where( t_user.organization == q_organization_internal_id(Parameter( "$1"))).select(fn.Count("*")).as_("users"), Query.from_(t_vlob_atom).where( t_vlob_atom.organization == q_organization_internal_id(Parameter( "$1"))).select(fn.Coalesce(fn.Sum(t_vlob_atom.size), 0)).as_("metadata_size"), Query.from_(t_block).where( t_block.organization == q_organization_internal_id(Parameter( "$1"))).select(fn.Coalesce(fn.Sum(t_block.size), 0)).as_("data_size"), ).get_sql() _q_update_organisation_expiration_date = (Query.update(t_organization).where( (t_organization.organization_id == Parameter("$1"))).set( t_organization.expiration_date, Parameter("$2")).get_sql()) class PGOrganizationComponent(BaseOrganizationComponent): def __init__(self, dbh: PGHandler, **kwargs): super().__init__(**kwargs)