Mercurial > prosody-hg

comparison tools/migration/migrator/prosody_sql.lua @ 5776:bd0ff8ae98a8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove all trailing whitespace
author Florian Zeitz <florob@babelmonkeys.de>
date Fri, 09 Aug 2013 17:48:21 +0200
parents 52ccbf71d062
children a5a080c12c96 4e3067272fae
comparison
equal deleted inserted replaced
5775:a6c2b8933507 5776:bd0ff8ae98a8
22 if params.driver == "PostgreSQL" then 22 if params.driver == "PostgreSQL" then
23 create_sql = create_sql:gsub("`", "\""); 23 create_sql = create_sql:gsub("`", "\"");
24 elseif params.driver == "MySQL" then 24 elseif params.driver == "MySQL" then
25 create_sql = create_sql:gsub("`value` TEXT", "`value` MEDIUMTEXT"); 25 create_sql = create_sql:gsub("`value` TEXT", "`value` MEDIUMTEXT");
26 end 26 end
27 27
28 local stmt = connection:prepare(create_sql); 28 local stmt = connection:prepare(create_sql);
29 if stmt then 29 if stmt then
30 local ok = stmt:execute(); 30 local ok = stmt:execute();
31 local commit_ok = connection:commit(); 31 local commit_ok = connection:commit();
32 if ok and commit_ok then 32 if ok and commit_ok then