NoteTemplateFormTemplateModel

Join row mirroring FORM_TEMPLATE rich-text blocks embedded in a NoteTemplate.

Source of truth is the rich-text block payload; this row is a queryable projection reconciled by the form module's NoteTemplateContentUpdatedEvent listener whenever note-template content changes. See spec §3.6.

Joins on FormTemplateVersion (the pinned version) so we can answer "is anyone still pinning this exact archived version?". The denormalized form_template column lets queries skip the join through the version when the family-level question suffices.

Attributes

form_template: FormTemplateform_template_id: strform_template_version: FormTemplateVersionform_template_version_id: strnote_template: NoteTemplate

Functions

__init__

Initialize self. See help(type(self)) for accurate signature.

clone

coerce

_coerce : bool - True

delete_instance

recursive : bool - False

delete_nullable : bool - False

dependencies

search_nullable : bool - True

exclude_null_children : bool - False

get_id

is_alias

is_dirty

save

Return type : BaseModel

unwrap

add_index @classmethod

fields : Any

after_all_tables_init @classmethod

Method call after all the table are inited

Useful when use DeferredForeignKey to create the foreign key manually latter

after_table_creation @classmethod

Method call after the table is created

Usefull to create the full text indexes

alias @classmethod

alias : Any

bind @classmethod

database : Any

bind_refs : bool - True

bind_backrefs : bool - True

_exclude : Any

bind_ctx @classmethod

database : Any

bind_refs : bool - True

bind_backrefs : bool - True

bulk_create @classmethod

model_list : Any

batch_size : Any

bulk_update @classmethod

model_list : Any

fields : Any

batch_size : Any

classname @classmethod

Returns the name of the class

slugify : bool - False

True to slugify the class name if True

snakefy : bool - False

True to snakefy the class name if True

replace_uppercase : bool - False

Replace upper cases by "-" if True

Return type : str

column_exists @classmethod

Returns True if the column exists in the table

column_name : str

The column name

Return type : bool

count_by_form_template_version @classmethod

version_id : str

Return type : int

create @classmethod

query : Any

create_foreign_key_if_not_exist @classmethod

Create a foreign key for a Foreign key field only if the foreign key does not exists

field : ForeignKeyField

[description]

create_full_text_index @classmethod

Method to create a full text index

columns : list

[description]

index_name : str

create_table @classmethod

Create model table

delete @classmethod

delete_by_id @classmethod

pk : Any

delete_for @classmethod

Remove the join row for (note_template, version). No-op if absent.

note_template_id : str

version_id : str

drop_table @classmethod

Drop model table

execute_sql @classmethod

Execute a raw SQL query. Can use the [TABLE_NAME] to replace by the table name

query : str

The query to execute

filter @classmethod

dq_nodes : Any

filters : Any

foreign_key_exists @classmethod

column_name : str

Return type : bool

full_classname @classmethod

Returns the full name of the class

slugify : bool - False

Slugify the returned class name if True

snakefy : bool - False

Snakefy the returned class name if True

Return type : str

get @classmethod

query : Any

filters : Any

get_by_form_template @classmethod

template_id : str

Return type : ModelSelect

get_by_form_template_version @classmethod

version_id : str

Return type : ModelSelect

get_by_id @classmethod

pk : Any

get_by_note_template @classmethod

note_template_id : str

Return type : list

get_db @classmethod

Return type : DatabaseProxy

get_db_manager @classmethod

Returns the (current) DbManager of this model

Return type : AbstractDbManager

get_metadata @classmethod

Return type : ModelMetadata

get_or_create @classmethod

get_or_none @classmethod

query : Any

filters : Any

get_table_name @classmethod

Returns the table name of this class

Return type : str | None

index @classmethod

fields : Any

index_exists @classmethod

Returns True if the index exists in the table

index_name : str

The index name

Return type : bool

inheritors @classmethod

Get all the classes that inherit this class

Return type : list

insert @classmethod

_Model__data : Any

insert : Any

insert_from @classmethod

query : Any

fields : Any

insert_many @classmethod

rows : Any

fields : Any

is_mysql_engine @classmethod

is_table @classmethod

Returns True if the class has a table name defined

Return type : bool

noop @classmethod

raw @classmethod

sql : Any

params : Any

replace @classmethod

_Model__data : Any

insert : Any

replace_many @classmethod

rows : Any

fields : Any

search @classmethod

Performs full-text search on the field. Must be overrided by child class to work

phrase : str

The phrase to search

modifier : str | None

Return type : ModelSelect

select @classmethod

fields : Any

set_by_id @classmethod

key : Any

value : Any

table_exists @classmethod

truncate_table @classmethod

options : Any

update @classmethod

_Model__data : Any

update : Any

upsert @classmethod

Insert a (note_template, version) row if missing.

The denormalized form_template column is set from the version row, so callers pass it explicitly rather than re-deriving inside this method (the listener already has the version loaded). No update path: the (note_template, version) pair fully determines form_template.

note_template_id : str

version_id : str

template_id : str

validate_model @classmethod

copy @staticmethod

method : Any

Have you developed a brick?