Function clearLocalState

examples/react-native/shopping-list/src/db/collections.ts:119–147

(
  offline: ReturnType<typeof createOfflineExecutor> | null,
)

}

export async function clearLocalState(
  offline: ReturnType<typeof createOfflineExecutor> | null,
): Promise<void> {
  if (offline) {
    await offline.clearOutbox()
  } else {
    await offlineStorage.clear()
  }

  const rows = extractRows(
    await executeSql(
      `SELECT name FROM sqlite_master WHERE type = 'table' AND name NOT LIKE 'sqlite_%'`,
    ),
  )

  await executeSql(`PRAGMA foreign_keys = OFF`)
  try {
    for (const row of rows) {
      const tableName = row.name
      if (typeof tableName === `string`) {
        await executeSql(
          `DROP TABLE IF EXISTS "${tableName.replace(/"/g, `""`)}"`,
        )
      }
    }
  } finally {
    await executeSql(`PRAGMA foreign_keys = ON`)
  }
}

export const listsCollection = createCollection(
  persistedCollectionOptions<