<feed xmlns='http://www.w3.org/2005/Atom'>
<title>yaqlite/src, branch update</title>
<subtitle>A bridge between YAML and SQLite</subtitle>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/'/>
<entry>
<title>insert(): Add a test with YAML keys referring to nonexistent columns</title>
<updated>2022-04-05T17:53:20+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-04-05T17:53:20+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=5f8b19f73b1a506cdcc4a33113a10c470927d09d'/>
<id>5f8b19f73b1a506cdcc4a33113a10c470927d09d</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add a SQL update function to update a record from YAML</title>
<updated>2022-04-02T18:35:28+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-04-02T18:35:28+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=bc0afe2353f925124c67bf5785813432de44af57'/>
<id>bc0afe2353f925124c67bf5785813432de44af57</id>
<content type='text'>
Add a new `db_update()` function to update an existing database record
from a YAML hash.

Had a little trouble building up the params for the prepared SQL
statement but finally managed to set up the types correctly and include
the record ID to update. Thanks to this Stack Overflow answer by
Shepmaster (https://stackoverflow.com/users/155423/shepmaster) for
pointing me in the right direction:
https://stackoverflow.com/questions/46624591/cannot-call-rusqlites-query-because-it-expects-the-type-rusqlitetypestos/46625932#46625932
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Add a new `db_update()` function to update an existing database record
from a YAML hash.

Had a little trouble building up the params for the prepared SQL
statement but finally managed to set up the types correctly and include
the record ID to update. Thanks to this Stack Overflow answer by
Shepmaster (https://stackoverflow.com/users/155423/shepmaster) for
pointing me in the right direction:
https://stackoverflow.com/questions/46624591/cannot-call-rusqlites-query-because-it-expects-the-type-rusqlitetypestos/46625932#46625932
</pre>
</div>
</content>
</entry>
<entry>
<title>Command::Update: Add a variant to specify primary key without column</title>
<updated>2022-04-01T21:44:39+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-04-01T21:44:39+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=02bc0d184fa60668bafe8de5ba844d132aa2ffb3'/>
<id>02bc0d184fa60668bafe8de5ba844d132aa2ffb3</id>
<content type='text'>
Allow passing the primary key either by value or prefixed by its column
name.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Allow passing the primary key either by value or prefixed by its column
name.
</pre>
</div>
</content>
</entry>
<entry>
<title>yaml::db_insert(): Generalise YAML walking function</title>
<updated>2022-04-01T19:56:58+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-04-01T19:56:58+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=fd1b777ec9bc70e8444c12cb453d14e72db2462c'/>
<id>fd1b777ec9bc70e8444c12cb453d14e72db2462c</id>
<content type='text'>
Split `db_insert()` into one function to do the YAML document recursion
and another to do the database insertion.

This will allow us to reuse the YAML document recursion function for
database `UPDATE` queries.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Split `db_insert()` into one function to do the YAML document recursion
and another to do the database insertion.

This will allow us to reuse the YAML document recursion function for
database `UPDATE` queries.
</pre>
</div>
</content>
</entry>
<entry>
<title>Command::Update: Add help text for `primary_key` CLI argument</title>
<updated>2022-03-31T22:11:49+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-03-31T22:11:24+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=775cf46a55379b6c712fd4770fd48935c2d06cc4'/>
<id>775cf46a55379b6c712fd4770fd48935c2d06cc4</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>main::Command: Idea for an `update` subcommand</title>
<updated>2022-03-31T19:49:59+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-03-31T19:49:59+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=783782030862d6d69edec7e35a04da6140161932'/>
<id>783782030862d6d69edec7e35a04da6140161932</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add license (GNU GPLv3+)</title>
<updated>2022-03-27T03:58:36+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-03-27T03:58:36+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=a4ff3950de526c6a6325c47ce334acf9576028ef'/>
<id>a4ff3950de526c6a6325c47ce334acf9576028ef</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>extract(): Rename function to `db_insert()`</title>
<updated>2022-03-22T23:27:50+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-03-22T23:24:22+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=2313a1bd0910e7b42cc23f83d6722272b87e0baf'/>
<id>2313a1bd0910e7b42cc23f83d6722272b87e0baf</id>
<content type='text'>
The name `extract()` didn't make sense to me any more since the function
is doing more than its originally intended behaviour which was to
extract the YAML into a hash-like format for easy insertion into the
database.

I decided to give up on that behaviour since this works for what we want
it to do. Maybe this function is doing more than it should, but I'm okay
with that for the current functional requirements.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The name `extract()` didn't make sense to me any more since the function
is doing more than its originally intended behaviour which was to
extract the YAML into a hash-like format for easy insertion into the
database.

I decided to give up on that behaviour since this works for what we want
it to do. Maybe this function is doing more than it should, but I'm okay
with that for the current functional requirements.
</pre>
</div>
</content>
</entry>
<entry>
<title>insert(): Add documentation</title>
<updated>2022-03-22T23:21:33+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-03-22T23:21:33+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=466aa5dc480048ff4448c2f2f1ee8cbe02cad3a8'/>
<id>466aa5dc480048ff4448c2f2f1ee8cbe02cad3a8</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>get_column_names(): Add documentation</title>
<updated>2022-03-22T23:18:59+00:00</updated>
<author>
<name>Teddy Wing</name>
</author>
<published>2022-03-22T23:18:59+00:00</published>
<link rel='alternate' type='text/html' href='https://git.teddywing.com/yaqlite/commit/?id=1b0ebeb7f4703872222a932dd3e0a79c68580b5a'/>
<id>1b0ebeb7f4703872222a932dd3e0a79c68580b5a</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
