#r
Вопрос:
HW07db lt;- dbConnect(RSQLite::SQLite(), "HW07-db.sqlite") dbListTables(HW07db) getwd() CUSTOMER lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/CUSTOMER.txt") DEPARTMENT lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/DEPARTMENT.txt") EMPLOYEE_PHONE lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/EMPLOYEE_PHONE.txt") EMPLOYEE lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/EMPLOYEE.txt") INVOICES lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/INVOICES.txt") PRODUCT lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/PRODUCT.txt") SALES_ORDER_LINE lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/SALES_ORDER_LINE.txt") SALES_ORDER lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/SALES_ORDER.txt") STOCK_TOTAL lt;- read.csv("/Users/nwillows/Desktop/UCSB-F21/PSTAT10/Labs/Lab13.14/tinyclothes/STOCK_TOTAL.txt") #добавьте фреймы данных в свою базу данных
получаю сообщение об ошибке ниже.
Error: disk I/O error Error: no such savepoint: dbWriteTable_59538_usblbmbhlq dbWriteTable(HW07db, "CUSTOMER", CUSTOMER) dbWriteTable(HW07db, "DEPARTMENT", DEPARTMENT) dbWriteTable(HW07db, "EMPLOYEE_PHONE", EMPLOYEE_PHONE) dbWriteTable(HW07db, "EMPLOYEE", EMPLOYEE) dbWriteTable(HW07db, "INVOICES", INVOICES) dbWriteTable(HW07db, "PRODUCT", PRODUCT) dbWriteTable(HW07db, "SALES_ORDER_LINE", SALES_ORDER_LINE) dbWriteTable(HW07db, "SALES_ORDER", SALES_ORDER) dbWriteTable(HW07db, "STOCK_TOTAL", STOCK_TOTAL)