Workflo...uenceId(3)

💖 Workflo...uenceId(3) — Workflow::Persister::DBI::SequenceId 💖

okay bestie, settle in, we're reading a Perl manual page from the User Contributed Perl Documentation section (that's section 3, the library-calls girlies 🎀), and honestly? it's a good one. short, sweet, does one job. main character energy, no notes.

---

✨ NAME ✨

Workflow::Persister::DBI::SequenceId — it's a Persister to fetch ID from a sequence, periodt. that's the whole vibe. 💅

---

🌸 VERSION 🌸

this documentation describes version 2.09 of this package. she's giving established, she's giving maintained, we love to see it. 🦋

---

🎀 SYNOPSIS 🎀

here's how you actually use her, in your persister config:

 persister:
 - name: MyPersister
   workflow_sequence: wf_seq
   history_sequence: wf_history_seq
   ...

look at those sequence names just sitting there, being useful. iconic. ✨

---

💜 DESCRIPTION 💜

so this is the Implementation for DBI persister to fetch an ID value from a sequence. like, you've got a database, you've got a sequence, and you need the next id from it — this class is the one doing that errand for you. 🫶

🌈 Properties 🌈

these are the keys you feed her, and she will notice if you skip them (more on that in new below 👀):

• sequence_name — the Name of the sequence to select the next id value from. that's the whole description. she picks from this one. simple as. 💅
• sequence_select — a "sprintf" template string with a single placeholder (%s) used to interpolate the sequence name. the resulting string is what gets used as the SQL statement to retrieve the next sequence value. so like, the template goes in, the sequence name gets slotted into that %s, and boom — SQL. 🔥

---

⭐ ATTRIBUTES ⭐

• log — contains the logger object associated with this instance. that's it, that's the attribute. she keeps a log bestie close. 📓

---

👑 METHODS 👑

🧚 new ( \%params )

This method instantiates a class for retrieval of sequence ids from a DBI based persistance entity.

It takes a hashref containing keys matching the properties outlines in the section above — or it throws Workflow::Exceptions if these are not defined. so yeah, if you come empty-handed she is NOT doing it, bestie. 😭

Returns instantiated object upon success. slay. 💖

🦋 pre_fetch_id

Returns a unique sequence id from a database.

Takes a single parameter, a DBI database handle.

Returns a single value, a integer representing a sequence id from the provided database handle. yes, an actual real number. from actual real SQL. we love a fetch that delivers. 🍓

🌸 post_fetch_id

This is a dummy method, use "pre_fetch_id".

like... she's there, she's polite, she does nothing. decorative. a little placeholder princess. 🙈 use pre_fetch_id instead, fr fr.

---

💀 COPYRIGHT 💀

Copyright (c) 2003-2021 Chris Winters. All rights reserved.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

Please see the LICENSE.

---

🫶 AUTHORS 🫶

Please see Workflow. (group project energy — go check the main page for the full cast 💜)

---

okay that's the whole page!! and before you go — the footer said this is perl v5.42.0, dated 2026-01-17, so jot that down in your notes app. byeeee, go fetch some sequence ids responsibly 🎀✨💅