TADSQLiteBackup Class

The class implementing SQLite backup, restore, copy database functionality.

Group

Classes

Class Hierarchy

File

uADPhysSQLite

Links

public, published, TADSQLiteBackup Members, Example 1, Example 2, Classes

Description

Use the TADSQLiteBackup component to add a backup, restore, copy database capability to an application.

To produce a DB backup an application should:

specify DriverLink;
specify Database or DatabaseObj - a source database file name or object to backup;
specify DestDatabase or DestDatabaseObj - a destination database file name or object to put a database backup file;
optionally specify WaitForLocks and BusyTimeout to avoid locking conflicts;
call Backup method.

Other properties and methods are optional.

The SQLite backup actually copies the specified database to a new file. The copying is consistent and does not depend on the currently connected users.

Also the copying may be performed not only between files, but also between memory and file or backward. In this case use DatabaseObj or DestDatabaseObj to specify connected memory database.

Syntax

TADSQLiteBackup = class(TADSQLiteService);

Example 1

ADSQLiteBackup1.Database := 'c:\addemo.sdb';
ADSQLiteBackup1.DestDatabase := 'c:\addemo.backup';
ADSQLiteBackup1.Backup;

Example 2

// create SQLite in-memory database
with ADConnection1.Params do begin
  Clear;
  Add('DriverID=SQLite');
  Add('Database=:memory:');
end;
ADConnection1.Connected := True;

// populate the in-memory database
ADConnection1.ExecSQL('create table aaa (f1 integer, f2 text)');
ADConnection1.ExecSQL('insert into aaa values (1, ''qqq'')');
ADConnection1.ExecSQL('insert into aaa values (2, ''www'')');
ADConnection1.ExecSQL('insert into aaa values (3, ''eee'')');

// specify the in-memory database objects as a backup source
ADSQLiteBackup1.DatabaseObj := ADConnection1.CliObj;

// specify database file name as a backup destination
ADSQLiteBackup1.DestDatabase := 'c:\db.sdb';
// copy the in-memory database to the file

ADSQLiteBackup1.Backup;

What do you think about this topic? Send feedback!