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)