class RegistrationForm(FlaskForm): username = StringField( 'Username', validators=[DataRequired(), AlphaSpace(), Length(min=2, max=20)]) email = StringField('Email', validators=[DataRequired(), Email()]) password = PasswordField('Password', validators=[DataRequired()]) confirm_password = PasswordField( 'Confirm Password', validators=[DataRequired(), EqualTo('password')]) submit = SubmitField('Sign-up') def validate_username(self, username): user = User.query.filter_by(username=username.data).first() if user: raise ValidationError( 'That Username is Taken. Please try something different!', 'warning') def validate_email(self, email): user = User.query.filter_by(email=email.data).first() if user: raise ValidationError( 'That Email is Taken. Please try something different!', 'warning') if (re.search(regex, email.data)): pass else: raise ValidationError('Invalid Email', 'warning')
class AddRecipe(FlaskForm): def semicolon_check(form, field): if len(field.data) > 0 and not ';' in field.data: raise validators.ValidationError( "Make sure that your tags are separated with semicolons!") name = StringField('Recipe Name', [ validators.DataRequired(), AlphaSpace('The name should only consist of letters and spaces') ]) ingredients = TextAreaField('Ingredients') servings = StringField('Servings') instructions = TextAreaField('Instructions') tags = StringField('Tags', [semicolon_check]) image = FileField('Image', validators=[FileAllowed(['jpg', 'png'], 'Images only!')])
class LoginForm(FlaskForm): username = StringField( 'username', validators=[ AlphaSpace(message="Name should contain only alphabets and space") ]) mobile = StringField('mobile', validators=[ Integer(), validators.Length( min=10, max=10, message="Enter Valid Contact Number") ]) email = StringField('email') subject = StringField('subject') message = StringField('message')
class PlayerForm(FlaskForm): player_name = StringField( 'Player Name', validators=[DataRequired(), AlphaSpace('Only string value allowed')]) image = FileField('Update Profile Picture', validators=[FileAllowed(['jpg', 'png'])]) player_style = SelectField('Playing Style', choices=[('N/A', 'N/A'), ('Right Hand Batsman', 'Right Hand Batsman'), ('Left Hand Batsman', 'Left Hand Batsman')], validators=[DataRequired()]) player_mat = IntegerField('Player Matches') player_inns = IntegerField('Player Innings') player_runs = IntegerField('Player Runs') player_hs = IntegerField('Player High Score') player_sr = FloatField('Players Strike Rate') player_ave = FloatField('Player Average') player_century = IntegerField('Player Century') player_country = SelectField('Player Country', choices=[('N/A', 'N/A'), ('Pakistan', 'Pakistan'), ('Australia', 'Australia'), ('England', 'England'), ('India', 'India')], validators=[DataRequired()]) player_type = SelectField('Player Type', choices=[('N/A', 'N/A'), ('All Rounder', 'All Rounder'), ('Batsman', 'Batsman'), ('Bowler', 'Bowler')]) player_bruns = IntegerField('Players bowling runs') player_wkts = IntegerField('Wickets taken') player_bave = FloatField('Players bowling Average') player_bsr = FloatField('Player Bowling Strike Rate') submit = SubmitField('Save')
class PaymentForm(FlaskForm): cardNumber = StringField( "<strong>Card Number</strong>", validators=[ InputRequired(), Regexp(cardNumberRegex, message="Must only contain numbers and dashes.") ]) cardType = SelectField("<strong>Card Type</strong>", choices=creditCardTypes) expirationMonth = SelectField("<strong>Expiration Month</strong>", choices=expirationMonths) expirationYear = SelectField("<strong>Expiration Year</strong>", choices=expirationYears) cvv = StringField("<strong>CVV</strong>", validators=[ InputRequired(), Length(min=3, max=3, message="Field must be 3 digits long."), Integer() ]) name = StringField( "<strong>Name on the Card</strong>", validators=[InputRequired(), Length(min=4, max=100), AlphaSpace()]) submit = SubmitField("Pay") # Convert card number to numbers only def validate(self): if not FlaskForm.validate(self): return False else: self.cardNumber.data = self.cardNumber.data.replace("-", "") return True
class AddBatsman(FlaskForm): PlayerName = StringField('Player Name', validators=[DataRequired(), AlphaSpace()]) country = SelectField('Country', choices=[ ('Batsman Dataset (Australia).csv', 'Australia'), ('Batsman Dataset (India).csv', 'India'), ('Batsman Dataset (England).csv', 'England') ], validators=[DataRequired()]) m1_run = IntegerField('M1(Run)', validators=[DataRequired(), Integer()]) m1_bowl = IntegerField('M1(Bowl)', validators=[DataRequired(), Integer()]) m1_sr = FloatField('M1(SR)', validators=[DataRequired(), Integer()]) average = FloatField('Average', validators=[DataRequired(), Integer()]) m1_6 = IntegerField('M1(6)', validators=[DataRequired(), Integer()]) m1_op = StringField('M1(OP)', validators=[DataRequired(), AlphaSpace()]) m1_vnu = StringField('M1(VNU)', validators=[DataRequired(), AlphaSpace()]) m2_run = IntegerField('M2(Run)', validators=[DataRequired(), Integer()]) m2_bowl = IntegerField('M2(Bowl)', validators=[DataRequired(), Integer()]) m2_sr = FloatField('M2(SR)', validators=[DataRequired(), Integer()]) m2_6 = IntegerField('M2(6)', validators=[DataRequired(), Integer()]) m2_4 = IntegerField('M2(4)', validators=[DataRequired(), Integer()]) m2_op = StringField('M2(OP)', validators=[DataRequired(), AlphaSpace()]) m2_vnu = StringField('M2(VNU)', validators=[DataRequired(), AlphaSpace()]) m3_run = IntegerField('M3(Run)', validators=[DataRequired(), Integer()]) m3_bowl = IntegerField('M3(Bowl)', validators=[DataRequired(), Integer()]) m3_sr = FloatField('M3(SR)', validators=[DataRequired(), Integer()]) m3_6 = IntegerField('M3(6)', validators=[DataRequired(), Integer()]) m3_4 = IntegerField('M3(4)', validators=[DataRequired(), Integer()]) m3_op = StringField('M3(OP)', validators=[DataRequired(), AlphaSpace()]) m3_vnu = StringField('M3(VNU)', validators=[DataRequired(), AlphaSpace()]) m4_run = IntegerField('M4(Run)', validators=[DataRequired(), Integer()]) m4_bowl = IntegerField('M4(Bowl)', validators=[DataRequired(), Integer()]) m4_sr = FloatField('M4(SR)', validators=[DataRequired(), Integer()]) m4_6 = IntegerField('M4(6)', validators=[DataRequired(), Integer()]) m4_4 = IntegerField('M4(4)', validators=[DataRequired(), Integer()]) m4_op = StringField('M4(OP)', validators=[DataRequired(), AlphaSpace()]) m4_vnu = StringField('M4(VNU)', validators=[DataRequired(), AlphaSpace()]) m5_run = IntegerField('M5(Run)', validators=[DataRequired(), Integer()]) m5_bowl = IntegerField('M5(Bowl)', validators=[DataRequired(), Integer()]) m5_sr = FloatField('M5(SR)', validators=[DataRequired(), Integer()]) m5_6 = IntegerField('M5(6)', validators=[DataRequired(), Integer()]) m5_4 = IntegerField('M5(4)', validators=[DataRequired(), Integer()]) m5_op = StringField('M5(OP)', validators=[DataRequired(), AlphaSpace()]) m5_vnu = StringField('M5(VNU)', validators=[DataRequired(), AlphaSpace()]) m6_run = IntegerField('M6(Run)', validators=[DataRequired(), Integer()]) m6_bowl = IntegerField('M6(Bowl)', validators=[DataRequired(), Integer()]) m6_sr = FloatField('M6(SR)', validators=[DataRequired(), Integer()]) m6_6 = IntegerField('M6(6)', validators=[DataRequired(), Integer()]) m6_4 = IntegerField('M6(4)', validators=[DataRequired(), Integer()]) m6_op = StringField('M6(OP)', validators=[DataRequired(), AlphaSpace()]) m6_vnu = StringField('M6(VNU)', validators=[DataRequired(), AlphaSpace()]) m7_run = IntegerField('M7(Run)', validators=[DataRequired(), Integer()]) m7_bowl = IntegerField('M7(Bowl)', validators=[DataRequired(), Integer()]) m7_sr = FloatField('M7(SR)', validators=[DataRequired(), Integer()]) m7_6 = IntegerField('M7(6)', validators=[DataRequired(), Integer()]) m7_4 = IntegerField('M7(4)', validators=[DataRequired(), Integer()]) m7_op = StringField('M7(OP)', validators=[DataRequired(), AlphaSpace()]) m7_vnu = StringField('M7(VNU)', validators=[DataRequired(), AlphaSpace()]) m8_run = IntegerField('M8(Run)', validators=[DataRequired(), Integer()]) m8_bowl = IntegerField('M8(Bowl)', validators=[DataRequired(), Integer()]) m8_sr = FloatField('M8(SR)', validators=[DataRequired(), Integer()]) m8_6 = IntegerField('M8(6)', validators=[DataRequired(), Integer()]) m8_4 = IntegerField('M8(4)', validators=[DataRequired(), Integer()]) m8_op = StringField('M8(OP)', validators=[DataRequired(), AlphaSpace()]) m8_vnu = StringField('M8(VNU)', validators=[DataRequired(), AlphaSpace()]) m9_run = IntegerField('M9(Run)', validators=[DataRequired(), Integer()]) m9_bowl = IntegerField('M9(Bowl)', validators=[DataRequired(), Integer()]) m9_sr = FloatField('M9(SR)', validators=[DataRequired(), Integer()]) m9_6 = IntegerField('M9(6)', validators=[DataRequired(), Integer()]) m9_4 = IntegerField('M9(4)', validators=[DataRequired(), Integer()]) m9_op = StringField('M9(OP)', validators=[DataRequired(), AlphaSpace()]) m9_vnu = StringField('M9(VNU)', validators=[DataRequired(), AlphaSpace()]) m10_run = IntegerField('M10(Run)', validators=[DataRequired(), Integer()]) m10_bowl = IntegerField('M10(Bowl)', validators=[DataRequired(), Integer()]) m10_sr = FloatField('M10(SR)', validators=[DataRequired(), Integer()]) m10_6 = IntegerField('M10(6)', validators=[DataRequired(), Integer()]) m10_4 = IntegerField('M10(4)', validators=[DataRequired(), Integer()]) m10_op = StringField('M10(OP)', validators=[DataRequired(), AlphaSpace()]) m10_vnu = StringField('M10(VNU)', validators=[DataRequired(), AlphaSpace()]) t50 = IntegerField('T(50)', validators=[DataRequired(), Integer()]) t100 = IntegerField('T(100)', validators=[DataRequired(), Integer()]) t4 = IntegerField('T(4)', validators=[DataRequired(), Integer()]) t6 = IntegerField('T(6)', validators=[DataRequired(), Integer()]) truns = IntegerField('TRuns', validators=[DataRequired(), Integer()]) tbf = IntegerField('TBF', validators=[DataRequired(), Integer()]) avgrun = FloatField('Avg.Run', validators=[DataRequired(), Integer()]) avgsr = FloatField('Avg.SR', validators=[DataRequired(), Integer()]) rf50 = FloatField('RF(50)', validators=[DataRequired(), Integer()]) rf100 = FloatField('RF100', validators=[DataRequired(), Integer()]) drb = FloatField('DRB', validators=[DataRequired(), Integer()]) truns_percentage = FloatField('TRuns(%)', validators=[DataRequired(), Integer()]) tbf_percentage = FloatField('TBF(%)', validators=[DataRequired(), Integer()]) submit = SubmitField('Submit')
class AddBowler(FlaskForm): PlayerName = StringField('Player Name', validators=[DataRequired(), AlphaSpace()]) country = SelectField('Country', choices=[ ('Bowlers Dataset (Australia).csv', 'Australia'), ('Bowlers Dataset (India).csv', 'India'), ('Bowlers Dataset (England).csv', 'England') ], validators=[DataRequired()]) m1_run = IntegerField('M1(Run)', validators=[DataRequired(), Integer()]) m1_bowl = IntegerField('M1(Bowl)', validators=[DataRequired(), Integer()]) m1_op = StringField('M1(OP)', validators=[DataRequired(), AlphaSpace()]) m1_vnu = StringField('M1(VNU)', validators=[DataRequired(), AlphaSpace()]) m2_run = IntegerField('M2(Run)', validators=[DataRequired(), Integer()]) m2_bowl = IntegerField('M2(Bowl)', validators=[DataRequired(), Integer()]) m2_op = StringField('M2(OP)', validators=[DataRequired(), AlphaSpace()]) m2_vnu = StringField('M2(VNU)', validators=[DataRequired(), AlphaSpace()]) m3_run = IntegerField('M3(Run)', validators=[DataRequired(), Integer()]) m3_bowl = IntegerField('M3(Bowl)', validators=[DataRequired(), Integer()]) m3_op = StringField('M3(OP)', validators=[DataRequired(), AlphaSpace()]) m3_vnu = StringField('M3(VNU)', validators=[DataRequired(), AlphaSpace()]) m4_run = IntegerField('M4(Run)', validators=[DataRequired(), Integer()]) m4_bowl = IntegerField('M4(Bowl)', validators=[DataRequired(), Integer()]) m4_op = StringField('M4(OP)', validators=[DataRequired(), AlphaSpace()]) m4_vnu = StringField('M4(VNU)', validators=[DataRequired(), AlphaSpace()]) m5_run = IntegerField('M5(Run)', validators=[DataRequired(), Integer()]) m5_bowl = IntegerField('M5(Bowl)', validators=[DataRequired(), Integer()]) m5_op = StringField('M5(OP)', validators=[DataRequired(), AlphaSpace()]) m5_vnu = StringField('M5(VNU)', validators=[DataRequired(), AlphaSpace()]) m6_run = IntegerField('M6(Run)', validators=[DataRequired(), Integer()]) m6_bowl = IntegerField('M6(Bowl)', validators=[DataRequired(), Integer()]) m6_op = StringField('M6(OP)', validators=[DataRequired(), AlphaSpace()]) m6_vnu = StringField('M6(VNU)', validators=[DataRequired(), AlphaSpace()]) m7_run = IntegerField('M7(Run)', validators=[DataRequired(), Integer()]) m7_bowl = IntegerField('M7(Bowl)', validators=[DataRequired(), Integer()]) m7_op = StringField('M7(OP)', validators=[DataRequired(), AlphaSpace()]) m7_vnu = StringField('M7(VNU)', validators=[DataRequired(), AlphaSpace()]) m8_run = IntegerField('M8(Run)', validators=[DataRequired(), Integer()]) m8_bowl = IntegerField('M8(Bowl)', validators=[DataRequired(), Integer()]) m8_op = StringField('M8(OP)', validators=[DataRequired(), AlphaSpace()]) m8_vnu = StringField('M8(VNU)', validators=[DataRequired(), AlphaSpace()]) m9_run = IntegerField('M9(Run)', validators=[DataRequired(), Integer()]) m9_bowl = IntegerField('M9(Bowl)', validators=[DataRequired(), Integer()]) m9_op = StringField('M9(OP)', validators=[DataRequired(), AlphaSpace()]) m9_vnu = StringField('M9(VNU)', validators=[DataRequired(), AlphaSpace()]) m10_run = IntegerField('M10(Run)', validators=[DataRequired(), Integer()]) m10_bowl = IntegerField('M10(Bowl)', validators=[DataRequired(), Integer()]) m10_op = StringField('M10(OP)', validators=[DataRequired(), AlphaSpace()]) m10_vnu = StringField('M10(VNU)', validators=[DataRequired(), AlphaSpace()]) t50 = IntegerField('T(50)', validators=[DataRequired(), Integer()]) t100 = IntegerField('T(100)', validators=[DataRequired(), Integer()]) truns = IntegerField('TRuns', validators=[DataRequired(), Integer()]) tbf = IntegerField('TBF', validators=[DataRequired(), Integer()]) avgrun = FloatField('Agv.Run', validators=[DataRequired()]) avgsr = FloatField('Agv.SR', validators=[DataRequired()]) rf50 = FloatField('RF(50)', validators=[DataRequired()]) rf100 = FloatField('RF(100)', validators=[DataRequired()]) wickets = IntegerField('Wickets', validators=[DataRequired(), Integer()]) truns_percentage = FloatField('TRuns(%)', validators=[DataRequired()]) tbf_percentage = FloatField('TBF(%)', validators=[DataRequired()]) submit = SubmitField('Submit')
class UpdateCustomer(FlaskForm): ws_ssn = StringField("SSN Id", validators=[DataRequired(),Integer(),Length(min=9,max=9) ]) ws_name = StringField("Customer Name", validators=[DataRequired(), Length(min=2,max=55), AlphaSpace() ]) ws_adrs = TextAreaField("Address", validators=[DataRequired(), Length(min=5,max=160), AlphaNumeric() ]) ws_age = StringField("Age", validators=[DataRequired(),Integer() ]) submit = SubmitField("Create")
class CreateCustomerForm(FlaskForm): ws_ssn = StringField("SSN Id", validators=[DataRequired(),Integer(),Length(min=9,max=9) ],render_kw={"placeholder": "Enter SSN Id"}) ws_name = StringField("Customer Name", validators=[DataRequired(), Length(min=2,max=55), AlphaSpace() ],render_kw={"placeholder": "Enter customer name"}) ws_adrs = TextAreaField("Address", validators=[DataRequired(), Length(min=5,max=160) ],render_kw={"placeholder": "Enter address"})#AlphaNumeric() ws_age = StringField("Age", validators=[DataRequired(),Integer() ],render_kw={"placeholder": "Enter age"}) submit = SubmitField("Create")
def test_alpha_space_raises(test_v, dummy_form, dummy_field): validator = AlphaSpace() dummy_field.data = test_v with pytest.raises(ValidationError): validator(dummy_form, dummy_field)
def test_alpha_space(test_v, dummy_form, dummy_field): validator = AlphaSpace() dummy_field.data = test_v validator(dummy_form, dummy_field)
class SearchName(FlaskForm): name = StringField('Recipe Name', [ validators.DataRequired(), AlphaSpace('The name should only consist of letters and spaces') ])
class RegisterForm(FlaskForm): title = SelectField("<strong>Title</strong>", choices=titles) firstName = StringField( "<strong>First Name *</strong>", validators=[InputRequired(), Length(min=4, max=45), Alpha()]) middleName = StringField( "<strong>Middle Name</strong>", validators=[Optional(), Length(min=4, max=45), Alpha()]) lastName = StringField( "<strong>Last Name *</strong>", validators=[InputRequired(), Length(min=4, max=45), Alpha()]) preferredName = StringField( "<strong>Preferred Name</strong>", validators=[Optional(), Length(min=1, max=45), Alpha()]) sex = SelectField("<strong>Sex *</strong>", choices=sexes) dateOfBirth = DateField("<strong>Date of Birth *</strong>", format="%Y-%m-%d", validators=[InputRequired()], render_kw={ "min": "1990-01-01", "max": datetime.date.today() }) street = StringField( "<strong>Street *</strong>", validators=[ InputRequired(), Length(min=4, max=100), Regexp( streetRegex, message= "Must only contain alpha characters, numbers, spaces and periods." ) ]) city = StringField( "<strong>City *</strong>", validators=[InputRequired(), Length(min=4, max=45), AlphaSpace()]) zipCode = StringField( "<strong>Zip Code *</strong>", validators=[InputRequired(), Length(min=4, max=10), Integer()]) state = StringField( "<strong>State</strong>", validators=[Optional(), Length(min=2, max=45), AlphaSpace()]) country = StringField( "<strong>Country *</strong>", validators=[InputRequired(), Length(min=4, max=45), AlphaSpace()]) phone = StringField( "<strong>Phone *</strong>", validators=[ InputRequired(), Length(min=4, max=200), Regexp(streetRegex, message= "Must only contain numbers, and some special characters.") ]) email = StringField( "<strong>Email *</strong>", validators=[InputRequired(), Length(min=4, max=100), Email()]) username = StringField( "<strong>Username *</strong>", validators=[InputRequired(), Length(min=4, max=45), AlphaNumeric()]) password = PasswordField("<strong>Password *</strong>", validators=[ InputRequired(), Length(min=4, max=64), AlphaNumeric(), EqualTo("repeatPassword", "Passwords must match.") ]) repeatPassword = PasswordField( "<strong>Repeat Password *</strong>", validators=[InputRequired(), Length(min=4, max=64), AlphaNumeric()]) securityQuestion = SelectField("<strong>Security Question *</strong>", choices=securityQuestions) securityAnswer = StringField( "<strong>Answer *</strong>", validators=[InputRequired(), Length(min=4, max=45), AlphaNumeric()]) submit = SubmitField("Register") # Check if email already exist in database def validate_email(self, email): with app.app_context(): cursor = mysql.connection.cursor() cursor.execute("SELECT * FROM users WHERE Email = \'%s\'" % self.email.data) alreadyExists = cursor.fetchone() cursor.close() if alreadyExists: raise ValidationError( "This email is taken. Please choose a different one.") # Check if username already exist in database def validate_username(self, username): with app.app_context(): cursor = mysql.connection.cursor() cursor.execute("SELECT * FROM users WHERE Username = \'%s\'" % self.username.data) alreadyExists = cursor.fetchone() cursor.close() if alreadyExists: raise ValidationError( "This username is taken. Please choose a different one.")