Hi Uvindra, What could be the possible values for ENVIRONMENT_CATEGORY column? Also, at a time, only one environment will be supported by the APIM, Do we really need AM_API_ENVIRONMENTS table?
On Tue, Nov 15, 2016 at 3:46 PM, Uvindra Dias Jayasinha <[email protected]> wrote: > As part of the C5 effort we need to evaluate how we are to persist API > Endpoint and API Environment information. Here is a brief introduction of > what each of these are. > > *API Endpoint* > The actual backend endpoint that a API created in APIM fronts. In C4 these > were defined as Production and Sandbox endpoints. So at DB table level we > could represent this as follows, > > CREATE TABLE `AM_API_ENDPOINTS` ( > `API_ID` INTEGER, > `ENVIRONMENT_CATEGORY` VARCHAR(30), > `ENDPOINT_TYPE` VARCHAR(30), > `IS_ENDPOINT_SECURED` BOOLEAN, > `TPS` INTEGER, > `AUTH_DIGEST` VARCHAR(30), > `USERNAME` VARCHAR(255), > `PASSWORD` VARCHAR(255) > ); > > This naturally maps to our current concepts that already exist in C4. > > *API Environment* > This represents different gateway environments across which a given API > can be deployed on such as Dev, QA, Production. So at DB table level we > could represent this as follows, > > CREATE TABLE `AM_API_ENVIRONMENTS` ( > `API_ID` INTEGER, > `ENV_NAME` VARCHAR(255), > `HTTP_URL` VARCHAR(255), > `HTTPS_URL` VARCHAR(255), > `APPEND_CONTEXT` BOOLEAN > ); > > > Is there an overlap between these two concepts in the way we are > representing them here? > > Please give your feedback. > > -- > Regards, > Uvindra > > Mobile: 777733962 > -- Thanks Abimaran Kugathasan Senior Software Engineer - API Technologies Email : [email protected] Mobile : +94 773922820 <http://stackoverflow.com/users/515034> <http://lk.linkedin.com/in/abimaran> <http://www.lkabimaran.blogspot.com/> <https://github.com/abimarank> <https://twitter.com/abimaran>
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
