Mixing
How to save multiple tables using Spring Boot JpaRepository and their MySQL script
//Restaurant entity class
public class Restaurant {
@GeneratedValue
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String name;
@OneToMany(mappedBy = "restaurant", cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true)
private List<Menu> menus;
}
//Menu entity class
public class Menu {
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String type;
@NotBlank
private String info;
@ManyToOne
@JoinColumn(name = "restaurant_id")
private Restaurant restaurant;
}
I have two entities: one is Restaurant and another is menu with end points
/restaurants
GET - get all restaurants
POST - upload restaurant
PUT - Update restaurant
DELETE - delete all restaurant
/restaurants/{id}
GET - get a restaurant by id
DELETE - delete a restaurant by id
/restaurants/{id}/menus/
GET - get all menus in the restaurant specified by id
POST - add new menus in the restaurant specified by id
DELETE - delete all menus in the restaurant specified by id
Now could you please check weather the entity class are correct and please provide me with the MySQL script to the above entities
java spring spring-data-jpa
edited Nov 20 '18 at 11:19
lospejos
1,42921426
asked Nov 20 '18 at 9:28
akashakash
33
add a comment |
//Restaurant entity class
public class Restaurant {
@GeneratedValue
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String name;
@OneToMany(mappedBy = "restaurant", cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true)
private List<Menu> menus;
}
//Menu entity class
public class Menu {
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String type;
@NotBlank
private String info;
@ManyToOne
@JoinColumn(name = "restaurant_id")
private Restaurant restaurant;
}
I have two entities: one is Restaurant and another is menu with end points
/restaurants
GET - get all restaurants
POST - upload restaurant
PUT - Update restaurant
DELETE - delete all restaurant
/restaurants/{id}
GET - get a restaurant by id
DELETE - delete a restaurant by id
/restaurants/{id}/menus/
GET - get all menus in the restaurant specified by id
POST - add new menus in the restaurant specified by id
DELETE - delete all menus in the restaurant specified by id
Now could you please check weather the entity class are correct and please provide me with the MySQL script to the above entities
java spring spring-data-jpa
edited Nov 20 '18 at 11:19
lospejos
1,42921426
asked Nov 20 '18 at 9:28
akashakash
33
add a comment |
//Restaurant entity class
public class Restaurant {
@GeneratedValue
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String name;
@OneToMany(mappedBy = "restaurant", cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true)
private List<Menu> menus;
}
//Menu entity class
public class Menu {
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String type;
@NotBlank
private String info;
@ManyToOne
@JoinColumn(name = "restaurant_id")
private Restaurant restaurant;
}
I have two entities: one is Restaurant and another is menu with end points
/restaurants
GET - get all restaurants
POST - upload restaurant
PUT - Update restaurant
DELETE - delete all restaurant
/restaurants/{id}
GET - get a restaurant by id
DELETE - delete a restaurant by id
/restaurants/{id}/menus/
GET - get all menus in the restaurant specified by id
POST - add new menus in the restaurant specified by id
DELETE - delete all menus in the restaurant specified by id
Now could you please check weather the entity class are correct and please provide me with the MySQL script to the above entities
java spring spring-data-jpa
edited Nov 20 '18 at 11:19
lospejos
1,42921426
asked Nov 20 '18 at 9:28
akashakash
33
//Restaurant entity class
public class Restaurant {
@GeneratedValue
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String name;
@OneToMany(mappedBy = "restaurant", cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true)
private List<Menu> menus;
}
//Menu entity class
public class Menu {
@Id
private Long id;
@NotBlank
@Size(min = 3, max = 50)
private String type;
@NotBlank
private String info;
@ManyToOne
@JoinColumn(name = "restaurant_id")
private Restaurant restaurant;
}
I have two entities: one is Restaurant and another is menu with end points
/restaurants
GET - get all restaurants
POST - upload restaurant
PUT - Update restaurant
DELETE - delete all restaurant
/restaurants/{id}
GET - get a restaurant by id
DELETE - delete a restaurant by id
/restaurants/{id}/menus/
GET - get all menus in the restaurant specified by id
POST - add new menus in the restaurant specified by id
DELETE - delete all menus in the restaurant specified by id
Now could you please check weather the entity class are correct and please provide me with the MySQL script to the above entities
java spring spring-data-jpa
java spring spring-data-jpa
edited Nov 20 '18 at 11:19
lospejos
1,42921426
asked Nov 20 '18 at 9:28
akashakash
33
edited Nov 20 '18 at 11:19
lospejos
1,42921426
asked Nov 20 '18 at 9:28
akashakash
33
edited Nov 20 '18 at 11:19
lospejos
1,42921426
edited Nov 20 '18 at 11:19
lospejos
1,42921426
edited Nov 20 '18 at 11:19
lospejos
1,42921426
1,42921426
asked Nov 20 '18 at 9:28
akashakash
33
asked Nov 20 '18 at 9:28
akashakash
33
asked Nov 20 '18 at 9:28
akashakash
33
33
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You should start with the documentation :
https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html
After that you can see other examples here or here
answered Nov 20 '18 at 10:47
redoffredoff
463410
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53389907%2fhow-to-save-multiple-tables-using-spring-boot-jparepository-and-their-mysql-scri%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You should start with the documentation :
https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html
After that you can see other examples here or here
answered Nov 20 '18 at 10:47
redoffredoff
463410
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
add a comment |
You should start with the documentation :
https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html
After that you can see other examples here or here
answered Nov 20 '18 at 10:47
redoffredoff
463410
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
add a comment |
You should start with the documentation :
https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html
After that you can see other examples here or here
answered Nov 20 '18 at 10:47
redoffredoff
463410
You should start with the documentation :
https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html
After that you can see other examples here or here
answered Nov 20 '18 at 10:47
redoffredoff
463410
answered Nov 20 '18 at 10:47
redoffredoff
463410
answered Nov 20 '18 at 10:47
redoffredoff
463410
answered Nov 20 '18 at 10:47
redoffredoff
463410
463410
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
add a comment |
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
could you please provide the sql script for the above
– akash
Nov 20 '18 at 10:57
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
Please read the documentation. If you use Spring Data Jpa Repository, there is no need to write sql scripts. The framework will do it for you
– redoff
Nov 20 '18 at 10:58
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53389907%2fhow-to-save-multiple-tables-using-spring-boot-jparepository-and-their-mysql-scri%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
