U i#=@szddlmZddlmZmZmZddlmZmZm Z m Z m Z ddl m Z m Z ddlmZmZddlmZmZeZGdddejZGd d d ejZGd d d ejZGd ddejZGdddejZGdddejZGdddejZdddddddddddd g d!d"d#d$d%d&d'd(d)d*d+d,g d-d.d/d0d1d2d3d4d5d6d7d8g d9d:d;dd?d@dAdBdCdDdEg dFdGdHdIdJdKdLdMdNdOdPdQdRdSgdTdUdVdWdXdYdZd[gdUd\dXd]d^d_d`dBgdadbdcdXdddedfdggdhdidjdkdld^d_dcdmdndodpdqdrdsgdtdidudvdwd_djdxdndodydqdrdsgdzd{d|d}d~dddddddddrdsgd{ddddddddddddsg d ddddddddddddg ddddddddddddg dddd/ddddddddDdg dddddddd^ddddg ddddddddd[ddddg ddTdUdVdWdd[ddddd8ddXgdUdad\dd[dddddd^d_doddXgdzddbdadddedddddgdjdXg dddddddd_ddjdxdrg ddZdvd[dddndxdrddsg dzd{ddvdd}ddjdxddrdsg d{dddddjdddg d dZdS)) SQLAlchemy)Mapped mapped_column relationship)IntegerStringJSON ForeignKeyBoolean)datetimetimezone)generate_password_hashcheck_password_hash)ListDictc@seZdZUdZeedddZeee d<ee dddZ ee e d<ee dddd Z ee e d <ee d ddZee e d <eeddd Zeee d<ee dddZee e d<eddddZeddddZddZddZdS) SchoolTableZschoolsT primary_key autoincrementidFnullable school_namerunique school_id2streamrdefault isLoggedInpassword TeacherTableschoolz all, delete)back_populatescascade StudentTablecCst||_dSNr r#selfr#r-/var/www/b2b/models.py set_passwordszSchoolTable.set_passwordcCs t|j|Sr)rr#r+r-r-r.check_passwordszSchoolTable.check_passwordN)__name__ __module__ __qualname__ __tablename__rrrrint__annotations__rrstrrrr r!boolr#rteachersstudentsr/r1r-r-r-r.r s rc@sDeZdZUdZeedddZeee d<ee dddZ ee e d<ee dddZ ee e d <ee d ddd Zee e d <ee dddZee e d <eeddZeeee d<edddZeee d<edddZeee d<eedddZee e d<eedddZeee d<edddZddZddZdS) r$r:Trrr"Fr firstnamelastnamerusernamer#gradescCs ttjSr)r nowr utcr-r-r-r.%zTeacherTable.r created_atcCs ttjSr)rAr-r-r-r.rD&rE last_loginr rr! schools.idrrr&cCst|d|_dS)N)r#r*r+r-r-r.r/,szTeacherTable.set_passwordcCs t|j|Sr)r0r+r-r-r.r1/szTeacherTable.check_passwordN)r2r3r4r5rrrrr6r7rr<r8r=r?r#rr@rrrGr rHr r!r rrr%r/r1r-r-r-r.r$s  r$c@seZdZUdZeedddZeee d<ee ddddZ ee e d<ee d dd Z ee e d <ee d dd Zee e d <ee ddd Zee e d<ee ddddZee e d<eedddZeee d<eedddZeee d<eedddZeee d<ee ddd Zee e d<ee d dd Zee e d<eedd Zeee d<eddd Zeee d!<ed"dd Zeee d#<eeddd$Zee e d%<eed&dd Zeee d'<ed(dd)Zd*d+Z d,d-Z!d.S)/r(r;TrrFrr?r"rr# gradesectionu 👨‍🎓ravataricoins(gemsstreakrr<r=roll_nocCs ttjSr)rAr-r-r-r.rDArEzStudentTable.rFrGcCs ttjSr)rAr-r-r-r.rDBrErHrIr!rJrrrKcCst||_dSr)r*r+r-r-r.r/HszStudentTable.set_passwordcCs t|j|Sr)r0r+r-r-r.r1KszStudentTable.check_passwordN)"r2r3r4r5rrrrr6r7rr?r8r#rNrPrRrSrUrWr<r=rXrGr rHr r!r rrr%r/r1r-r-r-r.r(2s(  r(c@seZdZUdZeedddZeee d<ee dddZ eee d<ee d ddZ eee d <ee d ddZeee d <ee d ddZeee d <eeddZeeee d<eeddZeeee d<edddZeee d<edZedZdS)TeacherAssessmentTableteacher_assessmentsTrrrJFrrz teachers.id created_byrMrNrPconcepts questionscCs ttjSr)rAr-r-r-r.rDXrEzTeacherAssessmentTable.rFrGrr$N)r2r3r4r5rrrrr6r7r rr[rrNr8rPrr\rr]rrGr rr%teacherr-r-r-r.rYNs rYc@seZdZUdZeeddddZeee d<ee dddZ eee d<ee d ddZ eee d <ee d ddZeee d <ee d ddZeee d <ee dddZeee d<eeddZeeee d<edddZeee d<dS)StudentAssesmentResultTableZstudent_assesment_resultsFT)rrrrz students.idr student_idrJrrMrNrPzteacher_assessments.id assesment_idconcept_detailcCs ttjSr)rAr-r-r-r.rDgrEz$StudentAssesmentResultTable.rF submitted_atN)r2r3r4r5rrrrr6r7r r`rrrNr8rPrarrbrrrcr r-r-r-r.r_]s r_c@seZdZUdZeedddZeee d<ee dddZ ee e d<ee dZ ee e d <eeddd Zeee d <ee d ddd Zee e d<ee d ddZee e d<eedddZeee d<ddZddZdS)PrincipalTableZ principalsTrrrFrr<r=rr!r"rr?r#rJrcCst||_dSr)r*r+r-r-r.r/tszPrincipalTable.set_passwordcCs t|j|Sr)r0r+r-r-r.r1wszPrincipalTable.check_passwordN)r2r3r4r5rrrrr6r7rr<r8r=r r!r9r?r#r rr/r1r-r-r-r.rdis rdc@sxeZdZdZejejddZejedddZ ejedddZ ejedddZ eej Z edd d fZd S) Conceptz0Concepts/topics for different grades and streamsT)rdFrrQZidx_grade_streamrNrN)r2r3r4__doc__dbColumnrrrnamerNrText descriptionIndexZ__table_args__r-r-r-r.rezs  rezCounting 1-100zNumber RecognitionzBefore and After NumberszGreater and SmallerzAddition (1-10)zSubtraction (1-10)zShapes and PatternszLength and HeightzWeight ComparisonzDays and Monthsz Time (Hours)z Money (Coins)zCounting 1-1000zPlace Value (Ones, Tens)z Skip CountingzAddition (1-50)zSubtraction (1-50)zIntroduction to MultiplicationzEven and Odd Numbersz2D and 3D ShapeszMeasurement (cm, m)zTime (Half Hours)zMoney (Notes and Coins)zData Handling (Pictographs)zNumbers up to 10,000z!Place Value (Hundreds, Thousands)z"Addition and Subtraction (3-digit)zMultiplication Tables (2-10)zDivision BasicszFractions (Half, Quarter)zSimple PatternszPerimeter and Area BasicszTime (Minutes)zMoney Problemsz Bar GraphsZSymmetryzNumbers up to 1,00,000zRoman NumeralszFactors and Multiplesz"Addition and Subtraction (4-digit)u#Multiplication (2-digit × 2-digit)zDivision (Long Division)z#Fractions (Proper, Improper, Mixed)zDecimals IntroductionzAngles and LineszPerimeter and Areaz Time ProblemszMoney Word ProblemszData Handling (Tables)zLarge Numbers (Lakhs, Crores)zPrime and Composite Numbersz HCF and LCMzFour Operations (Large Numbers)zFractions (All Operations)zDecimals (Operations)zPercentages BasicszRatio and Proportion IntrozSimple Interest BasicszPerimeter and Area (Complex)z Volume BasicszCoordinate Geometry IntrozData InterpretationzAverage and Meanz Whole NumbersZIntegersZ FractionsZDecimalsz Data HandlingZ MensurationZAlgebrazRatio and ProportionzFractions and DecimalszSimple EquationszLines and AnglesZ TrianglesZ CongruencezRational NumberszLinear EquationsZQuadrilateralszSquares and Square RootszCubes and Cube RootszComparing QuantitieszAlgebraic ExpressionszNumber SystemsZ PolynomialszCoordinate Geometryz!Linear Equations in Two VariableszEuclid's Geometryz%Areas of Parallelograms and TrianglesZCirclesZ ConstructionszHeron's FormulazSurface Areas and VolumesZ StatisticsZ Probabilityz Real Numbersz)Pair of Linear Equations in Two VariableszQuadratic EquationszArithmetic ProgressionsZ TrigonometryzAreas Related to CirclesZSetszRelations and FunctionszTrigonometric FunctionszMathematical InductionzComplex NumberszLinear InequalitieszPermutations and CombinationszBinomial TheoremzSequences and SerieszStraight LineszConic SectionszIntroduction to 3D GeometryzLimits and DerivativeszInverse Trigonometric FunctionsZMatricesZ Determinantsz Continuity and DifferentiabilityzApplications of DerivativesZ IntegralszApplications of IntegralszDifferential EquationszVector Algebraz 3D GeometryzLinear Programming) 123456789101112z Numbers 1-100zCounting and Number NameszBefore, After, BetweenzComparison of NumberszAddition Facts (1-10)zSubtraction Facts (1-10)z Basic ShapesZPatternszMeasurement (Longer, Shorter)zCalendar BasicszTime (O'clock)zMoney RecognitionzNumbers up to 1000zPlace Value (Tens, Ones)zOrdinal NumberszAddition (2-digit)zSubtraction (2-digit)zTimes Tables (2, 5, 10)z Odd and EvenzGeometry ShapeszLength (Inches, Feet)zTime (Half Past)zMoney (Paise, Rupees)z Simple GraphszNumbers up to 9999zPlace Value ChartzRounding Numbersu#Multiplication (1-digit × 2-digit)zDivision ConceptszIntroduction to FractionszPatterns and SequenceszPerimeter of ShapeszCapacity (Liters)z Time DurationzPictographs and Bar ChartszLarge Numbers (Lakhs)zRoman Numerals (I-C)zMultiples and FactorszLong Multiplicationz Long DivisionzEquivalent FractionszDecimals (Tenths)zArea and PerimeterzTime (12-hour and 24-hour)zMoney Calculationsz!Data Handling (Charts and Graphs)zLarge Numbers (Crores)zPrime and CompositezTests of DivisibilityzFractions (Mixed Operations)zDecimals (All Operations)zIntroduction to PercentageszSimple InterestzUnitary Methodz$Geometry (Triangles, Quadrilaterals)zVolume and CapacityzSymmetry and ReflectionzStatistics BasicszNatural NumbersZ PercentagezProfit and LosszBasic Geometrical ConceptszPractical GeometryZ ExponentszProfit, Loss and DiscountzFundamental ConceptsZ CongruencyzDirected NumberszSimple and Compound InterestzDirect and Inverse VariationsZ FactorisationzRational and Irrational NumberszCompound InterestZ ExpansionsZFactorizationszSimultaneous Linear EquationsZIndicesZ LogarithmszMean and MedianzCommercial MathematicsZ SimilarityZLociZ Histogramsz%Logarithmic and Exponential FunctionszQuadratic FunctionsZCalculuszProbability DistributionszSampling Theory)CBSEICSEN)Zflask_sqlalchemyrZsqlalchemy.ormrrr sqlalchemyrrrr r r r Zwerkzeug.securityr rtypingrrrhZModelrr$r(rYr_rdre CONCEPTS_DATAr-r-r-r.sR   C