odbtools/odbctest/mql/basic/24bucket_promdb/1110class.mql

/**
scope(file)
timeout(3m)
**/
;

create class if not exists /test() with namespace="test"
;
	
create class if not exists /test/bucketpromdb (
    
    host varchar,
    
    prom  bucket {
                "type"  :  "promdb",
                "ttl"   :   2,
                "dict"	 :	 true,
                "version":	1,
                "slot"	 :   5
            } 'prom',
            
    pprom  bucket {
                "type"  :  "promdb",
                "ttl"   :   2,
                "dict"	 :	 true,
                "version":	1,
                "slot"	 :   5
            } 'pprom',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdb'
;

create class if not exists /test/bucketpromdbmp (
    
    host varchar,
    ip	 varchar,
    
    prommp  bucket {
                "type"  :  "promdb",
                "ttl"   :   2,
                "dict"	 :	 true,
                "version":	1,
                "slot"	 :   5,
                "pattern": "{\"partition\":[15]}"
                
            } 'prommp',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdbmp', partition=(ip)
;

create class if not exists /test/bucketpromdbdelay (
   		
    host varchar,
    
    promdelay  bucket {
            "type"  :  "promdb",
            "ttl"   :   2,
            "slot"	 :   5,
            "collect":	 10
        } 'delay',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdbdelay'
;

create class if not exists /test/bucketpromdbsync (
    
    host varchar,
    
    prom_sync  bucket {
                "type"  :  "promdb",
                "syncdc":	true,
                "ttl"   :   2,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdbsync'
;

create class if not exists /test/bucketsplit (
    
    host varchar,
    
    prom_split  bucket {
                "type"  :  "promdb",
                "ttl"   :   2,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketsplit'
;

create class if not exists /test/promdb_string (
    
    host varchar,
    
    prom_str  bucket {
                "type"  :  "promdb",
                "ttl"   :   2,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='promdb_string'
;

create class if not exists /test/promdb_string2 (
   		
    host varchar,
    
    prom_str2  bucket {
                "cache" :  false,
                "type"  :  "promdb",
                "ttl"   :   2,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='promdb_string2'
;

create class if not exists /test/bucketpromdb2 (
    
    host varchar,
    
    prom2  bucket {
                "type"  :  "promdb",
                "single":	true,
                "ttl"   :   2,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdb2'
;

create class if not exists /test/bucketpromdb3 (
    
    host varchar,
    
    prom3  bucket {
            "type"  :  "promdb",
            "single":	true,
            "share" :  true,
            "ttl"   :   2,
            "slot"	 :   5
        } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdb3'
;

create class if not exists /test/bucketpromdb4 (
    
    host varchar,
    
    prom4  bucket {
                "type"  :  "promdb",
                "share" :  true,
                "ttl"   :   2,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdb4'
;

create class if not exists /test/bucketpromdbnocache (
    
    host varchar,
    
    prom_nocache  bucket {
                "type"  :  "promdb",
                "cache" :  false,
                "ttl"   :   1,
                "slot"	 :   5
            } 'full',

    keys(host),
    indexes(host)

) with key=manu, nickname='bucketpromdbnocache'
;

create class if not exists /test/bucketpromdb/subpromdb () with nickname ='subpromdb' ;

create class if not exists /test/bucketpromdb/subpromdb2 () with nickname ='subpromdb2' ;

create class if not exists /test/bucketpromdb2/subpromdbs() with nickname ='subpromdbs' ;

create class if not exists /test/bucketpromdb2/subpromdbss() with nickname ='subpromdbss' ;

create class if not exists /test/bucketpromdb2/subpromdbsss() with nickname ='subpromdbsss' ;