use chrono::{DateTime, Utc};
use serde::{Deserialize, Serialize};
use serde_json::Value;

pub use crate::database::{SortField, WhereClause, WhereCondition};

#[derive(Debug, Clone, Serialize, Deserialize, sqlx::FromRow)]
#[serde(rename_all = "camelCase")]
pub struct Record {
    pub uri: String,
    pub cid: String,
    pub did: String,
    pub collection: String,
    pub json: Value,
    pub indexed_at: DateTime<Utc>,
    pub slice_uri: Option<String>,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct IndexedRecord {
    pub uri: String,
    pub cid: String,
    pub did: String,
    pub collection: String,
    pub value: Value,
    pub indexed_at: String,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct BulkSyncParams {
    pub collections: Option<Vec<String>>,
    pub external_collections: Option<Vec<String>>,
    pub repos: Option<Vec<String>>,
    pub limit_per_repo: Option<i32>,
    pub skip_validation: Option<bool>,
    pub max_repos: Option<i32>,
}

#[derive(Debug, Clone, Serialize, Deserialize, sqlx::FromRow)]
#[serde(rename_all = "camelCase")]
pub struct Actor {
    pub did: String,
    pub handle: Option<String>,
    pub slice_uri: String,
    pub indexed_at: String,
}

#[derive(Debug, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct CollectionStats {
    pub collection: String,
    pub record_count: i64,
    pub unique_actors: i64,
}

#[derive(Debug, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct SliceRecordsParams {
    pub slice: String,
    pub limit: Option<i32>,
    pub cursor: Option<String>,
    #[serde(rename = "where")]
    pub where_clause: Option<WhereClause>,
    pub sort_by: Option<Vec<SortField>>,
}

#[derive(Debug, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct SliceRecordsOutput {
    pub records: Vec<IndexedRecord>,
    pub cursor: Option<String>,
}

#[derive(Debug, Clone, Serialize, Deserialize, sqlx::FromRow)]
#[serde(rename_all = "camelCase")]
pub struct OAuthClient {
    pub id: i32,
    pub slice_uri: String,
    pub client_id: String,
    pub registration_access_token: Option<String>,
    pub created_at: DateTime<Utc>,
    pub created_by_did: String,
}

#[derive(Debug, Serialize, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct SparklinePoint {
    pub timestamp: String,
    pub count: i64,
}