hibernate - Spring Data JPA repository query builder, many to many relationship -

-

i want construct find query in repository interface select elements mapped many many relationship.

user.java:

@entity @table(name = "user") public class user {     @id     @column(name = "id", columndefinition = "binary(16)")     private uuid id;      @column(name = "username")     private string username;      @column(name = "email")     private string email;      @column(name = "passwordhash")     private string passwordhash;      @manytomany(mappedby = "userstracking")     private set<show> shows; ...

show.java:

@entity @table(name = "shows") public class show {      @id     @column(name = "id", columndefinition = "binary(16)")     private uuid id;      @column(name = "imdb_id", length = 9, nullable = false)     private string imdbid;      @column(name = "title", length = 100, nullable = false)     private string title;      @column(name = "poster_url", length = 255, nullable = true)     private string posterurl;      @column(name = "rating", length = 3, nullable = true)     private double rating;      @column(name = "genre", length = 100, nullable = true)     private string genre;      @manytomany     @jointable(name = "users_shows",             joincolumns = @joincolumn(name = "show_id", referencedcolumnname = "id"),             inversejoincolumns = @joincolumn(name = "user_id", referencedcolumnname = "id"))     private set<user> userstracking; ...

to achieve using query builder (i think it's called) have written repository:

public interface showrepository extends crudrepository<show, uuid> {     list<show> findbyuser(user user); }

but able shows userrepository rather showrepository, should write this?

public interface userrepository extends crudrepository<user, uuid> {     list<show> findshows();     //or maybe?     list<show> findshowsbyuser(user user); }

am understanding whole query building correctly?


Comments

Post a Comment

Popular posts from this blog

yii2 - Yii 2 Running a Cron in the basic template -

-
i have seen instructions on running cron in advanced template, cant figure out how on basic template. have following controller in basic controllers folder. <?php namespace app\controllers; use yii\console\controller; /** * cron controller */ class croncontroller extends controller { public function actionindex() { echo "cron service runnning"; } public function actionmail($to) { echo "sending mail " . $to; } } i have navigated root of application , tried these comands yii cron php yii cron im getting unknown comand "cron" i know old question failed find actual answer this. if @ code yii exec file you'll notice requires /common/config/aliases.php file console/config/main.php. can naturally change these or copy on these advanced template. hope solves problem wanting same thing.
Read more

asp.net - 'System.Web.HttpContext' does not contain a definition for 'GetOwinContext' Mystery -

-
i realize question might seem trivial some, it's these types of things find myself fighting quite bit , want make sense of despite seeming losing battle in .net (for me anyway). so, if following: using system.web; ... applicationuser user = system.web.httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); that produces error in title , red getowincontext() , error cannot resolve symbol 'getowincontext()' however, if following (remove system.web in front of httpcontext ), works expected (or @ least no errors): using system.web; ... applicationuser user = httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); however, if (same line that's working using system.web commented out): //using system.web; ... applicationuser user = httpcontext.getowincontext().getusermana
Read more

php - How do you embed a video into a custom theme on WordPress? -

-
i'm using wordpress 4.2.3 , created custom theme use. when try embed youtube video (pasting http:// link content area), video shows in edit content area, when view site, shows text url instead. i tried sorts of things clear formatting, removing link, unchecking settings in writing area, etc. temporarily switched default wp theme , video shows up, i'm missing in template code, , can't figure out what. here code used outputting content in template. index.php <div class="video"> <?php $post_id = 26; $queried_post = get_post($post_id); echo $queried_post->post_content; ?> </div> thanks - appreciate it!
Read more