amplify codegen model adds non-existent Id field and ignores the key definition about amplify-codegen HOT 21 CLOSED

@lazy-var @asyschikov For a synchronization protocol to have correctness and convergence objects need to have unique identifiers. Since DataStore is local-first before mutations are reconciled and committed to DynamoDB, we create these identifiers locally using the id field with type ID. There is complexity in the use cases such as relational patterns that not only leverage @key with DynamoDB implications but also in the local storage engine that might leverage SQLite or IndexedDB depending on the platform. For our initial launch we wanted to ensure that the data integrity could be trustworthy and reliable which is why we require id however we do hear your feedback and are looking to enhance this functionality in the future such as providing another directive for customers like yourself to disambiguate the fields that are unique and will be used as alternative identifiers. I don't have a specific timeline on this as there are a couple other higher priority items in the customer backlog based on interest and feedback, however we are looking at a design on this in the coming months.

from amplify-codegen.

Its critical that AWS improve their documentation on the ID field. The rules around the ID field to not jump out at you.

Equally, we should be able to set the ID field... just insane that amplify overwrites a perfectly good UUID. To match future updates back to our internal model we have to maintain a parallel UUID. Silly.

from amplify-codegen.

+1 to implementing the ability to have custom a UUID field.

In my case I am beginning the process of transitioning my existing backend to use Amplify CLI + AppSync + DataStore. My primary key is already set and this is making it difficult to transition. I need to be able to update this record from outside the context of my client app and I won't have access to the randomly generated id.

Hopefully this gets on the roadmap soon!

from amplify-codegen.

@lazy-var @asyschikov For a synchronization protocol to have correctness and convergence objects need to have unique identifiers. Since DataStore is local-first before mutations are reconciled and committed to DynamoDB, we create these identifiers locally using the id field with type ID. There is complexity in the use cases such as relational patterns that not only leverage @key with DynamoDB implications but also in the local storage engine that might leverage SQLite or IndexedDB depending on the platform. For our initial launch we wanted to ensure that the data integrity could be trustworthy and reliable which is why we require id however we do hear your feedback and are looking to enhance this functionality in the future such as providing another directive for customers like yourself to disambiguate the fields that are unique and will be used as alternative identifiers. I don't have a specific timeline on this as there are a couple other higher priority items in the customer backlog based on interest and feedback, however we are looking at a design on this in the coming months.

I understand that DataStore creates autogenerated id on local model when creating new document because it will be unique and it prevents situation when user created local data and when sync will be performed reveals that data already exists.

But it will be great to have ability create own id, with in example some property like UNSAFE_key or method dangerouslySetKey. Programmer will be consciously use this ability.

Why it needed?

1. Because there are may be situations where you doesn't know autogenerated ID, but you know some attribute which is ID. Or ID can be composed from some attributes.
2. When key consist from partition and sort key. For example user subscriptions where pk - subscriber ID and sk - subscription ID. For this case also there is need to add support of object keys: DataStore.query(Subscription, {id: SOME_ID, target: SOME_TARGET}) to get single Model.

Also with above suggestions needed to add mecanism to restore deleted data, because key may stay same and now there is no chance to save model second time with DataStore.save

from amplify-codegen.

@undefobj sorry I missed your reply. Thanks for the clarification why ID is needed. My issue with the current implementations are two fold:

1. codegen is not fully consistent with GraphQL Transforms and the incompatibilities are not explicitly stated. @key works with AWS AppSync, it is properly mapped to the PK in a Amazon DynamoDB table and all the generated GraphQL queries. Changing PK in Amazon DynamoDB is very painful because it requires to drop/create the table. The codegen tool can't just make assumption that the id field is there even if it is not in the schema. My suggestion would be very explicitly list the requirements for the schema and list of directives that are not supported. I would also suggest that codegen explicitly fails with error if the schema does not validate.
2. Since @key is not supported it means that Sorted Keys are not supported as well if I got it right, which reduces Amazon DynamoDB to a simple Key Value store which it is not. I have no idea how to implement One To Many relationships without Sort Key. For example how would Post-Comments relationship work from the example schema? I understand that for a beta release it is a needed measure, it would help greatly if it was highlighted which functionality is not supported, because we already developed a schema, Web App client and were entirely blocked by the DataStore.

