class geneExpressionSchema(ma.ModelSchema):
class Meta:
model = GeneExpressionValues
sqla_session = db.session
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
gene = ma.Nested(GeneSchema, only=("ensg_number"))
class occurencesMiRNASchema(ma.ModelSchema):
class Meta:
model = OccurencesMiRNA
sqla_session = db.session
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
mirna = ma.Nested(miRNASchema, only=("mir_ID", "hs_nr"))
class miRNAExpressionSchema(ma.ModelSchema):
class Meta:
model = MiRNAExpressionValues
sqla_session = db.session
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
mirna = ma.Nested(miRNASchema, only=("mir_ID", "hs_nr"))
class PermissionSchema(ma.ModelSchema):
Role_Permission= ma.Nested(RoleSchema)
view_permission = ma.Nested(ViewGetSchemas)
class Meta:
model = Permissions
fields = ("id","add","edit","read","Role_Permission","view_permission")
sqla_session = db.session
class SurvivalPValueSchema(ma.ModelSchema):
class Meta:
model = SurvivalPValue
sql_session = db.session
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
gene = ma.Nested(GeneSchema, only=("ensg_number"))
class SelectedGenesSchema(ma.ModelSchema):
class Meta:
model = SelectedGenes
sqla_session = db.session
run = ma.Nested(RunSchema)
gene = ma.Nested(GeneSchema, olny=("ensg_number"))
class miRNAInteractionShortSchema(ma.ModelSchema):
class Meta:
model = miRNAInteraction
sqla_session = db.session
interactions_genegene = ma.Nested(GeneInteractionDatasetForMiRNSchema,
only=("run", "gene1", "gene2"))
mirna = ma.Nested(miRNASchema, only=("mir_ID", "hs_nr"))
class networkAnalysisSchema(ma.ModelSchema):
class Meta:
model = networkAnalysis
sqla_session = db.session
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
gene = ma.Nested(GeneSchema,
only=("gene_ID", "ensg_number", "gene_symbol"))
class GeneInteractionDatasetShortSchema(ma.ModelSchema):
class Meta:
model = GeneInteraction
sqla_session = db.session
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
gene1 = ma.Nested(GeneSchema, only=("ensg_number"))
gene2 = ma.Nested(GeneSchema, only=("ensg_number"))
class SurvivalPValueSchema(ma.ModelSchema):
class Meta:
model = SurvivalPValue
sql_session = db.session
fields = ["dataset", "gene", "pValue"]
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class miRNAExpressionSchema(ma.ModelSchema):
class Meta:
model = MiRNAExpressionValues
sqla_session = db.session
fields = ["dataset", "expr_value", "mirna", "sample_ID"]
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
mirna = ma.Nested(miRNASchema, only=("mir_ID", "hs_nr"))
class geneExpressionSchema(ma.ModelSchema):
class Meta:
model = GeneExpressionValues
sqla_session = db.session
fields = ["dataset", "expr_value", "gene", "sample_ID"]
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class networkAnalysisSchema(ma.ModelSchema):
class Meta:
model = networkAnalysis
sqla_session = db.session
fields = ["betweenness", "eigenvector", "gene", "node_degree", "run"]
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class GeneInteractionDatasetForMiRNSchema(ma.ModelSchema):
class Meta:
model = GeneInteraction
sqla_session = db.session
run = ma.Nested(RunForMirnaSchema, only=("run_ID", "dataset"))
gene1 = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
gene2 = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class GeneInteractionDatasetLongSchema(ma.ModelSchema):
class Meta:
model = GeneInteraction
sqla_session = db.session
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
gene1 = ma.Nested(GeneSchema, exclude=("gene_ID"))
gene2 = ma.Nested(GeneSchema, exclude=("gene_ID"))
class GeneCountSchema(ma.ModelSchema):
class Meta:
model = GeneCount
sql_session = db.session
fields = ["run", "gene", "count_all", "count_sign"]
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class miRNAInteractionSchema(ma.ModelSchema):
class Meta:
model = miRNAInteraction
sqla_session = db.session
fields = ["run", "gene", "mirna", "coefficient"]
run = ma.Nested(RunForMirnaSchema, only=("run_ID", "dataset"))
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
mirna = ma.Nested(miRNASchema, only=("mir_ID", "hs_nr"))
class GeneInteractionDatasetShortSchema(ma.ModelSchema):
class Meta:
model = GeneInteraction
sqla_session = db.session
fields = ["correlation", "mscor", "p_value", "run", "gene1", "gene2"]
run = ma.Nested(RunSchema, only=("run_ID", "dataset"))
gene1 = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
gene2 = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class SurvivalRateSchema(ma.ModelSchema):
class Meta:
model = SurvivalRate
sql_session = db.session
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
gene = ma.Nested(GeneSchema, only=("ensg_number"))
patient_information = ma.Nested(PatientInformationSchema,
only=("sample_ID"))
class ProductGetSchema(ma.ModelSchema):
category = ma.Nested(CategoriesGetSchema)
sizes = ma.Nested(SizeGetSchema, many=True)
globalsize_product = ma.Nested(GlobalSizeSchema)
class Meta:
model = Products
fields = ("id", "productEn", "productAr", "imagePath", "isActive",
"categoryId", "taxable", "sizes", 'category', "createdAt",
"updatedAt")
sqla_session = db.session
class LibraryUserSchema(ma.ModelSchema):
user_updated = ma.Nested(UserlibrarySchema, many=True)
user_created = ma.Nested(UserlibrarySchema, many=True)
# templates = ma.Nested(TemplateSchema, many=True)
class Meta:
model = Library
fields = ("id", "Libaray_Reference", "user_updated", "user_created",
"Version_id", "created_at", "updated_at")
sqla_session = db.session
class SurvivalRateSchema(ma.ModelSchema):
class Meta:
model = SurvivalRate
sql_session = db.session
fields = ["dataset", "gene", "overexpression", "patient_information"]
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
patient_information = ma.Nested(PatientInformationSchema,
only=("sample_ID", "disease_status",
"survival_time"))
class DistinctGeneSetSchema(ma.ModelSchema):
#class Meta:
# strict = True
#gene = fields.String()
class Meta:
model = GeneInteraction
sqla_session = db.session
fields = ["gene1", "gene2"]
gene1 = ma.Nested(GeneSchema, only=("ensg_number"))
gene2 = ma.Nested(GeneSchema, only=("ensg_number"))
class PriceGetSchema(ma.ModelSchema):
size_prices = ma.Nested(SizeGetSchema)
class Meta:
model = Prices
# fields = ("id","sizeId","productId","price")
sqla_session = db.session
class PatientInformationSchema(ma.ModelSchema):
class Meta:
model = PatientInformation
sqla_session = db.session
fields = ["dataset", "sample_ID", "disease_status", "survival_time"]
dataset = ma.Nested(DatasetSchema, only=("disease_name"))
class GeneOntologySchema(ma.ModelSchema):
class Meta:
model = GeneOntology
sql_session = db.session
fields = ["gene", "gene_ontology_symbol", "description"]
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class HallmarksSchema(ma.ModelSchema):
class Meta:
model = hallmarks
sql_session = db.session
fields = ["gene", "hallmark"]
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class WikipathwaySchema(ma.ModelSchema):
class Meta:
model = wikipathways
sql_session = db.session
fields = ["gene", "wp_key"]
gene = ma.Nested(GeneSchema, only=("ensg_number", "gene_symbol"))
class TallySheet_PRE_41_Schema(ma.ModelSchema):
class Meta:
fields = (
"tallySheetId",
"code",
"electionId",
"officeId",
"latestVersionId",
"tallySheetVersionId",
"createdBy",
"createdAt",
"electoralDistrictId",
"pollingDivisionId",
"countingCentreId",
"party_wise_results",
)
model = TallySheetPRE41Model
# optionally attach a Session
# to use for deserialization
sqla_session = db.session
createdBy = ma.Integer()
createdAt = ma.String()
party_wise_results = ma.Nested(TallySheet_PRE_41__party_Schema, many=True)
class PostsSchema(ma.ModelSchema):
author = ma.Nested(UserSchema)
class Meta:
model = Post
load_only = ('encryptionKey',)
dump_only = ('id','serial','date','author_id',)
include_fk = True
