deno_surreal

Simple library for querying a SurrealDB database

This library has no dependencies

Disclaimer! This project is not meant to be a replacement or contender to any official tools/libraries. It is not stable, and exists merely because I wanted to do a small project involving SurrealDB.

For documentation on SurrealDB go to the official SurrealDB Website

Create a SurrealDB connection:

Make sure it is the base url to your hosted database, and includes the port

As of now only allows basic authentication

import { SurrealDB } from "https://deno.land/x/deno_surreal/mod.ts"

const db = new SurrealDB("http://127.0.0.1:8000", {
  user: "root",
  pass: "root",
  namespace: "test",
  database: "test"
})

You could also choose to only update one

db.signin({
  user: "username",
  pass: "password"
})

Use a different namespace / database:

You could also choose to only update one

db.use({
  namespace: "test2", 
  database: "test2"
})

Create a new table record:

Typing is optional

type Person = {
  id: string
  name: string,
  age: number
}

const p1 = await db.create<Person>("person:1", {
  name: "Max Manus",
  age: 32
})

console.log(p1) // Prints: { age: 32, id: "person:1", name: "Max Manus" }

Execute custom queries:

It is possible to send multiple queries at once

const queryResults = await db.query<Person>("SELECT * FROM person WHERE age > 18")
const firstQR = queryResult[0]
const result = firstQR.result
console.log(p1) // Prints: [ { age: 32, id: "person:1", name: "Max Manus" } ]

It is also possible to check for errors with custom queries:

const queryResult = await db.query<Person>("SELECTTTT * FROM person WHERE age > 18")
const firstQR = queryResult[0]
if (!firstQR || firstQR.status === "ERR") {
  // Do something...
}

Execute a single custom query:

Single queries only return the resulting data of the query

const result = await db.singleQuery<Person>("SELECT * FROM person WHERE name = 'Max Manus'")
console.log(result) // Prints: [ { age: 32, id: "person:1", name: "Max Manus" } ]

Select one or more records from a table:

  const result1 = await db.select<Person>("person")
  const result2 = await db.select<Person>("person:1")

Delete one or more records from a table:

  await db.delete("person")
  await db.delete("person:1")

Update a specific record:

  const p1 = await db.update<Person>("person:1", {
    age: 98
  })
  console.log(p1) // Prints: { age: 98, id: "person:1", name: "Max Manus" }

Modify a specific record:

  const p1 = await db.modify<Person>("person:1", {
    age: 57
  })
  console.log(p1) // Prints: { age: 57, id: "person:1", name: "Max Manus" }