Cindex, a csv indexer

Cindex is a easy to use csv indexer with SQL-like simple query support.

Cindex is not intended for heavy database indexing but for simple in-memory querying. Use other databases interaction layer if you're using big chunks of csv files.

Usage

[dependencies]
cindex = "*" # Use the latest version if possible

# Use "default-features = false" if you don't need rayon iteration enhancement.

use std::fs::File;
use cindex::{Indexer, CsvType, Predicate, Query, OutOption, Operator};

let mut indexer = Indexer::new();

// Add table without types
// Default types for every columns are "Text"
indexer.add_table_fast(
    "table1", 
    File::open("test.csv").expect("Failed to open a file")
).expect("Failed to add table");

// Add table with column types
indexer.add_table(
    "table2", 
    vec![CsvType::Text, CsvType::Text],
    "id,address
10,110-2222".as_bytes()
).expect("Failed to add table");

// Add table from stdin
let stdin = std::io::stdin();
indexer.add_table_fast(
    "table3", 
    stdin.lock()
).expect("Failed to add table");

// Indexing

// Create query object and print output to terminal
let query = Query::from_str("SELECT a,b,c FROM table1 WHERE a = 10");
indexer.index(query, OutOption::Term).expect("Failed to index a table");

// Use raw query and yield output to a file
indexer.index_raw(
    "SELECT * FROM table3 WHERE id = 10", 
    OutOption::File(std::fs::File::create("out.csv").expect("Failed to create a file"))
).expect("Failed to index a table");

// Use builder pattern to construct query and index a table
let query = Query::empty("table2")
    .columns(vec!["id", "address"])
    .predicate(Predicate::new("id", Operator::Equal)
        .args(vec!["10"])
    )
    .predicate(Predicate::build()
        .column("address")
        .operator(Operator::NotEqual)
        .raw_args("111-2222")
    );

let mut acc = String::new();
indexer.index(query, OutOption::Value(&mut acc)).expect("Failed to index a table");

TODO

• DateTime csv type
• Multi where caluse support
• Join table