typeorm-fb

Based on https://github.com/kerwynrg/typeorm

Compiling:

npm install
npm run compile
npm run package

To use firebird you need to install node-firebird The generated package will be available on build/package.

Changelog

0.1.0

BREAKING CHANGES

• Table, AbstractTable, ClassTableChild, ClosureTable, EmbeddableTable, SingleTableChild deprecated decorators were removed. Use Entity, ClassEntityChild, ClosureEntity, SingleEntityChild decorators instead.
• EntityManager#create, Repository#create, EntityManager#preload, Repository#preload, EntityManager#merge, Repository#merge methods now accept DeepPartial<Entity> instead of Object.
• EntityManager#merge, Repository#merge methods first argument is now an entity where to need to merge all given entity-like objects.
• changed find* repository methods. Now conditions are Partial<Entity> type.
• removed FindOptions interface and introduced two new interfaces: FindOneOptions and FindManyOptions - each for its own findOne* or find* methods.
• dropped out some of options of FindOptions. Use QueryBuilder instead. However, added few new options as well.
• deprecated method addParameters has been removed from QueryBuilder. Use setParameters instead.
• removed setMaxResults, setFirstResult methods in QueryBuilder. Use take and skip methods instead.
• renamed entityManager to manager in Connection, AbstractRepository and event objects. entityManager property was removed.
• renamed persist to save in EntityManager and Repository objects. persist method was removed.
• SpecificRepository is removed. Use relational query builder functionality instead.
• transaction method has been removed from Repository. Use EntityManager#transaction method instead.
• custom repositories do not support container anymore.
• controller / subscriber / migrations from options tsconfig now appended with a project root directory
• removed naming strategy decorator, naming strategy by name functionality. Now naming strategy should be registered by passing naming strategy instance directly.
• driver section in connection options now deprecated. All settings should go directly to connection options root.
• removed fromTable from the QueryBuilder. Now use regular from to select from tables.
• removed usePool option from the connection options. Pooling now is always enabled.
• connection options interface has changed and now each platform has its own set of connection options.
• storage in sqlite options has been renamed to database.
• env variable names for connection were changed (TYPEORM_DRIVER_TYPE has been renamed to TYPEORM_CONNECTION, some other renaming). More env variable names you can find in ConnectionOptionsEnvReader class.
• some api changes in ConnectionManager and createConnection / createConnections methods of typeorm main entrypoint.
• simple_array column type now is called simple-array
• some column types were removed. Now orm uses column types of underlying database.
• now number type in column definitions (like @Column() likes: number) maps to integer instead of double. This is more programmatic design. If you need to store float-pointing values - define a type explicitly.
• fixedLength in column options has been removed. Now actual column types can be used, e.g. @Column("char") or @Column("varchar").
• timezone option has been removed from column options. Now corresponding database types can be used instead.
• localTimezone has been removed from the column options.
• skipSchemaSync in entity options has been renamed to skipSync.
• setLimit and setOffset in QueryBuilder were renamed into limit and offset.
• nativeInterface has been removed from a driver interface and implementations.
• now typeorm works with the latest version of mssql (version 4).
• fixed how orm creates default values for SqlServer - now it creates constraints for it as well.
• migrations interface has changed - now up and down accept only QueryRunner. To use Connection and EntityManager use properties of QueryRunner, e.g. queryRunner.connection and queryRunner.manager.
• now update method in QueryBuilder accepts Partial<Entity> and property names used in update map are column property names and they are automatically mapped to column names.
• SpecificRepository has been removed. Instead new RelationQueryBuilder was introduced.
• getEntitiesAndRawResults of QueryBuilder has been renamed to getRawAndEntities.
• in mssql all constraints are now generated using table name in their names - this is fixes issues with duplicate constraint names.
• now when object is loaded from the database all its columns with null values will be set into entity properties as null. Also after saving entity with unset properties that will be stored as nulls - their (properties) values will be set to null.
• create and update dates in entities now use date with fractional seconds.
• @PrimaryGeneratedColumn decorator now accept generation strategy as first argument (default is increment), instead of column type. Column type must be passed in options object, e.g. @PrimaryGeneratedColumn({ type: "bigint"}).
• @PrimaryColumn now does not accept generated parameter in options. Use @Generated or @PrimaryGeneratedColumn decorators instead.
• Logger interface has changed. Custom logger supply mechanism has changed.
• Now logging options in connection options is simple "true", or "all", or list of logging modes can be supplied.
• removed driver section in connection options. Define options right in the connection options section.
• Embedded decorator is deprecated now. use @Column(type => SomeEmbedded) instead.
• schemaName in connection options is removed. Use schema instead.
• TYPEORM_AUTO_SCHEMA_SYNC env variable is now called TYPEORM_SYNCHRONIZE.
• schemaSync method in Connection has been renamed to synchronize.
• getEntityManager has been deprecated. Use getManager instead.
• @TransactionEntityManager is now called @TransactionManager now.
• EmbeddableEntity, Embedded, AbstractEntity decorators has been removed. There is no need to use EmbeddableEntity and AbstractEntity decorators at all - entity will work as expected without them. Instead of @Embedded(type => X) decorator now @Column(type => X) must be used instead.
• tablesPrefix, autoSchemaSync, autoMigrationsRun, dropSchemaOnConnection options were removed. Use entityPrefix, synchronize, migrationsRun, dropSchema options instead.
• removed persist method from the Repository and EntityManager. Use save method instead.
• removed getEntityManager from typeorm namespace. Use getManager method instead.
• refactored how query runner works, removed query runner provider
• renamed TableSchema into Table
• renamed ColumnSchema into TableColumn
• renamed ForeignKeySchema into TableForeignKey
• renamed IndexSchema into TableIndex
• renamed PrimaryKeySchema into TablePrimaryKey

NEW FEATURES

• added mongodb support.
• entity now can be saved partially within update method.
• added prefix support to embeddeds.
• now embeddeds inside other embeddeds are supported.
• now relations are supported inside embeds.
• now relations for multiple primary keys are generated properly.
• now ormconfig is read from .env, .js, .json, .yml, .xml formats.
• all database-specific types are supported now.
• now migrations generation in mysql is supported. Use typeorm migrations:generate command.
• getGeneratedQuery was renamed to getQuery in QueryBuilder.
• getSqlWithParameters was renamed to getSqlAndParameters in QueryBuilder.
• sql queries are highlighted in console.
• added @Generated decorator. It can accept strategy option with values increment and uuid. Default is increment. It always generates value for column, except when column defined as nullable and user sets null value in to column.
• added logging of log-running requests.
• added replication support.
• added custom table schema and database support in Postgres, Mysql and Sql Server drivers.
• multiple bug fixes.
• added ActiveRecord support (by extending BaseEntity) class
• Connection how has createQueryRunner that can be used to control database connection and its transaction state
• QueryBuilder is abstract now and all different kinds of query builders were created for different query types - SelectQueryBuilder, UpdateQueryBuilder, InsertQueryBuilder and DeleteQueryBuilder with individual method available.