from amplify-codegen.

Hi!
please, do we have any news about this one?

@lazy-var @asyschikov For a synchronization protocol to have correctness and convergence objects need to have unique identifiers. Since DataStore is local-first before mutations are reconciled and committed to DynamoDB, we create these identifiers locally using the id field with type ID. There is complexity in the use cases such as relational patterns that not only leverage @key with DynamoDB implications but also in the local storage engine that might leverage SQLite or IndexedDB depending on the platform. For our initial launch we wanted to ensure that the data integrity could be trustworthy and reliable which is why we require id however we do hear your feedback and are looking to enhance this functionality in the future such as providing another directive for customers like yourself to disambiguate the fields that are unique and will be used as alternative identifiers. I don't have a specific timeline on this as there are a couple other higher priority items in the customer backlog based on interest and feedback, however we are looking at a design on this in the coming months.

from amplify-codegen.

@asyschikov could you please try with the latest version of the CLI if the problem persists?

from amplify-codegen.

@asyschikov Is the generated code used with DataStore or with plain API?

from amplify-codegen.

@attilah I updated to the latest version, but the result is expectedly same because I just sent you the link to the master branch of the amplify-cli where the id attribute is forcedly added to the model. I would not call it a bug, just a strange design decision. I guess it is some sort of convention with amplify-android (iOS too?) library because they expect Id to be there, I opened a sister issue there aws-amplify/amplify-android#210

@yuth it is generated by amplify codegen model, also by modelgen gradle task, not sure whether it means DataStore or plain API. The steps are taken from https://aws-amplify.github.io/docs/android/api .

from amplify-codegen.

@yuth it is generated by amplify codegen model, also by modelgen gradle task, not sure whether it means DataStore or plain API. The steps are taken from https://aws-amplify.github.io/docs/android/api .

OK, the generated model is used with API category and not with DataStore.

DataStore needs an id field to be present and it is not allowed to change the id field with @key directive. We need to have a way to know if the generated model is used for API category or DataStore. @TrekSoft, is it possible for generation of separate files for API and DataStore?

from amplify-codegen.

@yuth - yeah let's setup a time to discuss as a team

from amplify-codegen.

DataStore needs an id field to be present and it is not allowed to change the id field with @key directive.

@yuth I don't get that part. I don't think it is documented anywhere. If this is really mandatory for whatever reason the codegen should not validate the schema instead of appending the "id" field that just doesn't exist, because that's just not gonna work. It should state it with big bold letters.

The larger question is why this restriction even exists? It makes developers' life harder instead of easier. If you are adding a new android application to an existing amplify application you are basically screwed if your models don't have id fields, you can't just rename HK on a DynamoDB table. Not to mention tables with hash key and sort key, they are often used to create one-to-many relationships and the HK in the child table refers to the HK of the parent table (with a sort key to enable many children). This case is basically unimplementable right now. Including half of the examples for directives @connection and @key from here https://aws-amplify.github.io/docs/cli-toolchain/graphql .

from amplify-codegen.

DataStore needs an id field to be present and it is not allowed to change the id field with @key directive.

Hi @yuth , @TrekSoft , forcing id field to be present is fair for local to work, but does this means not custom @key is allowed for cloud side?
I see DataStore as a 'client' tool/component. And I expect it to work with custom indexes, custom AppSync resolvers, etc.

By providing flexibility with DataStore would allow projects to grow, going custom once the business model has been validated and 'opinionated' modelgen/GraphQL transform solution is not enough.

from amplify-codegen.

@asyschikov @key is supported as well as many to many as noted in the docs on relational models. However there are a few things that we need to put into place for some finer grained controls on ID fields. We understand this feedback and are looking at providing the optimization in the future.

Codegen is designed to fail if the schema isn't valid. Sometimes the known cases are missed though which is what happened here.

