Tamamlanmış

AWS Lambda with API to build a SQL query

I need a Lambda with API enabled that can take IDs list and Column names and give an output as a SQL Query. For example I give 1,2,3 as IDs , Name , Number, Color as column names. Then output should be

'Select Name, Number, Color

from NameTable a

inner join NumberTable b on [login to view URL] = [login to view URL]

inner join ColorTable c on [login to view URL] = [login to view URL]

where IDS in ( 1,2,3) .

If the column names are only Name and Number then query should be

'Select Name, Number

from NameTable a

inner join NumberTable b on [login to view URL] = [login to view URL]

where IDS in ( 1,2,3)

Lambda should check column names and based on the column name join statement should be added dynamically to build the query.

Beceriler: Aws Lambda

Daha fazlasını gör: sql parent child query xml, sql server remote query mysql, sql parentchild tree query, aws lambda python postgresql, aws lambda mysql example, amazon rds rest api, aws lambda connect to oracle database, aws lambda rds connection pool, aws lambda dashboard, aws lambda connect to sql server c#, aws lambda python mysql, sql add decimal query oracle, sql microsoft project query, oracle sql order date query example, aspnet build crystal report depending query, sql server 2008 query latitude longitude radius, oracle sql format currency query, sql database size query, wcf application insert database sql 2008 vbnet query, php sql main menu query

İşveren Hakkında:
( 1 değerlendirme ) India, India

Proje NO: #20785008

Seçilen:

Nil9985

hello, I have 6+ years of experience in AWS and lambda, will be glad to work on this project. thanks, Nilesh

%selectedBids___i_period_sub_7% gün içinde 3333%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 4 freelancer ortalamada ₹3458 teklif veriyor

sayansaha986

Hi, I can write a lambda function to return the SQL result as API endpoint. Let's have chat to discuss further on this project. Thanks, Sayan

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(3 Değerlendirme)
2.0
piyushlahoti

I have total 6+ Years of experience in development. I am working on AWS from long time. I have understood your requirements. I will deliver this with in time.

₹3800 INR in 7 gün içinde
(0 Değerlendirme)
0.0
RacoNZ

Hi there, Sounds quite straightforward. When you mention "API Enabled", does that mean you want an AWS API Gateway service there? or is it because you already have an API Endpoint which will be pointing and triggerin Daha Fazla

₹3700 INR in 3 gün içinde
(0 Değerlendirme)
0.0