Other string manipulation functions (and more) are detailed in the SQLite core functions list The following should point you in the right direction. If you disconnect from in-memory database, the database gets destroyed, so then you don't need to reset those. You can use the built in replace () function to perform a string replace in a query. Group 3 are for example schema_version, user_version, maybe some others, you need to look it up. If you don't disconnect, you will need to reset those to defaults manually. These pragmas are always set to defaults when opening new connection to the database. Group 2 are for example cache_size, recursive_triggers, jurnal_mode, foreign_keys, busy_timeout, etc. You should not need to reset pragmas from group 1. The encoding is defined at creation time and cannot be modified later. The page_count cannot be changed by user, but it changes automatically when adding data (obviously). For example page_size can be changed prior to "VACUUM", so the new page size will be set then. Those are definied at database creation moment and usualle cannot be modified later, with some exceptions. Group 1 are for example page_size, page_count, encoding, etc.
0 Comments
Leave a Reply. |