Untitled
import sqlite3 class schedule(): connection = 0 cursor = '' def __init__(self): self.connection = sqlite3.connect('schedule') self.cursor = self.connection.cursor() self.cursor.execute('CREATE TABLE IF NOT EXISTS'+ '`day` ('+ '`id` INT NOT NULL AUTO_INCREMENT,'+ '`date` DATE NOT NULL,'+ '`lessons_count` int NOT NULL,'+ '`place` varchar NOT NULL,'+ '`lessons` varchar NOT NULL,'+ 'PRIMARY KEY (`id`)'+ ');') self.cursor.execute('CREATE TABLE IF NOT EXISTS' + '`lesson` (' + '`id` INT NOT NULL AUTO_INCREMENT,' + '`teacher` varchar NOT NULL,' + '`theme` varchar NOT NULL,' + '`time` varchar NOT NULL,' + '`home_work` varchar NOT NULL' + '`replace` varchar NOT NULL,' + 'PRIMARY KEY (`id`)' + ');') def create_day(self, date, lessons_count, place, lessons): cursor.execute(f'INSER INTO day VALUES('+ '{date},{lessons_count},{place},{lessons})')
Leave a Comment