class st_test(): #st_test로 클래스 정의
    def __init__(self, std_name, std_number, subject, score): #변수 4개
        self.std_name = std_name
        self.std_number = std_number
        self.subject = subject
        self.score = score

def db_create(): #db생성
    sql = '''CREATE table test(
                std_name varchar(16),
                std_id varchar(16),
                subject varchar(16)
                score int,
                primary key(std_name,std_id,subject, score));'''
    conn = sq3.connect("lasttest.db")
    cur = conn.cursor()
    cur.execute(sql) #테이블 삽입
    conn.commit()
    cur.close()

def insert_db(): #db 연결
    conn = sq3.connect('lasttest.db')
    cur = conn.cursor()

    cur.execute('SELECT * FROM test') #test테이블에서 전체 가져오기
    records = cur.fetchall()

    for (std_name, std_number,subject, score) in records:
        print(std_name,std_number,subject,str(score))

    conn.commit()
    conn.close()

    insert_db(std_name,std_number,subject, score)