
    h                     >    d dl Zd dlmZ d Zd Zd Zd Zd Zd Z	dS )	    N)current_appc                  X    t          j        dddddt           j        j                  } | S )N	localhostfigoscolaridb_figoutf8mb4)hostuserpassworddatabasecharsetcursorclass)pymysqlconnectcursors
DictCursor)dbs    '/users/figo/public_html/wsgi/stud/db.pyget_dbr      s6    	O.
0 
0 
0B I    c                      t                                                      } d}|                     |           |                                 S )NzSELECT * FROM stud)r   cursorexecutefetchall)r   querys     r   showr      s:    			B EJJu;;==r   c                     t                                                      }d|  d}|                    |           |                                S )Nz"SELECT * FROM stud WHERE roll_no='')r   r   r   fetchone)roll_nor   r   s      r   getr"      sE    			B;;;;EJJu;;==r   c                     d }	 t                      }|                                                    d| d         | d         f           |                                 n# |j        $ r d| d          d}Y nw xY w|S )Nz0INSERT INTO stud (Name, roll_no) VALUES (%s, %s)namer!   User number  is already registered.r   r   r   commitIntegrityError)dataerrorr   s      r   insertr,      s    E	HXX
		&\4	?+	
 	
 	

 			 H H HGtIGGGHLs   AA A65A6c                     t                      }|                                                    d|            |                                 d S )Nz!DELETE FROM stud WHERE roll_no=%s)r   r   r   r(   )r!   r   s     r   deleter.   +   s<    	BIIKK;gGGGIIKKK
Fr   c                     d }	 t                      }|                                                    d| d         | d         |f           |                                 n# |j        $ r d| d          d}Y nw xY w|S )Nz4UPDATE stud SET roll_no=%s, Name=%s WHERE roll_no=%sr!   r$   r%   r&   r'   )r*   old_roll_nor+   r   s       r   updater1   1   s    EHXX
		RUYZcUdeijpeqs~T  	A  	A  	A
		 H H HGtIGGGHLs   AA A76A7)
pymysql.cursorsr   flaskr   r   r   r"   r,   r.   r1    r   r   <module>r5      s                           r   