Manual:Database Functions - Revision history

Missionz3r0: /* db:create */ Note how to create a compound unique columns.

2025-11-22T22:01:37Z

db:create: Note how to create a compound unique columns.

2025-11-08T01:37:00Z

db:Timestamp

2025-06-26T18:45:46Z

db:in_

2025-05-29T07:27:29Z

db:add

2025-05-28T14:40:14Z

db:Timestamp

2025-05-28T14:37:45Z

db:Timestamp

2025-05-28T14:28:09Z

Add: db:Timestamp example and aparameters

2025-05-24T13:39:08Z

db:close can close all database connections

2025-05-21T16:06:58Z

Transaction Functions -> Database Transactions

2025-05-21T16:03:14Z

Moved not_between down so it is in alphebetical order.

@@ Line 147: / Line 147: @@
    end
 </syntaxhighlight>
 See also: [[Manual:Scripting#Creating_a_Database| Creating a Database]]

@@ Line 371: / Line 371: @@
 : Can be a string, table, number (unix epoch), nil, or "CURRENT_TIMESTAMP"
 * ''fmt:''
-: Only used if <code>type(ts) == "string"</code>.  Same format as <code>datetime.parse</code>.
+: Only used if <code>type(ts) == "string"</code>.  Same format as <code>datetime:parse</code>.
 <syntaxhighlight lang="lua">

@@ Line 518: / Line 518: @@
 local mydb = db:get_database("my database")
 local areas = {"Undervault", "Hell", "Purgatory"}
 </syntaxhighlight>

@@ Line 8: / Line 8: @@
 ==db:add==
 ;<nowiki>db:add(sheet reference, table1, …, tableN)</nowiki>
-: Adds one or more new rows to the specified sheet. If any of these rows would violate a UNIQUE index, a lua error will be thrown and execution will cancel. As such it is advisable that if you use a UNIQUE index, you test those values before you attempt to insert a new row.
+: Adds one or more new rows to the specified sheet. If any of these rows would violate a UNIQUE index, a Lua error will be thrown if the default violations rule is FAIL. As such it is advisable that if you use a UNIQUE index, you test those values before you attempt to insert a new row.
 : Returns '''nil''' plus the error message if the operation failed (so it won't raise a runtime error in Mudlet).
 ;Example

@@ Line 374: / Line 374: @@
 <syntaxhighlight lang="lua">
-local ts = db:Timestamp("Wed May 28 13:35:37 2025")
+local ts = db:Timestamp("2025-05-28 13:35:37")
 -- ts is a table:

@@ Line 383: / Line 383: @@
 --   set       = function(timestamp) ... end
 -- }
 </syntaxhighlight>

@@ Line 367: / Line 367: @@
 ;<nowiki>db:Timestamp(time)</nowiki>
 :Returns a table that will be converted to an appropriate time. If the time argument is a table, it will be converted to the current OS time; if it is a number, it will be intrepreted as a Unix epoch time; if it is nil, it will be converted to a SQL NULL; it can also have the value of "CURRENT_TIMESTAMP", which will be converted to the corresponding SQL keyword.
 ==db:Null==

@@ Line 57: / Line 57: @@
 ==db:close==
-;<nowiki>db:close(database name)</nowiki>
+;<nowiki>db:close(db_name)</nowiki>
-:Closes a database connection so it can't be used anymore.
+:Closes a database connection or all database connections so they can't be used anymore.
 ==db:create==

@@ Line 521: / Line 521: @@
 :LIKE with "%" is therefore the same as ".*" regular expression.
-= Transaction Functions =
+= Database Transactions =
 These functions facilitate use of transactions with a database. This can safely be ignored in most cases, but can provide useful functionality in specific circumstances. Transactions allow batching sets of changes to be accepted or rejected at a later point. Bear in mind that transactions affect an entire database.

@@ Line 440: / Line 440: @@
 ;<nowiki>db:between(field reference, lower_bound, upper_bound)</nowiki>
 :Returns a database expression to test if the field in the sheet is a value between lower_bound and upper_bound. This only really makes sense for numbers and Timestamps.
 == db:eq ==
@@ Line 503: / Line 499: @@
 ;<nowiki>db:lte(field reference, value)</nowiki>
 :Returns a database expression to test if the field in the sheet is less than or equal to the value.
 == db:not_eq ==