npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

@dev101_cloud/nestjs-cassandra-module

v1.0.0

Published

Set of utilities for NestJS based on express-cassandra package

Downloads

10

Readme

Cassyllandra 🦠‍

Set of utilities for NestJS based on express-cassandra package. express-cassandra is a Cassandra ORM/ODM/OGM for NodeJS with support for Apache Cassandra, ScyllaDB, Datastax Enterprise, Elassandra & JanusGraph.

Based on https://www.npmjs.com/package/@ouato/nestjs-express-cassandra with bug fixes, new features, dependency updates and more.

Installation

$ npm i @dev5c32373043/nestjs-cassyllandra

Usage

import { CassyllandraModule } from '@dev5c32373043/nestjs-cassyllandra';

@Module({
  imports: [
    CassyllandraModule.forRoot({
      clientOptions: {
        contactPoints: ['127.0.0.1'],
        keyspace: 'dev',
        localDataCenter: 'datacenter1',
        queryOptions: {
          consistency: 1,
        },
      },
      ormOptions: {
        createKeyspace: true,
        defaultReplicationStrategy: {
          class: 'SimpleStrategy',
          replication_factor: 1,
        },
        migration: 'alter',
      },
      skipQueryTypeCheck: true,
    }),
  ],
  providers: [],
})
export class AppModule {}

skipQueryTypeCheck: boolean - globally skip field type check in queries instead of per field basis, default: false

For more client options look here

For more details about orm options look here

Async options

Quite often you might want to asynchronously pass your module options instead of passing them beforehand. In such case, use forRootAsync() method, that provides a couple of various ways to deal with async data.

1. Use factory

CassyllandraModule.forRootAsync({
  useFactory: () => ({...}),
})

Obviously, our factory behaves like every other one (might be async and is able to inject dependencies through inject).

CassyllandraModule.forRootAsync({
  imports: [ConfigModule],
  useFactory: (configService: ConfigService) => configService.get('db'),
  inject: [ConfigService],
});

2. Use class

CassyllandraModule.forRootAsync({
  useClass: ConfigService,
});

Above construction will instantiate ConfigService inside CassyllandraModule and will leverage it to create options object.

class ConfigService implements CassyllandraOptionsFactory {
  createCassyllandraOptions(): CassyllandraModuleOptions {
    return {...};
  }
}

3. Use existing

CassyllandraModule.forRootAsync({
  imports: [ConfigModule],
  useExisting: ConfigService,
});

It works the same as useClass with one critical difference - CassyllandraModule will look up imported modules to reuse already created ConfigService, instead of instantiating it on its own.

ORM Options

Defining our entity.

import {
  Entity,
  Column,
  GeneratedUUidColumn,
  CreateDateColumn,
  UpdateDateColumn,
  VersionColumn,
} from '@dev5c32373043/nestjs-cassyllandra';

@Entity({
  table_name: 'activities',
  key: ['id'],
})
export class ActivityEntity {
  @GeneratedUUidColumn()
  id: any;

  @Column({
    name: 'action',
    type: 'text',
    rule: {
      required: true,
    },
  })
  action: string;

  @Column({
    name: 'time',
    type: 'timestamp',
    default: { $db_function: 'toTimestamp(now())' },
  })
  time: Date;

  @Column({
    name: 'username',
    type: 'text',
    rule: {
      required: true,
    },
  })
  username: string;

  @Column({
    name: 'value',
    type: 'float',
    default: '1',
  })
  value: number;

  @CreateDateColumn()
  createdAt: Date;

  @UpdateDateColumn()
  updatedAt: Date;

  @VersionColumn()
  __v: string;
}

Let's have a look at the ActivityModule

import { Module } from '@nestjs/common';
import { CassyllandraModule } from '@dev5c32373043/nestjs-cassyllandra';
import { ActivityService } from './activity.service';
import { ActivityController } from './activity.controller';
import { ActivityEntity } from './activity.entity';

@Module({
  imports: [CassyllandraModule.forFeature([ActivityEntity])],
  providers: [ActivityService],
  controllers: [ActivityController],
})
export class ActivityModule {}

This module uses forFeature() method to define which entities shall be registered in the current scope. Thanks to that we can inject the ActivityEntity to the ActivityService using the @InjectModel() decorator:

