src/main/java/me/imsonmia/epqapi/repository/UserRepository.java


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

package me.imsonmia.epqapi.repository;

import java.util.Optional;

import org.springframework.data.repository.CrudRepository;

import me.imsonmia.epqapi.model.User;

public interface UserRepository extends CrudRepository<User, Long> {
    Optional<User> findByUserName(String userName);

    boolean existsByUserName(String userName);
}
// NOTE timestamp is a reserved SQL keyword
// create table user (date_joined datetime(6), id bigint not null, user_name
// varchar(255), primary key (id)) engine=InnoDB
// create table message (id bigint not null, timestamp bigint, content
// varchar(255), from varchar(255), to varchar(255), primary key (id))
// engine=InnoDB