| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 2022-03-12 | Add an `insert()` function for inserting YAML in database | Teddy Wing | |
| Make an interface that more cleanly says "insert this YAML into this database". | |||
| 2022-03-12 | Move `yaml_extract()` to `yaqlite::yaml::extract()` | Teddy Wing | |
| 2022-03-12 | Move `yaqlite::yaml` to `yaqlite::yaml::sql` | Teddy Wing | |
| Want to use `yaqlite::yaml` for the YAML extraction function. | |||
| 2022-03-12 | get_column_names(): Get table name from argument | Teddy Wing | |
| Remove the hard-coded table name. | |||
| 2022-03-12 | yaml_extract(): Remove old comments | Teddy Wing | |
| 2022-03-12 | Move `get_column_names()` to `sqlite` module | Teddy Wing | |
| 2022-03-12 | get_column_names(): Remove irrelevant comments | Teddy Wing | |
| 2022-03-12 | get_column_names(): Restore `Zero` value | Teddy Wing | |
| Turns out I didn't need the type of the column, so get rid of that value and resume using `Zero`. | |||
| 2022-03-12 | Move `Yaml` newtype to a new module in library crate | Teddy Wing | |
| Separate this code from the main binary file. | |||
| 2022-03-12 | yaml_extract(): Don't try to insert data for nonexistent columns | Teddy Wing | |
| If a hash key in the input YAML does not match one of the column names in the table we're inserting into, ignore that YAML field and use the other columns for insertion. | |||
| 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 | |
 |
index : yaqlite | |
| A bridge between YAML and SQLite |
| aboutsummaryrefslogtreecommitdiffstats |