AWS Lambda with API to build a SQL query

₹600-4000 INR

Đã hoàn thành

Đã đăng vào

gần 5 năm trước

₹600-4000 INR

Thanh toán khi bàn giao

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.

AWS Lambda

Mã dự án: 20785008

Về dự án

4 đề xuất

Dự án từ xa

Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@Nil9985

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

₹3.333 INR trong 7 ngày

0,0

(0 nhận xét)

0,0

4 freelancer chào giá trung bình ₹3.458 INR cho công việc này

@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

₹3.000 INR trong 1 ngày

5,0

(3 nhận xét)

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.

₹3.800 INR trong 7 ngày

0,0

(0 nhận xét)

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 triggering this Lambda? How would you like the output? as a simple one-off response or you want to persist it on an S3 bucket or something else? As per the description of your problem, as I already said, it's something straightforward to do. I have more than 10 years of experience and I just started on Freelancer so this could be a good chance for you and for me to do something nicely and smoothly. BTW: what programming language you'd prefer? I'd recommend nodejs or python, but I'm a Senior Software Architect and Developer so I can handle whatever you require. Cheers.

₹3.700 INR trong 3 ngày