Skip to content

A psql migration serializer that can can take file inputs to generate insert statements. This application is heavily scoped on a specific use-case of a generic User Management Service-like API. Feel free to adapt & use freely 👍

Notifications You must be signed in to change notification settings

KeithAlt/psql-serializer-ums-demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PostgresSQL User Management Service Serializer/Migration tool:

Shape large amounts of data into psql inserts. Adjust source & build as needed.

Example of migration output:

INSERT INTO user_member (id, name, email, user_role, phone, image_url, user_secret) VALUES
('0', 'Sofia Lowe', '[email protected]', 'Merchant', '(562) 246-7846', 'https://i.postimg.cc/7hGxR500/28.png', 'a89vsad0ansaodjsa90vas0dmfnfslalkasmdv');
INSERT INTO user_member (id, name, email, user_role, phone, image_url, user_secret) VALUES
('1', 'Erik Lubowitz', '[email protected]', 'Doorman', '(573) 248-0225', 'https://i.postimg.cc/qBSB3GHL/30.png', 'a89vsad0ansaodjsa90vas0dmfnfslalkasmdv');
INSERT INTO user_member (id, name, email, user_role, phone, image_url, user_secret) VALUES
('2', 'Willow Barton', '[email protected]', 'Counsellor', '(205) 107-7163', 'https://i.postimg.cc/vDwdS3Qw/41.png', 'a89vsad0ansaodjsa90vas0dmfnfslalkasmdv');
INSERT INTO user_member (id, name, email, user_role, phone, image_url, user_secret) VALUES
('3', 'Ezequiel Altenwerth', '[email protected]', 'Medical Assistant', '(465) 538-6730', 'https://i.postimg.cc/4NcfbhJT/32.png', 'a89vsad0ansaodjsa90vas0dmfnfslalkasmdv');
INSERT INTO user_member (id, name, email, user_role, phone, image_url, user_secret) VALUES
('4', 'Mallie Ruecker', '[email protected]', 'Catering staff', '(741) 010-7113', 'https://i.postimg.cc/9XRRK0WL/40.png', 'a89vsad0ansaodjsa90vas0dmfnfslalkasmdv');
INSERT INTO user_member (id, name, email, user_role, phone, image_url, user_secret) VALUES
('5', 'Courtney Watsica', '[email protected]', 'Receptionist', '(070) 647-8375', 'https://i.postimg.cc/907hpvHB/39.png', 'a89vsad0ansaodjsa90vas0dmfnfslalkasmdv');

#etc . . .

About

A psql migration serializer that can can take file inputs to generate insert statements. This application is heavily scoped on a specific use-case of a generic User Management Service-like API. Feel free to adapt & use freely 👍

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages