如何在Angular应用中使用OrientDB HTTP API？

Question

我试图从角度服务方法查询OrientDB。但获取身份验证是一个相关错误。根据我目前的理解，我需要两个GET请求才能成功查询OrientDB。

1. 身份验证调用。即请求http://localhost:2480/connect/

但是我在浏览器控制台中遇到了这些错误：

< li>XMLHttpRequest无法加载http://localhost:2480/connect/atu db。对预检请求的响应未通过访问控制检查:请求的资源上不存在“Access-Control-Allow-Origin”标头。因此，不允许访问源“http://localhost:8080”。 < Li > GET http://localhost:2480/query/atu db/SQL/select @ rid as rid，runOfDay from test result where executor platform data . machine name = ' nite shk ' 401(未授权) < li>XMLHttpRequest无法从TestResult加载http://localhost:2480/query/atu db/SQL/select @ rid as rid，runOfDay，其中executorplatformdata . machine name = ' nite shk '。请求的资源上没有“Access-Control-Allow-Origin”标头。因此，不允许访问源“http://localhost:8080”。响应的HTTP状态代码为401。

以下是角度服务的代码

angular.module('ReportApp')
    .factory('orientdbService', ['$http', '$log', '$q', 
        function($http, $log, $q) {
            'use strict';

            var fac = {};

            fac.config = appConfig;

            fac.query = function(sql, callback) {
                $log.log('Query: '+ sql);

                var url=encodeURI(this.config.orientBaseUrl+"query/"+this.config.dbName+"/sql/"+sql);
                $log.log('Request URI: '+ url);

                connectOrientDb()
                .then($http.get(url)
                    .then(function(response){ //Success
                            callback(response.data);
                        },
                        function(response){ //Failure
                            callback({
                                responseStatus: response.status,
                                responseData: response.data 
                            });
                        }));
            }

            fac.fetchCurrentDayReportIdList = function(hostMachineName){
                if(typeof(hostMachineName)  === "undefined"){
                    throw { 
                        name:        "Parameter Missing", 
                        level:       "Show Stopper", 
                        message:     "Error detected. This function prameter 'hostMachineName' is mandatory to evaluate return value.", 
                        htmlMessage: "Error detected. This function prameter '<code>hostMachineName</code>' is mandatory to evaluate return value.",
                        toString:    function(){return this.name + ": " + this.message;} 
                    }; 
                }

                var sql = "select @rid as rid, runOfDay from TestResult where executorPlatformData.machineName='"+hostMachineName+"'";

                var defer = $q.defer()
                this.query(sql,
                        function(data){
                            defer.resolve(data);
                        });
                return defer.promise;

            }

            var connectOrientDb = function(){
                var url=encodeURI(appConfig.orientBaseUrl+"connect/"+appConfig.dbName);
                var req ={
                             method: 'GET',
                             url: url,
                             headers: {
                               'Authorization': appConfig.authPayload
                             }
                         };
                $log.log('Request: '+req);
                var defer = $q.defer();
                $http(req).then(
                        function(res){ //Success
                            $log.log('Response: '+res);
                            defer.resolve(res);
                        }, 
                        function(res){ //Failure
                            /*throw {
                                name:   "Connection Failed",
                                level:  "Show Stopper",
                                message: "Error detected ("+response.status+"). Unable to connect to configured database.",
                                htmlMessage: "Error detected ("+response.status+"). Unable to connect to configured database.",
                                toString:    function(){return this.name + ": " + this.message;}
                            };*/
                            defer.reject(res);
                        }
                    );
                return defer.promise;
            }

            return fac;

        }
    ]);

调用< code > fetchCurrentDayReportIdList()时出现错误。谁能给我一个参考实现或者指出我的代码有什么问题吗？

注意:

全局变量appConfig包含一个格式如下的JSON对象。

    {
        "orientBaseUrl": "http://localhost:2480/",
        "dbName": "atudb",
        "dbUser": "root",
        "authPayload": "cm9vdDphZG1pbg==",
        "dbPassword": "admin",
        "formatDateTime": "yyyy-MM-dd HH:mm:ss"
    }

Answer 1

在< code>appConfig中，尝试在authPayLoad中添加< code>Basic

“AuthPayload”：“基本cm9vdDphZG1pbg==”

当然，像上面所说的@wolf4ood那样启用CORS。