# SQL Statements sceletons to be used by SQLTuple.
# NAME will be replaced with NTuple name.
# #s will be replaced by arguments passed to StmtSrc via query() or update().
# Implementation-specific commands have protocol name appended to their names.
# In case of using to create PreparedStatement, only the last command is used,
# others are executed directly.
#
# $Id: StmtSrc.properties,v 1.14 2007/05/22 23:33:20 hrivnac Exp $

hep.aida.ref.sql.StmtSrc.addIndex                = create index #1 on NAME (#2);
hep.aida.ref.sql.StmtSrc.addIndex.mysql          = alter table NAME add index #1 (#2);
hep.aida.ref.sql.StmtSrc.addIndex.cjdbc          = alter table NAME add index #1 (#2);
hep.aida.ref.sql.StmtSrc.addColumnAlter          = alter table NAME add #1 #2;
hep.aida.ref.sql.StmtSrc.addColumnUpdate         = update NAME set #1 = #2;
hep.aida.ref.sql.StmtSrc.groupValue              = select #1(#2) from NAME;
hep.aida.ref.sql.StmtSrc.start                   = select * from NAME;
hep.aida.ref.sql.StmtSrc.startFilter             = select * from NAME where #1;
hep.aida.ref.sql.StmtSrc.addRow                  = insert into NAME values (#1);
hep.aida.ref.sql.StmtSrc.rows                    = select count(*) from NAME;
hep.aida.ref.sql.StmtSrc.projectX                = select #1 from NAME;
hep.aida.ref.sql.StmtSrc.projectXW               = select #1, #2 from NAME;
hep.aida.ref.sql.StmtSrc.projectXF               = select #1 from NAME where #2;
hep.aida.ref.sql.StmtSrc.projectXFW              = select #1, #2 from NAME where #3;
hep.aida.ref.sql.StmtSrc.projectXY               = select #1, #2 from NAME;
hep.aida.ref.sql.StmtSrc.projectXYW              = select #1, #2, #3 from NAME;
hep.aida.ref.sql.StmtSrc.projectXYF              = select #1, #2 from NAME where #3;
hep.aida.ref.sql.StmtSrc.projectXYFW             = select #1, #2, #3 from NAME where #4;
hep.aida.ref.sql.StmtSrc.projectXYZ              = select #1, #2, #3 from NAME;
hep.aida.ref.sql.StmtSrc.projectXYZW             = select #1, #2, #3, #4 from NAME;
hep.aida.ref.sql.StmtSrc.projectXYZF             = select #1, #2, #3 from NAME where #4;
hep.aida.ref.sql.StmtSrc.projectXYZFW            = select #1, #2, #3, #4 from NAME where #5;
hep.aida.ref.sql.StmtSrc.getColumn               = select #1 from NAME;
hep.aida.ref.sql.StmtSrc.getColumnFilter         = select #1 from NAME where #2;
hep.aida.ref.sql.StmtSrc.createTable             = create table #1 (#2);
hep.aida.ref.sql.StmtSrc.createTableSelect       = create table #1 (#2) as select #2 from #3 where #4;
hep.aida.ref.sql.StmtSrc.createTableSelect.mysql = create table #1 select #2 from #3 where #4;
hep.aida.ref.sql.StmtSrc.dropTable               = drop table #1;
