AWS RDS MySQL, API Gateway, AWS Lambda

W Toku Opublikowano 5 lat temu Płatność przy odbiorze
W Toku Płatność przy odbiorze

i would like to have a MySQL database with 2 tables (users and Transactions) which can be exposed with AWS API Gateway and AWS Lambda.

Free lancer who will be assigned the project will have the responsibility to develop a 100% bug free project and will be responsible to submit a step by step guide explaining how to install the code and how to run and execute the code properly.

the potential candidate to the project should have previous experience in dealing with AWS.

the API developed here should be protected (HTTPS and token)

Users table fields:

user_id primary key, INT auto increment,

phone_number (format +0000000),

old_phone_number VARCHAR (format +0000000),

created_date TIMESTAMP,

network INT,

status INT,

last updated TIMESTAMP,

last_updated_by VARCHAR

renew INT

Transaction table fields:

transaction_id key, INT auto increment

user_id INT

phone_number VARCHAR (format +00000)

Start_date TIMESTAMP

Expiry_date TIMESTAMP

Payment_method VARCHAR

transaction_reference VARCHAR

API needed (HTTPS)

- checkUser (parameter phone) - return (1 + user_id+ status + network + created_date) if phone is in users table (phone_number and old_phone_number) or 0 if doesn't exist in database)

-newTransaction (Parameter: phone + Date + expiry_date + transaction_id + payment_method) - insert into transaction table, return 1 for success and 0 for failure

- stopAutoRenew - (parameter: phone_number) update users table, change renew field to 0

-changePhoneNumber (Parameter: old_phone, new_phone) update user table, put new_phone in phone_number and old_phone in old_phone_number

-suspendAccount (Parameter: phone_number) update users table, set status to 0

-reactivate Account (Parameter: phone_number) update users table, set status to 1

+ a couple of other simple API that we will determine later

Amazon Web Services API AWS Lambda MySQL

Numer ID Projektu: #17888394

O projekcie

4 ofert Zdalny projekt Aktywny 5 lat temu

4 freelancerów złożyło ofertę za $221 w tym projekcie

CronJobTechs

Hello sir..... Interested in creation of your database project..... Text back if interested Thanks >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

$250 USD w ciągu 3 dni
(2 Oceny)
2.5
byrapuns1

About Me: Cloud Architect with over 12 years of experience in designing solutions for large Enterprise and SMB’s. Skilled in IT Infrastructure Management (Data center, Networking, Server, Storage, Virtualization and Cl Więcej

$250 USD w ciągu 10 dni
(0 Oceny)
0.0