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