Today, we are issuing the fifteenth [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview015` (short: `preview015`).
Note that we recently adjusted the versioning schema in order to fully comply to the [semver](https://semver.org/) spec (the first release with the new version schema was `2.0.0-preview014`).
Major changes
Lift now features an explicit UI that warns about destructive changes before performing a schema migration: (Right now column and table dropping are recognized)
<img width="977" alt="Screenshot 2019-10-22 at 16 19 26" src="https://user-images.githubusercontent.com/4058327/67297589-683f1500-f4ea-11e9-8c3c-849994e5a81c.png">
Breaking changes
Photon.js now maps `DateTime` from the Prisma schema to `Date` in JavaScript
Assume you have the following Prisma model:
prisma
model Post {
id String default(cuid()) id unique
createdAt DateTime default(now())
updatedAt DateTime updatedAt
title String
}
The Photon.js generator now sets the types of the `createdAt` and `updatedAt` fields to `Date` instead of `string`:
ts
export declare type Post = {
id: string;
createdAt: Date;
updatedAt: Date;
title: string;
}
`findOne` doesn't throw any more but has optional return type
Based on [this](https://github.com/prisma/photonjs/issues/245) issue, we decided to adjust the Photon.js API for `findOne` calls. Instead of throwing an exception when there is no record that meets the specified `where` condition for a `findOne` call, it now returns `null`.
Assume again the same Prisma model as before:
prisma
model Post {
id String default(cuid()) id unique
createdAt DateTime default(now())
updatedAt DateTime updatedAt
title String
}
So, in your application code you might want to adjust the `catch` calls to explicit checks for `null`:
**Before**
ts
try {
const post = await photon.posts.findOne({
where: { id }
})
// ... do something with `post`
} catch(e) {
console.log(`Did not find record with ID: ${id}`)
}
**After**
ts
const post = await photon.posts.findOne({
where: { id }
})
if (post === null) {
console.log(`Did not find record with ID: ${id}`)
return
}
// ... do something with `post`
Fixes and improvements per Prisma Framework repository
`prisma2`
- [Cursor does not work in `alpha.241`](https://github.com/prisma/prisma2/issues/753)
- [Docs: Please document how to handle DateTime values with Photon.js](https://github.com/prisma/prisma2/issues/743)
- [More inclusive language in docs](https://github.com/prisma/prisma2/issues/722)
- [Telemetry: Error report ID](https://github.com/prisma/prisma2/issues/705)
- [Postgres: A database with that name doesn't exist at xx.xx.xx.xx using 2.0.0-preview013.3](https://github.com/prisma/prisma2/issues/694)
- [`init` flow doesn't show instruction to navigate into new directory](https://github.com/prisma/prisma2/issues/684)
- [fix: prisma2 introspect for mysql database](https://github.com/prisma/prisma2/issues/683)
- [`prisma2 dev`: Asks to save changes into a migration file by running `prisma2 lift save` but gives `Everything up-to-date` in terminal](https://github.com/prisma/prisma2/issues/651)
- [Telemetry prompt options don't work on Windows (cursor keys do nothing)](https://github.com/prisma/prisma2/issues/617)
- [Limitations: nested write vs. nested mutations](https://github.com/prisma/prisma2/issues/602)
- [Conflicting "Make sure to adjust the generator configuration in the schema.prisma file:" error message](https://github.com/prisma/prisma2/issues/589)
- [[Windows] `prisma2 init` fails with `Error: Can't find Python executable "python", you can set the PYTHON env variable.`](https://github.com/prisma/prisma2/issues/550)
`photonjs`
- [DateTime should be mapped to Date](https://github.com/prisma/photonjs/issues/260)
- [`.count()` returns `null` for empty tables](https://github.com/prisma/photonjs/issues/253)
- [Select in finds methods optional fields](https://github.com/prisma/photonjs/issues/256)
- [findOne: Stop throwing an error when no record found](https://github.com/prisma/photonjs/issues/245)
- [Possibly wrong type generation for `after` argument in findMany method (Postgres)](https://github.com/prisma/photonjs/issues/241)
- [`Field does not exist on enclosing type.` When using most filters (some, etc)](https://github.com/prisma/photonjs/issues/222)
`lift`
- [README contains wrong link to schema](https://github.com/prisma/lift/issues/166)
- [Implement Display of Destructive Changes](https://github.com/prisma/lift/issues/146)
`prisma-engine`
- [Arity of implicit relations: Change Unspecified relations from one-to-one's to one-to-many's](https://github.com/prisma/prisma-engine/issues/102)
- [Introspection Engine: Multi field id criterion (Multi column PKs)](https://github.com/prisma/prisma-engine/issues/69)
- [Introspection Engine: Multi field unique](https://github.com/prisma/prisma-engine/issues/61)
- [Fix MySQL SqlSchemaDescriber on MySQL 8](https://github.com/prisma/prisma-engine/issues/47)
2.0.0-preview014.2
Fixes
- [Postgres: A database with that name doesn't exist at xx.xx.xx.xx using 2.0.0-preview013.3](https://github.com/prisma/prisma2/issues/694)
- [Field does not exist on enclosing type.` When using most filters (some, etc)](https://github.com/prisma/photonjs/issues/222)
- [init` flow doesn't show instruction to navigate into new directory](https://github.com/prisma/prisma2/issues/684)
- [Telemetry: Error report ID](https://github.com/prisma/prisma2/issues/705)
- [Select in finds methods optional fields](https://github.com/prisma/photonjs/issues/256)
- [`.count()` returns `null` for empty tables](https://github.com/prisma/photonjs/issues/253)
- [README contains wrong link to schema](https://github.com/prisma/lift/issues/166)
2.0.0-preview014.1
Fixes
This patch release fixes a bug when using the `native` `binaryTarget` https://github.com/prisma/prisma2/issues/750