Skip to main content

writedb​

writedb(
    @path ## symbol (required)
    @db null
) -> llll/null

Write SQLite3 database @db as a .llll file.

Arguments​

  • @path [symbol]: Destination path for SQL database as a .llll file. (required)
  • @db [symbol/null]: Optional database name. If set to null, 'main' is used as the default database name. (default: null).

Output​

Query results. [llll/null]

Usage​

$events = importmidi('bach.mid'); ## MIDI as table data
$db1 = 'first'; ## database name 1
$db2 = 'second'; ## database name 2
$path = './mydb.llll'; ## output path
createdbtable(
    @data $events ## table data
    @name 'events' ## table name
    @db $db1 ## database name 1
);
writedb(@path $path @db $db1); ## write database 1
readdb(@path $path @db $db2); ## read and load into database 2
$results = querydb('SELECT * FROM events', $db2); ## query database 2
print($results)