Source: restfuldb
Version: 0.15.2+dfsg-2
Severity: serious
Tags: patch
Hi,
SQLite3 3.37.0 and onwards changed its inner working. Now table column
data types are stored as a value and always returned as uppercase
text. This breaks your package as it relies on the old behavior, when
this was stored as text and returned in a case it was defined.
As I broke it, I've created a fix for you, patch is attached. Couldn't
make it work with older SQLite3 versions thus you will need to build
depend on SQLite3 3.37.0 and newer.
Sorry for the inconvenience,
Laszlo/GCS
Description: SQLite3 3.37.0+ use uppercase column tupe names
Starting with SQLite3 3.37.0 it stores column type names as a value and
always displayed in uppercase letters.
Previously it stored type names as text with the same case as it was given.
This breaks testing where the column type is defined in lowercase and
expects it to be given back as-is.
Fix this with using type names in uppercase.
Author: Laszlo Boszormenyi (GCS) <g...@debian.org>
Forwarded: no
Last-Update: 2022-01-08
---
--- restfuldb-0.15.2+dfsg.orig/tests/cases/Database.pm_007.sh
+++ restfuldb-0.15.2+dfsg/tests/cases/Database.pm_007.sh
@@ -31,8 +31,8 @@ trap "exit 1" HUP INT QUIT TERM
TMP_DB_MAIN="${TMP_DIR}/test.db"
-sqlite3 ${TMP_DB_MAIN} "create table parent(id int, name text)"
-sqlite3 ${TMP_DB_MAIN} "create table child(id int, parent_id int, FOREIGN KEY(parent_id) REFERENCES parent(id))"
+sqlite3 ${TMP_DB_MAIN} "create table parent(id INT, name TEXT)"
+sqlite3 ${TMP_DB_MAIN} "create table child(id INT, parent_id INT, FOREIGN KEY(parent_id) REFERENCES parent(id))"
sqlite3 ${TMP_DB_MAIN} "insert into parent values (1, 'first entry')"
sqlite3 ${TMP_DB_MAIN} "insert into parent values (2, 'second entry')"
sqlite3 ${TMP_DB_MAIN} "insert into child values (1, 1)"
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_001.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_001.out
@@ -1,11 +1,11 @@
$VAR1 = {
- 'image' => 'blob'
+ 'image' => 'BLOB'
};
$VAR1 = {
- 'caption' => 'text',
- 'description' => 'text',
- 'id' => 'integer',
- 'image' => 'blob'
+ 'caption' => 'TEXT',
+ 'description' => 'TEXT',
+ 'id' => 'INTEGER',
+ 'image' => 'BLOB'
};
-----------------
$VAR1 = {
@@ -13,10 +13,10 @@ $VAR1 = {
'authors' => 'varchar',
'cdate' => 'date',
'ctime' => 'time',
- 'id' => 'integer',
- 'revision_id' => 'integer',
- 'title' => 'text',
- 'year' => 'integer'
+ 'id' => 'INTEGER',
+ 'revision_id' => 'INTEGER',
+ 'title' => 'TEXT',
+ 'year' => 'INTEGER'
};
$VAR1 = {
'PublicID' => '12',
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_007.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_007.out
@@ -5,7 +5,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent_id' => {
@@ -29,14 +29,14 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'first entry'
}
},
@@ -66,7 +66,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
}
},
@@ -89,7 +89,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent_id' => {
@@ -109,7 +109,7 @@ $VAR1 = [
}, 'Database::ForeignKey' ),
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 2
}
},
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_012.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_012.out
@@ -12,28 +12,28 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'locality' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'New Caledonia'
},
'mine' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Mea'
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Dunite'
}
},
@@ -60,7 +60,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'X-ray diffractometer'
},
'esu' => {
@@ -74,7 +74,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'result' => {
@@ -112,28 +112,28 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'locality' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'New Caledonia'
},
'mine' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Mea'
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Dunite'
}
},
@@ -166,7 +166,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'started' => {
@@ -211,7 +211,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'LIBS'
},
'esu' => {
@@ -225,7 +225,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 4
},
'result' => {
@@ -251,28 +251,28 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'locality' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'New Caledonia'
},
'mine' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Mea'
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Dunite'
}
},
@@ -305,7 +305,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'started' => {
@@ -330,7 +330,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'EXAFS'
},
'esu' => {
@@ -344,7 +344,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 5
},
'result' => {
@@ -370,28 +370,28 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'locality' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'New Caledonia'
},
'mine' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Mea'
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Dunite'
}
},
@@ -424,7 +424,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'started' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_013.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_013.out
@@ -59,7 +59,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -228,7 +228,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -566,7 +566,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -821,7 +821,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -984,7 +984,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1095,7 +1095,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1357,7 +1357,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1696,7 +1696,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1840,7 +1840,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1951,7 +1951,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2219,7 +2219,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2558,7 +2558,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2708,7 +2708,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2819,7 +2819,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3087,7 +3087,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3409,7 +3409,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3562,7 +3562,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3673,7 +3673,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3900,7 +3900,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4029,7 +4029,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4285,7 +4285,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4383,7 +4383,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4530,7 +4530,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4647,7 +4647,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4778,7 +4778,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4918,7 +4918,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5029,7 +5029,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5117,7 +5117,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -5361,7 +5361,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5782,7 +5782,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6058,7 +6058,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6169,7 +6169,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6484,7 +6484,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6595,7 +6595,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6868,7 +6868,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7042,7 +7042,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7416,7 +7416,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7684,7 +7684,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7847,7 +7847,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7958,7 +7958,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8233,7 +8233,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8585,7 +8585,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8729,7 +8729,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8840,7 +8840,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9121,7 +9121,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9473,7 +9473,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9623,7 +9623,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9734,7 +9734,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10015,7 +10015,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10350,7 +10350,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10503,7 +10503,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10614,7 +10614,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10854,7 +10854,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -10983,7 +10983,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11252,7 +11252,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -11350,7 +11350,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11497,7 +11497,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11614,7 +11614,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11745,7 +11745,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -11885,7 +11885,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11996,7 +11996,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -12084,7 +12084,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -12341,7 +12341,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -12775,7 +12775,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13051,7 +13051,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13162,7 +13162,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13477,7 +13477,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13588,7 +13588,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13860,7 +13860,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -14233,7 +14233,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -14501,7 +14501,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_014.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_014.out
@@ -64,7 +64,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -238,7 +238,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -612,7 +612,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -880,7 +880,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1043,7 +1043,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1154,7 +1154,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1429,7 +1429,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1781,7 +1781,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1925,7 +1925,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2036,7 +2036,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2317,7 +2317,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2669,7 +2669,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2819,7 +2819,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2930,7 +2930,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3211,7 +3211,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3546,7 +3546,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3699,7 +3699,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3810,7 +3810,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4050,7 +4050,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4179,7 +4179,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4448,7 +4448,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4546,7 +4546,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4693,7 +4693,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4810,7 +4810,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4941,7 +4941,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -5081,7 +5081,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5192,7 +5192,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5280,7 +5280,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -5537,7 +5537,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5971,7 +5971,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6247,7 +6247,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6358,7 +6358,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6673,7 +6673,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6784,7 +6784,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_015.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_015.out
@@ -12,21 +12,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 5
},
'title' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'The tale of nine tails'
},
'year' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1505
}
},
@@ -56,21 +56,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 6
},
'title' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'The tale of nine tails'
},
'year' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1505
}
},
@@ -97,21 +97,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 5
},
'title' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'The tale of nine tails'
},
'year' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1505
}
},
@@ -154,21 +154,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 6
},
'title' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'The tale of nine tails'
},
'year' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1505
}
},
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_016.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_016.out
@@ -65,7 +65,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => undef
},
'http_host' => {
@@ -256,7 +256,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -630,7 +630,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -898,7 +898,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1074,7 +1074,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1426,7 +1426,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1589,7 +1589,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1941,7 +1941,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2110,7 +2110,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2445,7 +2445,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2569,7 +2569,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -2698,7 +2698,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2967,7 +2967,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -3065,7 +3065,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3212,7 +3212,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3329,7 +3329,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3460,7 +3460,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -3607,7 +3607,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4041,7 +4041,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4317,7 +4317,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4428,7 +4428,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_017.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_017.out
@@ -5,28 +5,28 @@ $VAR1 = [
'coltype' => 'file',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'blob',
+ 'sqltype' => 'BLOB',
'urlvalue' => '/file/1/file'
},
'filename' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'test.csv'
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'mimetype' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'text/csv'
}
},
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_020.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_020.out
@@ -6,7 +6,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => undef
},
'geo_context' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_024.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_024.out
@@ -97,7 +97,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => undef
},
'geo_context' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_026.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_026.out
@@ -5,7 +5,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => undef
},
'geo_context' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_030.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_030.out
@@ -5,7 +5,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => undef
},
'geo_context' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_043.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_043.out
@@ -5,21 +5,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 2
},
'b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 3
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
}
},
@@ -44,7 +44,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent' => {
@@ -70,21 +70,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 2
},
'b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 3
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
}
},
@@ -132,21 +132,21 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent_a' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 2
},
'parent_b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 3
}
},
@@ -204,7 +204,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'parent' => {
'coltype' => 'fk',
@@ -229,19 +229,19 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
}
},
'metadata' => {
@@ -258,19 +258,19 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'parent_a' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'parent_b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
}
},
'metadata' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_044.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_044.out
@@ -5,7 +5,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent' => {
@@ -31,21 +31,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 2
},
'b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 3
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
}
},
@@ -93,21 +93,21 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent_a' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 2
},
'parent_b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 3
}
},
@@ -132,7 +132,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 1
},
'parent' => {
@@ -158,21 +158,21 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 5
},
'b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 6
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 4
}
},
@@ -197,7 +197,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'parent' => {
'coltype' => 'fk',
@@ -208,19 +208,19 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'id' => {
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
}
},
'metadata' => {
@@ -237,19 +237,19 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'parent_a' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'parent_b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
}
},
'metadata' => {
@@ -300,21 +300,21 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 4
},
'parent_a' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 5
},
'parent_b' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 6
}
},
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_061.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_061.out
@@ -59,7 +59,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -228,7 +228,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -566,7 +566,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -821,7 +821,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -984,7 +984,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1095,7 +1095,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1357,7 +1357,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1696,7 +1696,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1840,7 +1840,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -1951,7 +1951,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2219,7 +2219,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2558,7 +2558,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2708,7 +2708,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -2819,7 +2819,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3087,7 +3087,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3409,7 +3409,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3562,7 +3562,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3673,7 +3673,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -3900,7 +3900,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4029,7 +4029,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4285,7 +4285,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4383,7 +4383,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4530,7 +4530,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4647,7 +4647,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -4778,7 +4778,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -4918,7 +4918,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5029,7 +5029,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5117,7 +5117,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -5361,7 +5361,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -5782,7 +5782,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6058,7 +6058,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6169,7 +6169,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6484,7 +6484,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6595,7 +6595,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -6868,7 +6868,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7042,7 +7042,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7416,7 +7416,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7684,7 +7684,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7847,7 +7847,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -7958,7 +7958,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8233,7 +8233,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8585,7 +8585,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8729,7 +8729,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -8840,7 +8840,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9121,7 +9121,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9473,7 +9473,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9623,7 +9623,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -9734,7 +9734,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10015,7 +10015,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10350,7 +10350,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10503,7 +10503,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10614,7 +10614,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -10854,7 +10854,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -10983,7 +10983,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11252,7 +11252,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -11350,7 +11350,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11497,7 +11497,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11614,7 +11614,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11745,7 +11745,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -11885,7 +11885,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -11996,7 +11996,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -12084,7 +12084,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'geo_context' => {
'coltype' => undef,
@@ -12341,7 +12341,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -12775,7 +12775,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13051,7 +13051,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13162,7 +13162,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13477,7 +13477,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13588,7 +13588,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -13860,7 +13860,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -14233,7 +14233,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -14501,7 +14501,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_065.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_065.out
@@ -5,7 +5,7 @@ $VAR1 = [
'coltype' => 'text',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'X-ray diffractometer'
},
'esu' => {
@@ -19,7 +19,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'result' => {
@@ -57,28 +57,28 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'locality' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'New Caledonia'
},
'mine' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Mea'
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Dunite'
}
},
@@ -111,7 +111,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'started' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_066.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_066.out
@@ -5,7 +5,7 @@ $VAR1 = [
'coltype' => 'text',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Confidential. Please get authorisation to get full data.'
},
'esu' => {
@@ -19,7 +19,7 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'result' => {
@@ -57,28 +57,28 @@ $VAR1 = [
'coltype' => 'id',
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'locality' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'New Caledonia'
},
'mine' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Mea'
},
'name' => {
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => 'Dunite'
}
},
@@ -111,7 +111,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'started' => {
--- restfuldb-0.15.2+dfsg.orig/tests/outputs/Database.pm_070.out
+++ restfuldb-0.15.2+dfsg/tests/outputs/Database.pm_070.out
@@ -6,7 +6,7 @@ $VAR1 = [
'length' => undef,
'mandatory' => 1,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'primary_sample_id' => {
@@ -121,7 +121,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 1
},
'related_sample_id' => {
@@ -224,7 +224,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer',
+ 'sqltype' => 'INTEGER',
'value' => 2
},
'revision_id' => {
@@ -255,7 +255,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text',
+ 'sqltype' => 'TEXT',
'value' => undef
},
'http_host' => {
@@ -360,7 +360,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int',
+ 'sqltype' => 'INT',
'value' => 3
},
'uuid' => {
@@ -407,7 +407,7 @@ $VAR1 = [
'length' => undef,
'mandatory' => 1,
'resolver' => undef,
- 'sqltype' => 'integer'
+ 'sqltype' => 'INTEGER'
},
'primary_sample_id' => {
'coltype' => 'fk',
@@ -477,7 +477,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer'
+ 'sqltype' => 'INTEGER'
},
'related_sample_id' => {
'coltype' => 'fk',
@@ -547,7 +547,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'integer'
+ 'sqltype' => 'INTEGER'
},
'revision_id' => {
'coltype' => 'dbrev',
@@ -564,7 +564,7 @@ $VAR1 = [
'coltype' => undef,
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'text'
+ 'sqltype' => 'TEXT'
},
'http_host' => {
'coltype' => undef,
@@ -646,7 +646,7 @@ $VAR1 = [
},
'length' => undef,
'resolver' => undef,
- 'sqltype' => 'int'
+ 'sqltype' => 'INT'
},
'uuid' => {
'coltype' => 'uuid',
