Couchbase数据类型 #

基本类型
├── 数值类型
│   ├── 整数 (INTEGER)
│   └── 浮点数 (FLOAT/DOUBLE)
├── 字符串 (STRING)
├── 布尔值 (BOOLEAN)
└── 空值 (NULL)

复合类型
├── 对象 (OBJECT)
└── 数组 (ARRAY)

特殊类型
├── 缺失 (MISSING)
└── 二进制 (BINARY)

{
    "age": 25,
    "quantity": -100,
    "big_number": 9007199254740992
}

{
    "price": 99.99,
    "rate": 0.123456789,
    "scientific": 1.5e10
}

SELECT 
    42 AS integer_value,
    3.14 AS float_value,
    1.5e10 AS scientific_notation,
    -100 AS negative_value;

{
    "name": "张三",
    "email": "zhangsan@example.com",
    "description": "这是一个包含\"引号\"的字符串",
    "unicode": "你好世界 🌍"
}

SELECT 
    "Hello World" AS simple_string,
    "Line1\nLine2" AS multiline,
    "Unicode: 你好" AS unicode_string,
    "Quote: \"test\"" AS escaped;

{
    "is_active": true,
    "is_deleted": false,
    "has_permission": true
}

SELECT 
    true AS yes,
    false AS no,
    NOT true AS not_true,
    true AND false AS and_result,
    true OR false AS or_result;

{
    "middle_name": null,
    "phone": null
}

SELECT 
    a IS NULL AS is_null,
    a IS MISSING AS is_missing
FROM [
    {"a": null},
    {"b": 1}
] AS t;

{
    "user": {
        "id": "001",
        "name": "张三",
        "contact": {
            "email": "zhangsan@example.com",
            "phone": "13800138000"
        },
        "address": {
            "city": "北京",
            "street": "朝阳路100号",
            "zipcode": "100020"
        }
    }
}

SELECT 
    user.name,
    user.contact.email,
    user.address.city
FROM `my-bucket`.`_default`.`_default`
WHERE type = 'user';

SELECT 
    OBJECT_NAMES(user) AS field_names,
    OBJECT_VALUES(user) AS field_values,
    OBJECT_LENGTH(user) AS field_count
FROM `my-bucket`.`_default`.`_default`
WHERE type = 'user';

{
    "hobbies": ["阅读", "游泳", "编程"],
    "scores": [95, 88, 92, 85],
    "mixed": [1, "two", true, null, {"key": "value"}],
    "nested": [[1, 2], [3, 4], [5, 6]]
}

SELECT 
    hobbies[0] AS first_hobby,
    hobbies[-1] AS last_hobby,
    ARRAY_LENGTH(hobbies) AS count,
    ARRAY_APPEND(hobbies, "游戏") AS with_new_item
FROM `my-bucket`.`_default`.`_default`
WHERE type = 'user';

SELECT 
    name,
    age,
    age IS NULL AS is_null,
    age IS MISSING AS is_missing
FROM `my-bucket`.`_default`.`_default`;

SELECT 
    name,
    IFMISSING(phone, 'N/A') AS phone,
    IFMISSINGORNULL(email, 'unknown@example.com') AS email
FROM `my-bucket`.`_default`.`_default`;

{
    "type": "binary",
    "data": "SGVsbG8gV29ybGQh",
    "encoding": "base64"
}

SELECT 
    TYPE(42) AS num_type,
    TYPE("hello") AS str_type,
    TYPE(true) AS bool_type,
    TYPE(null) AS null_type,
    TYPE([1,2,3]) AS arr_type,
    TYPE({"a":1}) AS obj_type;

SELECT 
    IS_NUMBER(age) AS is_num,
    IS_STRING(name) AS is_str,
    IS_BOOLEAN(active) AS is_bool,
    IS_ARRAY(hobbies) AS is_arr,
    IS_OBJECT(address) AS is_obj
FROM `my-bucket`.`_default`.`_default`;

