<commit_before>-- Stop NOTE level warnings about objects (not)? existing
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;

-- Some handy views for admins viewing the doc store, NOT used by the app

create or replace view v_fs_volume as
select
    fv.id fs_volume_id,
    fv.path,
    case fv.status -- FsVolume.VolumeUseState
        when 0 then 'Active'
        when 1 then 'Inactive'
        when 3 then 'Closed'
        else concat('ERROR: UNKNOWN STATE (', fv.status, ')')
        end status,
    fv.byte_limit,
    from_unixtime(fv.create_time_ms / 1000) create_time,
    fv.update_user create_user,
    from_unixtime(fv.update_time_ms / 1000) update_time,
    fv.update_user update_user,
    fvs.id,
    fvs.bytes_used,
    fvs.bytes_free,
    fvs.bytes_total
from fs_volume fv
inner join fs_volume_state fvs on fv.fk_fs_volume_state_id = fvs.id;

-- vim: set tabstop=4 shiftwidth=4 expandtab:
<commit_msg>Add missing SET SQL_NOTES line<commit_after>-- Stop NOTE level warnings about objects (not)? existing
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;

-- Some handy views for admins viewing the doc store, NOT used by the app

create or replace view v_fs_volume as
select
    fv.id fs_volume_id,
    fv.path,
    case fv.status -- FsVolume.VolumeUseState
        when 0 then 'Active'
        when 1 then 'Inactive'
        when 3 then 'Closed'
        else concat('ERROR: UNKNOWN STATE (', fv.status, ')')
        end status,
    fv.byte_limit,
    from_unixtime(fv.create_time_ms / 1000) create_time,
    fv.update_user create_user,
    from_unixtime(fv.update_time_ms / 1000) update_time,
    fv.update_user update_user,
    fvs.id,
    fvs.bytes_used,
    fvs.bytes_free,
    fvs.bytes_total
from fs_volume fv
inner join fs_volume_state fvs on fv.fk_fs_volume_state_id = fvs.id;

SET SQL_NOTES=@OLD_SQL_NOTES;

-- vim: set tabstop=4 shiftwidth=4 expandtab:

{'fraction_non_alphanumeric': 0.08530042918454936, 'fraction_numerical': 0.015021459227467811, 'mean_word_length': 3.2972350230414746, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5634630', 'n_tokens_mistral': 706, 'n_tokens_neox': 654, 'n_words': 182}