wkdhkr/dedupper

Function deleteByHash has 31 lines of code (exceeds 25 allowed). Consider refactoring.

Open

  deleteByHash($hash: string): Promise<?any> {
    return new Promise((resolve, reject) => {
      if (!$hash) {
        resolve();
        return;

Function queryByValue has 26 lines of code (exceeds 25 allowed). Consider refactoring.

Open

  queryByValue(column: string, $value: number | string): Promise<any[]> {
    return new Promise((resolve, reject) => {
      const db = this.ss.spawn<any>(this.ss.detectDbFilePath(TYPE_IMAGE));
      const rows = [];
      db.serialize(async () => {

Similar blocks of code found in 2 locations. Consider refactoring.

Open

  deleteByHash($hash: string): Promise<?any> {
    return new Promise((resolve, reject) => {
      if (!$hash) {
        resolve();
        return;

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

  queryByHash($hash: string): Promise<?any> {
    return new Promise((resolve, reject) => {
      if (!$hash) {
        resolve();
        return;

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

              db.run(
                `insert${replaceStatement} into ${this.config.tagDbName} (${columns}) values (${values})`,
                this.createRowBind(row),
                err => {
                  if (err) {

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

  createRowBind: (row: any) => { ... } = (row: Object) => {
    const newRow = {};

    Object.keys(row).forEach(key => {
      newRow[`$${key}`] = row[key] !== undefined ? row[key] : null;

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

              const columns = [
                "hash",
                ...Array.from({ length: this.config.tagDbLength }).map(
                  (n, i) => `t${i + 1}`
                )

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

              const values = [
                "$hash",
                ...Array.from({ length: this.config.tagDbLength }).map(
                  (n, i) => `$t${i + 1}`
                )

• Read up
  Read up

Similar blocks of code found in 9 locations. Consider refactoring.

Open

  constructor(config: Config) {
    this.log = config.getLogger(this);
    this.config = config;
    this.ss = new SQLiteService(config);
  }

• Read up
  Read up

Similar blocks of code found in 3 locations. Consider refactoring.

Open

  async init() {
    const db = this.ss.spawn(this.ss.detectDbFilePath(TYPE_IMAGE));
    await this.prepareTable(db);
  }

• Read up
  Read up