[InterMine Dev] Questions on production database schema

JD Wong jdmswong at gmail.com
Tue Aug 6 15:01:36 BST 2013


Thanks Julie!

I have a follow up question if you don't mind, do you know if there is a
way to track the number of records added per source?  I'm interested in
writing tests to make sure each source is adding the proper number of
records, even for non-bioentity data types.

Cheers!
-JD


On Mon, Aug 5, 2013 at 6:32 AM, Julie Sullivan <julie at flymine.org> wrote:

>
> On 02/08/13 21:01, JD Wong wrote:
>
>> Come to think of it, I think this relationship is mapped in the
>> bioentitiesdatasets table.
>>
>
> Yes, that's right!
>
>
> I'm curious, is there another way records
>
>> are mapped to datasets ( besides tracker ), like for non-bioentity
>> classes?
>>
>
> No, not in the core model I don't think.
>
>  Thanks!
>> -JD
>>
>>
>> On Fri, Aug 2, 2013 at 1:32 PM, JD Wong <jdmswong at gmail.com
>> <mailto:jdmswong at gmail.com>> wrote:
>>
>>     Thanks Julie, that works well.  It would also be helpful to have the
>>     "dataset" object query too if that wouldn't be a problem, just to
>>     have that as a reference.
>>
>>     Cheers,
>>     -JD
>>
>>
>>     On Fri, Aug 2, 2013 at 10:34 AM, Julie Sullivan <julie at flymine.org
>>     <mailto:julie at flymine.org>> wrote:
>>
>>         Dataset as in the InterMine "dataset" object? Or are you trying
>>         to find out which data parser loaded which object?
>>
>>         If it's the latter, you can do this:
>>
>>         select distinct objectid from tracker where source_name =
>> 'uniprot';
>>
>>         The object id is the InterMine ID.
>>
>>         The `bag` tables are created when a user makes a list. When the
>>         user logs in the list is transferred to the userprofile, I think.
>>
>>
>>         On 02/08/13 15:13, JD Wong wrote:
>>
>>             Hi Dev,
>>
>>             I'm looking more closely at my mine's production database,
>>             and I was
>>             wondering a few things I hope someone here can shed some
>>             light on.
>>
>>             How are dataset tables linked to data, can i write an SQL
>>             query along
>>             the lines of " which records are in this dataset"?
>>
>>             There are also a bunch of bag tables like:
>>             public | integer_bag_1019                        | table
>>               | intermine
>>                public | integer_bag_1020                        | table
>>                 | intermine
>>                public | integer_bag_1021                        | table
>>                 | intermine
>>                public | integer_bag_228                         | table
>>                 | intermine
>>                public | integer_bag_229                         | table
>>                 | intermine
>>                public | integer_bag_231                         | table
>>                 | intermine
>>
>>             there many of these, and for string_bag too, does anyone
>>             know what they
>>             are for?
>>
>>             Thank you!
>>             -JD
>>
>>
>>             ______________________________**___________________
>>             dev mailing list
>>             dev at intermine.org <mailto:dev at intermine.org>
>>             http://mail.intermine.org/cgi-**__bin/mailman/listinfo/dev<http://mail.intermine.org/cgi-__bin/mailman/listinfo/dev>
>>             <http://mail.intermine.org/**cgi-bin/mailman/listinfo/dev<http://mail.intermine.org/cgi-bin/mailman/listinfo/dev>
>> >
>>
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.intermine.org/pipermail/dev/attachments/20130806/530dbb8c/attachment.html>


More information about the dev mailing list