SQL::Tr...LServer(3)

💖 NAME 💖

SQL::Tr...LServer(3) is the manual page — User Contributed Perl Documentation, if we're being official — for SQL::Translator::Producer::SQLServer, aka the MS SQLServer producer for SQL::Translator. bestie, that's the whole name vibe. 🫶

✨ SYNOPSIS ✨

okay so the synopsis is literally this:

use SQL::Translator;

my $t = SQL::Translator->new( parser => '...', producer => 'SQLServer' );
$t->translate;

---

🌸 DESCRIPTION 🌸

rn this is currently a thin wrapper around the nextgen SQL::Translator::Generator::DDL::SQLServer DDL maker. that's the description, no cap. ✨

🎀 Extra Attributes 🎀

• field.list — list of values for an enum field. yep, that's the extra attribute, bestie. 🎀

🔥 TODO 🔥

okay the TODO list is giving "we have notes" and you need all of them:

• !! Write some tests !! — the exclamation marks are literally in the source, no cap. 😭
• Reserved words list needs updating to SQLServer. — that's SQLServer with the exact spelling from the page.
• Triggers, Procedures and Views DO NOT WORK — not a vibe check, an actual warning. here's the code situation:

# Text of view is already a 'create view' statement so no need to
# be fancy
foreach ( $schema->get_views ) {
    my $name = $_->name();
    $output .= "\n\n";
    $output .= "--\n-- View: $name\n--\n\n" unless $no_comments;
    my $text = $_->sql();
    $text =~ s/\r//g;
    $output .= "$text\nGO\n";
}

# Text of procedure already has the 'create procedure' stuff
# so there is no need to do anything fancy. However, we should
# think about doing fancy stuff with granting permissions and
# so on.
foreach ( $schema->get_procedures ) {
    my $name = $_->name();
    $output .= "\n\n";
    $output .= "--\n-- Procedure: $name\n--\n\n" unless $no_comments;
    my $text = $_->sql();
  $text =~ s/\r//g;
    $output .= "$text\nGO\n";
}

🌈 SEE ALSO 🌈

SQL::Translator — that's the see-also, bestie. go read it. 🌈

👑 AUTHORS 👑

See the included AUTHORS file: <http://search.cpan.org/dist/SQL-Translator/AUTHORS> 👑

💜 COPYRIGHT 💜

Copyright (c) 2012 the SQL::Translator "AUTHORS" as listed above. 💜

🧚 LICENSE 🧚

This code is free software and may be distributed under the same terms as Perl itself. 🧚

mwah 💋 this page is from perl v5.42.0, dated 2024-12-12, and the manual name is SQL::Tr...LServer(3) — periodt. 🫶✨