package com.qianwen.core.tenant.constant;


public interface TenantBaseConstant {
    public static final String TENANT_DATASOURCE_CACHE = "blade:datasource";
    public static final String TENANT_DATASOURCE_KEY = "tenant:id:";
    public static final String TENANT_DATASOURCE_EXIST_KEY = "tenant:exist:";
    public static final String TENANT_DYNAMIC_DATASOURCE_PROP = "blade.tenant.dynamic-datasource";
    public static final String TENANT_DYNAMIC_GLOBAL_PROP = "blade.tenant.dynamic-global";
    public static final String TENANT_DATASOURCE_EXIST_STATEMENT = "select datasource_id from blade_tenant WHERE is_deleted = 0 AND tenant_id = ?";
    public static final String TENANT_DATASOURCE_BASE_STATEMENT = "SELECT tenant_id as tenantId, driver_class as driverClass, url, username, password from blade_tenant tenant LEFT JOIN blade_datasource datasource ON tenant.datasource_id = datasource.id ";
    public static final String TENANT_DATASOURCE_SINGLE_STATEMENT = "SELECT tenant_id as tenantId, driver_class as driverClass, url, username, password from blade_tenant tenant LEFT JOIN blade_datasource datasource ON tenant.datasource_id = datasource.id WHERE tenant.is_deleted = 0 AND tenant.tenant_id = ?";
    public static final String TENANT_DATASOURCE_GROUP_STATEMENT = "SELECT tenant_id as tenantId, driver_class as driverClass, url, username, password from blade_tenant tenant LEFT JOIN blade_datasource datasource ON tenant.datasource_id = datasource.id WHERE tenant.is_deleted = 0";
    public static final String TENANT_DATASOURCE_NOT_FOUND = "未找到租户信息,数据源加载失败!";
}