-
Notifications
You must be signed in to change notification settings - Fork 597
/
keyword.rs
109 lines (96 loc) · 3.13 KB
/
keyword.rs
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
use chrono::NaiveDateTime;
use diesel::prelude::*;
use crate::models::Crate;
use crate::schema::*;
use crate::sql::lower;
#[derive(Clone, Identifiable, Queryable, Debug)]
pub struct Keyword {
pub id: i32,
pub keyword: String,
pub crates_cnt: i32,
pub created_at: NaiveDateTime,
}
#[derive(Associations, Insertable, Identifiable, Debug, Clone, Copy)]
#[diesel(
table_name = crates_keywords,
check_for_backend(diesel::pg::Pg),
primary_key(crate_id, keyword_id),
belongs_to(Keyword),
belongs_to(Crate),
)]
pub struct CrateKeyword {
crate_id: i32,
keyword_id: i32,
}
impl Keyword {
pub fn find_by_keyword(conn: &mut PgConnection, name: &str) -> QueryResult<Keyword> {
keywords::table
.filter(keywords::keyword.eq(lower(name)))
.first(conn)
}
pub fn find_or_create_all(
conn: &mut PgConnection,
names: &[&str],
) -> QueryResult<Vec<Keyword>> {
let lowercase_names: Vec<_> = names.iter().map(|s| s.to_lowercase()).collect();
let new_keywords: Vec<_> = lowercase_names
.iter()
.map(|s| keywords::keyword.eq(s))
.collect();
diesel::insert_into(keywords::table)
.values(&new_keywords)
.on_conflict_do_nothing()
.execute(conn)?;
keywords::table
.filter(keywords::keyword.eq_any(&lowercase_names))
.load(conn)
}
pub fn valid_name(name: &str) -> bool {
let mut chars = name.chars();
let first = match chars.next() {
None => return false,
Some(c) => c,
};
first.is_ascii_alphanumeric()
&& chars.all(|c| c.is_ascii_alphanumeric() || c == '_' || c == '-' || c == '+')
}
pub fn update_crate(
conn: &mut PgConnection,
krate: &Crate,
keywords: &[&str],
) -> QueryResult<()> {
conn.transaction(|conn| {
let keywords = Keyword::find_or_create_all(conn, keywords)?;
diesel::delete(CrateKeyword::belonging_to(krate)).execute(conn)?;
let crate_keywords = keywords
.into_iter()
.map(|kw| CrateKeyword {
crate_id: krate.id,
keyword_id: kw.id,
})
.collect::<Vec<_>>();
diesel::insert_into(crates_keywords::table)
.values(&crate_keywords)
.execute(conn)?;
Ok(())
})
}
}
#[cfg(test)]
mod tests {
use super::*;
use crate::test_util::pg_connection;
#[test]
fn dont_associate_with_non_lowercased_keywords() {
let conn = &mut pg_connection();
// The code should be preventing lowercased keywords from existing,
// but if one happens to sneak in there, don't associate crates with it.
diesel::insert_into(keywords::table)
.values(keywords::keyword.eq("NO"))
.execute(conn)
.unwrap();
let associated = Keyword::find_or_create_all(conn, &["no"]).unwrap();
assert_eq!(associated.len(), 1);
assert_eq!(associated.first().unwrap().keyword, "no");
}
}