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.")