basnorth.blogg.se

Python crud gui for postgres
Python crud gui for postgres









python crud gui for postgres

  • vsb= ttk.Scrollbar( self , orient=tk.VERTICAL,command= self.
  • #Scroll bars are set up below considering placement position(x&y) ,height and width of treeview widget.
  • tvStudent.heading( '#7' , text= 'Date of Birth' , anchor= 'center' )

    python crud gui for postgres

    tvStudent.heading( '#6' , text= 'PhoneNumber' , anchor= 'center' ) lumn( '#5' ,width= 10 , anchor= 'center' , stretch= True ) tvStudent.heading( '#5' , text= 'State' , anchor= 'center' ) lumn( '#4' ,width= 10 , anchor= 'center' , stretch= True ) tvStudent.heading( '#4' , text= 'City' , anchor= 'center' ) lumn( '#3' ,width= 10 , anchor= 'center' , stretch= True ) tvStudent.heading( '#3' , text= 'LastName' , anchor= 'center' ) tvStudent.heading( '#2' , text= 'FirstName' , anchor= 'center' ) lumn( '#1' , width= 60 , anchor= 'center' , stretch= False ) tvStudent.heading( '#1' , text= 'RollNo' , anchor= 'center' ) tvStudent= ttk.Treeview( self ,show= "headings" ,height= "5" , columns=columns) btn_exit = tk.Button( self , text= "Exit" , font=( "Helvetica", 16 ), bg= "yellow" , fg= "blue" ,command= self.

    python crud gui for postgres

    btn_update = tk.Button( self ,text= "Update" ,font=( "Helvetica", 11 ),bg= "yellow" , fg= "blue" ,command= self. btn_register = tk.Button( self , text= "Register" , font=( "Helvetica", 11 ), bg= "yellow" , fg= "blue" ,

  • foreground= 'white' , borderwidth= 2 , year= 1950 ,locale= 'en_US' , date_pattern= 'y-mm-dd' ).
  • calDOB = DateEntry( self , width= 12 , background= 'darkblue' , lblSearch = tk.Label( self , text= "Please Enter Roll No:" ,font=( "Helvetica", 10 ), bg= "blue" , fg= "yellow" ) lblSelect = tk.Label( self , text= "Please select one record below to update or delete" , font=( "Helvetica", 10 ), bg= "blue" , fg= "yellow" ) lblContactNo = tk.Label( self , text= "Enter Contact No:" , font=( "Helvetica", 10 ), bg= "blue" , fg= "yellow" ) lblLName = tk.Label( self , text= "Enter LastName:" , font=( "Helvetica", 10 ), bg= "blue" , fg= "yellow" ) lblFName = tk.Label( self , text= "Enter FirstName:" , font=( "Helvetica", 10 ), bg= "blue" , fg= "yellow" ) lblTitle = tk.Label( self , text= "Student Management System" , font=( "Helvetica", 16 ), bg= "yellow" , fg= "green" )
  • db_cursor = db_connection.cursor(buffered= True ) # "buffered=True".makes db_cursor.row_count return actual number of records selected otherwise would return -1.
  • # creating database_cursor to perform SQL operation.
  • #user and password values to connect to MySQL Database server.
  • #Please change user and password values to your.
  • python crud gui for postgres

  • # it takes 3 required parameters 'host', 'user', 'password'.
  • # connecting to the database using 'connect()' method.
  • # importing 'nnector' for connection to mysql database.
  • from tkcalendar import Calendar, DateEntry.










  • Python crud gui for postgres