Sample SQL Scripts

MySQL with limit

Copy

-- dbvendor=MYSQL
-- username=aiq
-- password=thePassword
-- host=mysqlsmoketest.c7nn5t4czzya.us-west-2.rds.amazonaws.com
-- schema=aiq
-- port=3306
-- limit=21-50
-- tag=executions
-- connect
SELECT * FROM `aiq`.`UTPScenarioExecution`;
-- storeInLocker=
-- disconnect

Redshift

Copy

-- dbvendor=REDSHIFT
-- username=theUser
-- password=thePassword
-- host=sqlclient-test.cqzappbyyyx5.us-east-2.redshift.amazonaws.com
-- schema=dev
-- port=5439
-- limit=1-50000
-- tag=saleswb
-- connect
select sellerid, username, (firstname ||' '|| lastname) as name,
city, sum(qtysold)
from sales, date, users
where sales.sellerid = users.userid
and sales.dateid = date.dateid
and year = 2008
and city = 'San Diego'
group by sellerid, username, name, city
order by 5 desc;
-- storeInWhiteboard=
-- disconnect

Snowflake

Copy

-- dbvendor=SNOWFLAKE
-- region=us-west-2
-- account=qrazxhk-kiw37206
-- role=ACCOUNTADMIN
-- username=theUser
-- password=thePassword
-- warehouse=COMPUTE_WH
-- db=APPVANCE
-- schema=AIQ
-- connect
update COUNTRIES 
set COUNTRY_NAME='NAME CHANGED' 
where COUNTRY_CODE=999;
-- disconnect

MSSQL

Copy

-- dbvendor=MSSQL
-- username=theUser
-- password=thePassword
-- host=mssqlsmoketest.c6mn5c3czyyb.us-west-2.rds.amazonaws.com
-- schema=master
-- port=1433
-- connect
call sp_tables;
-- storeInLocker=
-- disconnect

Oracle

Copy

-- dbvendor=ORACLE
-- username=theUser
-- password=thePassword
-- host=oraclestest.c4nm5t3czzya.us-west-2.rds.amazonaws.com
-- schema=ORCL
-- port=1521
-- connect
SELECT aiq.getversion() FROM dual;
-- tag=results
-- storeInLocker=
-- disconnect