elliotchance

✅ v1.0 - Query Foundations

This release established everyday querying: SELECT with its core predicates, set functions and CASE, plus primary keys, column defaults and standard error codes.

• E051 Basic query specification
• E061-03 IN predicate with list of values
• E061-05 LIKE predicate: ESCAPE clause
• E071 Basic query expressions
• E091 Set functions
• E141-03 PRIMARY KEY constraints

elliotchance

%_f1%/%_f2%/%_f3%/%media% %_discnumber%$if(%discsubtitle%, - %discsubtitle%,)/
%_discnumber%-%_tracknumber% $if(%_multiartist%,%artist% - ,)%title%

elliotchance

Usage

1. Goto any tracklist page
2. View Menu > Developer Tools
3. Paste this entire cue.js and hit enter. It may prompt to allow downloads.
4. The mp3 file must be in the same folder AND named the same as the cue file (without extension).

For example:

elliotchance

Memory Management

There is no dynamic allocation, memory is prealloacted on the stack so there is no need or cost for garbage collection.

func addNumbers(a int, b int) {
  return a + b
}

elliotchance

// separator is what to put between each link. Examples:
// - New line: '\n'
// - Comma: ', '
// - Pipe: ' | '
const separator = '\n';

// The link for the URL. It must contain a slash at the end.
// You cannot use the [List123] links.
const listURL = 'https://rateyourmusic.com/list/echance/a-state-of-trance-1/';

elliotchance

let done;
do {
  done = true;
  Array.from(document.getElementsByClassName('box'))
    .sort((a, b) => {
      const [x, y] = [a.innerText, b.innerText];
      const cmp = x.localeCompare(y);
      if (cmp < 0) {
        done = false;
        document.getElementById(a.id).parentNode.insertBefore(document.getElementById(a.id), document.getElementById(b.id));

elliotchance

ready on 127.0.0.1:3210
connected
query: SELECT current_setting('server_version_num') as ver_num FROM singlerow;
response: vsql.Result{
    columns: ['VER_NUM']
    rows: [vsql.Row{
        offset: 0
        data: {'VER_NUM': vsql.Value{
            typ: CHARACTER VARYING
            f64_value: 0

elliotchance

package main

import (
  "fmt"
  "github.com/elliotchance/gedcom"
)

func main() {
  // 1. Load gedcom files.
  leftGedcom, err := gedcom.NewDocumentFromGEDCOMFile("file1.ged")

elliotchance

class DirtyRead(TransactionTest):
    def run(self):
        result1 = self.client1.fetch_record(id=1)
        self.client2.update_record(id=1, name="Joe 2")
        result2 = self.client1.fetch_record(id=1)
        return result1 != result2
      
class NonRepeatableRead(TransactionTest):
    def run(self):
        result1 = self.client1.fetch_record(id=1)

elliotchance

class TransactionTest:
    def __init__(self, transaction_type):
        self.table = Table()
        client = self.table.new_transaction(ReadCommittedTransaction)
        client.add_record(id=1, name="Joe")
        client.add_record(id=3, name="Jill")
        client.commit()
        self.client1 = self.table.new_transaction(transaction_type)
        self.client2 = self.table.new_transaction(transaction_type)