main.py

import mysql.connector as mc
import gtts
from playsound import playsound
import os
import re

con = mc.connect(host="localhost", user="alen", password="alen", database="railway_ticketing_software")
d = con.cursor()

def userid():
    m = input("User id (6 digits), numeric")
    ln = len(m)

    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(m) != None):
        print("Special Characters are not allowed")

        m = userid()

    else:
        if (m.isalpha()):
            print("Only numericals are allowed", ' \U0001F610')
            m = userid()

        elif (m.isnumeric()):
            if ln != 6:
                print("User id should be of 6 numericals ", "\U0001F610")
                m = userid()

        elif (not m.isdigit() and not m.isalpha()):
            print("Only numericals are allowed ", "\U0001F610")
            m = userid()

        else:
            if (m.isalpha()):
                print("Only numericals are allowed", ' \U0001F610')
                m = userid()

    return m

def a():
    m = input("User ID (6 digits), numeric: ")
    qr = "select * from user_info where user_id = %s"
    va = (m,)

    d.execute(qr, va)

    f = d.fetchall()

    rw = d.rowcount()

    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(m) != None):
        print("Special Characters are not allowed")

        m = a()

    else:
        if rw == 1:
            print("User id exist, please select another user id ", "\U0001F610")
            m = a()

        else:
            ln = len(m)

            if (m.isalpha()):
                print("Only numerals are allowed ", "\U0001F610")
                m = a()

            elif (m.isnumeric()):
                if ln != 6:
                    print("User id should be of 6 numerals ", "\U0001F610")
                    m = a()

            elif (not m.isdigit() and not m.isalpha()):
                print("Only alphabets are allowed ", "\U0001F610")
                m = a()

            else:
                print("Only numerals are allowed ", "\U0001F610")
                m = a()

    return m

def username():
    n = input("Enter username [Note: User _ instead of space]")
    regex = re.compile("'[-@!#$%^&*()<,.+>?/\|}{1234567890~:]'")

    if (regex.search(n) == None):
        print("Accepted")

    else:
        if (n.isdigit()):
            print("Only alphabets are allowed ", "\U0001F610")
            n = username()

        elif (not n.isdigit() and not n.isalpha()):
            print("Only alphabets are allowed ", "\U0001F610")
            n = username()

    return n

def nusername():
    n = input("Enter username [Note: Use _ instead of space]")
    regex = re.compile("[-@!#$%^&*()<,.+>?/\|}{1234567890~:]")

    if (regex.search(n) == None):
        print("Accepted")

    else:
        if ((n.isdigit())):
            print("Only alphabets are allowed ", "\U0001F610")
            n = username()

        elif (not n.isdigit() and not n.isalpha()):
            print("Only alphabets are allowed ", "\U0001F610")
            n = username()

    return n

def c():
    o = input("Enter user age: ")
    ln = len(o)
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(o) != None):
        print("Special characters are not allowed")
        o = c()

    else:
        if (o.isalpha()):
            print("Only numericals are allowed ", "\U0001F610")
            o = c()

        elif (o.isnumeric()):
            op = int(o)

            if (op > 116):
                print("Invalid age ", "\U0001F610")
                o = c()

        elif (not o.isnumeric() and not o.isalpha()):
            print("Only alphabets are allowed ", "\U0001F610")
            o = c()

        else:
            print("Only numerals are allowed ", "\U0001F610")
            o  = c()

    return o

def nc():
    o = input("Enter new user age: ")
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(o) != None):
        print("Special characters are not allowed ", "\U0001F610")
        o = nc()

    else:
        ln = len(o)

        if (o.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            o = nc()

        elif (not o.isnumeric() and not o.isalpha()):
            print("Only alphabets are allowed ", "\U0001F610")
            o = nc()

        else:
            print("Only numerals are allowed ", "\U0001F610")
            o = nc()

    return o

def da():
    p = input("User gender [Note: Use only m or f]: ")
    ln = len(p)
    ph = ['m', 'f']
    pk = p.lower()

    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(p) != None):
        print("Special characters are not allowed ", "\U0001F610")
        p = da()

    else:
        if (p.isnumeric()):
            print("Only alphabets are allowed ", "\U0001F610")
            p = da()

        elif (p.isalpha()):
            if ln != 1:
                print("Gender should be of 1 character [m or f]", "\U0001F610")
                p = da()

            elif pk != ph[0] and pk != ph[1]:
                print("Only m and f are allowed")
                p = da()

        elif (not p.isnumeric() and not p.isalpha()):
            print("Only alphabets are allowed ", "\U0001F610")
            p = da()

    return p

def e():
    q = input("Enter user mobile number [10 digits]: ")
    ln = len(q)
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(q) != None):
        print("Special characters are not allowed")
        q = e()

    else:
        if (q.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            q = e()

        elif (q.isnumeric()):
            if ln != 10:
                print("Mobile no should be of 10 numerals ", "\U0001F610")
                q = e()

        elif (not q.isnumeric() and not q.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            q = e()

    return q

def ne():
    q = input("Enter new mobile number [10 digits]: ")
    ln = len(q)
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(q) != None):
        print("Special characters are not allowed")
        q = ne()

    else:
        if (q.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            q = ne()

        elif (q.isnumeric()):
            if ln != 10:
                print("Mobile number should be of 10 numerals ", "\U0001F610")
                q = ne()

        elif (not q.isdigit() and not q.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            q = ne()

    return q

def fa():
    r = input("Password [4 digits]: ")
    ln = len(r)
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(r) != None):
        print("Special characters are not allowed")
        r = fa()

    else:
        if (r.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            r = fa()

        elif (r.isnumeric()):
            if ln != 4:
                print("Password should be of 4 numerals ", "\U0001F610")
                r = fa()

            else:
                print("Only numerals are allowed ", "\U0001F610")
                r = fa()

    return r

def nfa():
    r = input("Enter new password [4 digits]: ")
    ln = len(r)
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(r) != None):
        print("Special characters are not allowed")
        r = nfa()

    else:
        if (r.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            r = nfa()

        elif (r.isnumeric()):
            if ln != 4:
                print("Password should be of 4 numerals ", "\U0001F610")
                r = nfa()

        else:
            print("Only numerals are allowed ", "\U0001F610")
            r = nfa()

    return r

def trainid():
    r = input("Enter train id [5 digits]: ")
    ln = len(r)
    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(r) != None):
        print("Special characters are not allowed")
        r = trainid()

    else:
        if (r.isalpha()):
            print("Only numerals are allowed ", "\U0001F610")
            r = trainid()

        elif (r.isnumeric()):
            if ln != 5:
                print("Train ID should be of 5 numerals ", "\U0001F610")
                r = trainid()

        else:
            print("Only numerals are allowed ", "\U0001F610")
            r = trainid()

    return r

def newtrainid():
    r = input("Train ID [6 digits]: ")
    ln = len(r)
    qr = 'select * from trains_info where train_id = %s'
    va = (r,)

    d.execute(qr, va)

    f = d.fetchall()
    rw = d.rowcount

    regex = re.compile("[-@!#$%^_&*()<,.+>?/\|}{~:]")

    if (regex.search(r) != None):
        print("Special Characters are not allowed")
        r = newtrainid()