Function get_version_sql

backend/apps/db/db_sql.py:7–33

(ds: CoreDatasource, conf: DatasourceConf)

def get_version_sql(ds: CoreDatasource, conf: DatasourceConf):
    if equals_ignore_case(ds.type, "mysql", "doris", "starrocks"):
        return """
                SELECT VERSION()
                """
    elif equals_ignore_case(ds.type, "sqlServer"):
        return """
                select SERVERPROPERTY('ProductVersion')
                """
    elif equals_ignore_case(ds.type, "pg", "kingbase", "excel"):
        return """
              SELECT current_setting('server_version')
              """
    elif equals_ignore_case(ds.type, "oracle"):
        return """
                SELECT version FROM v$instance
                """
    elif equals_ignore_case(ds.type, "ck"):
        return """
                select  version()
                """
    elif equals_ignore_case(ds.type, "dm"):
        return """
                SELECT * FROM v$version
                """
    elif equals_ignore_case(ds.type, "redshift", "sqlite", "hive"):
        return ''


def get_table_sql(ds: CoreDatasource, conf: DatasourceConf, db_version: str = ''):