SELECT 
    TO_STRING(42) AS str_num,
    TO_STRING(3.14) AS str_float,
    TO_STRING(true) AS str_bool;

SELECT 
    TO_NUMBER("42") AS num_str,
    TO_NUMBER("3.14") AS float_str,
    TO_NUMBER(true) AS num_bool;

SELECT 
    TO_BOOLEAN(1) AS bool_num,
    TO_BOOLEAN("true") AS bool_str,
    TO_BOOLEAN(0) AS bool_zero;

SELECT 
    TO_ARRAY(1) AS arr_num,
    TO_ARRAY("hello") AS arr_str,
    TO_ARRAY([1,2,3]) AS arr_arr;

SELECT 
    TO_OBJECT({"a": 1}) AS obj_obj,
    TO_OBJECT([{"a": 1}, {"b": 2}]) AS obj_arr;

{
    "created_at": "2024-01-15T10:30:00Z",
    "updated_at": "2024-01-15T18:45:30+08:00",
    "birth_date": "1990-05-20"
}

SELECT 
    DATE_FORMAT_STR(created_at, 'YYYY-MM-DD') AS date_only,
    DATE_PART(created_at, 'year') AS year,
    DATE_PART(created_at, 'month') AS month,
    DATE_PART(created_at, 'day') AS day,
    DATE_PART(created_at, 'hour') AS hour,
    DATE_DIFF(created_at, updated_at, 'day') AS days_diff
FROM `my-bucket`.`_default`.`_default`;

SELECT 
    DATE_ADD_STR("2024-01-15", 7, "day") AS week_later,
    DATE_ADD_STR("2024-01-15", -1, "month") AS month_ago,
    DATE_TRUNC_STR("2024-01-15T10:30:00Z", "day") AS truncated;

{
    "type": "user",
    "id": "user_001",
    "name": "张三",
    "age": 28,
    "email": "zhangsan@example.com",
    "is_active": true,
    "score": 95.5,
    "hobbies": ["阅读", "游泳", "编程"],
    "address": {
        "city": "北京",
        "street": "朝阳路100号",
        "zipcode": "100020"
    },
    "metadata": {
        "created_at": "2024-01-15T10:30:00Z",
        "updated_at": "2024-01-20T15:45:00Z",
        "version": 1
    },
    "tags": ["vip", "premium"],
    "settings": null
}

{
    "type": "product",
    "id": "prod_001",
    "name": "iPhone 15",
    "price": 7999.00,
    "stock": 100,
    "is_available": true,
    "categories": ["电子产品", "手机", "苹果"],
    "specs": {
        "color": ["黑色", "白色", "蓝色"],
        "storage": [128, 256, 512],
        "weight": 171.5
    },
    "ratings": [5, 4, 5, 4, 5],
    "created_at": "2024-01-01T00:00:00Z"
}

{
    "type": "order",
    "id": "order_001",
    "user_id": "user_001",
    "items": [
        {
            "product_id": "prod_001",
            "name": "iPhone 15",
            "quantity": 1,
            "price": 7999.00
        },
        {
            "product_id": "prod_002",
            "name": "手机壳",
            "quantity": 2,
            "price": 99.00
        }
    ],
    "total_amount": 8197.00,
    "status": "pending",
    "payment": {
        "method": "credit_card",
        "transaction_id": "txn_123456"
    },
    "created_at": "2024-01-15T10:30:00Z"
}

{
    "good_example": {
        "age": 25,
        "price": 99.99,
        "is_active": true,
        "tags": ["tag1", "tag2"]
    },
    "bad_example": {
        "age": "25",
        "price": "99.99",
        "is_active": "true",
        "tags": "tag1,tag2"
    }
}

SELECT 
    name,
    IFMISSING(middle_name, '') AS middle_name,
    IFMISSINGORNULL(phone, 'N/A') AS phone,
    IFMISSING(age, 0) AS age
FROM `my-bucket`.`_default`.`_default`;