Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
1.3 kB
2
Indexable
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