pike module repository: Sql.Provider.jdbc

modules.gotpike.org

Modules

ADT
Database
GTK2
GUI
IP
PiJAX
Public
Sql
Stdio
Subversion
System
Tools
Xosd
lua
v4l2
wx

Recent Changes

Public.Parser.XML2 1.50
Public.ZeroMQ 1.1
Public.Template.Mustache 1.0
Public.Protocols.XMPP 1.4
Sql.Provider.jdbc 1.0

Popular Downloads

Public.Parser.JSON2 1.0
Public.Parser.JSON 0.2
GTK2 2.23
Public.Web.FCGI 1.8
Public.Parser.XML2 1.48

Module Information
Sql.Provider.jdbc
Viewing contents of Sql_Provider_jdbc-1.0/testsuite.in

START_MARKER

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	""),
	""
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B"),
	"SELECT A FROM B"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=:C"),
	"SELECT A FROM B WHERE C=?"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=:C "),
	"SELECT A FROM B WHERE C=? "
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=:C/2"),
	"SELECT A FROM B WHERE C=?/2"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=:C AND D=:C"),
	"SELECT A FROM B WHERE C=? AND D=?"
)

test_eval_error(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=:C AND D=:"),
	"SELECT A FROM B WHERE C=? AND D=?"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=':C' AND D=:C"),
	"SELECT A FROM B WHERE C=':C' AND D=?"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=':C' AND D=':C'"),
	"SELECT A FROM B WHERE C=':C' AND D=':C'"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"'SELECT A FROM B WHERE C=':C' AND D=':C''"),
	"'SELECT A FROM B WHERE C='?' AND D='?''"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C='':C' AND D=':C''"),
	"SELECT A FROM B WHERE C=''?' AND D='?''"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C=''':C' AND D=':C''"),
	"SELECT A FROM B WHERE C=''':C' AND D=':C''"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C='a'':C' AND D=':C''"),
	"SELECT A FROM B WHERE C='a'':C' AND D=':C''"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C='''a'':C' AND D=':C''"),
	"SELECT A FROM B WHERE C='''a'':C' AND D=':C''"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE C='''a'':C' AND D=:C"),
	"SELECT A FROM B WHERE C='''a'':C' AND D=?"
)

test_equal(
  Sql.Provider.jdbc.utils()->convert_placeholders(
	"SELECT A FROM B WHERE E=:E AND C='''a'':C' AND D=:C"),
	"SELECT A FROM B WHERE E=? AND C='''a'':C' AND D=?"
)

END_MARKER