python-project-generator 3.2.2

Generates a Python project structure.
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

use anyhow::Result;
use time::OffsetDateTime;

use crate::{file_manager::save_file_with_content, project_info::ProjectInfo};

fn create_initial_up_migration() -> String {
    r#"CREATE TABLE IF NOT EXISTS users (
  id UUID DEFAULT uuidv7() PRIMARY KEY,
  email TEXT NOT NULL UNIQUE,
  full_name TEXT NOT NULL,
  hashed_password TEXT NOT NULL,
  is_active BOOLEAN NOT NULL DEFAULT true,
  is_superuser BOOLEAN NOT NULL DEFAULT false,
  last_login TIMESTAMP NOT NULL DEFAULT NOW()
);
"#
    .to_string()
}

fn create_initial_down_migration() -> String {
    r#"DROP TABLE IF EXISTS users;
"#
    .to_string()
}

pub fn save_initial_migrations(project_info: &ProjectInfo) -> Result<()> {
    let now = OffsetDateTime::now_utc();
    let migration_prefix = format!(
        "{:04}{:02}{:02}{:02}{:02}{:02}",
        now.year(),
        now.month() as u8,
        now.day(),
        now.hour(),
        now.minute(),
        now.second()
    );
    let up_file_name = format!("{migration_prefix}_init.up.sql");
    let down_file_name = format!("{migration_prefix}_init.down.sql");

    let base = project_info.base_dir();
    let up_file_path = base.join(format!("migrations/{up_file_name}"));
    let up_file_content = create_initial_up_migration();

    save_file_with_content(&up_file_path, &up_file_content)?;

    let down_file_path = base.join(format!("migrations/{down_file_name}"));
    let down_file_content = create_initial_down_migration();

    save_file_with_content(&down_file_path, &down_file_content)?;

    Ok(())
}