RESTAPI
Notes (CRUD) and Authentication Using ktor (Kotlin)
and mySQL Database
.
Runs embedded web server on localhost:8080 (baseurl)
.
GET
All Notes.
{baseurl}/notes
GET
One Note By ID.
{baseurl}/notes/{id}
POST
One Note.
{baseurl}/notes
your json request
{
"note":"write your note"
}
PUT
Note By ID.
{baseurl}/notes/{id}
your json request
{
"note":"update your note"
}
DELETE
Note By ID.
{baseurl}/notes/{id}
POST
Login User.
{baseurl}/login
your json request
{
"userName":"mosamir",
"password":"1234567"
}
POST
Register User.
{baseurl}/register
your json request
{
"userName":"mosamir",
"password":"1234567"
}
can use MySQL Workbench
for create your database.
- Create Database.
create database notes;
- Select Database For Use.
USE notes;
- Create Notes Table.
create table note(
id int not null auto_increment,
note varchar(1500) not null,
primary key(id)
);
- Create Users Table.
create table users(
id int not null auto_increment,
userName varchar(100) not null,
password varchar(100) not null,
primary key(id)
);