Created
June 30, 2024 13:07
-
-
Save helje5/f19dc87ead6db32208f44a63389319e2 to your computer and use it in GitHub Desktop.
CoreData Simple Object Insert
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
💽 =============== | |
💽 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