Python Backend with MySQL: Setup, Connect, Add, Select, Join, Summaries of Mathematics

Download Python Backend with MySQL: Setup, Connect, Add, Select, Join and more Summaries Mathematics in PDF only on Docsity! Lap trinh hé th6ng backend voi Python Phi Hoang Anh Cai dat thu vién Cai dat thu vién: pip install pymysql Tao 1 database: CREATE TABLE user ( id INTEGER NOT NULL, email VARCHAR, password VARCHAR, PRIMARY KEY (id), UNIQUE (email) ) Select / Insert vai nhiéu ban ghi Lay vé tat ca ban ghi: result = cursor.fetchall() # [{'email': 'webmaster@python.org', 'password': 'very-secret'}] Update nhiéu ban ghi: data = [ ('Jane', “Jane ‘s password”) ('Joe', “Joe ‘s password”), ('John', “John ‘s password”) ] stmt = "INSERT INTO users (email, password) VALUES (%s, %S)" cursor.executemany(stmt, data) Insert ignore / On Duplicate key update Insert ignore: cho phép bo qua cac ban ghi co key da ton tai Sql = "INSERT IGNORE INTO users (email, password) VALUES (‘webmaster@python.org’, ‘very- secret’)" cursor.execute(sql) connection.commit() Insert on duplicate key update: Insert hoac update néu key bi trung Sql = "INSERT INTO users (email, password) VALUES (‘webmaster@python.org’, ‘very-secret’) ON DUPLICATE KEY UPDATE updated=VALUES(email)" cursor.execute(sql) connection.commit() Join tables Tao thém 1 bang sau: CREATE TABLE images ( id INTEGER NOT NULL image_path VARCHAR, email VARCHAR, PRIMARY KEY (id) ) sql = “INSERT INTO images (email, image_path) VALUES (‘webmaster@python.org’, ‘my_first_image’ )” cursor.execute(sql) connection.commit() sql = “SELECT users.email, users.password FROM users INNER JOIN images ON users.email=images.email” cursor.execute(sql) # [{'email': 'webmaster@python.org', 'password': 'very-secret'}]