os dados são trabalhado com a bibliote Faker do Pyton para gerar dados ficticios
This repository contains a set of Python scripts for generating and inserting fake data into a SQL Server database. These scripts are useful for testing and development purposes, allowing you to quickly populate your database with mock data.
- This script generates and inserts fake data into a SQL Server database using the
pyodbc
andFaker
libraries. - It creates fake records in the
certificado_colaborador
table with randomcolaborador_id
,certificado_id
, anddata_validade
values.
- Similar to the first script, this one generates and inserts fake data into a SQL Server database using the
pyodbc
andFaker
libraries. - It creates fake records in the
certificado_colaborador
table with fixedcolaborador_id
andcertificado_id
values and randomdata_validade
values.
- This script generates and inserts fake data into a SQL Server database using the
pyodbc
library. - It creates fake records in the
cliente_fornecedor
table with randomcliente_id
andfornecedor_id
values.
- Clone this repository to your local machine:
created by Satochi Yamamoto
git clone [email protected]:ydsoftware1979/Script_Carga_SQL_Python.git