surrealdb_sql/statements/
show.rs1use chrono::{DateTime, Utc};
2use common::fmt::{EscapeKwFreeIdent, SqlDatetime};
3use surrealdb_types::{SqlFormat, ToSql, write_sql};
4
5use crate::TableName;
6
7#[derive(Clone, Debug, Eq, PartialEq, PartialOrd, Hash)]
8#[cfg_attr(feature = "arbitrary", derive(arbitrary::Arbitrary))]
9pub enum ShowSince {
10 Timestamp(DateTime<Utc>),
11 Versionstamp(u64),
12}
13
14#[derive(Clone, Debug, Eq, PartialEq, PartialOrd, Hash)]
16#[cfg_attr(feature = "arbitrary", derive(arbitrary::Arbitrary))]
17pub struct ShowStatement {
18 pub table: Option<TableName>,
19 pub since: ShowSince,
20 pub limit: Option<u32>,
21}
22
23impl ToSql for ShowStatement {
24 fn fmt_sql(&self, f: &mut String, fmt: SqlFormat) {
25 write_sql!(f, fmt, "SHOW CHANGES FOR");
26 match self.table {
27 Some(ref v) => write_sql!(f, fmt, " TABLE {}", EscapeKwFreeIdent(v.as_str())),
28 None => write_sql!(f, fmt, " DATABASE"),
29 }
30 match self.since {
31 ShowSince::Timestamp(ref v) => write_sql!(f, fmt, " SINCE {}", SqlDatetime(*v)),
32 ShowSince::Versionstamp(ref v) => write_sql!(f, fmt, " SINCE {}", v),
33 }
34 if let Some(ref v) = self.limit {
35 write_sql!(f, fmt, " LIMIT {}", v)
36 }
37 }
38}