InstanceProperty.set()#

#InstanceProperty.set(*args: Type, **kwargs: Any) -> Instance

#import relationalai as rai

# Create a model named "books" with Author and Book types.
model = rai.Model("books")
Author = model.Type("Author")
Book = model.Type("Book")

# Add some authors and books to the model.
with model.rule():
    Book.add(title="Foundation", author=Author.add(name="Isaac Asimov"))

# Set a note property on the author of the Foundation book.
with model.rule():
    Book(title="Foundation").author.set(note="Science fiction author")

with model.query() as select:
    author = Author()
    response = select(author.name, author.note)

print(response.results)
# Output:
#            name                    note
# 0  Isaac Asimov  Science fiction author

## Add a books property to the Author type.
with model.rule():
    # Get all books
    book = Book()
    # Get the author of the book.
    author = book.author
    # Create multi-values books property for the author and add the book to it.
    # books multi-valued because it is created with InstanceProperty.add().
    author.books.add(book)

# Set the genre property to "Science Fiction" on books by Isaac Asimov.
with model.rule():
    Author(name="Isaac Asimov").books.set(genre="Science fiction")

# Get the names of authors and the titles and genres of their books.
with model.query() as select:
    # Get all author objects.
    author = Author()
    # Select the name of the author and the title and genre of their books.
    response = select(author.name, author.books.title, author.books.genre)

print(response.results)
# Output:
#            name       title            genre
# 0  Isaac Asimov  Foundation  Science fiction