PostgreSQL Support

[GoogleCodeExporter]

Changes to add PostgreSQL support to Ajaxed

# database.asp
property dbType:
    elseif str.matching(lcase(typ), "postgresql", true) then
        p_dbType = "postgresql"

insert function:
    if dbType = "sqlite" then
        insert = getScalar("SELECT last_insert_rowid();", 0)
    elseif dbType = "mysql" then
        insert = getScalar("SELECT last_insert_id();", 0)
    elseif dbType = "postgresql" then
        insert = getScalar(str.Format("SELECT currval('{0}_id_seq');", 
tablename), 0)
    else
        insert = aRS("id")
    end if

# test_database.asp
sub test_5()
    testDbms TEST_DB_POSTGRESQL, "PostgreSQL"
end sub

# testDatabases.asp
TEST_DB_POSTGRESQL = "Driver={PostgreSQL 
UNICODE};Server=localhost;Port=5432;Database=ajaxedtests;Uid=username;Pwd=p
assword;"

# config.asp
'const AJAXED_CONNSTRING = "Driver={PostgreSQL 
UNICODE};Server=localhost;Port=5432;Database=ajaxedtests;Uid=username;Pwd=p
assword;"

Original issue reported on code.google.com by iurisil...@gmail.com on 6 May 2009 at 11:53

[GoogleCodeExporter]

This issue was closed by r60.

Original comment by mga...@gmail.com on 23 May 2009 at 4:05

• Changed state: Fixed

[GoogleCodeExporter]

This issue was closed by revision 7747e519346d.

Original comment by mbussel...@gmail.com on 14 Jun 2013 at 6:31