Skip to content

Instantly share code, notes, and snippets.

@helje5
Created June 30, 2024 13:07
Show Gist options
  • Save helje5/f19dc87ead6db32208f44a63389319e2 to your computer and use it in GitHub Desktop.
Save helje5/f19dc87ead6db32208f44a63389319e2 to your computer and use it in GitHub Desktop.
CoreData Simple Object Insert
💽 ===============
💽 CoreData: 1 Simple Objects
===============
CoreData: annotation: Connecting to sqlite database file at "/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/CoreUserDB"
CoreData: annotation: creating schema.
CoreData: sql: pragma page_size=4096
CoreData: sql: pragma auto_vacuum=2
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: CREATE TABLE ZCOREUSER ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZAGE INTEGER, ZFIRSTNAME VARCHAR, ZSURNAME VARCHAR, ZID BLOB )
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a4780> on entity 'CoreUser' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreUser_UNIQUE_id ON ZCOREUSER (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreUser_UNIQUE_id ON ZCOREUSER (ZID COLLATE BINARY ASC)
CoreData: annotation: Creating primary key table.
CoreData: sql: CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(1, 'CoreUser', 0, 0)
CoreData: sql: CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: DELETE FROM Z_METADATA WHERE Z_VERSION = ?
CoreData: sql: INSERT INTO Z_METADATA (Z_VERSION, Z_UUID, Z_PLIST) VALUES (?, ?, ?)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB)
CoreData: sql: INSERT INTO Z_MODELCACHE (Z_CONTENT) VALUES (?)
CoreData: sql: COMMIT
CoreData: sql: pragma journal_mode=wal
CoreData: sql: pragma recursive_triggers=1
CoreData: sql: pragma journal_mode=wal
CoreData: sql: SELECT Z_VERSION, Z_UUID, Z_PLIST FROM Z_METADATA
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ACHANGE'
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: DELETE FROM ZCOREUSER WHERE Z_PK IN (SELECT t0.Z_PK FROM ZCOREUSER t0 )
CoreData: sql: COMMIT
CoreData: sql: pragma page_count
CoreData: annotation: sql execution time: 0.0000s
CoreData: sql: pragma freelist_count
CoreData: annotation: sql execution time: 0.0000s
💽 User instantiation: 0.0003
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: SELECT Z_MAX FROM Z_PRIMARYKEY WHERE Z_ENT = ?
CoreData: sql: UPDATE OR FAIL Z_PRIMARYKEY SET Z_MAX = ? WHERE Z_ENT = ? AND Z_MAX = ?
CoreData: sql: COMMIT
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: INSERT INTO ZCOREUSER(Z_PK, Z_ENT, Z_OPT, ZAGE, ZFIRSTNAME, ZSURNAME) VALUES(?, ?, ?, ?, ?, ?)
CoreData: sql: UPDATE OR FAIL ZCOREUSER SET ZID = ? WHERE Z_PK = ?
CoreData: sql: COMMIT
💽 Create users: 0.0068
CoreData: sql: SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZAGE, t0.ZFIRSTNAME, t0.ZID, t0.ZSURNAME FROM ZCOREUSER t0 WHERE t0.ZFIRSTNAME = ? ORDER BY t0.ZAGE
CoreData: annotation: sql connection fetch time: 0.0001s
CoreData: annotation: total fetch execution time: 0.0001s for 0 rows.
0 users named `Jane`
💽 Fetch users named `Jane` in age order: 0.0006
CoreData: sql: SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZAGE, t0.ZFIRSTNAME, t0.ZID, t0.ZSURNAME FROM ZCOREUSER t0 WHERE t0.ZFIRSTNAME = ?
CoreData: annotation: sql connection fetch time: 0.0000s
CoreData: annotation: total fetch execution time: 0.0001s for 0 rows.
0 users named `Jane` being renamed to `Wendy`
0 users renamed to `Wendy`
💽 Rename users named `Jane` to `Wendy`: 0.0004
💽 DB file size: 0.03 MB
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: DELETE FROM ZCOREUSER WHERE Z_PK IN (SELECT t0.Z_PK FROM ZCOREUSER t0 )
CoreData: sql: COMMIT
💽 Delete all users: 0.0003
CoreData: annotation: Connecting to sqlite database file at "/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/default.store"
CoreData: annotation: creating schema.
CoreData: sql: pragma page_size=4096
CoreData: sql: pragma auto_vacuum=2
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: CREATE TABLE ZSWIFTUSER ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZAGE INTEGER, ZFIRSTNAME VARCHAR, ZSURNAME VARCHAR, ZID BLOB )
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a5e00> on entity 'SwiftUser' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftUser_UNIQUE_id ON ZSWIFTUSER (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftUser_UNIQUE_id ON ZSWIFTUSER (ZID COLLATE BINARY ASC)
CoreData: annotation: Creating primary key table.
CoreData: sql: CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(1, 'SwiftUser', 0, 0)
CoreData: sql: CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: DELETE FROM Z_METADATA WHERE Z_VERSION = ?
CoreData: sql: INSERT INTO Z_METADATA (Z_VERSION, Z_UUID, Z_PLIST) VALUES (?, ?, ?)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB)
CoreData: sql: INSERT INTO Z_MODELCACHE (Z_CONTENT) VALUES (?)
CoreData: sql: CREATE TABLE ACHANGE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCHANGETYPE INTEGER, ZENTITY INTEGER, ZENTITYPK INTEGER, ZTRANSACTIONID INTEGER, ZCOLUMNS BLOB )
CoreData: sql: CREATE TABLE ATRANSACTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZAUTHORTS INTEGER, ZBUNDLEIDTS INTEGER, ZCONTEXTNAMETS INTEGER, ZPROCESSIDTS INTEGER, ZTIMESTAMP FLOAT, ZAUTHOR VARCHAR, ZBUNDLEID VARCHAR, ZCONTEXTNAME VARCHAR, ZPROCESSID VARCHAR, ZQUERYGEN BLOB )
CoreData: sql: CREATE TABLE ATRANSACTIONSTRING ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZNAME VARCHAR )
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1cc0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ACHANGE_ZTRANSACTIONID_INDEX ON ACHANGE (ZTRANSACTIONID)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ACHANGE_ZTRANSACTIONID_INDEX ON ACHANGE (ZTRANSACTIONID)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1cc0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZAUTHORTS_INDEX ON ATRANSACTION (ZAUTHORTS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZAUTHORTS_INDEX ON ATRANSACTION (ZAUTHORTS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1bd0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZBUNDLEIDTS_INDEX ON ATRANSACTION (ZBUNDLEIDTS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZBUNDLEIDTS_INDEX ON ATRANSACTION (ZBUNDLEIDTS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1db0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZCONTEXTNAMETS_INDEX ON ATRANSACTION (ZCONTEXTNAMETS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZCONTEXTNAMETS_INDEX ON ATRANSACTION (ZCONTEXTNAMETS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1c20> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZPROCESSIDTS_INDEX ON ATRANSACTION (ZPROCESSIDTS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZPROCESSIDTS_INDEX ON ATRANSACTION (ZPROCESSIDTS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1b80> on entity 'TRANSACTION' with sql text 'CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionAuthorIndex ON ATRANSACTION (ZAUTHOR COLLATE BINARY ASC)'
CoreData: sql: CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionAuthorIndex ON ATRANSACTION (ZAUTHOR COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1b30> on entity 'TRANSACTION' with sql text 'CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionTimestampIndex ON ATRANSACTION (ZTIMESTAMP COLLATE BINARY ASC)'
CoreData: sql: CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionTimestampIndex ON ATRANSACTION (ZTIMESTAMP COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1b30> on entity 'TRANSACTIONSTRING' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_TRANSACTIONSTRING_UNIQUE_NAME ON ATRANSACTIONSTRING (ZNAME COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_TRANSACTIONSTRING_UNIQUE_NAME ON ATRANSACTIONSTRING (ZNAME COLLATE BINARY ASC)
CoreData: sql: COMMIT
CoreData: sql: pragma journal_mode=wal
CoreData: sql: pragma recursive_triggers=1
CoreData: sql: pragma journal_mode=wal
CoreData: sql: SELECT Z_VERSION, Z_UUID, Z_PLIST FROM Z_METADATA
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ACHANGE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ATRANSACTION'
CoreData: debug: Remote Change Notification - registered core observer for 1866CB4E-08D9-4150-A47D-24E060204487
CoreData: debug: Remote Change Notification - registered for com.apple.coredata.NSPersistentStoreRemoteChangeNotification.remotenotification.1866CB4E-08D9-4150-A47D-24E060204487
BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: /private/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/default.store
CoreData: annotation: Disconnecting from sqlite database.
invalidated open fd: 6 (0x11)
CoreData: annotation: Connecting to sqlite database file at "/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/default.store"
CoreData: annotation: creating schema.
CoreData: sql: pragma page_size=4096
CoreData: sql: pragma auto_vacuum=2
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: CREATE TABLE ZSWIFTGRADE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSTUDENT INTEGER, ZEXAMBOARD VARCHAR, ZGRADE VARCHAR, ZSUBJECT VARCHAR, ZID BLOB )
CoreData: sql: CREATE TABLE ZSWIFTSCHOOL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZLOCATION VARCHAR, ZNAME VARCHAR, ZCOMPREHENSIVE VARCHAR, ZGRAMMAR VARCHAR, ZPRIVATE VARCHAR, ZRELIGIOUS VARCHAR, ZID BLOB )
CoreData: sql: CREATE TABLE ZSWIFTSTUDENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZAGE INTEGER, ZSCHOOL INTEGER, ZFIRSTNAME VARCHAR, ZSURNAME VARCHAR, ZID BLOB )
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a6800> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ZSWIFTGRADE_ZSTUDENT_INDEX ON ZSWIFTGRADE (ZSTUDENT)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ZSWIFTGRADE_ZSTUDENT_INDEX ON ZSWIFTGRADE (ZSTUDENT)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a67b0> on entity 'SwiftGrade' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftGrade_UNIQUE_id ON ZSWIFTGRADE (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftGrade_UNIQUE_id ON ZSWIFTGRADE (ZID COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a67b0> on entity 'SwiftSchool' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftSchool_UNIQUE_id ON ZSWIFTSCHOOL (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftSchool_UNIQUE_id ON ZSWIFTSCHOOL (ZID COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a67b0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ZSWIFTSTUDENT_ZSCHOOL_INDEX ON ZSWIFTSTUDENT (ZSCHOOL)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ZSWIFTSTUDENT_ZSCHOOL_INDEX ON ZSWIFTSTUDENT (ZSCHOOL)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a6800> on entity 'SwiftStudent' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftStudent_UNIQUE_id ON ZSWIFTSTUDENT (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_SwiftStudent_UNIQUE_id ON ZSWIFTSTUDENT (ZID COLLATE BINARY ASC)
CoreData: annotation: Creating primary key table.
CoreData: sql: CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(1, 'SwiftGrade', 0, 0)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(2, 'SwiftSchool', 0, 0)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(3, 'SwiftStudent', 0, 0)
CoreData: sql: CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: DELETE FROM Z_METADATA WHERE Z_VERSION = ?
CoreData: sql: INSERT INTO Z_METADATA (Z_VERSION, Z_UUID, Z_PLIST) VALUES (?, ?, ?)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB)
CoreData: sql: INSERT INTO Z_MODELCACHE (Z_CONTENT) VALUES (?)
CoreData: sql: CREATE TABLE ACHANGE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCHANGETYPE INTEGER, ZENTITY INTEGER, ZENTITYPK INTEGER, ZTRANSACTIONID INTEGER, ZCOLUMNS BLOB )
CoreData: sql: CREATE TABLE ATRANSACTION ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZAUTHORTS INTEGER, ZBUNDLEIDTS INTEGER, ZCONTEXTNAMETS INTEGER, ZPROCESSIDTS INTEGER, ZTIMESTAMP FLOAT, ZAUTHOR VARCHAR, ZBUNDLEID VARCHAR, ZCONTEXTNAME VARCHAR, ZPROCESSID VARCHAR, ZQUERYGEN BLOB )
CoreData: sql: CREATE TABLE ATRANSACTIONSTRING ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZNAME VARCHAR )
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1180> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ACHANGE_ZTRANSACTIONID_INDEX ON ACHANGE (ZTRANSACTIONID)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ACHANGE_ZTRANSACTIONID_INDEX ON ACHANGE (ZTRANSACTIONID)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1180> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZAUTHORTS_INDEX ON ATRANSACTION (ZAUTHORTS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZAUTHORTS_INDEX ON ATRANSACTION (ZAUTHORTS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1f90> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZBUNDLEIDTS_INDEX ON ATRANSACTION (ZBUNDLEIDTS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZBUNDLEIDTS_INDEX ON ATRANSACTION (ZBUNDLEIDTS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1f40> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZCONTEXTNAMETS_INDEX ON ATRANSACTION (ZCONTEXTNAMETS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZCONTEXTNAMETS_INDEX ON ATRANSACTION (ZCONTEXTNAMETS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1ef0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ATRANSACTION_ZPROCESSIDTS_INDEX ON ATRANSACTION (ZPROCESSIDTS)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ATRANSACTION_ZPROCESSIDTS_INDEX ON ATRANSACTION (ZPROCESSIDTS)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a1fe0> on entity 'TRANSACTION' with sql text 'CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionAuthorIndex ON ATRANSACTION (ZAUTHOR COLLATE BINARY ASC)'
CoreData: sql: CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionAuthorIndex ON ATRANSACTION (ZAUTHOR COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a2030> on entity 'TRANSACTION' with sql text 'CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionTimestampIndex ON ATRANSACTION (ZTIMESTAMP COLLATE BINARY ASC)'
CoreData: sql: CREATE INDEX IF NOT EXISTS Z_TRANSACTION_TransactionTimestampIndex ON ATRANSACTION (ZTIMESTAMP COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a4e60> on entity 'TRANSACTIONSTRING' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_TRANSACTIONSTRING_UNIQUE_NAME ON ATRANSACTIONSTRING (ZNAME COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_TRANSACTIONSTRING_UNIQUE_NAME ON ATRANSACTIONSTRING (ZNAME COLLATE BINARY ASC)
CoreData: sql: COMMIT
CoreData: sql: pragma journal_mode=wal
CoreData: sql: pragma recursive_triggers=1
CoreData: sql: pragma journal_mode=wal
CoreData: sql: SELECT Z_VERSION, Z_UUID, Z_PLIST FROM Z_METADATA
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ACHANGE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ATRANSACTION'
CoreData: debug: Remote Change Notification - registered core observer for 13E2B62A-ED0B-46D8-B648-C4C8324A3040
CoreData: debug: Remote Change Notification - registered for com.apple.coredata.NSPersistentStoreRemoteChangeNotification.remotenotification.13E2B62A-ED0B-46D8-B648-C4C8324A3040
BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: /private/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/default.store
CoreData: annotation: Disconnecting from sqlite database.
invalidated open fd: 6 (0x11)
CoreData: annotation: Connecting to sqlite database file at "/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/CoreUserDB"
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: pragma recursive_triggers=1
CoreData: sql: pragma journal_mode=wal
CoreData: sql: SELECT Z_VERSION, Z_UUID, Z_PLIST FROM Z_METADATA
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ACHANGE'
BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: /private/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/CoreUserDB
CoreData: annotation: Disconnecting from sqlite database.
BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: /private/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/CoreUserDB
invalidated open fd: 6 (0x11)
invalidated open fd: 3 (0x11)
WARN: Did not find target model for relationship: CoreStudent school
Could not find inverse relationship for: (<NSRelationshipDescription: 0x3022b8c80>), name grades, isOptional 0, isTransient 0, entity CoreStudent, renamingIdentifier , validation predicates (
), warnings (
), versionHashModifier (null)
userInfo {
}, destination entity CoreGrade, inverseRelationship (null), minCount 0, maxCount 0, isOrdered 0, deleteRule 2
error: Cannot use uniqueness constraints { (
(
id
)
) } on entity 'CoreSchool' due to relationship 'students' having a mandatory to-one inverse relationship 'school' and not using a cascade delete rule on 'students'
CoreData: error: Cannot use uniqueness constraints { (
(
id
)
) } on entity 'CoreSchool' due to relationship 'students' having a mandatory to-one inverse relationship 'school' and not using a cascade delete rule on 'students'
CoreData: annotation: Connecting to sqlite database file at "/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/CoreStudentDB"
CoreData: annotation: creating schema.
CoreData: sql: pragma page_size=4096
CoreData: sql: pragma auto_vacuum=2
CoreData: sql: BEGIN EXCLUSIVE
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: CREATE TABLE ZCOREGRADE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, Z3GRADES INTEGER, ZEXAMBOARD VARCHAR, ZGRADE VARCHAR, ZSTUDENT VARCHAR, ZSUBJECT VARCHAR, ZID BLOB )
CoreData: sql: CREATE TABLE ZCORESCHOOL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZLOCATION VARCHAR, ZNAME VARCHAR, ZTYPE VARCHAR, ZID BLOB )
CoreData: sql: CREATE TABLE ZCORESTUDENT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZAGE INTEGER, ZSCHOOL INTEGER, ZFIRSTNAME VARCHAR, ZSURNAME VARCHAR, ZID BLOB )
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a6080> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ZCOREGRADE_Z3GRADES_INDEX ON ZCOREGRADE (Z3GRADES)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ZCOREGRADE_Z3GRADES_INDEX ON ZCOREGRADE (Z3GRADES)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a5cc0> on entity 'CoreGrade' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreGrade_UNIQUE_id ON ZCOREGRADE (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreGrade_UNIQUE_id ON ZCOREGRADE (ZID COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a5cc0> on entity 'CoreSchool' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreSchool_UNIQUE_id ON ZCORESCHOOL (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreSchool_UNIQUE_id ON ZCORESCHOOL (ZID COLLATE BINARY ASC)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a5cc0> on entity '(null)' with sql text 'CREATE INDEX IF NOT EXISTS ZCORESTUDENT_ZSCHOOL_INDEX ON ZCORESTUDENT (ZSCHOOL)'
CoreData: sql: CREATE INDEX IF NOT EXISTS ZCORESTUDENT_ZSCHOOL_INDEX ON ZCORESTUDENT (ZSCHOOL)
CoreData: annotation: Execute create index statement: NSSQLiteStatement <0x3030a6080> on entity 'CoreStudent' with sql text 'CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreStudent_UNIQUE_id ON ZCORESTUDENT (ZID COLLATE BINARY ASC)'
CoreData: sql: CREATE UNIQUE INDEX IF NOT EXISTS Z_CoreStudent_UNIQUE_id ON ZCORESTUDENT (ZID COLLATE BINARY ASC)
CoreData: annotation: Creating primary key table.
CoreData: sql: CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(1, 'CoreGrade', 0, 0)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(2, 'CoreSchool', 0, 0)
CoreData: sql: INSERT INTO Z_PRIMARYKEY(Z_ENT, Z_NAME, Z_SUPER, Z_MAX) VALUES(3, 'CoreStudent', 0, 0)
CoreData: sql: CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: DELETE FROM Z_METADATA WHERE Z_VERSION = ?
CoreData: sql: INSERT INTO Z_METADATA (Z_VERSION, Z_UUID, Z_PLIST) VALUES (?, ?, ?)
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB)
CoreData: sql: INSERT INTO Z_MODELCACHE (Z_CONTENT) VALUES (?)
CoreData: sql: COMMIT
CoreData: sql: pragma journal_mode=wal
CoreData: sql: pragma recursive_triggers=1
CoreData: sql: pragma journal_mode=wal
CoreData: sql: SELECT Z_VERSION, Z_UUID, Z_PLIST FROM Z_METADATA
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_METADATA'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'Z_MODELCACHE'
CoreData: sql: SELECT TBL_NAME FROM SQLITE_MASTER WHERE TBL_NAME = 'ACHANGE'
CoreData: annotation: Disconnecting from sqlite database.
BUG IN CLIENT OF libsqlite3.dylib: database integrity compromised by API violation: vnode unlinked while in use: /private/var/mobile/Containers/Data/Application/556D618D-E701-4FCC-A879-D62AB3747F0F/Library/Application Support/CoreStudentDB
invalidated open fd: 7 (0x11)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment