Skip to content

Instantly share code, notes, and snippets.

@coco98
Created September 27, 2022 22:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save coco98/803b70ec3fdd48cbe388bd25fcbfcd0e to your computer and use it in GitHub Desktop.
Save coco98/803b70ec3fdd48cbe388bd25fcbfcd0e to your computer and use it in GitHub Desktop.
Sample messages table and data for testing out a streaming GraphQL API
-- After adding a Postgres source to your Hasura project,
-- head to the "Run SQL" page and copy-pasta the following SQL.
-- This SQL creates a messages table and inserts a 100 messages into the table.
CREATE TABLE messages (
id bigserial primary key,
message text
);
INSERT INTO messages (message) VALUES
('message 1'),
('message 2'),
('message 3'),
('message 4'),
('message 5'),
('message 6'),
('message 7'),
('message 8'),
('message 9'),
('message 10'),
('message 11'),
('message 12'),
('message 13'),
('message 14'),
('message 15'),
('message 16'),
('message 17'),
('message 18'),
('message 19'),
('message 20'),
('message 21'),
('message 22'),
('message 23'),
('message 24'),
('message 25'),
('message 26'),
('message 27'),
('message 28'),
('message 29'),
('message 30'),
('message 31'),
('message 32'),
('message 33'),
('message 34'),
('message 35'),
('message 36'),
('message 37'),
('message 38'),
('message 39'),
('message 40'),
('message 41'),
('message 42'),
('message 43'),
('message 44'),
('message 45'),
('message 46'),
('message 47'),
('message 48'),
('message 49'),
('message 50'),
('message 51'),
('message 52'),
('message 53'),
('message 54'),
('message 55'),
('message 56'),
('message 57'),
('message 58'),
('message 59'),
('message 60'),
('message 61'),
('message 62'),
('message 63'),
('message 64'),
('message 65'),
('message 66'),
('message 67'),
('message 68'),
('message 69'),
('message 70'),
('message 71'),
('message 72'),
('message 73'),
('message 74'),
('message 75'),
('message 76'),
('message 77'),
('message 78'),
('message 79'),
('message 80'),
('message 81'),
('message 82'),
('message 83'),
('message 84'),
('message 85'),
('message 86'),
('message 87'),
('message 88'),
('message 89'),
('message 90'),
('message 91'),
('message 92'),
('message 93'),
('message 94'),
('message 95'),
('message 96'),
('message 97'),
('message 98'),
('message 99'),
('message 100');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment