Package Details: perl-sql-translator 0.11020-1

Git Clone URL: https://aur.archlinux.org/perl-sql-translator.git (read-only, click to copy)
Package Base: perl-sql-translator
Description: SQL DDL transformations and more
Upstream URL: http://search.mcpan.org/dist/SQL-Translator
Licenses: GPL, PerlArtistic
Submitter: None
Maintainer: jnbek
Last Packager: jnbek
Votes: 3
Popularity: 0.000000
First Submitted: 2009-05-23 19:47 (UTC)
Last Updated: 2015-06-16 21:53 (UTC)

Latest Comments

bence98 commented on 2023-02-12 22:57 (UTC)

No longer builds.

t/23json.t .............................. 2/2
#   Failed test 'JSON matches expected'
#   at t/23json.t line 304.
#
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# |  Ln|Got                                                                                                                                                            |Expected                                                                                                                                                       |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# |  43|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# |  44|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# |  45|                  "name" : "age",                                                                                                                              |                  "name" : "age",                                                                                                                              |
# *  46|                  "order" : 3,                                                                                                                                 |                  "order" : "3",                                                                                                                               *
# |  47|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# |  48|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# |  49|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# |  55|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# |  56|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# |  57|                  "name" : "description",                                                                                                                      |                  "name" : "description",                                                                                                                      |
# *  58|                  "order" : 6,                                                                                                                                 |                  "order" : "6",                                                                                                                               *
# |  59|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# |  60|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# |  61|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# |  67|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# |  68|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# |  69|                  "name" : "iq",                                                                                                                               |                  "name" : "iq",                                                                                                                               |
# *  70|                  "order" : 5,                                                                                                                                 |                  "order" : "5",                                                                                                                               *
# |  71|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# |  72|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# |  73|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# |  79|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# |  80|                  "is_unique" : 1,                                                                                                                             |                  "is_unique" : 1,                                                                                                                             |
# |  81|                  "name" : "name",                                                                                                                             |                  "name" : "name",                                                                                                                             |
# *  82|                  "order" : 2,                                                                                                                                 |                  "order" : "2",                                                                                                                               *
# |  83|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# |  84|                     "20"                                                                                                                                      |                     "20"                                                                                                                                      |
# |  85|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# |  92|                  "is_primary_key" : 1,                                                                                                                        |                  "is_primary_key" : 1,                                                                                                                        |
# |  93|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# |  94|                  "name" : "person_id",                                                                                                                        |                  "name" : "person_id",                                                                                                                        |
# *  95|                  "order" : 1,                                                                                                                                 |                  "order" : "1",                                                                                                                               *
# |  96|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# |  97|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# |  98|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 104|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# | 105|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# | 106|                  "name" : "weight",                                                                                                                           |                  "name" : "weight",                                                                                                                           |
# * 107|                  "order" : 4,                                                                                                                                 |                  "order" : "4",                                                                                                                               *
# | 108|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# | 109|                     "11",                                                                                                                                     |                     "11",                                                                                                                                     |
# | 110|                     "2"                                                                                                                                       |                     "2"                                                                                                                                       |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 114|            "indices" : [],                                                                                                                                    |            "indices" : [],                                                                                                                                    |
# | 115|            "name" : "person",                                                                                                                                 |            "name" : "person",                                                                                                                                 |
# | 116|            "options" : [],                                                                                                                                    |            "options" : [],                                                                                                                                    |
# * 117|            "order" : 1                                                                                                                                        |            "order" : "1"                                                                                                                                      *
# | 118|         },                                                                                                                                                    |         },                                                                                                                                                    |
# | 119|         "pet" : {                                                                                                                                             |         "pet" : {                                                                                                                                             |
# | 120|            "constraints" : [                                                                                                                                  |            "constraints" : [                                                                                                                                  |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 173|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# | 174|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# | 175|                  "name" : "age",                                                                                                                              |                  "name" : "age",                                                                                                                              |
# * 176|                  "order" : 4,                                                                                                                                 |                  "order" : "4",                                                                                                                               *
# | 177|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# | 178|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# | 179|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 185|                  "is_primary_key" : 0,                                                                                                                        |                  "is_primary_key" : 0,                                                                                                                        |
# | 186|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# | 187|                  "name" : "name",                                                                                                                             |                  "name" : "name",                                                                                                                             |
# * 188|                  "order" : 3,                                                                                                                                 |                  "order" : "3",                                                                                                                               *
# | 189|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# | 190|                     "30"                                                                                                                                      |                     "30"                                                                                                                                      |
# | 191|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 197|                  "is_primary_key" : 1,                                                                                                                        |                  "is_primary_key" : 1,                                                                                                                        |
# | 198|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# | 199|                  "name" : "person_id",                                                                                                                        |                  "name" : "person_id",                                                                                                                        |
# * 200|                  "order" : 2,                                                                                                                                 |                  "order" : "2",                                                                                                                               *
# | 201|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# | 202|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# | 203|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 209|                  "is_primary_key" : 1,                                                                                                                        |                  "is_primary_key" : 1,                                                                                                                        |
# | 210|                  "is_unique" : 0,                                                                                                                             |                  "is_unique" : 0,                                                                                                                             |
# | 211|                  "name" : "pet_id",                                                                                                                           |                  "name" : "pet_id",                                                                                                                           |
# * 212|                  "order" : 1,                                                                                                                                 |                  "order" : "1",                                                                                                                               *
# | 213|                  "size" : [                                                                                                                                   |                  "size" : [                                                                                                                                   |
# | 214|                     "0"                                                                                                                                       |                     "0"                                                                                                                                       |
# | 215|                  ]                                                                                                                                            |                  ]                                                                                                                                            |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 218|            "indices" : [],                                                                                                                                    |            "indices" : [],                                                                                                                                    |
# | 219|            "name" : "pet",                                                                                                                                    |            "name" : "pet",                                                                                                                                    |
# | 220|            "options" : [],                                                                                                                                    |            "options" : [],                                                                                                                                    |
# * 221|            "order" : 2                                                                                                                                        |            "order" : "2"                                                                                                                                      *
# | 222|         }                                                                                                                                                     |         }                                                                                                                                                     |
# | 223|      },                                                                                                                                                       |      },                                                                                                                                                       |
# | 224|      "triggers" : {                                                                                                                                           |      "triggers" : {                                                                                                                                           |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 236|            "fields" : null,                                                                                                                                   |            "fields" : null,                                                                                                                                   |
# | 237|            "name" : "pet_trig",                                                                                                                               |            "name" : "pet_trig",                                                                                                                               |
# | 238|            "on_table" : "pet",                                                                                                                                |            "on_table" : "pet",                                                                                                                                |
# * 239|            "order" : 1,                                                                                                                                       |            "order" : "1",                                                                                                                                     *
# | 240|            "perform_action_when" : "after"                                                                                                                    |            "perform_action_when" : "after"                                                                                                                    |
# | 241|         }                                                                                                                                                     |         }                                                                                                                                                     |
# | 242|      },                                                                                                                                                       |      },                                                                                                                                                       |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
# | 244|         "person_pet" : {                                                                                                                                      |         "person_pet" : {                                                                                                                                      |
# | 245|            "fields" : [],                                                                                                                                     |            "fields" : [],                                                                                                                                     |
# | 246|            "name" : "person_pet",                                                                                                                             |            "name" : "person_pet",                                                                                                                             |
# * 247|            "order" : 1,                                                                                                                                       |            "order" : "1",                                                                                                                                     *
# | 248|            "sql" : "select pr.person_id, pr.name as person_name, pt.name as pet_name\\n  from   person pr, pet pt\\n  where  person.person_id=pet.pet_id\\n"  |            "sql" : "select pr.person_id, pr.name as person_name, pt.name as pet_name\\n  from   person pr, pet pt\\n  where  person.person_id=pet.pet_id\\n"  |
# | 249|         }                                                                                                                                                     |         }                                                                                                                                                     |
# | 250|      }                                                                                                                                                        |      }                                                                                                                                                        |
# +----+---------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
#
#
# Looks like you failed 1 test of 2.
t/23json.t .............................. Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/2 subtests
t/24yaml.t .............................. ok
t/25storable.t .......................... ok
t/26sybase.t ............................ ok
t/27sqlite-parser.t ..................... ok
t/29html.t .............................. ok
t/30sqlt-new-diff-mysql.t ............... ok
t/30sqlt-new-diff-pgsql.t ............... ok
t/30sqlt-new-diff-sqlite.t .............. ok
t/30sqlt-new-diff.t ..................... ok
t/31dumper.t ............................ 1/5 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/31dumper.t ............................ ok
t/32schema-lookups.t .................... ok
t/33tt-table-producer.t ................. ok
t/34tt-base.t ........................... ok
t/35-access-parser.t .................... ok
t/36-filters.t .......................... ok
t/38-filter-names.t ..................... ok
t/38-mysql-producer.t ................... ok
t/39-filter-globals.t ................... ok
t/40oracle-parser-dbi.t ................. ok
t/43xml-to-db2.t ........................ ok
t/44-xml-to-db2-array.t ................. ok
t/45db2-producer.t ...................... ok
t/46xml-to-pg.t ......................... ok
t/47postgres-producer.t ................. ok
t/48xml-to-sqlite.t ..................... ok
t/49xml-to-pg-samefield.t ............... ok
t/50-sqlserver-parser.t ................. ok
t/51-xml-to-oracle.t .................... ok
t/51-xml-to-oracle_quoted.t ............. ok
t/52-oracle-options.t ................... ok
t/53-oracle-delay-constraints.t ......... ok
t/53-oracle-delay-constraints_quoted.t .. ok
t/54-oracle-alter-field.t ............... ok
t/55-oracle-add-field.t ................. ok
t/55-oracle-producer.t .................. ok
t/56-sqlite-producer.t .................. ok
t/57-class-dbi.t ........................ ok
t/60roundtrip.t ......................... ok
t/61translator_agnostic.t ............... ok
t/62roundtrip_datacheck.t ............... ok
t/63-spacial-pgsql.t .................... ok
t/64xml-to-mysql.t ...................... ok
t/66-postgres-dbi-parser.t .............. skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
t/70sqlt-diff_script.t .................. Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script.t .................. 1/16 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script.t .................. 11/16 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script.t .................. ok
t/70sqlt-diff_script_old.t .............. 1/21 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script_old.t .............. 2/21 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script_old.t .............. 5/21 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script_old.t .............. 6/21 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script_old.t .............. 18/21 Use of uninitialized value $line in substitution (s///) at /usr/share/perl5/core_perl/Text/ParseWords.pm line 21.
t/70sqlt-diff_script_old.t .............. ok
t/71-generator-sql_server.t ............. ok
t/72-sqlite-add-drop-fields.t ........... ok
t/73-sqlite-respects-quote.t ............ ok
t/74-filename-arrayref.t ................ ok
t/mysql-sqlite-translate.t .............. ok
t/postgresql-rename-table-and-field.t ... skipped: Missing dependency: DBD::Pg
t/sqlite-rename-field.t ................. ok

Test Summary Report
-------------------
t/23json.t                            (Wstat: 256 (exited 1) Tests: 2 Failed: 1)
  Failed test:  2
  Non-zero exit status: 1
t/60roundtrip.t                       (Wstat: 0 Tests: 88 Failed: 0)
  TODO passed:   74, 76, 80, 82, 86, 88
Files=72, Tests=1849, 77 wallclock secs ( 0.61 usr  0.10 sys + 58.86 cusr  5.56 csys = 65.13 CPU)
Result: FAIL
Failed 1/72 test programs. 1/1849 subtests failed.
make: *** [Makefile:1156: test_dynamic] Error 255
==> ERROR: A failure occurred in check().

jnbek commented on 2013-05-13 22:35 (UTC)

It exists now, sorry about that. I made sure this package installed properly too, so all is well in Oz.. Sorry for the past few weeks

mzneverdies commented on 2013-05-13 14:47 (UTC)

perl-package-variant does no longer exists on aur

someonerandom commented on 2011-09-27 12:01 (UTC)

updated to version 0.11009, new dep: perl-moo http://pastebin.com/s3ExdEcE