1) How to set Content Type for Individualform data : https://stackoverflow.com/questions/21329426/spring-mvc-multipart-request-with-json Fix for : UNSUPPORTEDMEDIATYPEEXCEPTION: CONTENT TYPE 'APPLICATION/OCTET-STREAM' NOT SUPPORTED FOR (List options)
create table question (
questionid uuid not null,
answer_index bigint not null,
options jsonb not null,
question_img oid not null,
question_number SERIAL not null,
question_text varchar(255),
fk_project_uuid uuid,
primary key (questionid)
)
1 ) https://www.toptal.com/spring/spring-security-tutorial
2 ) https://github.com/jwtk/jjwt#jwt-create
3 ) https://github.com/jwtk/jjwt#quickstart
4 ) Auto incremented number generation for a Non-Primary key column
5 ) Query by Example : https://github.com/spring-projects/spring-data-commons/blob/main/src/main/asciidoc/query-by-example.adoc
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "question_number", unique = true, nullable = false, insertable = false, updatable = false)
// JUST @GeneratedValue(strategy = GenerationType.IDENTITY) doesn't work
- Install PostgreSQL Locally
- Configure Username and Password in properties file (spring) and also ENV VARIABLE DB_PASSWORD ;PRIVATE_KEY
- Disable Auth because Login and Logout is pending in Frontend
// to disable replace auth.requestMatchers("/auth/**") to
auth.requestMatchers("**")
- Create Type (eg : MCQ) in USING admin http://localhost:4200/admin
- Create Project using admin page
- Add question using http://localhost:4200/admin/questions
- docker-compose -f docker-compose.yaml up --build