Adding @dev-wso2 <[email protected]> On Thu, Oct 18, 2018 at 5:25 PM Nuwan Dias <[email protected]> wrote:
> Please discuss technical problems externally. > > On Thu, Oct 18, 2018 at 3:44 PM Mushthaq Rumy <[email protected]> wrote: > >> Hi All, >> >> While I was implementing the view page for API document (File) I came >> across an issue where we get the file name as null when using the >> micro-service to get the content of the the API document. >> While analyzing, when adding a file as an API document, I found out that >> first we save only the doc metadata and then we save the file content >> using a second call. >> >> After analyzing the DB scripts I figured out that the fileName is stored >> in AM_API_DOC_META_DATA table and the content is stored in >> AM_API_RESOURCES. So during the first call we do not have the file name and >> it is saved as null. During the second call the fileName is passed to the >> micro-service but it is not stored anywhere. Hence, the fileName is null >> when we get the content of the file. So to solve this issue, I thought of >> two solutions. >> >> 1. During the second call while adding a file document for API as we get >> the FileName to the micro-service we can retrieve the document metadata >> using the documentId and update the fileName apart from saving the content. >> Hence, it will be available when retrieving the content. >> >> 2. We can change the fileName field from AM_API_DOC_META_DATA to >> AM_API_RESOURCES as the content of the document is stored in this table. >> And while saving the content we can save it with the fileName. Hence, it >> will be available when retrieving the content. >> >> IMO as option 1 will have more DB calls, option 2 would be the preferred >> solution. >> >> Appreciate your valuable inputs. >> >> Thanks & Regards, >> Mushthaq >> -- >> Mushthaq Rumy >> *Senior Software Engineer* >> Mobile : +94 (0) 779 492140 >> Email : [email protected] >> WSO2, Inc.; http://wso2.com/ >> lean . enterprise . middleware. >> >> <http://wso2.com/signature> >> > > > -- > *Nuwan Dias* | Director | WSO2 Inc. > (m) +94 777 775 729 | (e) [email protected] > [image: Signature.jpg] > -- Mushthaq Rumy *Senior Software Engineer* Mobile : +94 (0) 779 492140 Email : [email protected] WSO2, Inc.; http://wso2.com/ lean . enterprise . middleware. <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
