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()