/** * {@inheritDoc} */ @Override public GeneRecord values(UInteger value1, String value2, UShort value3, UInteger value4, UInteger value5, UInteger value6, Byte value7, UInteger value8, String value9, GeneStatus value10, String value11, Byte value12, UInteger value13, String value14, UShort value15, Timestamp value16, Timestamp value17) { value1(value1); value2(value2); value3(value3); value4(value4); value5(value5); value6(value6); value7(value7); value8(value8); value9(value9); value10(value10); value11(value11); value12(value12); value13(value13); value14(value14); value15(value15); value16(value16); value17(value17); return this; }
/** * {@inheritDoc} */ @Override public OperonTranscriptGeneRecord values(UInteger value1, UInteger value2) { value1(value1); value2(value2); return this; }
/** * {@inheritDoc} */ @Override public IntronSupportingEvidenceRecord values(UInteger value1, UShort value2, UInteger value3, UInteger value4, UInteger value5, Byte value6, String value7, BigDecimal value8, IntronSupportingEvidenceScoreType value9, Byte value10) { value1(value1); value2(value2); value3(value3); value4(value4); value5(value5); value6(value6); value7(value7); value8(value8); value9(value9); value10(value10); return this; }
/** * Create a detached, initialised SupportingFeatureRecord */ public SupportingFeatureRecord(UInteger exonId, SupportingFeatureFeatureType featureType, UInteger featureId) { super(SupportingFeature.SUPPORTING_FEATURE); set(0, exonId); set(1, featureType); set(2, featureId); }
/** * Create a detached, initialised StableIdEventRecord */ public StableIdEventRecord(String oldStableId, Short oldVersion, String newStableId, Short newVersion, UInteger mappingSessionId, StableIdEventType type, Double score) { super(StableIdEvent.STABLE_ID_EVENT); set(0, oldStableId); set(1, oldVersion); set(2, newStableId); set(3, newVersion); set(4, mappingSessionId); set(5, type); set(6, score); }
/** * {@inheritDoc} */ @Override public ExonTranscriptRecord values(UInteger value1, UInteger value2, Integer value3) { value1(value1); value2(value2); value3(value3); return this; }
/** * Create a detached, initialised DensityTypeRecord */ public DensityTypeRecord(UInteger densityTypeId, UShort analysisId, Integer blockSize, Integer regionFeatures, DensityTypeValueType valueType) { super(DensityType.DENSITY_TYPE); set(0, densityTypeId); set(1, analysisId); set(2, blockSize); set(3, regionFeatures); set(4, valueType); }
/** * Create a detached, initialised TranscriptSupportingFeatureRecord */ public TranscriptSupportingFeatureRecord(UInteger transcriptId, TranscriptSupportingFeatureFeatureType featureType, UInteger featureId) { super(TranscriptSupportingFeature.TRANSCRIPT_SUPPORTING_FEATURE); set(0, transcriptId); set(1, featureType); set(2, featureId); }
/** * Create a detached, initialised MapRecord */ public MapRecord(UInteger mapId, String mapName) { super(Map.MAP); set(0, mapId); set(1, mapName); }
void write(@NotNull final String sample, @NotNull final List<EnrichedStructuralVariant> variants) { Timestamp timestamp = new Timestamp(new Date().getTime()); final Result<Record1<UInteger>> breakendsToDelete = context.select(STRUCTURALVARIANTBREAKEND.ID) .from(STRUCTURALVARIANTBREAKEND) .innerJoin(STRUCTURALVARIANT) .on(STRUCTURALVARIANT.ID.eq(STRUCTURALVARIANTBREAKEND.STRUCTURALVARIANTID)) .where(STRUCTURALVARIANT.SAMPLEID.eq(sample)) .fetch(); // NERA: delete annotations context.delete(STRUCTURALVARIANTDISRUPTION).where(STRUCTURALVARIANTDISRUPTION.BREAKENDID.in(breakendsToDelete)).execute(); context.delete(STRUCTURALVARIANTFUSION).where(STRUCTURALVARIANTFUSION.FIVEPRIMEBREAKENDID.in(breakendsToDelete)).execute(); context.delete(STRUCTURALVARIANTBREAKEND).where(STRUCTURALVARIANTBREAKEND.ID.in(breakendsToDelete)).execute(); // NERA: delete structural variants context.delete(STRUCTURALVARIANT).where(STRUCTURALVARIANT.SAMPLEID.eq(sample)).execute(); for (List<EnrichedStructuralVariant> batch : Iterables.partition(variants, BATCH_INSERT_SIZE)) { InsertValuesStep21 inserter = context.insertInto(STRUCTURALVARIANT, STRUCTURALVARIANT.SAMPLEID, STRUCTURALVARIANT.STARTCHROMOSOME, STRUCTURALVARIANT.ENDCHROMOSOME, STRUCTURALVARIANT.STARTPOSITION, STRUCTURALVARIANT.ENDPOSITION, STRUCTURALVARIANT.STARTORIENTATION, STRUCTURALVARIANT.ENDORIENTATION, STRUCTURALVARIANT.STARTHOMOLOGYSEQUENCE, STRUCTURALVARIANT.ENDHOMOLOGYSEQUENCE, STRUCTURALVARIANT.INSERTSEQUENCE, STRUCTURALVARIANT.TYPE, STRUCTURALVARIANT.STARTAF, STRUCTURALVARIANT.ADJUSTEDSTARTAF, STRUCTURALVARIANT.ADJUSTEDSTARTCOPYNUMBER, STRUCTURALVARIANT.ADJUSTEDSTARTCOPYNUMBERCHANGE, STRUCTURALVARIANT.ENDAF, STRUCTURALVARIANT.ADJUSTEDENDAF, STRUCTURALVARIANT.ADJUSTEDENDCOPYNUMBER, STRUCTURALVARIANT.ADJUSTEDENDCOPYNUMBERCHANGE, STRUCTURALVARIANT.PLOIDY, STRUCTURALVARIANT.MODIFIED); batch.forEach(entry -> addRecord(timestamp, inserter, sample, entry)); inserter.execute(); } }
/** * Getter for <code>homo_sapiens_core_89_37.dna_align_feature.external_db_id</code>. */ public UInteger getExternalDbId() { return (UInteger) get(14); }
/** * Getter for <code>homo_sapiens_core_89_37.assembly.cmp_seq_region_id</code>. */ public UInteger getCmpSeqRegionId() { return (UInteger) get(1); }
/** * Setter for <code>homo_sapiens_core_89_37.operon_transcript.seq_region_start</code>. */ public void setSeqRegionStart(UInteger value) { set(2, value); }
/** * Setter for <code>homo_sapiens_core_89_37.karyotype.seq_region_end</code>. */ public void setSeqRegionEnd(UInteger value) { set(3, value); }
/** * {@inheritDoc} */ @Override public Identity<AssociatedGroupRecord, UInteger> getIdentity() { return Keys.IDENTITY_ASSOCIATED_GROUP; }
/** * Getter for <code>homo_sapiens_core_89_37.external_synonym.xref_id</code>. */ public UInteger getXrefId() { return (UInteger) get(0); }
/** * {@inheritDoc} */ @Override public Identity<AltAlleleRecord, UInteger> getIdentity() { return Keys.IDENTITY_ALT_ALLELE; }
/** * {@inheritDoc} */ @Override public UInteger value1() { return getTranslationId(); }
/** * {@inheritDoc} */ @Override public Field<UInteger> field4() { return DnaAlignFeature.DNA_ALIGN_FEATURE.SEQ_REGION_END; }
/** * Getter for <code>homo_sapiens_core_89_37.density_feature.seq_region_end</code>. */ public UInteger getSeqRegionEnd() { return (UInteger) get(4); }
/** * {@inheritDoc} */ @Override public UInteger value1() { return getUnmappedReasonId(); }
/** * Getter for <code>homo_sapiens_core_89_37.marker_map_location.marker_synonym_id</code>. */ public UInteger getMarkerSynonymId() { return (UInteger) get(3); }
/** * {@inheritDoc} */ @Override public UInteger value1() { return getExternalDbId(); }
/** * {@inheritDoc} */ @Override public Field<UInteger> field2() { return AssociatedXref.ASSOCIATED_XREF.OBJECT_XREF_ID; }
/** * {@inheritDoc} */ @Override public Identity<SimpleFeatureRecord, UInteger> getIdentity() { return Keys.IDENTITY_SIMPLE_FEATURE; }
/** * {@inheritDoc} */ @Override public Field<UInteger> field3() { return DitagFeature.DITAG_FEATURE.DITAG_PAIR_ID; }
/** * {@inheritDoc} */ @Override public Row3<UInteger, TranscriptSupportingFeatureFeatureType, UInteger> valuesRow() { return (Row3) super.valuesRow(); }
/** * {@inheritDoc} */ @Override public OperonTranscriptRecord value3(UInteger value) { setSeqRegionStart(value); return this; }
/** * {@inheritDoc} */ @Override public UInteger value5() { return getSeqRegionEnd(); }
/** * Setter for <code>homo_sapiens_core_89_37.transcript_intron_supporting_evidence.intron_supporting_evidence_id</code>. */ public void setIntronSupportingEvidenceId(UInteger value) { set(1, value); }
/** * {@inheritDoc} */ @Override public DensityFeatureRecord value3(UInteger value) { setSeqRegionId(value); return this; }
/** * Getter for <code>homo_sapiens_core_89_37.prediction_transcript.seq_region_end</code>. */ public UInteger getSeqRegionEnd() { return (UInteger) get(3); }
/** * {@inheritDoc} */ @Override public Field<UInteger> field3() { return TranscriptIntronSupportingEvidence.TRANSCRIPT_INTRON_SUPPORTING_EVIDENCE.PREVIOUS_EXON_ID; }
/** * {@inheritDoc} */ @Override public Field<UInteger> field1() { return Gene.GENE.GENE_ID; }
/** * Setter for <code>homo_sapiens_core_89_37.marker_feature.seq_region_end</code>. */ public void setSeqRegionEnd(UInteger value) { set(4, value); }
/** * {@inheritDoc} */ @Override public Record1<UInteger> key() { return (Record1) super.key(); }
/** * {@inheritDoc} */ @Override public Identity<OperonTranscriptRecord, UInteger> getIdentity() { return Keys.IDENTITY_OPERON_TRANSCRIPT; }
/** * Setter for <code>homo_sapiens_core_89_37.density_feature.seq_region_start</code>. */ public void setSeqRegionStart(UInteger value) { set(3, value); }
/** * Setter for <code>homo_sapiens_core_89_37.gene.display_xref_id</code>. */ public void setDisplayXrefId(UInteger value) { set(7, value); }
/** * {@inheritDoc} */ @Override public Row3<UInteger, UShort, String> fieldsRow() { return (Row3) super.fieldsRow(); }