Mopy
Simple tool to create mock data
使い方
サンプルコード
users = Table(
"users",
id=PkIntSeed(),
age=RandIntSeed(min=0, max=100),
name=RandStrSeed(size=5),
birth=RandDateSeed()
)
items = Table(
"items",
id=PkIntSeed(),
price=RandIntSeed(min=0, max=1000),
user_id=users("id"),
user_name=users("name"),
type=EnumSeed(["ONE", "TWO", "THERE"]),
is_active=RandBoolSeed()
)
users.create(7).show_sql()
items.create(5).show_sql()
実行結果
INSERT INTO users(id, age, name, birth) VALUES (1, 53, 'a3X6w', '1953-07-03');
INSERT INTO users(id, age, name, birth) VALUES (2, 74, 'g2bqS', '2045-06-05');
INSERT INTO users(id, age, name, birth) VALUES (3, 32, '5KXmT', '1931-07-02');
INSERT INTO users(id, age, name, birth) VALUES (4, 75, 'YHbwC', '1938-01-14');
INSERT INTO users(id, age, name, birth) VALUES (5, 5, 'jHaTc', '2031-02-13');
INSERT INTO users(id, age, name, birth) VALUES (6, 14, 'CBPfh', '2087-09-26');
INSERT INTO users(id, age, name, birth) VALUES (7, 58, '47tJr', '1931-02-26');
INSERT INTO items(id, price, user_id, user_name, type, is_active) VALUES (1, 611, 1, 'a3X6w', 'THERE', False);
INSERT INTO items(id, price, user_id, user_name, type, is_active) VALUES (2, 790, 2, 'g2bqS', 'ONE', True);
INSERT INTO items(id, price, user_id, user_name, type, is_active) VALUES (3, 503, 3, '5KXmT', 'THERE', False);
INSERT INTO items(id, price, user_id, user_name, type, is_active) VALUES (4, 919, 4, 'YHbwC', 'TWO', False);
INSERT INTO items(id, price, user_id, user_name, type, is_active) VALUES (5, 451, 5, 'jHaTc', 'ONE', True);