⌚SB Watch 2
⌚SB Watch 2
🚚 Free fedex shipping from 97 $
🌎 WORLDWIDE SHIPPING for 25 $
Search
Close this search box.

Database

Introduction

It will be possible to upload data to Atom and query it with a MagiScript command.

Available data sources:

 

  • card: card stack-related queries, several popular stacks are supported

Querying the “pi” Database

To query the “pi” database, use the db.query() function with the first argument set to “pi”. The second argument should be a 4-digit number you want to search for in the database. For example, db.query(‘pi’, 4000) searches for the number 4000 in the “pi” database.

The db.query() function will return an object with keys page, line, and across. These keys represent the page number, line number, and column number where the 4-digit number can be found in the book.

Here’s an example code snippet that demonstrates how to query the “pi” database:

				
					let data = db.query('pi', '4000');
console.log(data.page); // outputs the page
console.log(data.line); // outputs the line
console.log(data.across); // outputs the column
				
			

In this example, the db.query() function searches for the number 4000 in the “pi” database. The result is stored in the data variable, and then the console.log() function is used to output the result to the console.

Card Database (since firmware v1.1.31)

With the card database, you can work with card positions in popular stacks like:

 

    • “simple”: a simple card deck order, clubs, diamonds, hearts, and spades from Ace to King:
      AC->KC, AD->KD, AH->KH, AS->KS

    • “new”: a new deck order:
      AH->KH, AC->KC, KD->AD, KS->AS

    • “mnemonica”: Mnemonica by Juan Tamariz

    • “aronson”: Aronson stack by Simon Aronson

    • “memorandum”: Memorandum by Woody Aragón

You can query the card at position #n (please note, that the first card is n = 0):

 

				
					let card = db.query('card', 'mnemonica', 0); // first card in new deck order
console.log(card.pos);   // 0 - pos in this ("mnemonica") stack
console.log(card.code);  // 3 - pos in "simple" stack
console.log(card.name);  // 4C
console.log(card.value); // 3 - Four
console.log(card.color); // 0 - Clubs
				
			

The name property (‘4C’ in this case) can be sent to PeekSmith and it will recognize it as a poker card when Smart Text is ON. The code is the position of the card in the “simple” stack (color * 13 + value).

You can also search for the card in the stacks by name, and receive the index (pos):

 

				
					let card = db.query('card', 'new', '10H'); // first card in new deck order
console.log(card.pos);   // 9 - 10th card in stack
console.log(card.code);  // 35 - pos in "simple" stack
console.log(card.name);  // 10H
console.log(card.value); // 9 - Ten
console.log(card.color); // 2 - Hearths
				
			

And finally, it is also an option to search for the card by providing the color and value:

 

				
					let card = db.query('card', 'sistebbings', 2, 11); // first card in new deck order
console.log(card.pos);   // 11 - 10th card in stack
console.log(card.code);  // 37 - pos in "simple" stack
console.log(card.name);  // QH
console.log(card.value); // 11 - Queen
console.log(card.color); // 2 - Hearths
				
			

Conclusion

In MagiScript, it is possible to query information from a local “database” using the db.query() function.

The “pi” database is a predefined data source that can be queried using MagiScript. By passing a 4-digit number to the db.query() function, you can find the page, line, and column where the number can be found in the Pi book.

The “card” database is to help you work with card stacks, which can be useful for ACAAN routines.

For example, you can try this code. The LED will go green for 1 second, but this is running in the background, and the code execution goes on. The wait function then waits 2 seconds. The LED will turn off after 1 second and will stay off for a second until the wait function ends. Then it turns yellow and stays on.

 

Read on about the timers below, however, this is the alternative we recommend. It is harder to read, more code, but MagiScript events won’t be blocked at all.