Method get_table_data

solidui/views/metadata/api.py:110–150

(self)

    @expose('/queryTableData', methods=("GET",))
    @safe
    def get_table_data(self) -> FlaskResponse:
        data_source_name = request.args.get('dataSourceName')
        database = request.args.get('database')
        table_name = request.args.get('tableName')
        type_name = request.args.get('typeName', default=None)
        # Call the service method to get table data. You need to implement this logic
        data_source = DataSourceDAO.get_data_source_name(data_source_name)
        if data_source is None:
            return self.handle_error(SolidUIErrorType.QUERY_DATASOURCE_ERROR)

        data_source_type = DataSourceTypeDAO.get_id(data_source.datasource_type_id)
        if data_source_type is None:
            return self.handle_error(SolidUIErrorType.QUERY_DATASOURCE_TYPE_ERROR)

        # Parse the JSON parameters
        params = json.loads(data_source.parameter)

        # Create a JDBC client
        jdbc_client = JdbcClientFactory.create_client(
            db_type=data_source_type.name,  # Assuming MySQL for example
            host=params.get("host"),
            port=params.get("port"),
            username=params.get("username"),
            password=params.get("password"),
            database=params.get("database"),
            extra_params=params.get("params", {})
        )

        select_all_data_sql = jdbc_client.generate_select_all_data_sql(database, table_name)
        select_result = JdbcClientFactory.run_query(jdbc_client, select_all_data_sql)

        # Transform the result into the desired format
        if not select_result or len(select_result) == 1:
            return self.handle_error(SolidUIErrorType.QUERY_METADATA_SQL_ERROR)

        field_value_results = []
        columns = select_result[0]
        for row in select_result[1:]:
            field_value_results.append(dict(zip(columns, row)))

        return self.response_format(data=field_value_results)

    @expose('/querySql', methods=("GET",))
    @safe