SQLiteQuery (BioFSharp.Mz)

SQLiteQuery Module

Namespace: BioFSharp.Mz
Assembly: BioFSharp.Mz.dll
Parent Module: Db

Prepared statements via Closure

Functions and values

Function or value	Description
`createTableCleavageIndex cn` Full Usage: `createTableCleavageIndex cn` Parameters: cn : `SQLiteConnection` Returns: `int`	Creates Table CleavageIndex cn : `SQLiteConnection` Returns: `int`
`createTableModSequence cn` Full Usage: `createTableModSequence cn` Parameters: cn : `SQLiteConnection` Returns: `int`	Creates Table ModSequence cn : `SQLiteConnection` Returns: `int`
`createTablePepSequence cn` Full Usage: `createTablePepSequence cn` Parameters: cn : `SQLiteConnection` Returns: `int`	Creates Table PepSequence cn : `SQLiteConnection` Returns: `int`
`createTableProtein cn` Full Usage: `createTableProtein cn` Parameters: cn : `SQLiteConnection` Returns: `int`	Creates Table Protein cn : `SQLiteConnection` Returns: `int`
`createTableSearchDbParams cn` Full Usage: `createTableSearchDbParams cn` Parameters: cn : `SQLiteConnection` Returns: `int`	Creates Table SearchDbParams cn : `SQLiteConnection` Returns: `int`
`pragmaSynchronousOFF cn` Full Usage: `pragmaSynchronousOFF cn` Parameters: cn : `SQLiteConnection` Returns: `int`	cn : `SQLiteConnection` Returns: `int`
`prepareInsertCleavageIndex cn tr` Full Usage: `prepareInsertCleavageIndex cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int32 -> int32 -> int32 -> int32 -> int`	Prepares statement to insert a CleavageIndex entry cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int32 -> int32 -> int32 -> int32 -> int`
`prepareInsertModSequence cn tr` Full Usage: `prepareInsertModSequence cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> float -> int64 -> string -> int -> int`	Prepares statement to insert a ModSequence entry cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> float -> int64 -> string -> int -> int`
`prepareInsertPepSequence cn tr` Full Usage: `prepareInsertPepSequence cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> string -> int`	Prepares statement to insert a PepSequence entry cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> string -> int`
`prepareInsertProtein cn tr` Full Usage: `prepareInsertProtein cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> string -> string -> int`	Prepares statement to insert a Protein entry cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> string -> string -> int`
`prepareInsertSearchDbParams cn` Full Usage: `prepareInsertSearchDbParams cn` Parameters: cn : `SQLiteConnection` Returns: `string -> string -> string -> string -> int32 -> int32 -> double -> int32 -> int32 -> string -> string -> string -> string -> int32 -> int`	Prepares statement to insert a SearchDBParams entry cn : `SQLiteConnection` Returns: `string -> string -> string -> string -> int32 -> int32 -> double -> int32 -> int32 -> string -> string -> string -> string -> int32 -> int`
`prepareSelectCleavageIndexByPepSequenceID cn tr` Full Usage: `prepareSelectCleavageIndexByPepSequenceID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> (int * int * int * int * int * int) list`	Prepares statement to select a CleavageIndex entry PepSequenceID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> (int * int * int * int * int * int) list`
`prepareSelectCleavageIndexByProteinID cn tr` Full Usage: `prepareSelectCleavageIndexByProteinID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * int * int * int * int * int`	Prepares statement to select a CleavageIndex entry ProteinID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * int * int * int * int * int`
`prepareSelectMassByModSequenceAndGlobalMod cn` Full Usage: `prepareSelectMassByModSequenceAndGlobalMod cn` Parameters: cn : `SQLiteConnection` Returns: `string -> int -> float option`	Prepares statement to select a ModSequence entry by Massrange (Between selected Mass -/+ the selected toleranceWidth) cn : `SQLiteConnection` Returns: `string -> int -> float option`
`prepareSelectModsequenceByMass cn tr` Full Usage: `prepareSelectModsequenceByMass cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int -> int * int * float * int64 * string * string`	Prepares statement to select a ModSequence entry by Mass cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int -> int * int * float * int64 * string * string`
`prepareSelectModsequenceByMassRange cn` Full Usage: `prepareSelectModsequenceByMassRange cn` Parameters: cn : `SQLiteConnection` Returns: `int64 -> int64 -> (int * int * float * int64 * string * int) list`	Prepares statement to select a ModSequence entry by Massrange (Between selected Mass -/+ the selected toleranceWidth) cn : `SQLiteConnection` Returns: `int64 -> int64 -> (int * int * float * int64 * string * int) list`
`prepareSelectModsequenceByMassRangeWith cn tr` Full Usage: `prepareSelectModsequenceByMassRangeWith cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int64 -> int64 -> (int * int * float * int64 * string * int) list`	Prepares statement to select a ModSequence entry by Massrange (Between selected Mass -/+ the selected toleranceWidth) cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int64 -> int64 -> (int * int * float * int64 * string * int) list`
`prepareSelectModsequenceByModSequenceID cn tr` Full Usage: `prepareSelectModsequenceByModSequenceID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * int * float * int64 * string * int`	Prepares statement to select a ModSequence entry by ModSequenceID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * int * float * int64 * string * int`
`prepareSelectModsequenceByPepSequenceID cn tr` Full Usage: `prepareSelectModsequenceByPepSequenceID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * int * float * int64 * string * string`	Prepares statement to select a ModSequence entry by PepSequenceID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * int * float * int64 * string * string`
`prepareSelectModsequenceBySequence cn tr` Full Usage: `prepareSelectModsequenceBySequence cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int * int * float * int64 * string * string`	Prepares statement to select a ModSequence entry by Sequence cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int * int * float * int64 * string * string`
`prepareSelectModsequenceBySequenceAndGMod cn` Full Usage: `prepareSelectModsequenceBySequenceAndGMod cn` Parameters: cn : `SQLiteConnection` Returns: `string -> int -> int * int * float * int64 * string * int`	Prepares statement to select a ModSequence entry by Sequence and GlobalMod cn : `SQLiteConnection` Returns: `string -> int -> int * int * float * int64 * string * int`
`prepareSelectPepSequenceByPepSequenceID cn tr` Full Usage: `prepareSelectPepSequenceByPepSequenceID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int -> string`	Prepares statement to select a Peptide Sequence entry by ID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int -> string`
`prepareSelectPepSequenceBySequence cn tr` Full Usage: `prepareSelectPepSequenceBySequence cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int`	Prepares statement to select a PepSequence entry by PepSequence - Version without try.. with pattern to enhance the Select performance cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int`
`prepareSelectPepSequenceBySequence' cn tr` Full Usage: `prepareSelectPepSequenceBySequence' cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int`	Prepares statement to select a PepSequence entry by PepSequence cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int`
`prepareSelectProteinAccessionByID cn tr` Full Usage: `prepareSelectProteinAccessionByID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> string`	Prepares statement to select a Protein Accession entry by ID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> string`
`prepareSelectProteinByAccession cn tr` Full Usage: `prepareSelectProteinByAccession cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int * string * string`	Prepares statement to select a Protein entry by Accession cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int * string * string`
`prepareSelectProteinByID cn tr` Full Usage: `prepareSelectProteinByID cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * string * string`	Prepares statement to select a Protein entry by ID cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `int32 -> int * string * string`
`prepareSelectProteinBySequence cn tr` Full Usage: `prepareSelectProteinBySequence cn tr` Parameters: cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int * string * string`	Prepares statement to select a Protein entry by Sequence cn : `SQLiteConnection` tr : `SQLiteTransaction` Returns: `string -> int * string * string`
`prepareSelectSearchDbParamsbyParams cn` Full Usage: `prepareSelectSearchDbParamsbyParams cn` Parameters: cn : `SQLiteConnection` Returns: `string -> string -> int32 -> int32 -> float -> int32 -> int32 -> string -> string -> string -> string -> int32 -> (int * string * string * string * string * int * int * float * int * int * string * string * string * string * int) option`	Prepares statement to select all SearchDbParams entries by FastaPath, Protease, MinmissedCleavages, MaxmissedCleavages, MaxMass, MinPepLength, MaxPepLength, IsotopicLabel, MassMode, FixedMods, VariableMods, VarModsThreshold cn : `SQLiteConnection` Returns: `string -> string -> int32 -> int32 -> float -> int32 -> int32 -> string -> string -> string -> string -> int32 -> (int * string * string * string * string * int * int * float * int * int * string * string * string * string * int) option`
`prepareSelectSearchModsbyParams cn` Full Usage: `prepareSelectSearchModsbyParams cn` Parameters: cn : `SQLiteConnection` Returns: `string -> string -> int32 -> int32 -> float -> int32 -> int32 -> string -> string -> string -> string -> int32 -> SearchModification list`	Prepares statement to select all SearchModifications by SearchDbParams cn : `SQLiteConnection` Returns: `string -> string -> int32 -> int32 -> float -> int32 -> int32 -> string -> string -> string -> string -> int32 -> SearchModification list`
`selectProteins cn` Full Usage: `selectProteins cn` Parameters: cn : `SQLiteConnection` Returns: `(string * string) list`	Prepares statement to select Accession and Sequence of Proteins from SearchDB cn : `SQLiteConnection` Returns: `(string * string) list`
`selectSearchDbParams cn` Full Usage: `selectSearchDbParams cn` Parameters: cn : `SQLiteConnection` Returns: `(int * string * string * string * string * int * int * float * int * int * string * string * string * string * int) option`	Prepares statement to select all SearchDbParams cn : `SQLiteConnection` Returns: `(int * string * string * string * string * int * int * float * int * int * string * string * string * string * int) option`
`setIndexOnModSequenceAndGlobalMod cn` Full Usage: `setIndexOnModSequenceAndGlobalMod cn` Parameters: cn : `SQLiteConnection` Returns: `int`	cn : `SQLiteConnection` Returns: `int`
`setMassIndexOnModSequence cn` Full Usage: `setMassIndexOnModSequence cn` Parameters: cn : `SQLiteConnection` Returns: `int`	cn : `SQLiteConnection` Returns: `int`
`setPepSequenceIDIndexOnCleavageIndex cn` Full Usage: `setPepSequenceIDIndexOnCleavageIndex cn` Parameters: cn : `SQLiteConnection` Returns: `int`	cn : `SQLiteConnection` Returns: `int`
`setSequenceIndexOnPepSequence cn` Full Usage: `setSequenceIndexOnPepSequence cn` Parameters: cn : `SQLiteConnection` Returns: `int`	cn : `SQLiteConnection` Returns: `int`