How to change device in Sessions table

ERPNext
1

this is the Sessions table

image
image1294×669 50.6 KB

i have made a login api, this is the in between code of that api, i want to change the device to “mobile”, how can i do this, anyone?

image
image908×295 45 KB

2

use this code

image
image1045×281 26.6 KB

try:
        login_manager = frappe.auth.LoginManager()
        login_manager.authenticate(user=usr, pwd=pwd)
        login_manager.post_login()
        frappe.db.sql("""UPDATE `tabSessions` SET device = 'mobile' WHERE sid = %s""", frappe.session.sid)
        frappe.db.commit()
        
    except:
        data_dict = {
            "Login":False,
            "message":"Invalid username or password"
        }
        return data_dict