data-faking 0.1.2

Generate massive amounts of fake data
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152

// NAIVE date datetime timestamp generation for sql targets

/*
https://learn.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver16

Data type	Format	Range	Accuracy	Storage size (bytes)	User-defined fractional second precision	Time zone offset
time	hh:mm:ss[.nnnnnnn]	00:00:00.0000000 through 23:59:59.9999999	100 nanoseconds	3 to 5	Yes	No
date	YYYY-MM-DD	0001-01-01 through 9999-12-31	1 day	3	No	No
smalldatetime	YYYY-MM-DD hh:mm:ss	1900-01-01 through 2079-06-06	1 minute	4	No	No
datetime	YYYY-MM-DD hh:mm:ss[.nnn]	1753-01-01 through 9999-12-31	0.00333 second	8	No	No

datetime2	YYYY-MM-DD hh:mm:ss[.nnn nnnn]	0001-01-01 00:00:00.0000000 through 9999-12-31 23:59:59.9999999	100 nanoseconds	6 to 8	Yes	No
datetimeoffset	YYYY-MM-DD hh:mm:ss[.nnn nnnn] [+|-]hh:mm	0001-01-01 00:00:00.0000000 through 9999-12-31 23:59:59.9999999 (in UTC)
 */

use crate::utils::seeder;
use wasm_bindgen::prelude::*;

// TEMP
pub const YEAR_MIN: i32 = 1971;
pub const YEAR_MAX: i32 = 2037;

pub const MONTH_MIN: i32 = 1;
pub const MONTH_MAX: i32 = 12;

// NOTE(clearfeld): TEMP use chrono to get days in month do not use 28 limit
pub const DAYS_MIN: i32 = 1;
pub const DAYS_MAX: i32 = 28;

pub const HOURS_MIN: i32 = 0;
pub const HOURS_MAX: i32 = 23;

pub const MINUTES_MIN: i32 = 0;
pub const MINUTES_MAX: i32 = 59;

pub const SECONDS_MIN: i32 = 0;
pub const SECONDS_MAX: i32 = 59;

pub const NANO_MIN: i32 = 0;
pub const NANO_MAX: i32 = 23;

// SQL Server

// PostgreSQL and MySQL
// MySQL - TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.
// MySQL - DATETIME supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

fn zero_pad_string(arg: i32) -> String {
    if arg < 10 {
        format!("0{}",arg)
    } else {
        arg.to_string()
    }
}

#[wasm_bindgen]
pub fn sql_time() -> String {
	format!(
		"{}:{}:{}",
		zero_pad_string(seeder::gen_range(HOURS_MIN..=HOURS_MAX)),
		zero_pad_string(seeder::gen_range(MINUTES_MIN..=MINUTES_MAX)),
		zero_pad_string(seeder::gen_range(SECONDS_MIN..=SECONDS_MAX))
	)
}

#[wasm_bindgen]
pub fn sql_server_time() -> String {
	format!(
		"{}:{}:{}.{}{}{}{}{}{}{}",
		zero_pad_string(seeder::gen_range(HOURS_MIN..=HOURS_MAX)),
		zero_pad_string(seeder::gen_range(MINUTES_MIN..=MINUTES_MAX)),
		zero_pad_string(seeder::gen_range(SECONDS_MIN..=SECONDS_MAX)),

        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9)
	)
}

#[wasm_bindgen]
pub fn sql_date() -> String {
	format!(
		"{}-{}-{}",
		zero_pad_string(seeder::gen_range(YEAR_MIN..=YEAR_MAX)),
		zero_pad_string(seeder::gen_range(MONTH_MIN..=MONTH_MAX)),
		zero_pad_string(seeder::gen_range(DAYS_MIN..=DAYS_MAX))
	)
}

#[wasm_bindgen]
pub fn sql_datetime() -> String {
	format!(
		"{}-{}-{} {}:{}:{}.{}{}{}{}{}",
		zero_pad_string(seeder::gen_range(YEAR_MIN..=YEAR_MAX)),
		zero_pad_string(seeder::gen_range(MONTH_MIN..=MONTH_MAX)),
		zero_pad_string(seeder::gen_range(DAYS_MIN..=DAYS_MAX)),

		zero_pad_string(seeder::gen_range(HOURS_MIN..=HOURS_MAX)),
		zero_pad_string(seeder::gen_range(MINUTES_MIN..=MINUTES_MAX)),
		zero_pad_string(seeder::gen_range(SECONDS_MIN..=SECONDS_MAX)),

        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9)
	)
}

#[wasm_bindgen]
pub fn sql_server_datetime() -> String {
	format!(
		"{}-{}-{} {}:{}:{}.{}{}{}",
		zero_pad_string(seeder::gen_range(YEAR_MIN..=YEAR_MAX)),
		zero_pad_string(seeder::gen_range(MONTH_MIN..=MONTH_MAX)),
		zero_pad_string(seeder::gen_range(DAYS_MIN..=DAYS_MAX)),

		zero_pad_string(seeder::gen_range(HOURS_MIN..=HOURS_MAX)),
		zero_pad_string(seeder::gen_range(MINUTES_MIN..=MINUTES_MAX)),
		zero_pad_string(seeder::gen_range(SECONDS_MIN..=SECONDS_MAX)),

        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9)
	)
}

#[wasm_bindgen]
pub fn sql_server_datetime2() -> String {
	format!(
		"{}-{}-{} {}:{}:{}.{}{}{}{}{}{}{}",
		zero_pad_string(seeder::gen_range(YEAR_MIN..=YEAR_MAX)),
		zero_pad_string(seeder::gen_range(MONTH_MIN..=MONTH_MAX)),
		zero_pad_string(seeder::gen_range(DAYS_MIN..=DAYS_MAX)),

		zero_pad_string(seeder::gen_range(HOURS_MIN..=HOURS_MAX)),
		zero_pad_string(seeder::gen_range(MINUTES_MIN..=MINUTES_MAX)),
		zero_pad_string(seeder::gen_range(SECONDS_MIN..=SECONDS_MAX)),

        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9),
        seeder::gen_range(0..=9)
	)
}