Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

8.6 KB
Raw Blame
INSERT INTO public."macro_user" ("id", "username", "email", "stripe_customer_id")
VALUES ('a1111111-1111-1111-1111-111111111111', 'user', '[email protected]', 'stripe_id');

INSERT INTO
  public."User" ("id", "email", "stripeCustomerId", "macro_user_id") (
    SELECT
      'macro|[email protected]',
      '[email protected]',
      'stripe_id',
      'a1111111-1111-1111-1111-111111111111'
  );

INSERT INTO
  public."Project" ("id", "name", "userId") (
    SELECT
      'project-one',
      'test_project_name',
      'macro|[email protected]'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt",
    "projectId"
  ) (
    SELECT
      'document-one',
      'test_document_name',
      'txt',
      'macro|[email protected]',
      '2019-10-16 00:00:00',
      '2019-10-16 00:00:00',
      'project-one'
  );

INSERT INTO
  public."DocumentInstance" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt",
    "sha"
  ) (
    SELECT
      'test_document_name',
      'document-one',
      '2019-10-16 00:00:00',
      '2019-10-16 00:00:00',
      'sha'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'document-two',
      'test_document_name',
      'pdf',
      'macro|[email protected]',
      '2019-10-16 00:10:00',
      '2019-10-16 00:10:00'
  );

INSERT INTO
  public."DocumentInstance" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt",
    "sha"
  ) (
    SELECT
      'test_document_name',
      'document-two',
      '2019-10-16 00:10:00',
      '2019-10-16 00:10:00',
      'sha'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'document-three',
      'test_document_name',
      'pdf',
      'macro|[email protected]',
      '2019-10-16 00:20:00',
      '2019-10-16 00:20:00'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt",
    "deletedAt"
  ) (
    SELECT
      'document-deleted',
      'test_document_name',
      'pdf',
      'macro|[email protected]',
      '2019-10-16 00:20:00',
      '2024-08-08 11:10:00',
      '2024-08-08 11:11:00'
  );

INSERT INTO
  public."DocumentInstance" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt",
    "sha"
  ) (
    SELECT
      'test_document_name',
      'document-three',
      '2019-10-16 00:30:00',
      '2019-10-16 00:30:00',
      'sha'
  );

INSERT INTO
  public."Chat" ("id", "name", "userId", "createdAt", "updatedAt") (
    SELECT
      'chat-one',
      'test-chat',
      'macro|[email protected]',
      '2019-10-16 00:21:00',
      '2019-10-16 00:21:00'
  );

INSERT INTO
  public."ChatMessage" ("chatId", "content", "role") (
    SELECT
      'chat-one',
      '"content1"',
      'user'
  );

INSERT INTO
  public."ChatMessage" ("chatId", "content", "role") (
    SELECT
      'chat-one',
      '"content2"',
      'system'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'document-four',
      'test_document_name',
      'pdf',
      'macro|[email protected]',
      '2019-10-16 00:40:00',
      '2019-10-16 00:40:00'
  );

INSERT INTO
  public."DocumentInstance" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt",
    "sha"
  ) (
    SELECT
      'test_document_name',
      'document-four',
      '2019-10-16 00:40:00',
      '2019-10-16 00:40:00',
      'sha'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'document-five',
      'test_document_name',
      'pdf',
      'macro|[email protected]',
      '2019-10-16 00:50:00',
      '2019-10-16 00:50:00'
  );

INSERT INTO
  public."DocumentInstance" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt",
    "sha"
  ) (
    SELECT
      'test_document_name',
      'document-five',
      '2019-10-16 00:50:00',
      '2019-10-16 00:50:00',
      'sha'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'document-six',
      'test_document_name',
      'pdf',
      'macro|[email protected]',
      '2019-10-16 01:00:00',
      '2019-10-16 01:00:00'
  );

INSERT INTO
  public."DocumentInstance" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt",
    "sha"
  ) (
    SELECT
      'test_document_name',
      'document-six',
      '2019-10-16 01:00:00',
      '2019-10-16 01:00:00',
      'sha'
  );

INSERT INTO
  public."Document" (
    "id",
    "name",
    "fileType",
    "owner",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'document-seven',
      'document-seven',
      'docx',
      'macro|[email protected]',
      '2019-10-16 01:01:00',
      '2019-10-16 01:01:00'
  );

INSERT INTO
  public."DocumentBom" (
    "revisionName",
    "documentId",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'test_document_name',
      'document-seven',
      '2019-10-16 01:01:00',
      '2019-10-16 01:01:00'
  );

INSERT INTO
  public."BomPart" ("id", "sha", "path", "documentBomId") (
    SELECT
      'b1',
      'sha-1',
      'path',
      1
  );

INSERT INTO
  public."BomPart" ("id", "sha", "path", "documentBomId") (
    SELECT
      'b2',
      'sha-2',
      'path',
      1
  );

INSERT INTO
  public."BomPart" ("id", "sha", "path", "documentBomId") (
    SELECT
      'b3',
      'sha-3',
      'path',
      1
  );

INSERT INTO
  public."Chat" ("id", "name", "userId", "createdAt", "updatedAt") (
    SELECT
      'chat-two',
      'test-chat',
      'macro|[email protected]',
      '2019-10-16 01:02:00',
      '2019-10-16 01:02:00'
  );

INSERT INTO
  public."ChatMessage" ("chatId", "content", "role") (
    SELECT
      'chat-two',
      '"content1"',
      'user'
  );

INSERT INTO
  public."ChatMessage" ("chatId", "content", "role") (
    SELECT
      'chat-two',
      '"content2"',
      'system'
  );

INSERT INTO
  public."Chat" ("id", "name", "userId", "createdAt", "updatedAt") (
    SELECT
      'chat-three',
      'test-chat',
      'macro|[email protected]',
      '2019-10-16 02:00:00',
      '2019-10-16 02:00:00'
  );

INSERT INTO
  public."ChatMessage" ("chatId", "content", "role") (
    SELECT
      'chat-three',
      '"content1"',
      'user'
  );

INSERT INTO
  public."ChatMessage" ("chatId", "content", "role") (
    SELECT
      'chat-three',
      '"content2"',
      'system'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'document-one',
      'document',
      '2019-10-16 00:00:00',
      '2019-10-16 02:00:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'document-two',
      'document',
      '2019-10-16 00:10:00',
      '2019-10-16 00:45:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'document-three',
      'document',
      '2019-10-16 00:30:00',
      '2019-10-16 00:41:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'document-four',
      'document',
      '2019-10-16 00:40:00',
      '2019-10-16 00:40:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'document-five',
      'document',
      '2019-10-16 00:50:00',
      '2019-10-16 00:50:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'document-six',
      'document',
      '2019-10-16 01:00:00',
      '2019-10-16 01:00:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'chat-three',
      'chat',
      '2019-10-16 03:00:00',
      '2019-10-16 03:00:00'
  );

INSERT INTO
  public."UserHistory" (
    "userId",
    "itemId",
    "itemType",
    "createdAt",
    "updatedAt"
  ) (
    SELECT
      'macro|[email protected]',
      'project-one',
      'project',
      '2019-10-16 04:00:00',
      '2019-10-16 04:00:00'
  );