iGarment Wiki

User Tools

Site Tools

Trace:
en:db_api

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:db_api [2026/06/03 09:47] – administratoren:db_api [2026/06/05 07:14] (current) – administrator
Line 1: Line 1:
-====== Datebase API ======+====== Database API ======
  
 ===== iGarment API: Query ===== ===== iGarment API: Query =====
Line 36: Line 36:
 Example, single SQL Example, single SQL
  
-  
    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;
    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo
-  
  
 Return data Return data
Line 63: Line 61:
 Example, multiple select Example, multiple select
  
-SELECT * FROM table1; +  SELECT * FROM table1; 
-SELECT * FROM table2;+  SELECT * FROM table2;
  
 You should get the select data of 'table2'. You should get the select data of 'table2'.
Line 70: Line 68:
 Example, multple select return mutlipe dataset Example, multple select return mutlipe dataset
  
-SELECT * FROM table1 into table1; +  SELECT * FROM table1 into table1; 
-SELECT * FROM table2;+  SELECT * FROM table2;
  
 The return data will be a list of two elements with the following structure. The return data will be a list of two elements with the following structure.
Line 87: Line 85:
 You may also store data into temporay table to be used by subsequence select.  If you use temporay table, the temporary table name must be started with T_. You may also store data into temporay table to be used by subsequence select.  If you use temporay table, the temporary table name must be started with T_.
  
-~~~sql +  SELECT * FROM table1 INTO TEMPORARY TABLE T_A; 
-SELECT * FROM table1 INTO TEMPORARY TABLE T_A; +  CREATE INDEX T_A_KEY1 ON (order); 
-CREATE INDEX T_A_KEY1 ON (order);+ 
 +  SELECT * FROM table2 LEFT JOIN T_A WHERE T_A.order > 1000; 
 +  DROP INDEX T_A_KEY1; 
 +   
 +===== iGarment API: Get file =====
  
-SELECT * FROM table2 LEFT JOIN T_A WHERE T_A.order > 1000; 
-DROP INDEX T_A_KEY1; 
-iGarment API: Get file 
 API to download file. Supported method is GET. API to download file. Supported method is GET.
  
Line 99: Line 98:
  
 <file_name> is real file name saved in system, can query it from attach table or system image table. <file_name> is real file name saved in system, can query it from attach table or system image table.
-Request Example+ 
 +**Request Example**
  
 eg: get style image (example with trial505, https://trial505.igx.biz/api) eg: get style image (example with trial505, https://trial505.igx.biz/api)
 +
 step 1. get real file name from system image table: ~/db/query step 1. get real file name from system image table: ~/db/query
  
-sql: select b.ImageType, b.RealFileName from SAYSKTCH a inner join SYIMAGE b on b.ImageID = a.ImageID where a.OrderNo = 'BEI-TEST24-001'+  sql: select b.ImageType, b.RealFileName from SAYSKTCH a inner join SYIMAGE b on b.ImageID = a.ImageID where a.OrderNo = 'BEI-TEST24-001'
 return: return:
    [{    [{
Line 111: Line 112:
         "records":  [["JPG","b9b957b159d66ceec231a26c776dd9d390"]]         "records":  [["JPG","b9b957b159d66ceec231a26c776dd9d390"]]
     }]     }]
 +    
 step 2. url: ~/db/get_file/b9b957b159d66ceec231a26c776dd9d390 step 2. url: ~/db/get_file/b9b957b159d66ceec231a26c776dd9d390
  
-Return Example+**Return Example**
  
-{+  {
   "file_name": "b9b957b159d66ceec231a26c776dd9d390",  #file name, same as query param   "file_name": "b9b957b159d66ceec231a26c776dd9d390",  #file name, same as query param
   "file_type": "",   #file suffix   "file_type": "",   #file suffix
   "data": "iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAIAAAAHjs1qAAAACXBIWXMAAAsSAAALEgHS3X78AAAgAElEQVR4nOy9WZckSXYedu...... sfuTm4f5Wv8uXknobmV/kqf6N8hftX+Q3JV7h/ld+QfIX7V/kNyVe4f5XfkHyF+1f5DclXuH+V35B8hftX+Q3J/w+JbeR8InngWAAAAABJRU5ErkJggg=="   "data": "iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAIAAAAHjs1qAAAACXBIWXMAAAsSAAALEgHS3X78AAAgAElEQVR4nOy9WZckSXYedu...... sfuTm4f5Wv8uXknobmV/kqf6N8hftX+Q3JV7h/ld+QfIX7V/kNyVe4f5XfkHyF+1f5DclXuH+V35B8hftX+Q3J/w+JbeR8InngWAAAAABJRU5ErkJggg=="
    # file data, encoded in Base64    # file data, encoded in Base64
-} +  } 
-If file_type is blank, can get file type from system image table.+   
 +''If file_type is blank, can get file type from system image table.''
en/db_api.1780480073.txt.gzip · Last modified: by administrator