def truncate(): # чистит id записей conn = m.get_connection() try: with conn.cursor() as cur: sql = "TRUNCATE `groups`" count = cur.execute(sql) conn.commit() print(f'deleted = {count} rows') finally: conn.close()
def del_all(): conn = m.get_connection() try: with conn.cursor() as cur: sql = "DELETE FROM `groups`" count = cur.execute(sql) conn.commit() print(f'deleted = {count} rows') finally: conn.close()
def insert_many(rows): # пока только ONE conn = m.get_connection() try: with conn.cursor() as cur: sql = "INSERT INTO `groups` (nameGr,idCur) VALUES (%s,%s)" count = cur.executemany(sql, rows) # список кортежей conn.commit() print(f'inserted {count} rows') finally: conn.close()
def insert_one(rows): # пока только ONE conn = m.get_connection() try: with conn.cursor() as cur: sql = "INSERT INTO `groups` (`nameGr`,`idCur`) VALUES (%s,%s)" row = rows[0] count = cur.execute(sql, (row[1], row[2])) # только nameGr, idCur conn.commit() print(f'inserted = {count} rows') finally: conn.close()
def delete(nameGr): conn = m.get_connection() try: with conn.cursor() as cur: sql = "DELETE FROM `groups` WHERE nameGr = %s" count = cur.execute(sql, (nameGr)) conn.commit() print(f'deleted = {count} rows') except: print('ошибка записи') finally: conn.close()
def create(): # чистит id записей conn = m.get_connection() try: with conn.cursor() as cur: sql = " \ CREATE TABLE `soft0016_faculty`.`students` \ (`id` INT NOT NULL AUTO_INCREMENT, \ `nameSt` VARCHAR(20) NOT NULL, \ `sex` INT NOT NULL, \ `age` INT NOT NULL, \ `idGr` INT NOT NULL, \ PRIMARY KEY (`id`)) \ ENGINE = InnoDB;" cur.execute(sql) conn.commit() finally: conn.close()
import pymysql.cursors import modules.module as m conn = m.get_connection() try: with conn.cursor() as cur: name_table = 'curators' nameCur = 'Джек Дорси' sql = "INSERT INTO " + \ name_table +\ " (nameCur) VALUES(%s)" count = cur.execute(sql, nameCur) conn.commit() print(f'inserted = {count}') # # finally: conn.close()