{"id":263,"date":"2025-01-13T10:00:00","date_gmt":"2025-01-13T16:00:00","guid":{"rendered":"https:\/\/douglasstarnes.dev\/?p=263"},"modified":"2025-01-13T10:10:47","modified_gmt":"2025-01-13T16:10:47","slug":"filtering-and-removing-data-with-the-sqlmodel-api-and-typer-options","status":"publish","type":"post","link":"https:\/\/douglasstarnes.dev\/index.php\/2025\/01\/13\/filtering-and-removing-data-with-the-sqlmodel-api-and-typer-options\/","title":{"rendered":"Filtering and Removing Data with the SQLModel API and Typer Options"},"content":{"rendered":"\n

In the previous post, we saw how to use SQLModel to implement the Event data model class and create a command to accept user input to add new Events to the database. We also saw how to retrieve those events and format them using Rich tables. <\/p>\n\n\n\n

This post will look at how to use SQLModel to filter the Events by adding options to the CLI to show or hide private and past Events. And it will look at how to remove individual Events and remove Events in bulk.<\/p>\n\n\n\n

Suppose that there are the following events in the database:<\/p>\n\n\n\n

Title<\/strong><\/td>Timestamp<\/strong><\/td>Private<\/strong><\/td><\/tr>
Normal Event<\/td>February 2, 2025<\/td>No<\/td><\/tr>
Past Event<\/td>January 1, 2025<\/td>No<\/td><\/tr>
Private Event<\/td>March 3, 2025<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Keep in mind that this post is being written on January 11, 2025. Thus the “Past Event” on January 1, 2025 is the only event in the past on the date this post was written.<\/em><\/p>\n\n\n\n

Filtering Data<\/h3>\n\n\n\n

Let’s create a couple of options to filter the private events and the past events. These options will be passed as parameters to the show_events <\/code>command function. Let’s start with show_past<\/code>:<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
from<\/span> typing <\/span>import<\/span> Annotated<\/span><\/span>\n<\/span>\n@<\/span>app<\/span>.<\/span>command<\/span>()<\/span><\/span>\ndef<\/span> <\/span>show_events<\/span>(<\/span><\/span>\n  <\/span>show_past<\/span>:<\/span> Annotated<\/span>[<\/span>bool<\/span>,<\/span> typer<\/span>.<\/span>Option<\/span>()]<\/span> <\/span>=<\/span> <\/span>False<\/span>,<\/span><\/span>\n)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
There is a lot going here so let’s take it apart.  The first thing is this Annotated <\/code>type from the typing <\/code>module.  It let’s us add metadata to a type.  In this case we are using it to tell Typer that show_past <\/code>is of type bool and that it should be a CLI option with the typer.Option()<\/code> function.  In addition, the default value of show_past <\/code>is True<\/code>.  Since the option is a bool<\/code>, Typer will make some assumptions for us.  It will create command line options: --show-past<\/code> and --no-show-past<\/code>.  If --show-past<\/code> is present in the command, the show_past <\/code>parameter will receive a value of True<\/code>.  If --no-show-past<\/code> is present, the show_past <\/code>parameter will receive a value of False<\/code>.  Since the default value of show_past <\/code>is True<\/code>, omitting both options will be the same as --show-past<\/code> being present in the show-events<\/code> command.<\/p>\n\n\n\n
For show_private<\/code>, we can do the same thing:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
@<\/span>app<\/span>.<\/span>command<\/span>()<\/span><\/span>\ndef<\/span> <\/span>show_events<\/span>(<\/span><\/span>\n  <\/span>show_past<\/span>:<\/span> Annotated<\/span>[<\/span>bool<\/span>,<\/span> typer<\/span>.<\/span>Option<\/span>()]<\/span> <\/span>=<\/span> <\/span>True<\/span>,<\/span><\/span>\n  <\/span>show_private<\/span>:<\/span> Annotated<\/span>[<\/span>bool<\/span>,<\/span> typer<\/span>.<\/span>Option<\/span>()]<\/span> <\/span>=<\/span> <\/span>False<\/span><\/span>\n)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The show_private <\/code>parameter has a default value of False<\/code>.  Therefore, of the two CLI options, --show-private<\/code> and --no-show-private<\/code>, --no-show-private<\/code> will be the default if neither is included in the show-events <\/code>command.<\/p>\n\n\n\n
TLDR: By default the show-events<\/code> command will show past events, but not private events.  Now let’s make it work.<\/p>\n\n\n\n
In show_events<\/code>, remove the code that executes the select statement that retrieves all of the events.  Replace it with the select <\/code>statement and order the events by timestamp in ascending order:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
query <\/span>=<\/span> <\/span>select<\/span>(<\/span>Event<\/span>).<\/span>order_by<\/span>(<\/span>Event<\/span>.<\/span>timestamp<\/span>.<\/span>asc<\/span>())<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This statement selects all events regardless of whether they are past or private.  Now we can add where clauses to the statement to filter the data based on the options.  If the --no-show-past <\/code>option is present, we should only include events with a timestamp <\/code>of today or later:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
query <\/span>=<\/span> <\/span>select<\/span>(<\/span>Event<\/span>).<\/span>order_by<\/span>(<\/span>Event<\/span>.<\/span>timestamp<\/span>.<\/span>asc<\/span>())<\/span><\/span>\nif<\/span> <\/span>not<\/span> show_past<\/span>:<\/span><\/span>\n  query <\/span>=<\/span> query<\/span>.<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>timestamp <\/span>>=<\/span> datetime<\/span>.<\/span>date<\/span>.<\/span>today<\/span>())<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
And if the --no-show-private<\/code> option is present, we should only include events where private <\/code>is False<\/code>:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
query <\/span>=<\/span> <\/span>select<\/span>(<\/span>Event<\/span>).<\/span>order_by<\/span>(<\/span>Event<\/span>.<\/span>timestamp<\/span>.<\/span>asc<\/span>())<\/span><\/span>\nif<\/span> <\/span>not<\/span> show_past<\/span>:<\/span><\/span>\n  query <\/span>=<\/span> query<\/span>.<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>timestamp <\/span>>=<\/span> datetime<\/span>.<\/span>date<\/span>.<\/span>today<\/span>())<\/span><\/span>\nif<\/span> <\/span>not<\/span> show_private<\/span>:<\/span><\/span>\n  query <\/span>=<\/span> query<\/span>.<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>private <\/span>==<\/span> <\/span>False<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
And now you can execute the statement and retrieve the results with the session<\/code>:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
query <\/span>=<\/span> <\/span>select<\/span>(<\/span>Event<\/span>).<\/span>order_by<\/span>(<\/span>Event<\/span>.<\/span>timestamp<\/span>.<\/span>asc<\/span>())<\/span><\/span>\nif<\/span> <\/span>not<\/span> show_past<\/span>:<\/span><\/span>\n  query <\/span>=<\/span> query<\/span>.<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>timestamp <\/span>>=<\/span> datetime<\/span>.<\/span>date<\/span>.<\/span>today<\/span>())<\/span><\/span>\nif<\/span> <\/span>not<\/span> show_private<\/span>:<\/span><\/span>\n  query <\/span>=<\/span> query<\/span>.<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>private <\/span>==<\/span> <\/span>False<\/span>)<\/span><\/span>\nevents <\/span>=<\/span> session<\/span>.<\/span>exec<\/span>(<\/span>query<\/span>).<\/span>all<\/span>()<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The result of the code remains the same!<\/p>\n\n\n\n
At the command line, get the help for the show-events<\/code> command:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> <\/span>--help<\/span><\/span>\n                                                                                                                                             <\/span><\/span>\n <\/span>Usage:<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> [OPTIONS]                                                                                                        <\/span><\/span>\n                                                                                                                                             <\/span><\/span>\n\u256d\u2500Options\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u256e<\/span><\/span>\n\u2502<\/span> <\/span>--show-past<\/span>       <\/span>--no-show-past<\/span>         [default: <\/span>show-past]<\/span>           <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>--show-private<\/span>    <\/span>--no-show-private<\/span>      [default: <\/span>no-show-private]<\/span>     <\/span>\u2502<\/span>                                                                  <\/span><\/span>\n\u2502<\/span> <\/span>--help<\/span>                                   <\/span>Show<\/span> <\/span>this<\/span> <\/span>message<\/span> <\/span>and<\/span> <\/span>exit.<\/span>    <\/span>\u2502<\/span>                                                                  <\/span><\/span>\n\u2570\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u256f<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
As explained about the default options are --show-past<\/code> and --no-show-private<\/code>.  So invoking the show-events<\/code> command without any options will display all events that are not private.  Let’s see if it does:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span><\/span>\n                  <\/span>Events<\/span>                   <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>Title<\/span>        <\/span>\u2503<\/span> <\/span>Days<\/span> <\/span>Remaining<\/span> <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>Past<\/span> <\/span>Event<\/span>   <\/span>\u2502<\/span> <\/span>-10<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Normal<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>22<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The output shows the one past event (again, as of the date of writing this post) and does not show the private event.  To show the private event, invoke the show-events<\/code> command with the --show-private<\/code> option:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> <\/span>--show-private<\/span><\/span>\n                   <\/span>Events<\/span>                   <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>Title<\/span>         <\/span>\u2503<\/span> <\/span>Days<\/span> <\/span>Remaining<\/span> <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>Past<\/span> <\/span>Event<\/span>    <\/span>\u2502<\/span> <\/span>-10<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Normal<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>22<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Private<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>51<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This is the equivalent of showing all events.  And we can add the --no-show-past <\/code>option to omit past events:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> <\/span>--show-private<\/span> <\/span>--no-show-past<\/span><\/span>\n                   <\/span>Events<\/span>                   <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>Title<\/span>         <\/span>\u2503<\/span> <\/span>Days<\/span> <\/span>Remaining<\/span> <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>Normal<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>22<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Private<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>51<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Note that you cannot use both --show-private<\/code> and --no-show-private<\/code> (or --show-past<\/code> and --no-show-past<\/code>) at the same time.<\/p>\n\n\n\n
And since showing private events is controlled by the options, you can remove the Private <\/strong>column from the table.  Again, in a later post we’ll show how to use styles to format the events in the table.<\/p>\n\n\n\n
Removing<\/h3>\n\n\n\n
I’ve added a few more events to the database:<\/p>\n\n\n\n
Title<\/strong><\/td>Timestamp<\/strong><\/td>Private<\/strong><\/td><\/tr>
Normal Event<\/td>February 2, 2025<\/td>No<\/td><\/tr>
Past Event<\/td>January 1, 2025<\/td>No<\/td><\/tr>
Private Event<\/td>March 3, 2025<\/td>Yes<\/td><\/tr>
Yesterday<\/td>January 10, 2025<\/td>No<\/td><\/tr>
Secret Event<\/td>April 4, 2025<\/td>Yes<\/td><\/tr>
Cinco de Mayo<\/td>May 5, 2025<\/td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
In this section we will add a new command, remove-event<\/code>.  By default, it will list all future events in a table and ask the user to select one to remove.  It will also have an option to remove all past events.  Let’s start with removing a single event.<\/p>\n\n\n\n
Write the command function and in a session, create and execute a select statement for all events in the future.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
@<\/span>app<\/span>.<\/span>command<\/span>()<\/span><\/span>\ndef<\/span> <\/span>remove_event<\/span>():<\/span><\/span>\n  <\/span>with<\/span> <\/span>Session<\/span>(<\/span>engine<\/span>)<\/span> <\/span>as<\/span> session<\/span>:<\/span><\/span>\n    query <\/span>=<\/span> <\/span>select<\/span>(<\/span>Event<\/span>).<\/span>where<\/span>(<\/span><\/span>\n      Event<\/span>.<\/span>timestamp <\/span>>=<\/span> datetime<\/span>.<\/span>date<\/span>.<\/span>today<\/span>()<\/span><\/span>\n    <\/span>).<\/span>order_by<\/span>(<\/span><\/span>\n      Event<\/span>.<\/span>timestamp<\/span>.<\/span>asc<\/span>()<\/span><\/span>\n    <\/span>)<\/span><\/span>\n    events <\/span>=<\/span> session<\/span>.<\/span>exec<\/span>(<\/span>query<\/span>).<\/span>all<\/span>()<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Display the events, with their IDs, in a table:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
event_table <\/span>=<\/span> <\/span>Table<\/span>(<\/span>title<\/span>=<\/span>"<\/span>Events<\/span>"<\/span>,<\/span> <\/span>show_header<\/span>=True<\/span>)<\/span><\/span>\nevent_table<\/span>.<\/span>add_column<\/span>(<\/span>"<\/span>ID<\/span>"<\/span>)<\/span><\/span>\nevent_table<\/span>.<\/span>add_column<\/span>(<\/span>"<\/span>Title<\/span>"<\/span>)<\/span><\/span>\nevent_table<\/span>.<\/span>add_column<\/span>(<\/span>"<\/span>Timestamp<\/span>"<\/span>)<\/span><\/span>\nevent_table<\/span>.<\/span>add_column<\/span>(<\/span>"<\/span>Private<\/span>"<\/span>)<\/span><\/span>\n<\/span>\nfor<\/span> event <\/span>in<\/span> events<\/span>:<\/span><\/span>\n  event_table<\/span>.<\/span>add_row<\/span>(<\/span><\/span>\n    <\/span>str<\/span>(<\/span>event<\/span>.<\/span>id<\/span>),<\/span><\/span>\n    event<\/span>.<\/span>title<\/span>,<\/span><\/span>\n    event<\/span>.<\/span>timestamp<\/span>.<\/span>strftime<\/span>(<\/span>"<\/span>%Y-%m-<\/span>%d<\/span>"<\/span>),<\/span><\/span>\n    <\/span>"<\/span>Yes<\/span>"<\/span> <\/span>if<\/span> event<\/span>.<\/span>private <\/span>else<\/span> <\/span>"<\/span>No<\/span>"<\/span><\/span>\n  <\/span>)<\/span><\/span>\nconsole<\/span>.<\/span>print<\/span>(<\/span>event_table<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Now prompt the user for the ID of the event to remove.  Remember to response to an integer as the Prompt.ask <\/code>function returns a string back to us.  For now, we’ll assume the user enters a valid ID:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
event_id <\/span>=<\/span> <\/span>int<\/span>(<\/span><\/span>\n  Prompt<\/span>.<\/span>ask<\/span>(<\/span><\/span>\n    <\/span>"<\/span>What is the ID of the event you want to remove<\/span>"<\/span><\/span>\n  <\/span>)<\/span><\/span>\n)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Since this is a destructive action, we should confirm the user’s choice.  This presents a case for the choices <\/code>keyword argument to the Prompt.ask <\/code>function.  In this case, we want the user to respond with “y” or “n”.  We can also mark one of the choices <\/code>as the default <\/code>value:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
if<\/span> Prompt<\/span>.<\/span>ask<\/span>(<\/span><\/span>\n  <\/span>f<\/span>"Are you sure you want to remove the event with ID <\/span>{<\/span>event_id<\/span>}<\/span>"<\/span>,<\/span> <\/span><\/span>\n  <\/span>choices<\/span>=<\/span>[<\/span>"<\/span>y<\/span>"<\/span>,<\/span> <\/span>"<\/span>n<\/span>"<\/span>],<\/span> <\/span><\/span>\n  <\/span>default<\/span>=<\/span>"<\/span>n<\/span>"<\/span><\/span>\n)<\/span> <\/span>==<\/span> <\/span>"<\/span>y<\/span>"<\/span>:<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
If the user confirms get the event to be removed.  For this we can use a special shortcut method of the session that selects an object by the primary key.  The get <\/code>method accepts the type of the object and the value of the primary key.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
selected <\/span>=<\/span> session<\/span>.<\/span>get<\/span>(<\/span>Event<\/span>,<\/span> event_id<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Use the session <\/code>to delete <\/code>the object and then commit <\/code>the changes<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
session<\/span>.<\/span>delete<\/span>(<\/span>selected<\/span>)<\/span><\/span>\nsession<\/span>.<\/span>commit<\/span>()<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Print a confirmation to the user and we’re done!<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
console<\/span>.<\/span>print<\/span>(<\/span><\/span>\n  <\/span>f<\/span>"Removed event with ID <\/span>{<\/span>event_id<\/span>}<\/span>"<\/span>,<\/span> <\/span><\/span>\n  <\/span>style<\/span>=<\/span>app_styles<\/span>.<\/span>success<\/span><\/span>\n)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Removing an event is simple:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>remove-event<\/span><\/span>\n                   <\/span>Events<\/span>                    <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>ID<\/span> <\/span>\u2503<\/span> <\/span>Title<\/span>         <\/span>\u2503<\/span> <\/span>Timestamp<\/span>  <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>2<\/span>  <\/span>\u2502<\/span> <\/span>Normal<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>2025<\/span>-02-02<\/span> <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>3<\/span>  <\/span>\u2502<\/span> <\/span>Private<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>2025<\/span>-03-03<\/span> <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>5<\/span>  <\/span>\u2502<\/span> <\/span>Secret<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>2025<\/span>-04-04<\/span> <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>6<\/span>  <\/span>\u2502<\/span> <\/span>Cinco<\/span> <\/span>de<\/span> <\/span>Mayo<\/span> <\/span>\u2502<\/span> <\/span>2025<\/span>-05-05<\/span> <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span>\nWhat<\/span> <\/span>is<\/span> <\/span>the<\/span> <\/span>ID<\/span> <\/span>of<\/span> <\/span>the<\/span> <\/span>event<\/span> <\/span>you<\/span> <\/span>want<\/span> <\/span>to<\/span> <\/span>remove:<\/span> <\/span>2<\/span><\/span>\nAre<\/span> <\/span>you<\/span> <\/span>sure<\/span> <\/span>you<\/span> <\/span>want<\/span> <\/span>to<\/span> <\/span>remove<\/span> <\/span>the<\/span> <\/span>event<\/span> <\/span>with<\/span> <\/span>ID<\/span> <\/span>2<\/span> [y\/n] <\/span>(<\/span>n<\/span>)<\/span>: y<\/span><\/span>\nRemoving<\/span> <\/span>event<\/span> <\/span>with<\/span> <\/span>ID<\/span> <\/span>2<\/span><\/span>\n<\/span>\n$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> <\/span>--show-private<\/span><\/span>\n                   <\/span>Events<\/span>                   <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>Title<\/span>         <\/span>\u2503<\/span> <\/span>Days<\/span> <\/span>Remaining<\/span> <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>Past<\/span> <\/span>Event<\/span>    <\/span>\u2502<\/span> <\/span>-10<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Yesterday<\/span>     <\/span>\u2502<\/span> <\/span>-1<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Private<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>51<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Secret<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>83<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Cinco<\/span> <\/span>de<\/span> <\/span>Mayo<\/span> <\/span>\u2502<\/span> <\/span>114<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Now let’s add an option to remove all past events.  First add a parameter to the command function using the Annotated <\/code>type.  The default value is False:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
def<\/span> <\/span>remove_event<\/span>(<\/span><\/span>\n  <\/span>purge_past<\/span>:<\/span> Annotated<\/span>[<\/span>bool<\/span>,<\/span> typer<\/span>.<\/span>Option<\/span>()]<\/span> <\/span>=<\/span> <\/span>False<\/span><\/span>\n)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Inside of the with <\/code>block for the session<\/code>, add a condition to check the value of purge_past<\/code>.  If it is True, delete the past events.  If False<\/code>, run the code to list the events and select one to remove by ID:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
with<\/span> <\/span>Session<\/span>(<\/span>engine<\/span>)<\/span> <\/span>as<\/span> session<\/span>:<\/span><\/span>\n  <\/span>if<\/span> purge_past<\/span>:<\/span><\/span>\n    <\/span># delete past events<\/span><\/span>\n  <\/span>else<\/span>:<\/span><\/span>\n    <\/span># delete simgle event<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Again this is a destructive action so we’ll ask the user to confirm:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
if<\/span> purge_past<\/span>:<\/span><\/span>\n  <\/span>if<\/span> Prompt<\/span>.<\/span>ask<\/span>(<\/span>"<\/span>Are you sure you want to remove past events<\/span>"<\/span>,<\/span><\/span>\n                <\/span>choices<\/span>=<\/span>[<\/span>"<\/span>y<\/span>"<\/span>,<\/span> <\/span>"<\/span>n<\/span>"<\/span>],<\/span><\/span>\n                <\/span>default<\/span>=<\/span>"<\/span>n<\/span>"<\/span>)<\/span> <\/span>==<\/span> <\/span>"<\/span>y<\/span>"<\/span>:<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Since we want to delete multiple events we will use the delete <\/code>function from the sqlmodel <\/code>package:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
from<\/span> sqlmodel <\/span>import<\/span> Field<\/span>,<\/span> Session<\/span>,<\/span> SQLModel<\/span>,<\/span> create_engine<\/span>,<\/span> delete<\/span>,<\/span> select<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The statement itself is just like a select statement, except using the delete <\/code>function:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
if<\/span> purge_past<\/span>:<\/span><\/span>\n  <\/span>if<\/span> Prompt<\/span>.<\/span>ask<\/span>(<\/span>"<\/span>Are you sure you want to remove past events<\/span>"<\/span>,<\/span><\/span>\n                <\/span>choices<\/span>=<\/span>[<\/span>"<\/span>y<\/span>"<\/span>,<\/span> <\/span>"<\/span>n<\/span>"<\/span>],<\/span><\/span>\n                <\/span>default<\/span>=<\/span>"<\/span>n<\/span>"<\/span>)<\/span> <\/span>==<\/span> <\/span>"<\/span>y<\/span>"<\/span>:<\/span><\/span>\n    query <\/span>=<\/span> <\/span>delete<\/span>(<\/span>Event<\/span>).<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>timestamp <\/span><<\/span> datetime<\/span>.<\/span>date<\/span>.<\/span>today<\/span>())<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
To finish up, execute the statement, commit the changes and print a confirmation to the user:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
if<\/span> purge_past<\/span>:<\/span><\/span>\n  <\/span>if<\/span> Prompt<\/span>.<\/span>ask<\/span>(<\/span>"<\/span>Are you sure you want to remove past events<\/span>"<\/span>,<\/span><\/span>\n                <\/span>choices<\/span>=<\/span>[<\/span>"<\/span>y<\/span>"<\/span>,<\/span> <\/span>"<\/span>n<\/span>"<\/span>],<\/span><\/span>\n                <\/span>default<\/span>=<\/span>"<\/span>n<\/span>"<\/span>)<\/span> <\/span>==<\/span> <\/span>"<\/span>y<\/span>"<\/span>:<\/span><\/span>\n    query <\/span>=<\/span> <\/span>delete<\/span>(<\/span>Event<\/span>).<\/span>where<\/span>(<\/span>Event<\/span>.<\/span>timestamp <\/span><<\/span> datetime<\/span>.<\/span>date<\/span>.<\/span>today<\/span>())<\/span><\/span>\n    session<\/span>.<\/span>exec<\/span>(<\/span>query<\/span>)<\/span><\/span>\n    session<\/span>.<\/span>commit<\/span>()<\/span><\/span>\n    console<\/span>.<\/span>print<\/span>(<\/span>"<\/span>Removed all past events<\/span>"<\/span>,<\/span> <\/span>style<\/span>=<\/span>app_styles<\/span>.<\/span>success<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Currently, there are 5 events in the database, 2 are past events.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> <\/span>--show-private<\/span><\/span>\n                   <\/span>Events<\/span>                   <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>Title<\/span>         <\/span>\u2503<\/span> <\/span>Days<\/span> <\/span>Remaining<\/span> <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>Past<\/span> <\/span>Event<\/span>    <\/span>\u2502<\/span> <\/span>-10<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Yesterday<\/span>     <\/span>\u2502<\/span> <\/span>-1<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Private<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>51<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Secret<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>83<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Cinco<\/span> <\/span>de<\/span> <\/span>Mayo<\/span> <\/span>\u2502<\/span> <\/span>114<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Invoke the remove-event command with the --purge-past<\/code> option:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>remove-event<\/span> <\/span>--purge-past<\/span><\/span>\nAre<\/span> <\/span>you<\/span> <\/span>sure<\/span> <\/span>you<\/span> <\/span>want<\/span> <\/span>to<\/span> <\/span>remove<\/span> <\/span>past<\/span> <\/span>events<\/span> [y\/n] <\/span>(<\/span>n<\/span>)<\/span>: y<\/span><\/span>\nRemoved<\/span> <\/span>all<\/span> <\/span>past<\/span> <\/span>events<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
And see the past events are no longer in the list:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
$<\/span> <\/span>python<\/span> <\/span>main.py<\/span> <\/span>show-events<\/span> <\/span>--show-private<\/span><\/span>\n                   <\/span>Events<\/span>                   <\/span><\/span>\n\u250f\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2533\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2513<\/span><\/span>\n\u2503<\/span> <\/span>Title<\/span>         <\/span>\u2503<\/span> <\/span>Days<\/span> <\/span>Remaining<\/span> <\/span>\u2503<\/span> <\/span>Private<\/span> <\/span>\u2503<\/span><\/span>\n\u2521\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2547\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2501\u2529<\/span><\/span>\n\u2502<\/span> <\/span>Private<\/span> <\/span>Event<\/span> <\/span>\u2502<\/span> <\/span>51<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Secret<\/span> <\/span>Event<\/span>  <\/span>\u2502<\/span> <\/span>83<\/span> <\/span>remaining<\/span>   <\/span>\u2502<\/span> <\/span>Yes<\/span>     <\/span>\u2502<\/span><\/span>\n\u2502<\/span> <\/span>Cinco<\/span> <\/span>de<\/span> <\/span>Mayo<\/span> <\/span>\u2502<\/span> <\/span>114<\/span> <\/span>remaining<\/span>  <\/span>\u2502<\/span> <\/span>No<\/span>      <\/span>\u2502<\/span><\/span>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Summary<\/h3>\n\n\n\n
In this post, you saw how to create options for Typer commands.  You used these options along with the where method in the SQLModel API to filter data in the database.  You also saw two different ways to delete data.  The first is to select a single object and delete it using a session.  The second is to use the delete function the in SQLModel API to delete multiple objects at the same time.<\/p>\n","protected":false},"excerpt":{"rendered":"
In the previous post, we saw how to use SQLModel to implement the Event data…<\/p>\n","protected":false},"author":1,"featured_media":267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[31,4,30,32,28,24],"class_list":["post-263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python","tag-cli","tag-python","tag-rich","tag-sqlmodel","tag-typer","tag-vscode"],"_links":{"self":[{"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/posts\/263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/comments?post=263"}],"version-history":[{"count":4,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/posts\/263\/revisions"}],"predecessor-version":[{"id":272,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/posts\/263\/revisions\/272"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/media\/267"}],"wp:attachment":[{"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/media?parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/categories?post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/douglasstarnes.dev\/index.php\/wp-json\/wp\/v2\/tags?post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}