wso2 api管理器数据库 [英] wso2 api manager database

问题描述

我不明白如何访问 API (api_id) USER (user_id) 的数据，订阅(用户 'x' 是否订阅了 API 'y'?)...

I don't understand how can I access the data of APIs (api_id) USER (user_id), subscriptions (is a user 'x' subscribed to API 'y'?) ...

如何通过连接到某些数据库来执行此类控制?

推荐答案

虽然你的问题不是很清楚，但希望你想知道WSO2 API Manager是如何实现数据库数据访问部分的.我将解释WSO2 API Manager是如何控制的超过数据库数据.

Though your question is not much clear,hope you want to know how WSO2 API Manager implemented database data accessing part.I'll explain how WSO2 API Manager did controlling over database data.

您可以从 [1] 中找到 WSO2 API Manager 使用的数据库脚本[它包含 h2/mysql/oracle dbscripts]，用于创建它的数据库表结构.您会注意到有单独的数据库表要存储有关 API [AM_API] 、订阅者 [AM_SUBSCRIBER] 和订阅 [AM_SUBSCRIPTION] 等的信息.您会注意到如何使用外键来启用表之间的关系以执行对数据的控制，同时确保数据以一致的方式存储.

You could found the database scripts[it contains h2/mysql/oracle dbscripts] use by WSO2 API Manager from [1] which used to create the database table structure of it.You'll notice there are separate database tables to store information on APIs[AM_API] ,subscribers[AM_SUBSCRIBER] and subscriptions[AM_SUBSCRIPTION],etc.And you'll notice how foreign keys have been used to enable relationships among tables to perform controls over data while ensuring that the data stored in a consistent way.

然后有一个为 WSO2 API Manager 相关的后端功能定义的内置 java API，您可以从 [2] 中找到它，并且可以从 [3] 中找到其实现的 java 代码.如果您查看 ApiMgtDAO.javaorg.wso2.carbon.apimgt.impl 包中的类实现，您将更好地了解 API Manager 的数据库访问层是如何通过查询数据库数据来实现的.

Then there's an inbuilt java API defined for WSO2 API Manager related back-end functionalities and you can found it from [2] and its implemented java code can be found from [3].If you have a look on ApiMgtDAO.java class implementation in org.wso2.carbon.apimgt.impl bundle,you'll get a better understanding how the database access layer for API Manager implemented with querying through database data.

希望以上内容对您有所帮助.

Hope above will help to you.

谢谢；

/拉拉吉

[1] https://svn.wso2.org/repos/wso2/carbon/platform/branches/4.0.0/products/apimgt/1.0.0/modules/distribution/resources/sql/

[2]https://svn.wso2.org/repos/wso2/carbon/platform/branches/4.0.0/components/apimgt/org.wso2.carbon.apimgt.api/1.0.0/

[2]https://svn.wso2.org/repos/wso2/carbon/platform/branches/4.0.0/components/apimgt/org.wso2.carbon.apimgt.api/1.0.0/

[3]https://svn.wso2.org/repos/wso2/carbon/platform/branches/4.0.0/components/apimgt/org.wso2.carbon.apimgt.impl/1.0.0/

[3]https://svn.wso2.org/repos/wso2/carbon/platform/branches/4.0.0/components/apimgt/org.wso2.carbon.apimgt.impl/1.0.0/

这篇关于wso2 api管理器数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！