elite-libs / dataanalyzer.app Goto Github PK

The simplified naming mode may need better runtime support for transforming object shapes (in and out of the local system.)

Options from least effort:

1. Add inline comments w/ field's original name.
2. Leave up to each Adapter, possibly with a renderTransforms(fieldNameMappings) interface.
3. Change Naming options to be simpler (like don't prefix subtypes or use custom prefix.)

AC

• Enter schema name shows as the initial 'Schema Name' text box value.

see https://github.com/grantila/typeconv

Provide a high-level stats table on the input data & how it was ultimately processed.

• https://github.com/sinclairzx81/typebox

Remove .required() and use .optional() for non-required fields.

Opportunity: add DataAnalyzer to the Prisma docs.

Example models

model Post {
  id        Int     @id @default(autoincrement())
  title     String
  content   String?
  published Boolean @default(false)
  author    User?   @relation(fields:  [authorId], references: [id])
  authorId  Int?
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

Reference Info

• data types
• associations
• enforcing-the-table-name-to-be-equal-to-the-model-name

Model Definition

const { Sequelize, Model, DataTypes } = require("sequelize");
const sequelize = new Sequelize("sqlite::memory:");

const User = sequelize.define("user", {
  name: DataTypes.TEXT,
  favoriteColor: {
    type: DataTypes.TEXT,
    defaultValue: 'green'
  },
  age: DataTypes.INTEGER,
  cash: DataTypes.INTEGER
});

Relationships

Foo.hasOne(Bar, {
  foreignKey: {
    // name: 'myFooId'
    type: DataTypes.UUID
  }
});
Bar.belongsTo(Foo);