import { Injectable } from '@nestjs/common';
import { InjectModel, BaseModel } from '@dev5c32373043/nestjs-cassyllandra';
import { ActivityEntity } from './activity.entity';

@Injectable()
export class ActivityService {
  constructor(
    @InjectModel(ActivityEntity)
    private readonly activityEntity: BaseModel<ActivityEntity>,
  ) {}

  getByAction(action: string): Promise<ActivityEntity> {
    return this.activityEntity.findOneAsync({ action }, { raw: true, allow_filtering: true });
  }
}

Using Column Decorators: To auto-generate uuid/timeuuid column, you need to decorate an entity's properties you want to make into an auto-generated uuid/timeuuid column with a @GeneratedUUidColumn decorator.

import { Entity, Column, GeneratedUUidColumn } from '@dev5c32373043/nestjs-cassyllandra';

@Entity({
  table_name: 'activities',
  key: ['id'],
})
export class ActivityEntity {
  @GeneratedUUidColumn()
  id: any;

  @GeneratedUUidColumn('timeuuid')
  time_id: any;
}

To auto-generate createdDate/updatedDate column, you need to decorate an entity's properties you want to make into an auto-generated createdDate/updatedDate column with a @CreateDateColumn or @UpdateDateColumn decorator (not combine with @Column decorator).

To index a column, you need to decorate an entity's properties you want to index with a @IndexColumn decorator.

To auto-generate version column, you need to decorate an entity's properties you want to make into an auto-generated version column with a @VersionColumn decorator (not combine with @Column decorator).

import {
  Column,
  Entity,
  IndexColumn,
  VersionColumn,
  UpdateDateColumn,
  CreateDateColumn,
  GeneratedUUidColumn,
} from '@dev5c32373043/nestjs-cassyllandra';

@Entity({
  table_name: 'activities',
  key: ['id'],
})
export class ActivityEntity {
  @GeneratedUUidColumn()
  id: any;

  @Column({
    type: 'text',
  })
  @IndexColumn()
  action: string;

  @CreateDateColumn()
  createdAt: Date;

  @UpdateDateColumn()
  updatedAt: Date;

  @VersionColumn()
  __v: any;
}

Using Hook Function Decorators: An entity of express-cassandra support multiple hook function. For more details see.

To create hook function in an entity use @BeforeSave, @AfterSave, @BeforeUpdate, @AfterUpdate, @BeforeDelete, @AfterDelete decorators.

import {
  Entity,
  Column,
  AfterSave,
  BeforeSave,
  AfterUpdate,
  AfterDelete,
  BeforeDelete,
  BeforeUpdate,
  GeneratedUUidColumn,
} from '@dev5c32373043/nestjs-cassyllandra';

@Entity({
  table_name: 'activities',
  key: ['id'],
})
export class ActivityEntity {
  @GeneratedUUidColumn()
  id: any;

  @BeforeSave()
  beforeSave(instance) {
    // your code here
  }

  @AfterSave()
  afterSave(instance) {
    // your code here
  }

  @BeforeUpdate()
  beforeUpdate(query, updateValues, options) {
    // your code here
  }

  @AfterUpdate()
  afterUpdate(query, updateValues, options) {
    // your code here
  }

  @BeforeDelete()
  beforeDelete(query, options) {
    // your code here
  }

  @AfterDelete()
  afterDelete(query, options) {
    // your code here
  }
}

Using Model

Important Note: BaseModel<T> is a wrapper for express-cassandra model. If column names in the model differ (e.g., @Column({ name: 'my_field', type: 'text' }) myField: string), you must handle the mapping yourself. Alternatively, consider using the Repository for a cleaner approach. Choose based on your needs.

import { Injectable } from '@nestjs/common';
import { BaseModel, InjectModel, ResultSet } from '@dev5c32373043/nestjs-cassyllandra';

import { ActivityEntity } from './activity.model';

@Injectable()
export class ActivityService {
  readonly entitySource: string;

  constructor(
    @InjectModel(ActivityEntity)
    readonly activityModel: BaseModel<ActivityEntity>,
  ) {
    this.entitySource = `${this.activityModel.get_keyspace_name()}"."${this.activityModel.get_table_name()}`;
  }