We're looking at additional workflows for table recreation while in dev/test stage and iterating on schemas which you can comment on here: aws-amplify/amplify-cli#2384

DataStore on JavaScript is not beta. It's fully released. On iOS/Android it's in Preview. Again, sometimes things aren't covered in docs or in code checks because they are unforeseen.

from amplify-codegen.

This is soooo necessary!

But it will be great to have ability create own id, with in example some property like UNSAFE_key or method dangerouslySetKey. Programmer will be consciously use this ability.

This would be needed in all scenarios where you're creating something with a custom primary key. I'm trying to do this right now with usernames. I need to set username as an "unsafe key" as in, it'd be saved locally but if there's an error (already exists) it'd have to throw an error from DataStore.save. There's no way to do this right now!

from amplify-codegen.

@attilah

Hey just wondering if there is any update for this.

from amplify-codegen.

Hello,

I'm wondering about this also. Personally I have used the schema from Nader Dabit's Chatt app here..

https://dev.to/dabit3/building-chatt---a-real-time-multi-user-graphql-chat-app-3jik

CLI: 4.27.1

I'm using using his schema to create a messaging feature in an app using DataStore.

Big thanks to Nader by the way, I would be lost without all his resources online!

type Message {
  id: ID!
  author: User
  authorId: String
  content: String!
  conversation: Conversation!
  messageConversationId: ID!
  createdAt: String
  updatedAt: String
}

But I notice the following query to get all messages in a conversation doesn't work as I get the invalid field error..

const messages = await DataStore.query(Message, (m) =>
        m.messageConversationId('eq', '601afe05-f39a-4a08-b391-47aed452c361')
      )

Error: error fetching data... Error: Invalid field for model. field: messageConversationId, model: Message

There's even an explicit messageConversationId field in the schema which I use in the message mutation, and I see it in my DataStore message items, but its not seen in my query. For the moment I may just create another field in the messages schema called something like 'msgConvId' and query on that, if thats bad practice please let me know as I'm new to Amplify, thank you!

from amplify-codegen.

I would also use this functionality as I just had to change my model's primary key to not be a composite key as I had designed, but instead switch that to a secondary index in order to also be able to use DataStore on the frontend.

It's not ideal, especially now that the GraphQL query generated for the secondary key has all the pagination constructs because it's not guaranteed to return a unique record for the composite key since it's no longer the primary key.

Perhaps this is just a limitation of the combination of DataStore's requirement to understandably ensure a unique id locally and DynamoDB's inability to specify unique constraints on secondary indexes, but if there is a solution here I would very much appreciate it.

from amplify-codegen.

I believe this functionality would be helpful for my use case as well. I have a set of items which are not modeled in DataStore with globally unique identifiers (“Service Tickets”) which users can collaborate on. There is a separate system of record which manages the Service Tickets. What I’d like to use DataStore for is to manage how those tickets change over time. For example: Multiple users can “Update” certain fields on those tickets. It is only the “Update” information that resides in DataStore. If two users both Update the same Ticket simultaneously, I would like for both of those changes to be "merged" to maintain the invariant that only 0 or 1 "Update" exists for a given Service_Ticket_Id. Since DataStore uses a separate uniqueness identifier (id), there doesn't seem to be a way to accomplish this.

@danrivett I don't have much experience with secondary indexes, but as I understand them they are only eventually consistent with the base table. How are you managing scenarios where propagation is delayed (or fails)?

from amplify-codegen.

dropping the table and recreating it worked for me as it was a small table.

from amplify-codegen.

Hi, this is a known gap in DataStore interacting with a customer Primary Key today. If you refer to the JavaScript DataStore docs https://docs.amplify.aws/lib/datastore/relational/q/platform/js/ we do call out that you'll need to explicitly set the id column as well. This will only be supported for the new v2 transformer once released, so in order to take advantage you'll need to upgrade. In the interim, similar to what the docs suggest you'll need to explicitly set your id column to the same as your defined primary key. Closing this issue and will track release of v2 support in #424

from amplify-codegen.