sqliteCloneIntoDB: clone an sqlite table schema (including indexes) from the...

In MotusWTS/motusServer: Operate a server to process data for http://motus.org

clone an sqlite table schema (including indexes) from the main DB into an attached DB

Description

clone an sqlite table schema (including indexes) from the main DB into an attached DB

Usage

sqliteCloneIntoDB(sql, tableName, dbName)

Arguments

sql	safeSQL object to sqlite database
tableName	character; name of table in main database which should be cloned into attached database
dbName	name of attached DB; i.e. the 'D' from a statement like ‘attach database ’blam.sqlite' as D'. The database must already have been attached by the caller.

Details

creates the empty table with the same key and with any associated indexes, but only if a table (and/or indexes) of the same name don't already exist in the attached db.

MotusWTS/motusServer documentation built on Oct. 13, 2024, 7:31 p.m.