  async save(payload) {
    const activity = new this.activityModel(payload);
    await activity.saveAsync();
    return activity.toJSON();
  }

  async update(query, payload) {
    return this.activityModel.updateAsync(query, payload);
  }

  async delete(query, opts) {
    return this.activityModel.deleteAsync(query, opts);
  }

  async find(query, opts) {
    return this.activityModel.findAsync(query, opts);
  }

  async findOne(q, opts) {
    return this.activityModel.findOneAsync(q, opts);
  }

  async stream(query, opts, onRead) {
    return new Promise((resolve, reject) => {
      this.activityModel.stream(query, opts, onRead, err => {
        if (err) return reject(err);
        resolve(null);
      });
    });
  }

  eachRow(query, opts, onRead): Promise<any> {
    return new Promise((resolve, reject) =>
      this.activityModel.eachRow(query, opts, onRead, err => {
        if (err) return reject(err);
        resolve(null);
      }),
    );
  }

  async rawQuery(query, params = []): Promise<ResultSet> {
    return this.activityModel.execute_queryAsync(query, params);
  }

  async doBatch(queries: { query: string; params: any[] }[]): Promise<void> {
    await activityModel.execute_batchAsync(queries);
  }

  async truncate(): Promise<void> {
    await this.activityModel.truncateAsync();
  }
}

For more details look here

Using Repository

import { Module } from '@nestjs/common';
import { CassyllandraModule } from '@dev5c32373043/nestjs-cassyllandra';
import { ActivityService } from './activity.service';
import { ActivityController } from './activity.controller';
import { ActivityEntity } from './activity.entity';

@Module({
  imports: [CassyllandraModule.forFeature([ActivityEntity])],
  providers: [ActivityService],
  controllers: [ActivityController],
})
export class ActivityModule {}
import { Injectable } from '@nestjs/common';
import { InjectRepository, Repository } from '@dev5c32373043/nestjs-cassyllandra';
import { ActivityEntity } from './activity.entity';

@Injectable()
export class ActivityService {
  constructor(
    @InjectRepository(ActivityEntity)
    private readonly activityRepository: Repository<ActivityEntity>,
  ) {}

  async create(payload): Promise<ActivityEntity> {
    return this.activityRepository.create(payload);
  }

  async insertMany(payload): Promise<ActivityEntity[]> {
    return this.activityRepository.insertMany(payload);
  }

  async update(query, payload, opts = {}): Promise<any> {
    return this.activityRepository.update(query, payload, opts);
  }

  async removeOne(entity, opts = {}): Promise<void> {
    await this.activityRepository.removeOne(entity, opts);
  }

  async removeMany(entities, opts = {}): Promise<void> {
    await this.activityRepository.removeMany(entities, opts);
  }

  async delete(query, opts = {}): Promise<void> {
    await this.activityRepository.delete(query, opts);
  }

  async find(q?: object, opts?: object): Promise<ActivityEntity[]> {
    return this.activityRepository.find(q, opts);
  }

  async findOne(q?: object, opts?: object): Promise<ActivityEntity> {
    return this.activityRepository.findOne(q, opts);
  }

  async findOneOrFail(q?: object, opts?: object): Promise<ActivityEntity> {
    return this.activityRepository.findOneOrFail(q, opts);
  }

  async stream(query, opts, onRead): Promise<any> {
    return this.activityRepository.stream(query, opts, onRead);
  }

  async eachRow(query, opts, onRead): Promise<any> {
    return this.activityRepository.eachRow(query, opts, onRead);
  }

  async rawQuery(query): Promise<ResultSet> {
    return this.activityRepository.executeQuery(query);
  }

  async truncate(): Promise<void> {
    await this.activityRepository.truncate();
  }
}

Using Batch operations:

@Injectable()
export class ActivitiesService {
  constructor(
    @InjectRepository(ActivityEntity)
    private readonly activityRepository: Repository<ActivityEntity>,
  ) {}

  async performBatchOps(): Promise<void> {
    const activity1 = { id: 'c4a07d0f-51f1-4a7d-9dcb-b3166265931d', action: 'action', username: 'user', value: 0 };
    const activity2 = {
      id: 'c7579abc-e22f-411d-a7c7-a445952701d8',
      action: 'action',
      username: 'inactive user',
      value: 0,
    };

    const batch = this.activityRepository.initBatch();
    batch.insert({ action: 'new action', username: 'user', value: 1 });
    batch.update({ id: activity1.id }, { value: 1 });
    batch.remove({ id: activity2.id });

    await batch.execute();
  }
}

