get_table_row_count

Function get_table_row_count 

Source
pub fn get_table_row_count(conn: &Connection, table: &str) -> Result<usize>
Expand description

Get row count for a specific table

Executes COUNT(*) query on the specified table.

§Arguments

  • conn - SQLite database connection
  • table - Table name (should be validated with validate_table_name)

§Returns

Number of rows in the table

§Security

IMPORTANT: Table name should be validated before calling this function to prevent SQL injection. Use crate::jsonb::validate_table_name().

§Examples

let conn = open_sqlite("database.db")?;
let table = "users";
validate_table_name(table)?;
let count = get_table_row_count(&conn, table)?;
println!("Table {} has {} rows", table, count);