Orm Default
- 2 installs
- 14 repo stars
- Updated July 28, 2026
- constructive-io/agentic-db
Query the agentic-db default API in TypeScript with typed CRUD, vector and hybrid search, and relation walking across 91 generated tables.
About
An ORM client for the agentic-db default API providing typed CRUD, vector and hybrid search, and relation walking across 91 generated tables. A developer uses it to query the data model in TypeScript with a required select and QueryBuilder results.
- createClient factory returns a Prisma-like ORM with one model per generated table
- Typed CRUD plus vector and hybrid search and relation walking across 91 tables
Orm Default by the numbers
- 2 all-time installs (skills.sh)
- Ranked #741 of 911 Databases skills by installs in the Skillselion catalog
- Data as of Jul 29, 2026 (Skillselion catalog sync)
npx skills add https://github.com/constructive-io/agentic-db --skill orm-defaultAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 2 |
|---|---|
| repo stars | ★ 14 |
| Last updated | July 28, 2026 |
| Repository | constructive-io/agentic-db ↗ |
What it does
Query the agentic-db default API in TypeScript with typed CRUD, vector and hybrid search, and relation walking across 91 generated tables.
Files
skill
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Skill records
Usage
db.skill.findMany({ select: { id: true } }).execute()
db.skill.findOne({ id: '<value>', select: { id: true } }).execute()
db.skill.create({ data: { entityId: '<value>', name: '<value>', slug: '<value>', description: '<value>', content: '<value>', procedure: '<value>', interface: '<value>', requirements: '<value>', prerequisites: '<value>', alwaysLoad: '<value>', filePath: '<value>', contentHash: '<value>', category: '<value>', isActive: '<value>', abstract: '<value>', overview: '<value>', activeCount: '<value>', lastAccessedAt: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', intentTrigger: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', slugTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', contentTrgmSimilarity: '<value>', procedureTrgmSimilarity: '<value>', filePathTrgmSimilarity: '<value>', contentHashTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', abstractTrgmSimilarity: '<value>', overviewTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', intentTriggerVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.skill.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.skill.delete({ where: { id: '<value>' } }).execute()Examples
List all skill records
const items = await db.skill.findMany({
select: { id: true, entityId: true }
}).execute();Create a skill
const item = await db.skill.create({
data: { entityId: 'value', name: 'value', slug: 'value', description: 'value', content: 'value', procedure: 'value', interface: 'value', requirements: 'value', prerequisites: 'value', alwaysLoad: 'value', filePath: 'value', contentHash: 'value', category: 'value', isActive: 'value', abstract: 'value', overview: 'value', activeCount: 'value', lastAccessedAt: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', intentTrigger: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', slugTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', contentTrgmSimilarity: 'value', procedureTrgmSimilarity: 'value', filePathTrgmSimilarity: 'value', contentHashTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', abstractTrgmSimilarity: 'value', overviewTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', intentTriggerVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();activityLog
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ActivityLog records
Usage
db.activityLog.findMany({ select: { id: true } }).execute()
db.activityLog.findOne({ id: '<value>', select: { id: true } }).execute()
db.activityLog.create({ data: { entityId: '<value>', actorType: '<value>', actorId: '<value>', action: '<value>', targetType: '<value>', targetId: '<value>', metadata: '<value>', actorTypeTrgmSimilarity: '<value>', actionTrgmSimilarity: '<value>', targetTypeTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.activityLog.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.activityLog.delete({ where: { id: '<value>' } }).execute()Examples
List all activityLog records
const items = await db.activityLog.findMany({
select: { id: true, entityId: true }
}).execute();Create a activityLog
const item = await db.activityLog.create({
data: { entityId: 'value', actorType: 'value', actorId: 'value', action: 'value', targetType: 'value', targetId: 'value', metadata: 'value', actorTypeTrgmSimilarity: 'value', actionTrgmSimilarity: 'value', targetTypeTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();agentPrompt
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for AgentPrompt records
Usage
db.agentPrompt.findMany({ select: { id: true } }).execute()
db.agentPrompt.findOne({ id: '<value>', select: { id: true } }).execute()
db.agentPrompt.create({ data: { agentId: '<value>', promptId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.agentPrompt.update({ where: { id: '<value>' }, data: { agentId: '<new>' }, select: { id: true } }).execute()
db.agentPrompt.delete({ where: { id: '<value>' } }).execute()Examples
List all agentPrompt records
const items = await db.agentPrompt.findMany({
select: { id: true, agentId: true }
}).execute();Create a agentPrompt
const item = await db.agentPrompt.create({
data: { agentId: 'value', promptId: 'value', entityId: 'value' },
select: { id: true }
}).execute();agentRule
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for AgentRule records
Usage
db.agentRule.findMany({ select: { id: true } }).execute()
db.agentRule.findOne({ id: '<value>', select: { id: true } }).execute()
db.agentRule.create({ data: { agentId: '<value>', ruleId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.agentRule.update({ where: { id: '<value>' }, data: { agentId: '<new>' }, select: { id: true } }).execute()
db.agentRule.delete({ where: { id: '<value>' } }).execute()Examples
List all agentRule records
const items = await db.agentRule.findMany({
select: { id: true, agentId: true }
}).execute();Create a agentRule
const item = await db.agentRule.create({
data: { agentId: 'value', ruleId: 'value', entityId: 'value' },
select: { id: true }
}).execute();agentSkill
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for AgentSkill records
Usage
db.agentSkill.findMany({ select: { id: true } }).execute()
db.agentSkill.findOne({ id: '<value>', select: { id: true } }).execute()
db.agentSkill.create({ data: { agentId: '<value>', skillId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.agentSkill.update({ where: { id: '<value>' }, data: { agentId: '<new>' }, select: { id: true } }).execute()
db.agentSkill.delete({ where: { id: '<value>' } }).execute()Examples
List all agentSkill records
const items = await db.agentSkill.findMany({
select: { id: true, agentId: true }
}).execute();Create a agentSkill
const item = await db.agentSkill.create({
data: { agentId: 'value', skillId: 'value', entityId: 'value' },
select: { id: true }
}).execute();agentSpawn
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for AgentSpawn records
Usage
db.agentSpawn.findMany({ select: { id: true } }).execute()
db.agentSpawn.findOne({ id: '<value>', select: { id: true } }).execute()
db.agentSpawn.create({ data: { entityId: '<value>', parentAgentId: '<value>', childAgentId: '<value>', sessionId: '<value>', task: '<value>', status: '<value>', result: '<value>', maxIterations: '<value>', startedAt: '<value>', completedAt: '<value>', agentId: '<value>', taskTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.agentSpawn.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.agentSpawn.delete({ where: { id: '<value>' } }).execute()Examples
List all agentSpawn records
const items = await db.agentSpawn.findMany({
select: { id: true, entityId: true }
}).execute();Create a agentSpawn
const item = await db.agentSpawn.create({
data: { entityId: 'value', parentAgentId: 'value', childAgentId: 'value', sessionId: 'value', task: 'value', status: 'value', result: 'value', maxIterations: 'value', startedAt: 'value', completedAt: 'value', agentId: 'value', taskTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();agentTool
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for AgentTool records
Usage
db.agentTool.findMany({ select: { id: true } }).execute()
db.agentTool.findOne({ id: '<value>', select: { id: true } }).execute()
db.agentTool.create({ data: { agentId: '<value>', toolId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.agentTool.update({ where: { id: '<value>' }, data: { agentId: '<new>' }, select: { id: true } }).execute()
db.agentTool.delete({ where: { id: '<value>' } }).execute()Examples
List all agentTool records
const items = await db.agentTool.findMany({
select: { id: true, agentId: true }
}).execute();Create a agentTool
const item = await db.agentTool.create({
data: { agentId: 'value', toolId: 'value', entityId: 'value' },
select: { id: true }
}).execute();agent
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Agent records
Usage
db.agent.findMany({ select: { id: true } }).execute()
db.agent.findOne({ id: '<value>', select: { id: true } }).execute()
db.agent.create({ data: { entityId: '<value>', name: '<value>', role: '<value>', capabilities: '<value>', config: '<value>', status: '<value>', persona: '<value>', backstory: '<value>', communicationStyle: '<value>', systemPrompt: '<value>', preferredModel: '<value>', fallbackModels: '<value>', temperature: '<value>', mood: '<value>', focus: '<value>', lastActiveAt: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', roleTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', personaTrgmSimilarity: '<value>', backstoryTrgmSimilarity: '<value>', communicationStyleTrgmSimilarity: '<value>', systemPromptTrgmSimilarity: '<value>', preferredModelTrgmSimilarity: '<value>', moodTrgmSimilarity: '<value>', focusTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.agent.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.agent.delete({ where: { id: '<value>' } }).execute()Examples
List all agent records
const items = await db.agent.findMany({
select: { id: true, entityId: true }
}).execute();Create a agent
const item = await db.agent.create({
data: { entityId: 'value', name: 'value', role: 'value', capabilities: 'value', config: 'value', status: 'value', persona: 'value', backstory: 'value', communicationStyle: 'value', systemPrompt: 'value', preferredModel: 'value', fallbackModels: 'value', temperature: 'value', mood: 'value', focus: 'value', lastActiveAt: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', roleTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', personaTrgmSimilarity: 'value', backstoryTrgmSimilarity: 'value', communicationStyleTrgmSimilarity: 'value', systemPromptTrgmSimilarity: 'value', preferredModelTrgmSimilarity: 'value', moodTrgmSimilarity: 'value', focusTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();attachment
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Attachment records
Usage
db.attachment.findMany({ select: { id: true } }).execute()
db.attachment.findOne({ id: '<value>', select: { id: true } }).execute()
db.attachment.create({ data: { entityId: '<value>', url: '<value>', filename: '<value>', mimeType: '<value>', sizeBytes: '<value>', attachableType: '<value>', attachableId: '<value>', urlTrgmSimilarity: '<value>', filenameTrgmSimilarity: '<value>', mimeTypeTrgmSimilarity: '<value>', attachableTypeTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.attachment.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.attachment.delete({ where: { id: '<value>' } }).execute()Examples
List all attachment records
const items = await db.attachment.findMany({
select: { id: true, entityId: true }
}).execute();Create a attachment
const item = await db.attachment.create({
data: { entityId: 'value', url: 'value', filename: 'value', mimeType: 'value', sizeBytes: 'value', attachableType: 'value', attachableId: 'value', urlTrgmSimilarity: 'value', filenameTrgmSimilarity: 'value', mimeTypeTrgmSimilarity: 'value', attachableTypeTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();billingSubscription
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for BillingSubscription records
Usage
db.billingSubscription.findMany({ select: { id: true } }).execute()
db.billingSubscription.findOne({ id: '<value>', select: { id: true } }).execute()
db.billingSubscription.create({ data: { entityId: '<value>', name: '<value>', amount: '<value>', currency: '<value>', frequency: '<value>', provider: '<value>', nextBillingDate: '<value>', cancellationDate: '<value>', status: '<value>', tags: '<value>', notes: '<value>', nameTrgmSimilarity: '<value>', currencyTrgmSimilarity: '<value>', frequencyTrgmSimilarity: '<value>', providerTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', notesTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.billingSubscription.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.billingSubscription.delete({ where: { id: '<value>' } }).execute()Examples
List all billingSubscription records
const items = await db.billingSubscription.findMany({
select: { id: true, entityId: true }
}).execute();Create a billingSubscription
const item = await db.billingSubscription.create({
data: { entityId: 'value', name: 'value', amount: 'value', currency: 'value', frequency: 'value', provider: 'value', nextBillingDate: 'value', cancellationDate: 'value', status: 'value', tags: 'value', notes: 'value', nameTrgmSimilarity: 'value', currencyTrgmSimilarity: 'value', frequencyTrgmSimilarity: 'value', providerTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', notesTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();blueprint
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Blueprint records
Usage
db.blueprint.findMany({ select: { id: true } }).execute()
db.blueprint.findOne({ id: '<value>', select: { id: true } }).execute()
db.blueprint.create({ data: { entityId: '<value>', title: '<value>', steps: '<value>', triggerConditions: '<value>', conversationId: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', triggerConditionsTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.blueprint.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.blueprint.delete({ where: { id: '<value>' } }).execute()Examples
List all blueprint records
const items = await db.blueprint.findMany({
select: { id: true, entityId: true }
}).execute();Create a blueprint
const item = await db.blueprint.create({
data: { entityId: 'value', title: 'value', steps: 'value', triggerConditions: 'value', conversationId: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', triggerConditionsTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();calendarAccount
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for CalendarAccount records
Usage
db.calendarAccount.findMany({ select: { id: true } }).execute()
db.calendarAccount.findOne({ id: '<value>', select: { id: true } }).execute()
db.calendarAccount.create({ data: { entityId: '<value>', email: '<value>', provider: '<value>', syncToken: '<value>', lastSyncedAt: '<value>', emailTrgmSimilarity: '<value>', providerTrgmSimilarity: '<value>', syncTokenTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.calendarAccount.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.calendarAccount.delete({ where: { id: '<value>' } }).execute()Examples
List all calendarAccount records
const items = await db.calendarAccount.findMany({
select: { id: true, entityId: true }
}).execute();Create a calendarAccount
const item = await db.calendarAccount.create({
data: { entityId: 'value', email: 'value', provider: 'value', syncToken: 'value', lastSyncedAt: 'value', emailTrgmSimilarity: 'value', providerTrgmSimilarity: 'value', syncTokenTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();calendarEventContact
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for CalendarEventContact records
Usage
db.calendarEventContact.findMany({ select: { id: true } }).execute()
db.calendarEventContact.findOne({ id: '<value>', select: { id: true } }).execute()
db.calendarEventContact.create({ data: { calendarEventId: '<value>', contactId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.calendarEventContact.update({ where: { id: '<value>' }, data: { calendarEventId: '<new>' }, select: { id: true } }).execute()
db.calendarEventContact.delete({ where: { id: '<value>' } }).execute()Examples
List all calendarEventContact records
const items = await db.calendarEventContact.findMany({
select: { id: true, calendarEventId: true }
}).execute();Create a calendarEventContact
const item = await db.calendarEventContact.create({
data: { calendarEventId: 'value', contactId: 'value', entityId: 'value' },
select: { id: true }
}).execute();calendarEvent
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for CalendarEvent records
Usage
db.calendarEvent.findMany({ select: { id: true } }).execute()
db.calendarEvent.findOne({ id: '<value>', select: { id: true } }).execute()
db.calendarEvent.create({ data: { entityId: '<value>', calendarAccountId: '<value>', remoteId: '<value>', title: '<value>', description: '<value>', startAt: '<value>', endAt: '<value>', allDay: '<value>', location: '<value>', recurrenceRule: '<value>', status: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', remoteIdTrgmSimilarity: '<value>', titleTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', locationTrgmSimilarity: '<value>', recurrenceRuleTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.calendarEvent.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.calendarEvent.delete({ where: { id: '<value>' } }).execute()Examples
List all calendarEvent records
const items = await db.calendarEvent.findMany({
select: { id: true, entityId: true }
}).execute();Create a calendarEvent
const item = await db.calendarEvent.create({
data: { entityId: 'value', calendarAccountId: 'value', remoteId: 'value', title: 'value', description: 'value', startAt: 'value', endAt: 'value', allDay: 'value', location: 'value', recurrenceRule: 'value', status: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', remoteIdTrgmSimilarity: 'value', titleTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', locationTrgmSimilarity: 'value', recurrenceRuleTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();chatMessage
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ChatMessage records
Usage
db.chatMessage.findMany({ select: { id: true } }).execute()
db.chatMessage.findOne({ id: '<value>', select: { id: true } }).execute()
db.chatMessage.create({ data: { entityId: '<value>', chatId: '<value>', threadId: '<value>', role: '<value>', content: '<value>', toolCalls: '<value>', embeddingText: '<value>', embedding: '<value>', contentBm25Score: '<value>', embeddingTextBm25Score: '<value>', roleTrgmSimilarity: '<value>', contentTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.chatMessage.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.chatMessage.delete({ where: { id: '<value>' } }).execute()Examples
List all chatMessage records
const items = await db.chatMessage.findMany({
select: { id: true, entityId: true }
}).execute();Create a chatMessage
const item = await db.chatMessage.create({
data: { entityId: 'value', chatId: 'value', threadId: 'value', role: 'value', content: 'value', toolCalls: 'value', embeddingText: 'value', embedding: 'value', contentBm25Score: 'value', embeddingTextBm25Score: 'value', roleTrgmSimilarity: 'value', contentTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();chat
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Chat records
Usage
db.chat.findMany({ select: { id: true } }).execute()
db.chat.findOne({ id: '<value>', select: { id: true } }).execute()
db.chat.create({ data: { entityId: '<value>', title: '<value>', startedAt: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.chat.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.chat.delete({ where: { id: '<value>' } }).execute()Examples
List all chat records
const items = await db.chat.findMany({
select: { id: true, entityId: true }
}).execute();Create a chat
const item = await db.chat.create({
data: { entityId: 'value', title: 'value', startedAt: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();chunk
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Chunk records
Usage
db.chunk.findMany({ select: { id: true } }).execute()
db.chunk.findOne({ id: '<value>', select: { id: true } }).execute()
db.chunk.create({ data: { entityId: '<value>', fileId: '<value>', repositoryId: '<value>', content: '<value>', startLine: '<value>', endLine: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', contentTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.chunk.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.chunk.delete({ where: { id: '<value>' } }).execute()Examples
List all chunk records
const items = await db.chunk.findMany({
select: { id: true, entityId: true }
}).execute();Create a chunk
const item = await db.chunk.create({
data: { entityId: 'value', fileId: 'value', repositoryId: 'value', content: 'value', startLine: 'value', endLine: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', contentTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();companyEvent
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for CompanyEvent records
Usage
db.companyEvent.findMany({ select: { id: true } }).execute()
db.companyEvent.findOne({ id: '<value>', select: { id: true } }).execute()
db.companyEvent.create({ data: { companyId: '<value>', eventId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.companyEvent.update({ where: { id: '<value>' }, data: { companyId: '<new>' }, select: { id: true } }).execute()
db.companyEvent.delete({ where: { id: '<value>' } }).execute()Examples
List all companyEvent records
const items = await db.companyEvent.findMany({
select: { id: true, companyId: true }
}).execute();Create a companyEvent
const item = await db.companyEvent.create({
data: { companyId: 'value', eventId: 'value', entityId: 'value' },
select: { id: true }
}).execute();companyImage
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for CompanyImage records
Usage
db.companyImage.findMany({ select: { id: true } }).execute()
db.companyImage.findOne({ id: '<value>', select: { id: true } }).execute()
db.companyImage.create({ data: { companyId: '<value>', imageId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.companyImage.update({ where: { id: '<value>' }, data: { companyId: '<new>' }, select: { id: true } }).execute()
db.companyImage.delete({ where: { id: '<value>' } }).execute()Examples
List all companyImage records
const items = await db.companyImage.findMany({
select: { id: true, companyId: true }
}).execute();Create a companyImage
const item = await db.companyImage.create({
data: { companyId: 'value', imageId: 'value', entityId: 'value' },
select: { id: true }
}).execute();companyLink
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for CompanyLink records
Usage
db.companyLink.findMany({ select: { id: true } }).execute()
db.companyLink.findOne({ id: '<value>', select: { id: true } }).execute()
db.companyLink.create({ data: { entityId: '<value>', title: '<value>', url: '<value>', embedding: '<value>', companyId: '<value>', titleTrgmSimilarity: '<value>', urlTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.companyLink.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.companyLink.delete({ where: { id: '<value>' } }).execute()Examples
List all companyLink records
const items = await db.companyLink.findMany({
select: { id: true, entityId: true }
}).execute();Create a companyLink
const item = await db.companyLink.create({
data: { entityId: 'value', title: 'value', url: 'value', embedding: 'value', companyId: 'value', titleTrgmSimilarity: 'value', urlTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();company
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Company records
Usage
db.company.findMany({ select: { id: true } }).execute()
db.company.findOne({ id: '<value>', select: { id: true } }).execute()
db.company.create({ data: { entityId: '<value>', name: '<value>', domain: '<value>', industry: '<value>', description: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', searchTsv: '<value>', mainImageId: '<value>', searchTsvRank: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', domainTrgmSimilarity: '<value>', industryTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.company.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.company.delete({ where: { id: '<value>' } }).execute()Examples
List all company records
const items = await db.company.findMany({
select: { id: true, entityId: true }
}).execute();Create a company
const item = await db.company.create({
data: { entityId: 'value', name: 'value', domain: 'value', industry: 'value', description: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', searchTsv: 'value', mainImageId: 'value', searchTsvRank: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', domainTrgmSimilarity: 'value', industryTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();contactCompany
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ContactCompany records
Usage
db.contactCompany.findMany({ select: { id: true } }).execute()
db.contactCompany.findOne({ id: '<value>', select: { id: true } }).execute()
db.contactCompany.create({ data: { contactId: '<value>', companyId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.contactCompany.update({ where: { id: '<value>' }, data: { contactId: '<new>' }, select: { id: true } }).execute()
db.contactCompany.delete({ where: { id: '<value>' } }).execute()Examples
List all contactCompany records
const items = await db.contactCompany.findMany({
select: { id: true, contactId: true }
}).execute();Create a contactCompany
const item = await db.contactCompany.create({
data: { contactId: 'value', companyId: 'value', entityId: 'value' },
select: { id: true }
}).execute();contactEvent
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ContactEvent records
Usage
db.contactEvent.findMany({ select: { id: true } }).execute()
db.contactEvent.findOne({ id: '<value>', select: { id: true } }).execute()
db.contactEvent.create({ data: { contactId: '<value>', eventId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.contactEvent.update({ where: { id: '<value>' }, data: { contactId: '<new>' }, select: { id: true } }).execute()
db.contactEvent.delete({ where: { id: '<value>' } }).execute()Examples
List all contactEvent records
const items = await db.contactEvent.findMany({
select: { id: true, contactId: true }
}).execute();Create a contactEvent
const item = await db.contactEvent.create({
data: { contactId: 'value', eventId: 'value', entityId: 'value' },
select: { id: true }
}).execute();contactImage
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ContactImage records
Usage
db.contactImage.findMany({ select: { id: true } }).execute()
db.contactImage.findOne({ id: '<value>', select: { id: true } }).execute()
db.contactImage.create({ data: { contactId: '<value>', imageId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.contactImage.update({ where: { id: '<value>' }, data: { contactId: '<new>' }, select: { id: true } }).execute()
db.contactImage.delete({ where: { id: '<value>' } }).execute()Examples
List all contactImage records
const items = await db.contactImage.findMany({
select: { id: true, contactId: true }
}).execute();Create a contactImage
const item = await db.contactImage.create({
data: { contactId: 'value', imageId: 'value', entityId: 'value' },
select: { id: true }
}).execute();contactLink
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ContactLink records
Usage
db.contactLink.findMany({ select: { id: true } }).execute()
db.contactLink.findOne({ id: '<value>', select: { id: true } }).execute()
db.contactLink.create({ data: { entityId: '<value>', title: '<value>', url: '<value>', embedding: '<value>', contactId: '<value>', titleTrgmSimilarity: '<value>', urlTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.contactLink.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.contactLink.delete({ where: { id: '<value>' } }).execute()Examples
List all contactLink records
const items = await db.contactLink.findMany({
select: { id: true, entityId: true }
}).execute();Create a contactLink
const item = await db.contactLink.create({
data: { entityId: 'value', title: 'value', url: 'value', embedding: 'value', contactId: 'value', titleTrgmSimilarity: 'value', urlTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();contact
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Contact records
Usage
db.contact.findMany({ select: { id: true } }).execute()
db.contact.findOne({ id: '<value>', select: { id: true } }).execute()
db.contact.create({ data: { entityId: '<value>', firstName: '<value>', lastName: '<value>', email: '<value>', phone: '<value>', headline: '<value>', bio: '<value>', location: '<value>', birthday: '<value>', relationshipType: '<value>', howWeMet: '<value>', twitterHandle: '<value>', linkedinUrl: '<value>', githubUsername: '<value>', instagramHandle: '<value>', website: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', searchTsv: '<value>', mainImageId: '<value>', searchTsvRank: '<value>', embeddingTextBm25Score: '<value>', firstNameTrgmSimilarity: '<value>', lastNameTrgmSimilarity: '<value>', emailTrgmSimilarity: '<value>', phoneTrgmSimilarity: '<value>', headlineTrgmSimilarity: '<value>', bioTrgmSimilarity: '<value>', locationTrgmSimilarity: '<value>', relationshipTypeTrgmSimilarity: '<value>', howWeMetTrgmSimilarity: '<value>', twitterHandleTrgmSimilarity: '<value>', linkedinUrlTrgmSimilarity: '<value>', githubUsernameTrgmSimilarity: '<value>', instagramHandleTrgmSimilarity: '<value>', websiteTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.contact.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.contact.delete({ where: { id: '<value>' } }).execute()Examples
List all contact records
const items = await db.contact.findMany({
select: { id: true, entityId: true }
}).execute();Create a contact
const item = await db.contact.create({
data: { entityId: 'value', firstName: 'value', lastName: 'value', email: 'value', phone: 'value', headline: 'value', bio: 'value', location: 'value', birthday: 'value', relationshipType: 'value', howWeMet: 'value', twitterHandle: 'value', linkedinUrl: 'value', githubUsername: 'value', instagramHandle: 'value', website: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', searchTsv: 'value', mainImageId: 'value', searchTsvRank: 'value', embeddingTextBm25Score: 'value', firstNameTrgmSimilarity: 'value', lastNameTrgmSimilarity: 'value', emailTrgmSimilarity: 'value', phoneTrgmSimilarity: 'value', headlineTrgmSimilarity: 'value', bioTrgmSimilarity: 'value', locationTrgmSimilarity: 'value', relationshipTypeTrgmSimilarity: 'value', howWeMetTrgmSimilarity: 'value', twitterHandleTrgmSimilarity: 'value', linkedinUrlTrgmSimilarity: 'value', githubUsernameTrgmSimilarity: 'value', instagramHandleTrgmSimilarity: 'value', websiteTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();contextRelation
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ContextRelation records
Usage
db.contextRelation.findMany({ select: { id: true } }).execute()
db.contextRelation.findOne({ id: '<value>', select: { id: true } }).execute()
db.contextRelation.create({ data: { entityId: '<value>', fromType: '<value>', fromId: '<value>', toType: '<value>', toId: '<value>', relationKind: '<value>', reason: '<value>', strength: '<value>', fromTypeTrgmSimilarity: '<value>', toTypeTrgmSimilarity: '<value>', relationKindTrgmSimilarity: '<value>', reasonTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.contextRelation.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.contextRelation.delete({ where: { id: '<value>' } }).execute()Examples
List all contextRelation records
const items = await db.contextRelation.findMany({
select: { id: true, entityId: true }
}).execute();Create a contextRelation
const item = await db.contextRelation.create({
data: { entityId: 'value', fromType: 'value', fromId: 'value', toType: 'value', toId: 'value', relationKind: 'value', reason: 'value', strength: 'value', fromTypeTrgmSimilarity: 'value', toTypeTrgmSimilarity: 'value', relationKindTrgmSimilarity: 'value', reasonTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();dealContact
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for DealContact records
Usage
db.dealContact.findMany({ select: { id: true } }).execute()
db.dealContact.findOne({ id: '<value>', select: { id: true } }).execute()
db.dealContact.create({ data: { dealId: '<value>', contactId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.dealContact.update({ where: { id: '<value>' }, data: { dealId: '<new>' }, select: { id: true } }).execute()
db.dealContact.delete({ where: { id: '<value>' } }).execute()Examples
List all dealContact records
const items = await db.dealContact.findMany({
select: { id: true, dealId: true }
}).execute();Create a dealContact
const item = await db.dealContact.create({
data: { dealId: 'value', contactId: 'value', entityId: 'value' },
select: { id: true }
}).execute();deal
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Deal records
Usage
db.deal.findMany({ select: { id: true } }).execute()
db.deal.findOne({ id: '<value>', select: { id: true } }).execute()
db.deal.create({ data: { entityId: '<value>', name: '<value>', stage: '<value>', value: '<value>', currency: '<value>', expectedCloseDate: '<value>', notes: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', stageTrgmSimilarity: '<value>', currencyTrgmSimilarity: '<value>', notesTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.deal.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.deal.delete({ where: { id: '<value>' } }).execute()Examples
List all deal records
const items = await db.deal.findMany({
select: { id: true, entityId: true }
}).execute();Create a deal
const item = await db.deal.create({
data: { entityId: 'value', name: 'value', stage: 'value', value: 'value', currency: 'value', expectedCloseDate: 'value', notes: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', stageTrgmSimilarity: 'value', currencyTrgmSimilarity: 'value', notesTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();document
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Document records
Usage
db.document.findMany({ select: { id: true } }).execute()
db.document.findOne({ id: '<value>', select: { id: true } }).execute()
db.document.create({ data: { entityId: '<value>', title: '<value>', url: '<value>', content: '<value>', sourceType: '<value>', isRead: '<value>', savedAt: '<value>', parentDocumentId: '<value>', abstract: '<value>', overview: '<value>', activeCount: '<value>', lastAccessedAt: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', searchTsv: '<value>', searchTsvRank: '<value>', contentBm25Score: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', urlTrgmSimilarity: '<value>', contentTrgmSimilarity: '<value>', sourceTypeTrgmSimilarity: '<value>', abstractTrgmSimilarity: '<value>', overviewTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.document.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.document.delete({ where: { id: '<value>' } }).execute()Examples
List all document records
const items = await db.document.findMany({
select: { id: true, entityId: true }
}).execute();Create a document
const item = await db.document.create({
data: { entityId: 'value', title: 'value', url: 'value', content: 'value', sourceType: 'value', isRead: 'value', savedAt: 'value', parentDocumentId: 'value', abstract: 'value', overview: 'value', activeCount: 'value', lastAccessedAt: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', searchTsv: 'value', searchTsvRank: 'value', contentBm25Score: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', urlTrgmSimilarity: 'value', contentTrgmSimilarity: 'value', sourceTypeTrgmSimilarity: 'value', abstractTrgmSimilarity: 'value', overviewTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();emailAccount
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for EmailAccount records
Usage
db.emailAccount.findMany({ select: { id: true } }).execute()
db.emailAccount.findOne({ id: '<value>', select: { id: true } }).execute()
db.emailAccount.create({ data: { entityId: '<value>', email: '<value>', provider: '<value>', syncState: '<value>', emailTrgmSimilarity: '<value>', providerTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.emailAccount.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.emailAccount.delete({ where: { id: '<value>' } }).execute()Examples
List all emailAccount records
const items = await db.emailAccount.findMany({
select: { id: true, entityId: true }
}).execute();Create a emailAccount
const item = await db.emailAccount.create({
data: { entityId: 'value', email: 'value', provider: 'value', syncState: 'value', emailTrgmSimilarity: 'value', providerTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();eventImage
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for EventImage records
Usage
db.eventImage.findMany({ select: { id: true } }).execute()
db.eventImage.findOne({ id: '<value>', select: { id: true } }).execute()
db.eventImage.create({ data: { eventId: '<value>', imageId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.eventImage.update({ where: { id: '<value>' }, data: { eventId: '<new>' }, select: { id: true } }).execute()
db.eventImage.delete({ where: { id: '<value>' } }).execute()Examples
List all eventImage records
const items = await db.eventImage.findMany({
select: { id: true, eventId: true }
}).execute();Create a eventImage
const item = await db.eventImage.create({
data: { eventId: 'value', imageId: 'value', entityId: 'value' },
select: { id: true }
}).execute();eventLink
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for EventLink records
Usage
db.eventLink.findMany({ select: { id: true } }).execute()
db.eventLink.findOne({ id: '<value>', select: { id: true } }).execute()
db.eventLink.create({ data: { entityId: '<value>', title: '<value>', url: '<value>', embedding: '<value>', eventId: '<value>', titleTrgmSimilarity: '<value>', urlTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.eventLink.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.eventLink.delete({ where: { id: '<value>' } }).execute()Examples
List all eventLink records
const items = await db.eventLink.findMany({
select: { id: true, entityId: true }
}).execute();Create a eventLink
const item = await db.eventLink.create({
data: { entityId: 'value', title: 'value', url: 'value', embedding: 'value', eventId: 'value', titleTrgmSimilarity: 'value', urlTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();eventVenue
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for EventVenue records
Usage
db.eventVenue.findMany({ select: { id: true } }).execute()
db.eventVenue.findOne({ id: '<value>', select: { id: true } }).execute()
db.eventVenue.create({ data: { eventId: '<value>', venueId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.eventVenue.update({ where: { id: '<value>' }, data: { eventId: '<new>' }, select: { id: true } }).execute()
db.eventVenue.delete({ where: { id: '<value>' } }).execute()Examples
List all eventVenue records
const items = await db.eventVenue.findMany({
select: { id: true, eventId: true }
}).execute();Create a eventVenue
const item = await db.eventVenue.create({
data: { eventId: 'value', venueId: 'value', entityId: 'value' },
select: { id: true }
}).execute();event
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Event records
Usage
db.event.findMany({ select: { id: true } }).execute()
db.event.findOne({ id: '<value>', select: { id: true } }).execute()
db.event.create({ data: { entityId: '<value>', name: '<value>', eventType: '<value>', location: '<value>', city: '<value>', startedAt: '<value>', endedAt: '<value>', notes: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', searchTsv: '<value>', mainImageId: '<value>', searchTsvRank: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', eventTypeTrgmSimilarity: '<value>', locationTrgmSimilarity: '<value>', cityTrgmSimilarity: '<value>', notesTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.event.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.event.delete({ where: { id: '<value>' } }).execute()Examples
List all event records
const items = await db.event.findMany({
select: { id: true, entityId: true }
}).execute();Create a event
const item = await db.event.create({
data: { entityId: 'value', name: 'value', eventType: 'value', location: 'value', city: 'value', startedAt: 'value', endedAt: 'value', notes: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', searchTsv: 'value', mainImageId: 'value', searchTsvRank: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', eventTypeTrgmSimilarity: 'value', locationTrgmSimilarity: 'value', cityTrgmSimilarity: 'value', notesTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();executionLog
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ExecutionLog records
Usage
db.executionLog.findMany({ select: { id: true } }).execute()
db.executionLog.findOne({ id: '<value>', select: { id: true } }).execute()
db.executionLog.create({ data: { entityId: '<value>', sessionId: '<value>', stepName: '<value>', input: '<value>', output: '<value>', toolCalls: '<value>', durationMs: '<value>', stepNameTrgmSimilarity: '<value>', inputTrgmSimilarity: '<value>', outputTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.executionLog.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.executionLog.delete({ where: { id: '<value>' } }).execute()Examples
List all executionLog records
const items = await db.executionLog.findMany({
select: { id: true, entityId: true }
}).execute();Create a executionLog
const item = await db.executionLog.create({
data: { entityId: 'value', sessionId: 'value', stepName: 'value', input: 'value', output: 'value', toolCalls: 'value', durationMs: 'value', stepNameTrgmSimilarity: 'value', inputTrgmSimilarity: 'value', outputTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();expenseContact
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ExpenseContact records
Usage
db.expenseContact.findMany({ select: { id: true } }).execute()
db.expenseContact.findOne({ id: '<value>', select: { id: true } }).execute()
db.expenseContact.create({ data: { expenseId: '<value>', contactId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.expenseContact.update({ where: { id: '<value>' }, data: { expenseId: '<new>' }, select: { id: true } }).execute()
db.expenseContact.delete({ where: { id: '<value>' } }).execute()Examples
List all expenseContact records
const items = await db.expenseContact.findMany({
select: { id: true, expenseId: true }
}).execute();Create a expenseContact
const item = await db.expenseContact.create({
data: { expenseId: 'value', contactId: 'value', entityId: 'value' },
select: { id: true }
}).execute();expense
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Expense records
Usage
db.expense.findMany({ select: { id: true } }).execute()
db.expense.findOne({ id: '<value>', select: { id: true } }).execute()
db.expense.create({ data: { entityId: '<value>', amount: '<value>', currency: '<value>', date: '<value>', category: '<value>', description: '<value>', merchant: '<value>', receiptUrl: '<value>', isRecurring: '<value>', tags: '<value>', currencyTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', merchantTrgmSimilarity: '<value>', receiptUrlTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.expense.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.expense.delete({ where: { id: '<value>' } }).execute()Examples
List all expense records
const items = await db.expense.findMany({
select: { id: true, entityId: true }
}).execute();Create a expense
const item = await db.expense.create({
data: { entityId: 'value', amount: 'value', currency: 'value', date: 'value', category: 'value', description: 'value', merchant: 'value', receiptUrl: 'value', isRecurring: 'value', tags: 'value', currencyTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', merchantTrgmSimilarity: 'value', receiptUrlTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();feedback
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Feedback records
Usage
db.feedback.findMany({ select: { id: true } }).execute()
db.feedback.findOne({ id: '<value>', select: { id: true } }).execute()
db.feedback.create({ data: { entityId: '<value>', targetType: '<value>', targetId: '<value>', rating: '<value>', comment: '<value>', source: '<value>', targetTypeTrgmSimilarity: '<value>', commentTrgmSimilarity: '<value>', sourceTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.feedback.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.feedback.delete({ where: { id: '<value>' } }).execute()Examples
List all feedback records
const items = await db.feedback.findMany({
select: { id: true, entityId: true }
}).execute();Create a feedback
const item = await db.feedback.create({
data: { entityId: 'value', targetType: 'value', targetId: 'value', rating: 'value', comment: 'value', source: 'value', targetTypeTrgmSimilarity: 'value', commentTrgmSimilarity: 'value', sourceTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();file
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for File records
Usage
db.file.findMany({ select: { id: true } }).execute()
db.file.findOne({ id: '<value>', select: { id: true } }).execute()
db.file.create({ data: { entityId: '<value>', repositoryId: '<value>', path: '<value>', language: '<value>', hash: '<value>', pathTrgmSimilarity: '<value>', languageTrgmSimilarity: '<value>', hashTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.file.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.file.delete({ where: { id: '<value>' } }).execute()Examples
List all file records
const items = await db.file.findMany({
select: { id: true, entityId: true }
}).execute();Create a file
const item = await db.file.create({
data: { entityId: 'value', repositoryId: 'value', path: 'value', language: 'value', hash: 'value', pathTrgmSimilarity: 'value', languageTrgmSimilarity: 'value', hashTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();goalHabit
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for GoalHabit records
Usage
db.goalHabit.findMany({ select: { id: true } }).execute()
db.goalHabit.findOne({ id: '<value>', select: { id: true } }).execute()
db.goalHabit.create({ data: { goalId: '<value>', habitId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.goalHabit.update({ where: { id: '<value>' }, data: { goalId: '<new>' }, select: { id: true } }).execute()
db.goalHabit.delete({ where: { id: '<value>' } }).execute()Examples
List all goalHabit records
const items = await db.goalHabit.findMany({
select: { id: true, goalId: true }
}).execute();Create a goalHabit
const item = await db.goalHabit.create({
data: { goalId: 'value', habitId: 'value', entityId: 'value' },
select: { id: true }
}).execute();goalProject
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for GoalProject records
Usage
db.goalProject.findMany({ select: { id: true } }).execute()
db.goalProject.findOne({ id: '<value>', select: { id: true } }).execute()
db.goalProject.create({ data: { goalId: '<value>', projectId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.goalProject.update({ where: { id: '<value>' }, data: { goalId: '<new>' }, select: { id: true } }).execute()
db.goalProject.delete({ where: { id: '<value>' } }).execute()Examples
List all goalProject records
const items = await db.goalProject.findMany({
select: { id: true, goalId: true }
}).execute();Create a goalProject
const item = await db.goalProject.create({
data: { goalId: 'value', projectId: 'value', entityId: 'value' },
select: { id: true }
}).execute();goal
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Goal records
Usage
db.goal.findMany({ select: { id: true } }).execute()
db.goal.findOne({ id: '<value>', select: { id: true } }).execute()
db.goal.create({ data: { entityId: '<value>', title: '<value>', description: '<value>', targetDate: '<value>', status: '<value>', category: '<value>', progressPct: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.goal.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.goal.delete({ where: { id: '<value>' } }).execute()Examples
List all goal records
const items = await db.goal.findMany({
select: { id: true, entityId: true }
}).execute();Create a goal
const item = await db.goal.create({
data: { entityId: 'value', title: 'value', description: 'value', targetDate: 'value', status: 'value', category: 'value', progressPct: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();habitLog
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for HabitLog records
Usage
db.habitLog.findMany({ select: { id: true } }).execute()
db.habitLog.findOne({ id: '<value>', select: { id: true } }).execute()
db.habitLog.create({ data: { entityId: '<value>', habitId: '<value>', completedAt: '<value>', activityType: '<value>', durationMinutes: '<value>', distance: '<value>', distanceUnit: '<value>', reps: '<value>', sets: '<value>', weightAmount: '<value>', weightUnit: '<value>', calories: '<value>', data: '<value>', notes: '<value>', tags: '<value>', activityTypeTrgmSimilarity: '<value>', distanceUnitTrgmSimilarity: '<value>', weightUnitTrgmSimilarity: '<value>', notesTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.habitLog.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.habitLog.delete({ where: { id: '<value>' } }).execute()Examples
List all habitLog records
const items = await db.habitLog.findMany({
select: { id: true, entityId: true }
}).execute();Create a habitLog
const item = await db.habitLog.create({
data: { entityId: 'value', habitId: 'value', completedAt: 'value', activityType: 'value', durationMinutes: 'value', distance: 'value', distanceUnit: 'value', reps: 'value', sets: 'value', weightAmount: 'value', weightUnit: 'value', calories: 'value', data: 'value', notes: 'value', tags: 'value', activityTypeTrgmSimilarity: 'value', distanceUnitTrgmSimilarity: 'value', weightUnitTrgmSimilarity: 'value', notesTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();habit
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Habit records
Usage
db.habit.findMany({ select: { id: true } }).execute()
db.habit.findOne({ id: '<value>', select: { id: true } }).execute()
db.habit.create({ data: { entityId: '<value>', name: '<value>', frequency: '<value>', targetCount: '<value>', currentStreak: '<value>', bestStreak: '<value>', category: '<value>', tags: '<value>', nameTrgmSimilarity: '<value>', frequencyTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.habit.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.habit.delete({ where: { id: '<value>' } }).execute()Examples
List all habit records
const items = await db.habit.findMany({
select: { id: true, entityId: true }
}).execute();Create a habit
const item = await db.habit.create({
data: { entityId: 'value', name: 'value', frequency: 'value', targetCount: 'value', currentStreak: 'value', bestStreak: 'value', category: 'value', tags: 'value', nameTrgmSimilarity: 'value', frequencyTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();idea
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Idea records
Usage
db.idea.findMany({ select: { id: true } }).execute()
db.idea.findOne({ id: '<value>', select: { id: true } }).execute()
db.idea.create({ data: { entityId: '<value>', content: '<value>', source: '<value>', status: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', contentTrgmSimilarity: '<value>', sourceTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.idea.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.idea.delete({ where: { id: '<value>' } }).execute()Examples
List all idea records
const items = await db.idea.findMany({
select: { id: true, entityId: true }
}).execute();Create a idea
const item = await db.idea.create({
data: { entityId: 'value', content: 'value', source: 'value', status: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', contentTrgmSimilarity: 'value', sourceTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();image
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Image records
Usage
db.image.findMany({ select: { id: true } }).execute()
db.image.findOne({ id: '<value>', select: { id: true } }).execute()
db.image.create({ data: { entityId: '<value>', url: '<value>', meta: '<value>', altText: '<value>', caption: '<value>', embedding: '<value>', urlTrgmSimilarity: '<value>', altTextTrgmSimilarity: '<value>', captionTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.image.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.image.delete({ where: { id: '<value>' } }).execute()Examples
List all image records
const items = await db.image.findMany({
select: { id: true, entityId: true }
}).execute();Create a image
const item = await db.image.create({
data: { entityId: 'value', url: 'value', meta: 'value', altText: 'value', caption: 'value', embedding: 'value', urlTrgmSimilarity: 'value', altTextTrgmSimilarity: 'value', captionTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();integration
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Integration records
Usage
db.integration.findMany({ select: { id: true } }).execute()
db.integration.findOne({ id: '<value>', select: { id: true } }).execute()
db.integration.create({ data: { entityId: '<value>', name: '<value>', provider: '<value>', type: '<value>', credentialsRef: '<value>', config: '<value>', status: '<value>', lastSyncedAt: '<value>', nameTrgmSimilarity: '<value>', providerTrgmSimilarity: '<value>', typeTrgmSimilarity: '<value>', credentialsRefTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.integration.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.integration.delete({ where: { id: '<value>' } }).execute()Examples
List all integration records
const items = await db.integration.findMany({
select: { id: true, entityId: true }
}).execute();Create a integration
const item = await db.integration.create({
data: { entityId: 'value', name: 'value', provider: 'value', type: 'value', credentialsRef: 'value', config: 'value', status: 'value', lastSyncedAt: 'value', nameTrgmSimilarity: 'value', providerTrgmSimilarity: 'value', typeTrgmSimilarity: 'value', credentialsRefTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();interaction
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Interaction records
Usage
db.interaction.findMany({ select: { id: true } }).execute()
db.interaction.findOne({ id: '<value>', select: { id: true } }).execute()
db.interaction.create({ data: { entityId: '<value>', contactId: '<value>', type: '<value>', occurredAt: '<value>', summary: '<value>', sentiment: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', typeTrgmSimilarity: '<value>', summaryTrgmSimilarity: '<value>', sentimentTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.interaction.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.interaction.delete({ where: { id: '<value>' } }).execute()Examples
List all interaction records
const items = await db.interaction.findMany({
select: { id: true, entityId: true }
}).execute();Create a interaction
const item = await db.interaction.create({
data: { entityId: 'value', contactId: 'value', type: 'value', occurredAt: 'value', summary: 'value', sentiment: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', typeTrgmSimilarity: 'value', summaryTrgmSimilarity: 'value', sentimentTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();listItem
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ListItem records
Usage
db.listItem.findMany({ select: { id: true } }).execute()
db.listItem.findOne({ id: '<value>', select: { id: true } }).execute()
db.listItem.create({ data: { entityId: '<value>', listId: '<value>', content: '<value>', position: '<value>', isChecked: '<value>', refId: '<value>', refType: '<value>', contentTrgmSimilarity: '<value>', refTypeTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.listItem.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.listItem.delete({ where: { id: '<value>' } }).execute()Examples
List all listItem records
const items = await db.listItem.findMany({
select: { id: true, entityId: true }
}).execute();Create a listItem
const item = await db.listItem.create({
data: { entityId: 'value', listId: 'value', content: 'value', position: 'value', isChecked: 'value', refId: 'value', refType: 'value', contentTrgmSimilarity: 'value', refTypeTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();list
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for List records
Usage
db.list.findMany({ select: { id: true } }).execute()
db.list.findOne({ id: '<value>', select: { id: true } }).execute()
db.list.create({ data: { entityId: '<value>', name: '<value>', description: '<value>', type: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', typeTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.list.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.list.delete({ where: { id: '<value>' } }).execute()Examples
List all list records
const items = await db.list.findMany({
select: { id: true, entityId: true }
}).execute();Create a list
const item = await db.list.create({
data: { entityId: 'value', name: 'value', description: 'value', type: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', typeTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();memory
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Memory records
Usage
db.memory.findMany({ select: { id: true } }).execute()
db.memory.findOne({ id: '<value>', select: { id: true } }).execute()
db.memory.create({ data: { entityId: '<value>', content: '<value>', memoryType: '<value>', memoryCategory: '<value>', agentId: '<value>', importance: '<value>', verified: '<value>', source: '<value>', relatedEntityType: '<value>', relatedEntityId: '<value>', abstract: '<value>', overview: '<value>', activeCount: '<value>', lastAccessedAt: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', contentTrgmSimilarity: '<value>', memoryTypeTrgmSimilarity: '<value>', memoryCategoryTrgmSimilarity: '<value>', sourceTrgmSimilarity: '<value>', relatedEntityTypeTrgmSimilarity: '<value>', abstractTrgmSimilarity: '<value>', overviewTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.memory.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.memory.delete({ where: { id: '<value>' } }).execute()Examples
List all memory records
const items = await db.memory.findMany({
select: { id: true, entityId: true }
}).execute();Create a memory
const item = await db.memory.create({
data: { entityId: 'value', content: 'value', memoryType: 'value', memoryCategory: 'value', agentId: 'value', importance: 'value', verified: 'value', source: 'value', relatedEntityType: 'value', relatedEntityId: 'value', abstract: 'value', overview: 'value', activeCount: 'value', lastAccessedAt: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', contentTrgmSimilarity: 'value', memoryTypeTrgmSimilarity: 'value', memoryCategoryTrgmSimilarity: 'value', sourceTrgmSimilarity: 'value', relatedEntityTypeTrgmSimilarity: 'value', abstractTrgmSimilarity: 'value', overviewTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();message
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Message records
Usage
db.message.findMany({ select: { id: true } }).execute()
db.message.findOne({ id: '<value>', select: { id: true } }).execute()
db.message.create({ data: { entityId: '<value>', emailAccountId: '<value>', threadId: '<value>', remoteId: '<value>', fromAddress: '<value>', toAddresses: '<value>', subject: '<value>', bodyText: '<value>', receivedAt: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', bodyTextBm25Score: '<value>', embeddingTextBm25Score: '<value>', threadIdTrgmSimilarity: '<value>', remoteIdTrgmSimilarity: '<value>', fromAddressTrgmSimilarity: '<value>', subjectTrgmSimilarity: '<value>', bodyTextTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.message.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.message.delete({ where: { id: '<value>' } }).execute()Examples
List all message records
const items = await db.message.findMany({
select: { id: true, entityId: true }
}).execute();Create a message
const item = await db.message.create({
data: { entityId: 'value', emailAccountId: 'value', threadId: 'value', remoteId: 'value', fromAddress: 'value', toAddresses: 'value', subject: 'value', bodyText: 'value', receivedAt: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', bodyTextBm25Score: 'value', embeddingTextBm25Score: 'value', threadIdTrgmSimilarity: 'value', remoteIdTrgmSimilarity: 'value', fromAddressTrgmSimilarity: 'value', subjectTrgmSimilarity: 'value', bodyTextTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();milestone
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Milestone records
Usage
db.milestone.findMany({ select: { id: true } }).execute()
db.milestone.findOne({ id: '<value>', select: { id: true } }).execute()
db.milestone.create({ data: { entityId: '<value>', projectId: '<value>', name: '<value>', dueDate: '<value>', status: '<value>', nameTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.milestone.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.milestone.delete({ where: { id: '<value>' } }).execute()Examples
List all milestone records
const items = await db.milestone.findMany({
select: { id: true, entityId: true }
}).execute();Create a milestone
const item = await db.milestone.create({
data: { entityId: 'value', projectId: 'value', name: 'value', dueDate: 'value', status: 'value', nameTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();note
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Note records
Usage
db.note.findMany({ select: { id: true } }).execute()
db.note.findOne({ id: '<value>', select: { id: true } }).execute()
db.note.create({ data: { entityId: '<value>', content: '<value>', notableType: '<value>', notableId: '<value>', abstract: '<value>', overview: '<value>', activeCount: '<value>', lastAccessedAt: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', contentBm25Score: '<value>', embeddingTextBm25Score: '<value>', contentTrgmSimilarity: '<value>', notableTypeTrgmSimilarity: '<value>', abstractTrgmSimilarity: '<value>', overviewTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.note.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.note.delete({ where: { id: '<value>' } }).execute()Examples
List all note records
const items = await db.note.findMany({
select: { id: true, entityId: true }
}).execute();Create a note
const item = await db.note.create({
data: { entityId: 'value', content: 'value', notableType: 'value', notableId: 'value', abstract: 'value', overview: 'value', activeCount: 'value', lastAccessedAt: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', contentBm25Score: 'value', embeddingTextBm25Score: 'value', contentTrgmSimilarity: 'value', notableTypeTrgmSimilarity: 'value', abstractTrgmSimilarity: 'value', overviewTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();notification
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Notification records
Usage
db.notification.findMany({ select: { id: true } }).execute()
db.notification.findOne({ id: '<value>', select: { id: true } }).execute()
db.notification.create({ data: { entityId: '<value>', title: '<value>', body: '<value>', type: '<value>', priority: '<value>', readAt: '<value>', actionUrl: '<value>', sourceEntityId: '<value>', sourceEntityType: '<value>', titleTrgmSimilarity: '<value>', bodyTrgmSimilarity: '<value>', typeTrgmSimilarity: '<value>', priorityTrgmSimilarity: '<value>', actionUrlTrgmSimilarity: '<value>', sourceEntityTypeTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.notification.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.notification.delete({ where: { id: '<value>' } }).execute()Examples
List all notification records
const items = await db.notification.findMany({
select: { id: true, entityId: true }
}).execute();Create a notification
const item = await db.notification.create({
data: { entityId: 'value', title: 'value', body: 'value', type: 'value', priority: 'value', readAt: 'value', actionUrl: 'value', sourceEntityId: 'value', sourceEntityType: 'value', titleTrgmSimilarity: 'value', bodyTrgmSimilarity: 'value', typeTrgmSimilarity: 'value', priorityTrgmSimilarity: 'value', actionUrlTrgmSimilarity: 'value', sourceEntityTypeTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();process
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Process records
Usage
db.process.findMany({ select: { id: true } }).execute()
db.process.findOne({ id: '<value>', select: { id: true } }).execute()
db.process.create({ data: { entityId: '<value>', pid: '<value>', agentId: '<value>', command: '<value>', startedAt: '<value>', endedAt: '<value>', status: '<value>', exitCode: '<value>', logsPath: '<value>', commandTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', logsPathTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.process.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.process.delete({ where: { id: '<value>' } }).execute()Examples
List all process records
const items = await db.process.findMany({
select: { id: true, entityId: true }
}).execute();Create a process
const item = await db.process.create({
data: { entityId: 'value', pid: 'value', agentId: 'value', command: 'value', startedAt: 'value', endedAt: 'value', status: 'value', exitCode: 'value', logsPath: 'value', commandTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', logsPathTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();projectContact
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ProjectContact records
Usage
db.projectContact.findMany({ select: { id: true } }).execute()
db.projectContact.findOne({ id: '<value>', select: { id: true } }).execute()
db.projectContact.create({ data: { projectId: '<value>', contactId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.projectContact.update({ where: { id: '<value>' }, data: { projectId: '<new>' }, select: { id: true } }).execute()
db.projectContact.delete({ where: { id: '<value>' } }).execute()Examples
List all projectContact records
const items = await db.projectContact.findMany({
select: { id: true, projectId: true }
}).execute();Create a projectContact
const item = await db.projectContact.create({
data: { projectId: 'value', contactId: 'value', entityId: 'value' },
select: { id: true }
}).execute();project
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Project records
Usage
db.project.findMany({ select: { id: true } }).execute()
db.project.findOne({ id: '<value>', select: { id: true } }).execute()
db.project.create({ data: { entityId: '<value>', name: '<value>', description: '<value>', status: '<value>', startDate: '<value>', dueDate: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', searchTsv: '<value>', searchTsvRank: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.project.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.project.delete({ where: { id: '<value>' } }).execute()Examples
List all project records
const items = await db.project.findMany({
select: { id: true, entityId: true }
}).execute();Create a project
const item = await db.project.create({
data: { entityId: 'value', name: 'value', description: 'value', status: 'value', startDate: 'value', dueDate: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', searchTsv: 'value', searchTsvRank: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();prompt
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Prompt records
Usage
db.prompt.findMany({ select: { id: true } }).execute()
db.prompt.findOne({ id: '<value>', select: { id: true } }).execute()
db.prompt.create({ data: { entityId: '<value>', name: '<value>', content: '<value>', type: '<value>', model: '<value>', version: '<value>', isActive: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', contentBm25Score: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', contentTrgmSimilarity: '<value>', typeTrgmSimilarity: '<value>', modelTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.prompt.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.prompt.delete({ where: { id: '<value>' } }).execute()Examples
List all prompt records
const items = await db.prompt.findMany({
select: { id: true, entityId: true }
}).execute();Create a prompt
const item = await db.prompt.create({
data: { entityId: 'value', name: 'value', content: 'value', type: 'value', model: 'value', version: 'value', isActive: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', contentBm25Score: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', contentTrgmSimilarity: 'value', typeTrgmSimilarity: 'value', modelTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();recipe
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Recipe records
Usage
db.recipe.findMany({ select: { id: true } }).execute()
db.recipe.findOne({ id: '<value>', select: { id: true } }).execute()
db.recipe.create({ data: { entityId: '<value>', name: '<value>', description: '<value>', cuisine: '<value>', prepTimeMinutes: '<value>', cookTimeMinutes: '<value>', servings: '<value>', difficulty: '<value>', ingredients: '<value>', instructions: '<value>', sourceUrl: '<value>', imageUrl: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', cuisineTrgmSimilarity: '<value>', difficultyTrgmSimilarity: '<value>', sourceUrlTrgmSimilarity: '<value>', imageUrlTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.recipe.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.recipe.delete({ where: { id: '<value>' } }).execute()Examples
List all recipe records
const items = await db.recipe.findMany({
select: { id: true, entityId: true }
}).execute();Create a recipe
const item = await db.recipe.create({
data: { entityId: 'value', name: 'value', description: 'value', cuisine: 'value', prepTimeMinutes: 'value', cookTimeMinutes: 'value', servings: 'value', difficulty: 'value', ingredients: 'value', instructions: 'value', sourceUrl: 'value', imageUrl: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', cuisineTrgmSimilarity: 'value', difficultyTrgmSimilarity: 'value', sourceUrlTrgmSimilarity: 'value', imageUrlTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();reminder
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Reminder records
Usage
db.reminder.findMany({ select: { id: true } }).execute()
db.reminder.findOne({ id: '<value>', select: { id: true } }).execute()
db.reminder.create({ data: { entityId: '<value>', title: '<value>', dueAt: '<value>', completedAt: '<value>', recurrence: '<value>', status: '<value>', relatedEntityId: '<value>', relatedEntityType: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', recurrenceTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', relatedEntityTypeTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.reminder.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.reminder.delete({ where: { id: '<value>' } }).execute()Examples
List all reminder records
const items = await db.reminder.findMany({
select: { id: true, entityId: true }
}).execute();Create a reminder
const item = await db.reminder.create({
data: { entityId: 'value', title: 'value', dueAt: 'value', completedAt: 'value', recurrence: 'value', status: 'value', relatedEntityId: 'value', relatedEntityType: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', recurrenceTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', relatedEntityTypeTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();repository
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Repository records
Usage
db.repository.findMany({ select: { id: true } }).execute()
db.repository.findOne({ id: '<value>', select: { id: true } }).execute()
db.repository.create({ data: { entityId: '<value>', name: '<value>', url: '<value>', description: '<value>', defaultBranch: '<value>', lastSyncedAt: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', urlTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', defaultBranchTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.repository.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.repository.delete({ where: { id: '<value>' } }).execute()Examples
List all repository records
const items = await db.repository.findMany({
select: { id: true, entityId: true }
}).execute();Create a repository
const item = await db.repository.create({
data: { entityId: 'value', name: 'value', url: 'value', description: 'value', defaultBranch: 'value', lastSyncedAt: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', urlTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', defaultBranchTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();rule
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Rule records
Usage
db.rule.findMany({ select: { id: true } }).execute()
db.rule.findOne({ id: '<value>', select: { id: true } }).execute()
db.rule.create({ data: { entityId: '<value>', title: '<value>', content: '<value>', kind: '<value>', severity: '<value>', isActive: '<value>', slug: '<value>', verification: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', triggerConcept: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', contentTrgmSimilarity: '<value>', kindTrgmSimilarity: '<value>', severityTrgmSimilarity: '<value>', slugTrgmSimilarity: '<value>', verificationTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', triggerConceptVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.rule.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.rule.delete({ where: { id: '<value>' } }).execute()Examples
List all rule records
const items = await db.rule.findMany({
select: { id: true, entityId: true }
}).execute();Create a rule
const item = await db.rule.create({
data: { entityId: 'value', title: 'value', content: 'value', kind: 'value', severity: 'value', isActive: 'value', slug: 'value', verification: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', triggerConcept: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', contentTrgmSimilarity: 'value', kindTrgmSimilarity: 'value', severityTrgmSimilarity: 'value', slugTrgmSimilarity: 'value', verificationTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', triggerConceptVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();scheduledJob
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for ScheduledJob records
Usage
db.scheduledJob.findMany({ select: { id: true } }).execute()
db.scheduledJob.findOne({ id: '<value>', select: { id: true } }).execute()
db.scheduledJob.create({ data: { entityId: '<value>', name: '<value>', scheduleType: '<value>', scheduleExpr: '<value>', runAt: '<value>', command: '<value>', message: '<value>', agentId: '<value>', sessionId: '<value>', isActive: '<value>', deleteAfterRun: '<value>', lastRunAt: '<value>', nextRunAt: '<value>', runCount: '<value>', lastResult: '<value>', nameTrgmSimilarity: '<value>', scheduleTypeTrgmSimilarity: '<value>', scheduleExprTrgmSimilarity: '<value>', commandTrgmSimilarity: '<value>', messageTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.scheduledJob.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.scheduledJob.delete({ where: { id: '<value>' } }).execute()Examples
List all scheduledJob records
const items = await db.scheduledJob.findMany({
select: { id: true, entityId: true }
}).execute();Create a scheduledJob
const item = await db.scheduledJob.create({
data: { entityId: 'value', name: 'value', scheduleType: 'value', scheduleExpr: 'value', runAt: 'value', command: 'value', message: 'value', agentId: 'value', sessionId: 'value', isActive: 'value', deleteAfterRun: 'value', lastRunAt: 'value', nextRunAt: 'value', runCount: 'value', lastResult: 'value', nameTrgmSimilarity: 'value', scheduleTypeTrgmSimilarity: 'value', scheduleExprTrgmSimilarity: 'value', commandTrgmSimilarity: 'value', messageTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();sessionArchive
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for SessionArchive records
Usage
db.sessionArchive.findMany({ select: { id: true } }).execute()
db.sessionArchive.findOne({ id: '<value>', select: { id: true } }).execute()
db.sessionArchive.create({ data: { entityId: '<value>', sessionId: '<value>', archiveIndex: '<value>', summary: '<value>', messageRangeStart: '<value>', messageRangeEnd: '<value>', rawMessages: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', summaryTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.sessionArchive.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.sessionArchive.delete({ where: { id: '<value>' } }).execute()Examples
List all sessionArchive records
const items = await db.sessionArchive.findMany({
select: { id: true, entityId: true }
}).execute();Create a sessionArchive
const item = await db.sessionArchive.create({
data: { entityId: 'value', sessionId: 'value', archiveIndex: 'value', summary: 'value', messageRangeStart: 'value', messageRangeEnd: 'value', rawMessages: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', summaryTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();session
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Session records
Usage
db.session.findMany({ select: { id: true } }).execute()
db.session.findOne({ id: '<value>', select: { id: true } }).execute()
db.session.create({ data: { entityId: '<value>', title: '<value>', agentId: '<value>', startedAt: '<value>', endedAt: '<value>', status: '<value>', contextSummary: '<value>', sessionSummary: '<value>', archivedMessages: '<value>', compressionCount: '<value>', archivedAt: '<value>', extractedMemoryIds: '<value>', contextsUsed: '<value>', skillsUsed: '<value>', embeddingText: '<value>', embedding: '<value>', uagentTrgmSimilarity: '<value>', fingerprintModeTrgmSimilarity: '<value>', csrfSecretTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.session.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.session.delete({ where: { id: '<value>' } }).execute()Examples
List all session records
const items = await db.session.findMany({
select: { id: true, entityId: true }
}).execute();Create a session
const item = await db.session.create({
data: { entityId: 'value', title: 'value', agentId: 'value', startedAt: 'value', endedAt: 'value', status: 'value', contextSummary: 'value', sessionSummary: 'value', archivedMessages: 'value', compressionCount: 'value', archivedAt: 'value', extractedMemoryIds: 'value', contextsUsed: 'value', skillsUsed: 'value', embeddingText: 'value', embedding: 'value', uagentTrgmSimilarity: 'value', fingerprintModeTrgmSimilarity: 'value', csrfSecretTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();skillExecution
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for SkillExecution records
Usage
db.skillExecution.findMany({ select: { id: true } }).execute()
db.skillExecution.findOne({ id: '<value>', select: { id: true } }).execute()
db.skillExecution.create({ data: { entityId: '<value>', skillId: '<value>', agentId: '<value>', sessionId: '<value>', status: '<value>', startedAt: '<value>', completedAt: '<value>', durationMs: '<value>', input: '<value>', output: '<value>', error: '<value>', statusTrgmSimilarity: '<value>', errorTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.skillExecution.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.skillExecution.delete({ where: { id: '<value>' } }).execute()Examples
List all skillExecution records
const items = await db.skillExecution.findMany({
select: { id: true, entityId: true }
}).execute();Create a skillExecution
const item = await db.skillExecution.create({
data: { entityId: 'value', skillId: 'value', agentId: 'value', sessionId: 'value', status: 'value', startedAt: 'value', completedAt: 'value', durationMs: 'value', input: 'value', output: 'value', error: 'value', statusTrgmSimilarity: 'value', errorTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();tag
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Tag records
Usage
db.tag.findMany({ select: { id: true } }).execute()
db.tag.findOne({ id: '<value>', select: { id: true } }).execute()
db.tag.create({ data: { entityId: '<value>', name: '<value>', color: '<value>', category: '<value>', usageCount: '<value>', nameTrgmSimilarity: '<value>', colorTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.tag.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.tag.delete({ where: { id: '<value>' } }).execute()Examples
List all tag records
const items = await db.tag.findMany({
select: { id: true, entityId: true }
}).execute();Create a tag
const item = await db.tag.create({
data: { entityId: 'value', name: 'value', color: 'value', category: 'value', usageCount: 'value', nameTrgmSimilarity: 'value', colorTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();taskContact
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for TaskContact records
Usage
db.taskContact.findMany({ select: { id: true } }).execute()
db.taskContact.findOne({ id: '<value>', select: { id: true } }).execute()
db.taskContact.create({ data: { taskId: '<value>', contactId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.taskContact.update({ where: { id: '<value>' }, data: { taskId: '<new>' }, select: { id: true } }).execute()
db.taskContact.delete({ where: { id: '<value>' } }).execute()Examples
List all taskContact records
const items = await db.taskContact.findMany({
select: { id: true, taskId: true }
}).execute();Create a taskContact
const item = await db.taskContact.create({
data: { taskId: 'value', contactId: 'value', entityId: 'value' },
select: { id: true }
}).execute();task
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Task records
Usage
db.task.findMany({ select: { id: true } }).execute()
db.task.findOne({ id: '<value>', select: { id: true } }).execute()
db.task.create({ data: { entityId: '<value>', title: '<value>', description: '<value>', status: '<value>', priority: '<value>', projectId: '<value>', taskType: '<value>', assignedAgentId: '<value>', parentTaskId: '<value>', dueDate: '<value>', completedAt: '<value>', conversationId: '<value>', dependencies: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', taskTypeTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.task.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.task.delete({ where: { id: '<value>' } }).execute()Examples
List all task records
const items = await db.task.findMany({
select: { id: true, entityId: true }
}).execute();Create a task
const item = await db.task.create({
data: { entityId: 'value', title: 'value', description: 'value', status: 'value', priority: 'value', projectId: 'value', taskType: 'value', assignedAgentId: 'value', parentTaskId: 'value', dueDate: 'value', completedAt: 'value', conversationId: 'value', dependencies: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', taskTypeTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();template
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Template records
Usage
db.template.findMany({ select: { id: true } }).execute()
db.template.findOne({ id: '<value>', select: { id: true } }).execute()
db.template.create({ data: { entityId: '<value>', name: '<value>', description: '<value>', type: '<value>', content: '<value>', variables: '<value>', isActive: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', typeTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.template.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.template.delete({ where: { id: '<value>' } }).execute()Examples
List all template records
const items = await db.template.findMany({
select: { id: true, entityId: true }
}).execute();Create a template
const item = await db.template.create({
data: { entityId: 'value', name: 'value', description: 'value', type: 'value', content: 'value', variables: 'value', isActive: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', typeTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();thread
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Thread records
Usage
db.thread.findMany({ select: { id: true } }).execute()
db.thread.findOne({ id: '<value>', select: { id: true } }).execute()
db.thread.create({ data: { entityId: '<value>', title: '<value>', summary: '<value>', status: '<value>', parentThreadId: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', titleTrgmSimilarity: '<value>', summaryTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.thread.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.thread.delete({ where: { id: '<value>' } }).execute()Examples
List all thread records
const items = await db.thread.findMany({
select: { id: true, entityId: true }
}).execute();Create a thread
const item = await db.thread.create({
data: { entityId: 'value', title: 'value', summary: 'value', status: 'value', parentThreadId: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', titleTrgmSimilarity: 'value', summaryTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();tool
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Tool records
Usage
db.tool.findMany({ select: { id: true } }).execute()
db.tool.findOne({ id: '<value>', select: { id: true } }).execute()
db.tool.create({ data: { entityId: '<value>', name: '<value>', description: '<value>', type: '<value>', inputSchema: '<value>', outputSchema: '<value>', endpoint: '<value>', authMethod: '<value>', isActive: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', typeTrgmSimilarity: '<value>', endpointTrgmSimilarity: '<value>', authMethodTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.tool.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.tool.delete({ where: { id: '<value>' } }).execute()Examples
List all tool records
const items = await db.tool.findMany({
select: { id: true, entityId: true }
}).execute();Create a tool
const item = await db.tool.create({
data: { entityId: 'value', name: 'value', description: 'value', type: 'value', inputSchema: 'value', outputSchema: 'value', endpoint: 'value', authMethod: 'value', isActive: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', typeTrgmSimilarity: 'value', endpointTrgmSimilarity: 'value', authMethodTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();trip
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Trip records
Usage
db.trip.findMany({ select: { id: true } }).execute()
db.trip.findOne({ id: '<value>', select: { id: true } }).execute()
db.trip.create({ data: { entityId: '<value>', name: '<value>', destination: '<value>', startDate: '<value>', endDate: '<value>', status: '<value>', notes: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', destinationTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', notesTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.trip.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.trip.delete({ where: { id: '<value>' } }).execute()Examples
List all trip records
const items = await db.trip.findMany({
select: { id: true, entityId: true }
}).execute();Create a trip
const item = await db.trip.create({
data: { entityId: 'value', name: 'value', destination: 'value', startDate: 'value', endDate: 'value', status: 'value', notes: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', destinationTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', notesTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();userSetting
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for UserSetting records
Usage
db.userSetting.findMany({ select: { id: true } }).execute()
db.userSetting.findOne({ id: '<value>', select: { id: true } }).execute()
db.userSetting.create({ data: { entityId: '<value>', key: '<value>', value: '<value>', category: '<value>', keyTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.userSetting.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.userSetting.delete({ where: { id: '<value>' } }).execute()Examples
List all userSetting records
const items = await db.userSetting.findMany({
select: { id: true, entityId: true }
}).execute();Create a userSetting
const item = await db.userSetting.create({
data: { entityId: 'value', key: 'value', value: 'value', category: 'value', keyTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();venueImage
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for VenueImage records
Usage
db.venueImage.findMany({ select: { id: true } }).execute()
db.venueImage.findOne({ id: '<value>', select: { id: true } }).execute()
db.venueImage.create({ data: { venueId: '<value>', imageId: '<value>', entityId: '<value>' }, select: { id: true } }).execute()
db.venueImage.update({ where: { id: '<value>' }, data: { venueId: '<new>' }, select: { id: true } }).execute()
db.venueImage.delete({ where: { id: '<value>' } }).execute()Examples
List all venueImage records
const items = await db.venueImage.findMany({
select: { id: true, venueId: true }
}).execute();Create a venueImage
const item = await db.venueImage.create({
data: { venueId: 'value', imageId: 'value', entityId: 'value' },
select: { id: true }
}).execute();venueLink
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for VenueLink records
Usage
db.venueLink.findMany({ select: { id: true } }).execute()
db.venueLink.findOne({ id: '<value>', select: { id: true } }).execute()
db.venueLink.create({ data: { entityId: '<value>', title: '<value>', url: '<value>', embedding: '<value>', venueId: '<value>', titleTrgmSimilarity: '<value>', urlTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.venueLink.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.venueLink.delete({ where: { id: '<value>' } }).execute()Examples
List all venueLink records
const items = await db.venueLink.findMany({
select: { id: true, entityId: true }
}).execute();Create a venueLink
const item = await db.venueLink.create({
data: { entityId: 'value', title: 'value', url: 'value', embedding: 'value', venueId: 'value', titleTrgmSimilarity: 'value', urlTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();venue
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Venue records
Usage
db.venue.findMany({ select: { id: true } }).execute()
db.venue.findOne({ id: '<value>', select: { id: true } }).execute()
db.venue.create({ data: { entityId: '<value>', name: '<value>', address: '<value>', neighborhood: '<value>', city: '<value>', category: '<value>', status: '<value>', googlePlaceId: '<value>', rating: '<value>', priceLevel: '<value>', isFavorite: '<value>', notes: '<value>', tags: '<value>', embeddingText: '<value>', embedding: '<value>', searchTsv: '<value>', mainImageId: '<value>', searchTsvRank: '<value>', embeddingTextBm25Score: '<value>', nameTrgmSimilarity: '<value>', addressTrgmSimilarity: '<value>', neighborhoodTrgmSimilarity: '<value>', cityTrgmSimilarity: '<value>', categoryTrgmSimilarity: '<value>', statusTrgmSimilarity: '<value>', googlePlaceIdTrgmSimilarity: '<value>', priceLevelTrgmSimilarity: '<value>', notesTrgmSimilarity: '<value>', embeddingTextTrgmSimilarity: '<value>', embeddingVectorDistance: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.venue.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.venue.delete({ where: { id: '<value>' } }).execute()Examples
List all venue records
const items = await db.venue.findMany({
select: { id: true, entityId: true }
}).execute();Create a venue
const item = await db.venue.create({
data: { entityId: 'value', name: 'value', address: 'value', neighborhood: 'value', city: 'value', category: 'value', status: 'value', googlePlaceId: 'value', rating: 'value', priceLevel: 'value', isFavorite: 'value', notes: 'value', tags: 'value', embeddingText: 'value', embedding: 'value', searchTsv: 'value', mainImageId: 'value', searchTsvRank: 'value', embeddingTextBm25Score: 'value', nameTrgmSimilarity: 'value', addressTrgmSimilarity: 'value', neighborhoodTrgmSimilarity: 'value', cityTrgmSimilarity: 'value', categoryTrgmSimilarity: 'value', statusTrgmSimilarity: 'value', googlePlaceIdTrgmSimilarity: 'value', priceLevelTrgmSimilarity: 'value', notesTrgmSimilarity: 'value', embeddingTextTrgmSimilarity: 'value', embeddingVectorDistance: 'value', searchScore: 'value' },
select: { id: true }
}).execute();webhook
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Webhook records
Usage
db.webhook.findMany({ select: { id: true } }).execute()
db.webhook.findOne({ id: '<value>', select: { id: true } }).execute()
db.webhook.create({ data: { entityId: '<value>', integrationId: '<value>', url: '<value>', eventType: '<value>', secret: '<value>', isActive: '<value>', urlTrgmSimilarity: '<value>', eventTypeTrgmSimilarity: '<value>', secretTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.webhook.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.webhook.delete({ where: { id: '<value>' } }).execute()Examples
List all webhook records
const items = await db.webhook.findMany({
select: { id: true, entityId: true }
}).execute();Create a webhook
const item = await db.webhook.create({
data: { entityId: 'value', integrationId: 'value', url: 'value', eventType: 'value', secret: 'value', isActive: 'value', urlTrgmSimilarity: 'value', eventTypeTrgmSimilarity: 'value', secretTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();workflowRun
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for WorkflowRun records
Usage
db.workflowRun.findMany({ select: { id: true } }).execute()
db.workflowRun.findOne({ id: '<value>', select: { id: true } }).execute()
db.workflowRun.create({ data: { entityId: '<value>', workflowId: '<value>', status: '<value>', startedAt: '<value>', completedAt: '<value>', input: '<value>', output: '<value>', error: '<value>', statusTrgmSimilarity: '<value>', errorTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.workflowRun.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.workflowRun.delete({ where: { id: '<value>' } }).execute()Examples
List all workflowRun records
const items = await db.workflowRun.findMany({
select: { id: true, entityId: true }
}).execute();Create a workflowRun
const item = await db.workflowRun.create({
data: { entityId: 'value', workflowId: 'value', status: 'value', startedAt: 'value', completedAt: 'value', input: 'value', output: 'value', error: 'value', statusTrgmSimilarity: 'value', errorTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();workflowStep
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for WorkflowStep records
Usage
db.workflowStep.findMany({ select: { id: true } }).execute()
db.workflowStep.findOne({ id: '<value>', select: { id: true } }).execute()
db.workflowStep.create({ data: { entityId: '<value>', workflowId: '<value>', stepOrder: '<value>', actionType: '<value>', actionConfig: '<value>', onSuccessStep: '<value>', onFailureStep: '<value>', timeoutMs: '<value>', actionTypeTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.workflowStep.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.workflowStep.delete({ where: { id: '<value>' } }).execute()Examples
List all workflowStep records
const items = await db.workflowStep.findMany({
select: { id: true, entityId: true }
}).execute();Create a workflowStep
const item = await db.workflowStep.create({
data: { entityId: 'value', workflowId: 'value', stepOrder: 'value', actionType: 'value', actionConfig: 'value', onSuccessStep: 'value', onFailureStep: 'value', timeoutMs: 'value', actionTypeTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();workflow
<!-- @constructive-io/graphql-codegen - DO NOT EDIT -->
ORM operations for Workflow records
Usage
db.workflow.findMany({ select: { id: true } }).execute()
db.workflow.findOne({ id: '<value>', select: { id: true } }).execute()
db.workflow.create({ data: { entityId: '<value>', name: '<value>', description: '<value>', triggerType: '<value>', triggerConfig: '<value>', isActive: '<value>', tags: '<value>', nameTrgmSimilarity: '<value>', descriptionTrgmSimilarity: '<value>', triggerTypeTrgmSimilarity: '<value>', searchScore: '<value>' }, select: { id: true } }).execute()
db.workflow.update({ where: { id: '<value>' }, data: { entityId: '<new>' }, select: { id: true } }).execute()
db.workflow.delete({ where: { id: '<value>' } }).execute()Examples
List all workflow records
const items = await db.workflow.findMany({
select: { id: true, entityId: true }
}).execute();Create a workflow
const item = await db.workflow.create({
data: { entityId: 'value', name: 'value', description: 'value', triggerType: 'value', triggerConfig: 'value', isActive: 'value', tags: 'value', nameTrgmSimilarity: 'value', descriptionTrgmSimilarity: 'value', triggerTypeTrgmSimilarity: 'value', searchScore: 'value' },
select: { id: true }
}).execute();Related skills
Lark BaseLet their coding agents read from, write to, and query structured data stored in Lark Base (Feishu) spreadsheets and databases.493k
Azure KustoRun fast KQL queries against Azure Data Explorer for log analytics, telemetry, and time-series data.484k1.3k
Lark SheetsCreate, read, update, and export spreadsheets inside Lark (Feishu) directly from their AI coding agent.389k15.9k
Supabase Postgres Best PracticesAutomatically apply Supabase Postgres performance rules during query writing, schema design, and database optimization.313k2.4k
Firebase Data ConnectGenerate complete, production-ready Firebase Data Connect GraphQL schemas and queries for complex relational data models.112k392Firebase FirestoreAdd Cloud Firestore read/write capabilities to an Android Kotlin app using the official Firebase SDK.77k392Databasesdatabases