Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Apply Factory pattern into other tables #2

Open
1 of 4 tasks
lelouvincx opened this issue Sep 13, 2023 · 2 comments · Fixed by #5
Open
1 of 4 tasks

Apply Factory pattern into other tables #2

lelouvincx opened this issue Sep 13, 2023 · 2 comments · Fixed by #5
Assignees
Labels
documentation Improvements or additions to documentation feature New feature or request help wanted Extra attention is needed

Comments

@lelouvincx
Copy link
Owner

lelouvincx commented Sep 13, 2023

Currently the Fake Data Generation app can generate only 1 table: public.test.

Trouble in creating generating functions for other tables.

Todos:

  • A json file, saves database schema. (So that the Streamlit app can initialize schemas and tables.
  • Class Table has:
    • Auto update schema
    • For each datatype from PostgreSQL, create factory pattern with corresponding Faker()
@lelouvincx lelouvincx self-assigned this Sep 13, 2023
@lelouvincx lelouvincx converted this from a draft issue Sep 13, 2023
@lelouvincx
Copy link
Owner Author

Data catalog here: https://dbdocs.io/lelouvincx/WideWorldImporters

@lelouvincx lelouvincx added feature New feature or request help wanted Extra attention is needed labels Sep 13, 2023
@lelouvincx lelouvincx moved this from Blocked to Todo in Database Replication Project Sep 18, 2023
@lelouvincx lelouvincx moved this from Todo to In Progress in Database Replication Project Sep 18, 2023
lelouvincx added a commit that referenced this issue Sep 18, 2023
lelouvincx added a commit that referenced this issue Sep 18, 2023
@lelouvincx
Copy link
Owner Author

Data types extracted from database:
{'int8', 'numeric', 'bool', 'varchar', 'date', 'int4', 'text', 'timestamp', 'bytea', 'bpchar'}

Trong Faker có nhiều loại kiểu dữ liệu để fake, gọi là Provider. Một số Provider cơ bản: address, automotive, color, company, geo, text, sentence, zipcode...

lelouvincx added a commit that referenced this issue Sep 19, 2023
@lelouvincx lelouvincx moved this from In Progress to Blocked in Database Replication Project Sep 19, 2023
@lelouvincx lelouvincx linked a pull request Sep 19, 2023 that will close this issue
@lelouvincx lelouvincx reopened this Sep 19, 2023
@lelouvincx lelouvincx moved this from Done to Blocked in Database Replication Project Sep 19, 2023
lelouvincx added a commit that referenced this issue Sep 19, 2023
@lelouvincx lelouvincx added the documentation Improvements or additions to documentation label Sep 19, 2023
@lelouvincx lelouvincx added this to the Analytics schema milestone Dec 9, 2023
lelouvincx added a commit that referenced this issue Dec 23, 2023
lelouvincx added a commit that referenced this issue Dec 23, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation feature New feature or request help wanted Extra attention is needed
Projects
Status: Blocked
Development

Successfully merging a pull request may close this issue.

1 participant