Python Dynamic Queries

Static Query:

• Static queries execute with fixed set of values.
• query = “insert into account values(101, ‘amar’ , 5000)”

Dynamic Query:

• Dynamic query execute with different set of values every time.
• We can construct the dynamic query by reading input from the end user.
• For example:
  • no = int(input(“Enter accno : “))
  • name = input(“Enter name : “)
  • bal = int(input(“Enter balance : “))
  • query = “insert into account values(%d, ‘%s’ , %d)” %(no, name, bal)

import mysql.connector
class DB:
    con=None
    def main():
        try :
            DB.con = mysql.connector.connect(user='root',
                                    password='root',
                                    host='127.0.0.1',
                                    database='student')
            print("Connected...")
            cur = DB.con.cursor()

            no = int(input("Enter accno : "))
            name = input("Enter name : ")
            bal = int(input("Enter balance : "))

            query = "insert into account values(%d, '%s' , %d)" %(no,name,bal)
            print("Query is :",query)

            cur.execute(query)
            print("Records inserted...")

            DB.con.commit()
            print("Transaction committed...")

        except Exception as e:
            print("Exception :",e)

        finally:
            if DB.con != None:
                DB.con.close()
                print("Connection closed..")

        return

DB.main()