import type { PickDetails } from './types';
import type { EnrichedGameData } from '../seo/data-enrichment';
export interface PickRow {
    id: number;
    game_key: string;
    league: string;
    pick_type: string;
    selection: string;
    pick_direction: string;
    blog_post_id: number | null;
    x_post_id: string | null;
    x_post_url: string | null;
    created_at: string;
}
/**
 * Insert a new pick into sc_picks.
 */
export declare function insertPick(pick: PickDetails, enriched: EnrichedGameData, blogPostId: number | null): Promise<number>;
/**
 * Check for an existing pick on the same game+type within a time window (idempotency).
 */
export declare function getRecentPick(gameKey: string, pickType: string, hours?: number): Promise<PickRow | null>;
/**
 * After X post succeeds, update the pick with tweet info.
 */
export declare function updatePickXPost(pickId: number, xPostId: string, xPostUrl: string): Promise<void>;
/**
 * Replace {{X_POST_LINK}} in the blog post content with the actual tweet URL.
 */
export declare function updateBlogXPostLink(blogPostId: number, xPostUrl: string): Promise<void>;
/**
 * Link a pick to a tweet row ID (sc_twitter_tweets.id).
 */
export declare function updatePickTweetRow(pickId: number, tweetRowId: number): Promise<void>;
//# sourceMappingURL=breakdown-data-queries.d.ts.map