Age | Commit message (Collapse) | Author | |
---|---|---|---|
2022-03-12 | Convert `yaml::Yaml` values to `rusqlite::ToSql` | Teddy Wing | |
This enables us to build a list of params for insertion and insert them into the database. Not sure if `NULL` makes sense for all of these types, but this at least gives us the type conversion necessary to get the YAML values into the SQL query, cool. | |||
2022-03-12 | yaml_extract: Trying to build up a SQL insert statement | Teddy Wing | |
Doesn't work yet as I need a way to convert `Yaml` values to Rusqlite SQL params. | |||
2022-03-10 | Start encoding SQLite affinity rules | Teddy Wing | |
Need to figure out what to do for NUMERIC affinity since Rusqlite doesn't expose a variant for that pseudo-type. | |||
2022-03-09 | Idea for getting SQLite type affinity from a type string | Teddy Wing | |
2022-03-09 | get_column_names(): Add a note to map to the enum type instead of String | Teddy Wing | |
2022-03-09 | get_column_names(): Also get column type | Teddy Wing | |
Creates a map from column name to type. | |||
2022-03-09 | yaml_extract(): Fix code from transaction argument idea | Teddy Wing | |
2022-03-09 | Add TODO for column type | Teddy Wing | |
Want to translate YAML types to SQLite types. | |||
2022-03-09 | Idea for inserting values from YAML into SQLite table | Teddy Wing | |
Need to figure out how to insert `table_columns.len()` values. | |||
2022-03-09 | Check if YAML hash key matches column name | Teddy Wing | |
Possibly ugly passing `table_columns` into `yaml_extract`, but just trying to get things working for now. Query a "people" DB table instead as that matches the test YAML file. | |||
2022-03-09 | get_column_names(): Put column names in a `HashMap` | Teddy Wing | |
Make it easier to find out if a column name exists in the table. | |||
2022-03-08 | get_column_names(): Remove transaction code | Teddy Wing | |
We probably don't even need a transaction for a `SELECT`. Get rid of that code and remove the `mut` on `dbconn` which was only necessary for the transaction. | |||
2022-03-08 | Get column names from SQLite table | Teddy Wing | |
Eliminated the transaction because of a borrow problem. | |||
2022-03-08 | Try extracting YAML data | Teddy Wing | |
2022-03-07 | Try reading and parsing a YAML file | Teddy Wing | |
2022-03-07 | Add notes | Teddy Wing | |
2022-03-07 | New Rust 1.59.0 project | Teddy Wing | |
$ rustc --version rustc 1.59.0 (9d1b2106e 2022-02-23) $ cargo init --bin | |||
2022-03-06 | Idea for a program to convert between YAML and SQLite | Teddy Wing | |