API for making direct sql requests to a MSSQL or Postgresql dataabses It used to make an API for PostgreSQL or MSSQL databases for fast deploying simple db-related API's for checking the data (like firebase) Being silly and easy it provides fast queries to database and correct json responses, and it's still used for simple prototyping and data exchange for easy and on-testing web, mobile, desktop apps.
Request for Select query
| url | method |
|---|---|
| 127.0.0.1:8000/api/v1/make-db-request | POST |
{
"query_string": "select * from tbl_mg_materials",
"base64_columns": [ "group_code", "image_pict", "firm_id_guid"]
//"query_string": "select \"ResName\" from tbl_dk_resource",
}base64_columns - are the ones you prefer to be encoded in base64. You need it mostly in image BLOB
Response
{
"data": [
{
"T_ID": 1,
"a_status_id": 1,
"acc_card_cost_of_sale_id": 108,
"acc_card_inventory_id": 237,
"acc_card_purches_disc_id": 0,
"acc_card_purches_id": 0,
"acc_card_purches_ret_id": 0,
"acc_card_sale_disc_id": 36,
"acc_card_sale_id": 34,
"acc_card_sale_ret_id": 35,
"acc_card_scrap_id": 64,
"acc_card_usage_id": 64,
"data_send": 0,
"dept_id": 1,
"div_id": 1,
"firm_id": 1,
"firm_id_guid": "CAB9C297-C332-4BF1-AD3B-A27154BEEC7C",
"group_code": "SALAT",
"m_cat_id": 14,
"mat_auto_price": "0.00000",
"mat_auto_production": 0,
"mat_brand_code": "",
"mat_height": "0.00000",
"mat_last_purch_arap_id": 0,
"mat_length": "0.00000",
"mat_manufacturer": null,
"mat_name_lang1": "WINIGRET ",
"mat_name_lang2": "",
"mat_name_lang3": "",
"mat_name_lang4": "",
"mat_name_lang5": "",
"mat_online_isvisible": null,
"mat_real_price": "0.00000",
"mat_shop_code": "",
"mat_size_code": "",
"mat_weight": "0.00000",
"mat_width": "0.00000",
"material_code": "AN00000049",
"material_description": "",
"material_description1": "",
"material_id": 49,
"material_id_guid": "d0d43809-d242-43b0-acf7-0e4812bb2e94",
"material_name": "WINIGRET ",
"modify_date": "2021-03-18T16:00:33.523Z",
"security_code": "KUHNYA",
"spe_code": "",
"spe_code1": "",
"spe_code10": "",
"spe_code11": "",
"spe_code12": "",
"spe_code13": null,
"spe_code14": null,
"spe_code15": null,
"spe_code2": "",
"spe_code3": "",
"spe_code4": "",
"spe_code5": "",
"spe_code6": "",
"spe_code7": "",
"spe_code8": "",
"spe_code9": "",
"sync_datetime": null,
"unit_det_id": 1,
"unit_id": 1
},
{
"T_ID": 1,
"a_status_id": 1,
"acc_card_cost_of_sale_id": 108,
"acc_card_inventory_id": 237,
"acc_card_purches_disc_id": 0,
"acc_card_purches_id": 0,
"acc_card_purches_ret_id": 0,
"acc_card_sale_disc_id": 36,
"acc_card_sale_id": 34,
"acc_card_sale_ret_id": 35,
"acc_card_scrap_id": 64,
"acc_card_usage_id": 64,
"data_send": 0,
"dept_id": 1,
"div_id": 1,
"firm_id": 1,
"firm_id_guid": "CAB9C297-C332-4BF1-AD3B-A27154BEEC7C",
"group_code": "SALAT",
"m_cat_id": 14,
"mat_auto_price": "0.00000",
"mat_auto_production": 0,
"mat_brand_code": "",
"mat_height": "0.00000",
"mat_last_purch_arap_id": 0,
"mat_length": "0.00000",
"mat_manufacturer": null,
"mat_name_lang1": "OLWIYE ",
"mat_name_lang2": "",
"mat_name_lang3": "",
"mat_name_lang4": "",
"mat_name_lang5": "",
"mat_online_isvisible": null,
"mat_real_price": "0.00000",
"mat_shop_code": "",
"mat_size_code": "",
"mat_weight": "0.00000",
"mat_width": "0.00000",
"material_code": "AN00000050",
"material_description": "",
"material_description1": "",
"material_id": 50,
"material_id_guid": "CCC697DF-142B-449F-BF40-59C22C02E4CC",
"material_name": "OLWIYE ",
"modify_date": "2021-03-18T16:00:33.523Z",
"security_code": "KUHNYA",
"spe_code": "",
"spe_code1": "",
"spe_code10": "",
"spe_code11": "",
"spe_code12": "",
"spe_code13": null,
"spe_code14": null,
"spe_code15": null,
"spe_code2": "",
"spe_code3": "",
"spe_code4": "",
"spe_code5": "",
"spe_code6": "",
"spe_code7": "",
"spe_code8": "",
"spe_code9": "",
"sync_datetime": null,
"unit_det_id": 1,
"unit_id": 1
}
],
"status": 1,
"total": 2,
"message": "db query result"
}Request for Update | Insert | Delete query
| url | method |
|---|---|
| 127.0.0.1:8000/api/v1/make-db-request?executeOnly=1 | POST |
{
"query_string": "update tbl_dk_users set \"URegNo\" = 'SSFK123' where \"UId\" = 1"
}Response
{
"data": null,
"status": 1,
"total": 1,
"message": "db query result"
}!! Use executeOnly to make other than SELECT queries