Using Custom Repository

Let's create a repository:

import { Repository, EntityRepository } from '@dev5c32373043/nestjs-cassyllandra';
import { ActivityEntity } from './activity.entity';

@EntityRepository(ActivityEntity)
export class ActivityRepository extends Repository<ActivityEntity> {
  async findById(id: any): Promise<ActivityEntity> {
    return this.findOne({ id: id });
  }
}

Let's have a look at the ActivityModule:

import { Module } from '@nestjs/common';
import { CassyllandraModule } from '@dev5c32373043/nestjs-cassyllandra';

import { ActivitiesController } from './activities.controller';
import { ActivityRepository } from './activity.repository';
import { ActivityService } from './activity.service';
import { ActivityEntity } from './activity.entity';

@Module({
  imports: [CassyllandraModule.forFeature([ActivityEntity, ActivityRepository])],
  providers: [ActivityService],
  controllers: [ActivitiesController],
})
export class ActivitiesModule {}

Now let's use ActivityRepository in ActivityService:

import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@dev5c32373043/nestjs-cassyllandra';

import { ActivityRepository } from './activity.repository';
import { ActivityEntity } from './activity.entity';

@Injectable()
export class ActivityService {
  constructor(
    @InjectRepository(ActivityRepository)
    private readonly activityRepository: ActivityRepository,
  ) {}

  async getById(id: any): Promise<ActivityEntity> {
    return this.activityRepository.findById(id);
  }
}

Injecting connection:

import { Injectable } from '@nestjs/common';
import { InjectRepository, InjectConnection } from '@dev5c32373043/nestjs-cassyllandra';

import { ActivityRepository } from './activity.repository';
import { ActivityEntity } from './activity.entity';

@Injectable()
export class PersonService {
  constructor(
    @InjectConnection()
    private readonly connection: Connection,
    @InjectRepository(ActivityRepository)
    private readonly activityRepository: ActivityRepository,
  ) {}

  async getById(id: any): Promise<ActivityEntity> {
    return this.activityRepository.findById(id);
  }
}

Using Elassandra

Express cassandra support Elassandra. For more details see.

@Module({
  imports: [
    ScyllaModule.forRoot({
      clientOptions: {
        // omitted other options for clarity
      },
      ormOptions: {
        // omitted other options for clarity
        migration: 'alter',
        manageESIndex: true,
      },
    }),
  ],
  providers: [], // [...]
})
export class AppModule {}
import { Entity, Column } from '@dev5c32373043/nestjs-cassyllandra';

@Entity({
  table_name: 'activities',
  key: ['id'],
  es_index_mapping: {
    discover: '.*',
    properties: {
      action: {
        type: 'string',
        index: 'analyzed',
      },
    },
  },
})
export class ActivityEntity {
  @Column({
    type: 'uuid',
    default: { $db_function: 'uuid()' },
  })
  id: any;

  @Column({
    type: 'text',
  })
  action: string;
}
import { Module } from '@nestjs/common';
import { CassyllandraModule } from '@dev5c32373043/nestjs-cassyllandra';

import { ActivitiesController } from './activities.controller';
import { ActivitiesService } from './activities.service';
import { ActivityEntity } from './activity.entity';

@Module({
  imports: [CassyllandraModule.forFeature([ActivityEntity])],
  providers: [ActivitiesService],
  controllers: [ActivitiesController],
})
export class ActivitiesModule {}
import { Injectable } from '@nestjs/common';
import { InjectModel, BaseModel } from '@dev5c32373043/nestjs-cassyllandra';
import { promisify } from 'util';

import { ActivityEntity } from './activity.entity';

@Injectable()
export class ActivitiesService {
  constructor(
    @InjectModel(ActivityEntity)
    private readonly activityEntity: BaseModel<ActivityEntity>,
  ) {}

  searchName(action: string): Promise<any> {
    return promisify(this.activityEntity.search)({ q: `action:${action}` });
  }
}

Requirements

Contributing

Any contribution is highly appreciated.