#!/bin/sh --

PSQL="psql -X"

killall memcached
memcached -d -p 11211
${PSQL} -f /usr/local/pgsql/share/contrib/pgmemcache.sql
${PSQL} -c "SELECT memcache_init();"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_init();"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('pgtest1','val','5 minutes'::INTERVAL, 0);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('pgtest2','val','5 minutes'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('pgtest3','val');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('pgtest4');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('pgtest5','val',NOW() + '5 minutes'::INTERVAL, 0);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('pgtest6','val',NOW() + '5 minutes'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_get('pgtest1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_add('counter1', 42);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_incr('counter1', 2);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_incr('counter1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_decr('counter1', 10);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_decr('counter1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_delete('counter1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_delete('counter1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_delete('pgtest1', '5 seconds'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_flush_all('pgtest1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_get('pgtest1') IS NULL;"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_hash('pgtest1');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_replace('pgtest1','val1','5 minutes'::INTERVAL, 0);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_replace('pgtest2','val2','5 minutes'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_replace('pgtest3','val3');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_replace('pgtest4');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_replace('pgtest5','val5',NOW() + '5 minutes'::INTERVAL, 0);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_replace('pgtest6','val6',NOW() + '5 minutes'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_set('pgtest1','foo1','5 minutes'::INTERVAL, 0);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_set('pgtest2','foo2','5 minutes'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_set('pgtest3','foo3');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_set('pgtest4');"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_set('pgtest5','foo5',NOW() + '5 minutes'::INTERVAL, 0);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_set('pgtest6','foo6',NOW() + '5 minutes'::INTERVAL);"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_stats();"
${PSQL} -c "SELECT memcache_init(); SELECT memcache_server_add('localhost', '11211'); SELECT memcache_stats('cmd_get'), memcache_stats('cmd_set'), memcache_stats('get_hits');"

${PSQL} -c "SELECT memcache_init(); SELECT memcache_init(); SELECT memcache_free(); SELECT memcache_init();"