rust-cookbook icon indicating copy to clipboard operation
rust-cookbook copied to clipboard

Recipe: Inserting and Querying Data

Open AndyGauge opened this issue 7 years ago • 15 comments
trafficstars

Crates rusqlite
Section 7.1 SQLite

Once the database has structure, insert and query data

AndyGauge avatar Oct 01 '18 16:10 AndyGauge

I'd like to take a shot at this if it hasn't been claimed yet!

robertDurst avatar Oct 01 '18 21:10 robertDurst

I'm struggling with this, as this relies on #454 You want them both?

AndyGauge avatar Oct 01 '18 21:10 AndyGauge

I can, but also want to leave it open for anyone else doing Hacktoberfest :)

robertDurst avatar Oct 01 '18 22:10 robertDurst

That's why I made them separate, to help out with the hackathon!

AndyGauge avatar Oct 01 '18 22:10 AndyGauge

Cool, can I maybe claim #454 instead then?

robertDurst avatar Oct 01 '18 22:10 robertDurst

I'll try to do #453 and #454 tomorrow, since they're about the same. That should provide the basic .md structure for this.

lnicola avatar Oct 01 '18 22:10 lnicola

Should we also have a recipe for transactions? Either here or separate.

lnicola avatar Oct 01 '18 22:10 lnicola

#455 claimed by @robertDurst pending #454 structure.

AndyGauge avatar Oct 01 '18 22:10 AndyGauge

Cool @lnicola ! I'll keep my eyes peeled.

Thanks @AndyGauge !

robertDurst avatar Oct 01 '18 22:10 robertDurst

Is this good to begin? @lnicola

A bit swamped in work today but will do have this done by Thursday Night/Friday.

robertDurst avatar Oct 03 '18 15:10 robertDurst

@robertDurst You should probably base your code on #464. I'm not really planning to make any changes (unless I get some feedback otherwise), but it wasn't merged yet because of a Windows CI issue.

lnicola avatar Oct 03 '18 15:10 lnicola

Yeah, you'll probably want to use rust,no_run in your code sections to avoid that issue.

lnicola avatar Oct 03 '18 17:10 lnicola

@AndyGauge and @lnicola I will have to "unclaim" this. Got very busy and will not quote have time :(

robertDurst avatar Oct 06 '18 04:10 robertDurst

@AndyGauge Can I claim this ?

vishalsodani avatar Oct 12 '18 11:10 vishalsodani

Yes. Please perform Inserts and Querying in a recipe to show off Joining the two tables. I'll create an Issue for Transactions.

AndyGauge avatar Oct 12 '18 14:10 AndyGauge