valildation.test.js

const validation = require("./validation")
const { isValidTable, isValidColumn, isComputedColumn } = require("./validation")

var schema = {
  mytable: {
    columns: [
      { name: "mycolumn" },
      { name: "my_column2" },
      { name: "computedCol", isComputed: 1 }
    ]
  },
  customer: {
    columns: [
      { name: 'ID'},
      { name: 'address'},
      { name: 'name'}
    ]
  },
  myuser: {
    columns: [
      { name: 'ID'},
      { name: 'name'},
      { name: 'customerid'},
    ]
  }, job: {
    columns: [
      { name: 'ID'},
      { name: 'name'},
      { name: 'customerid'},
    ]
  }, timeentry: {
    columns: [
      { name: 'ID'},
      { name: 'starttime'},
      { name: 'stoptime'},
    ]
  }
}

validation.setSchema(schema)


test("test validation utils", () => {
    expect(isValidTable("mytable")).toBeTruthy()
    expect(isValidColumn("mytable", "mycolumn")).toBeTruthy()
    expect(isValidColumn("mytable", "my_column2")).toBeTruthy()
    expect(isValidColumn("mytable", "dbo.mycolumn")).toBeFalsy()
    expect(isValidColumn("mytable", "mycolumn--")).toBeFalsy()
    expect(isValidColumn("mytable", "my column")).toBeFalsy()
    expect(isValidColumn("mytable", "mycolumn'")).toBeFalsy()
    expect(isValidColumn("mytable", "mycolumn;")).toBeFalsy()

    expect(isComputedColumn("mytable", "computedCol")).toBeTruthy()
    expect(isComputedColumn("mytable", "mycolumn")).toBeFalsy()

    //test names with .
    expect(isValidColumn("mytable", "mytable.mycolumn")).toBeTruthy()
    expect(isValidColumn("mytable", "mytable.mytable.mycolumn")).toBeFalsy()

    //test joins
    expect(isValidColumn("myuser", "customername", ['customer'])).toBeTruthy()
    expect(isValidColumn("timeentry", "customerid", [{model:'job', fields:"customerid"}])).toBeTruthy()

  })