Find conversation Between Specific Set of User ID's - Mailboxer Rails -


the title of question says all, wondering if can me find conversation exists between specific set of user id's. basically, if tries start conversation set of users, if conversation exact set of users exists, want app load conversation rather create one. proper query this? tried looking @ conversation class: http://rubydoc.info/gems/mailboxer/conversation. when run

conversation.first.participants

i can see participants in conversation, didn't see way query conversation contains set of id's.

what want able like:

find conversation participants [current_user.id, 3, 5]

and match conversation participants id's [current_user.id, 3, 5] not conversation participants id's [current_user.id, 3] or conversation participants id's [current_user.id, 3, 5, 7].

after referencing mailboxer coversation doc , sql finding records have same relationships , rails query doc

i think should work

participants_id = [current_user.id, 3, 5] select('distinct mailboxer_conversations.*').   where('mailboxer_notifications.type'=> mailboxer::message.name).   order("mailboxer_conversations.updated_at desc").   joins(:receipts).where('mailboxer_receipts.receiver_id in (#{participants_id.join(",")}) , mailboxer_receipts.receiver_type => #{current_user.class.base_class.to_s})')').group('mailboxer_conversations.id').having('count(1) = #{participants_id.length}')

the first part of query 

participants_id = [current_user.id, 3, 5] select('distinct mailboxer_conversations.*').   where('mailboxer_notifications.type'=> mailboxer::message.name).   order("mailboxer_conversations.updated_at desc").   joins(:receipts).where('mailboxer_receipts.receiver_id in (#{participants_id.join(",")} , mailboxer_receipts.receiver_type => #{current_user.class.base_class.to_s})')

is used mailboxer if user participant or not

the second part 

.group('mailboxer_conversations.id').having('count(1) = #{participants_id.length}')

is used group results conversation id , filters results not repeated each participant means return 1 has relation of them.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more