Unit Instance

HTTP 200 OK
Allow: GET, PUT, PATCH, DELETE, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "translation": "https://l10n.opensuse.org/api/translations/packages-i18n/perl-master/cs/?format=api",
    "source": [
        "This module was inspired by the excellent DBIx::Abstract. However, in using that module I found that what I really wanted to do was generate SQL, but still retain complete control over my statement handles and use the DBI interface. So, I set out to create an abstract SQL generation module.\n\nWhile based on the concepts used by DBIx::Abstract, there are several important differences, especially when it comes to WHERE clauses. I have modified the concepts used to make the SQL easier to generate from Perl data structures and, IMO, more intuitive. The underlying idea is for this module to do what you mean, based on the data structures you provide it. The big advantage is that you don't have to modify your code every time your data changes, as this module figures it out.\n\nTo begin with, an SQL INSERT is as easy as just specifying a hash of 'key=value' pairs:\n\n    my %data = (         name => 'Jimbo Bobson',         phone => '123-456-7890',         address => '42 Sister Lane',         city => 'St. Louis',         state => 'Louisiana',     );\n\nThe SQL can then be generated with this:\n\n    my($stmt, @bind) = $sql->insert('people', \\%data);\n\nWhich would give you something like this:\n\n    $stmt = \"INSERT INTO people                     (address, city, name, phone, state)                     VALUES (?, ?, ?, ?, ?)\";     @bind = ('42 Sister Lane', 'St. Louis', 'Jimbo Bobson',              '123-456-7890', 'Louisiana');\n\nThese are then used directly in your DBI code:\n\n    my $sth = $dbh->prepare($stmt);     $sth->execute(@bind);"
    ],
    "previous_source": "",
    "target": [
        ""
    ],
    "id_hash": -6120440729888793583,
    "content_hash": -6120440729888793583,
    "location": "",
    "context": "",
    "note": "leap/perl-SQL-Abstract/description",
    "flags": "",
    "labels": [],
    "state": 0,
    "fuzzy": false,
    "translated": false,
    "approved": false,
    "position": 1726,
    "has_suggestion": false,
    "has_comment": false,
    "has_failing_check": false,
    "num_words": 236,
    "source_unit": "https://l10n.opensuse.org/api/units/12653800/?format=api",
    "priority": 100,
    "id": 7120261,
    "web_url": "https://l10n.opensuse.org/translate/packages-i18n/perl-master/cs/?checksum=2b0fd3956a255c11",
    "url": "https://l10n.opensuse.org/api/units/7120261/?format=api",
    "explanation": "",
    "extra_flags": "",
    "pending": false,
    "timestamp": "2017-07-16T13:17:50.067327Z"
}