# 2006 August 23

#

# The author disclaims copyright to this source code.  In place of

# a legal notice, here is a blessing:

#

#    May you do good and not evil.

#    May you find forgiveness for yourself and forgive others.

#    May you share freely, never taking more than you give.

#

#***********************************************************************

# This file implements regression tests for SQLite library.  The

# focus of this script is automatic extension loading and the

# sqlite3_auto_extension() API.

#

# $Id: loadext2.test,v 1.3 2008/03/19 16:08:54 drh Exp $

set testdir [file dirname $argv0]

source $testdir/tester.tcl

# Only run these tests if the approriate APIs are defined

# in the system under test.

#

ifcapable !load_ext {

  finish_test

  return

}

if {[info command sqlite3_auto_extension_sqr]==""} {

  finish_test

  return

}

# None of the extension are loaded by default.

#

do_test loadext2-1.1 {

  catchsql {

    SELECT sqr(2)

  }

} {1 {no such function: sqr}}

do_test loadext2-1.2 {

  catchsql {

    SELECT cube(2)

  }

} {1 {no such function: cube}}

# Register auto-loaders.  Still functions do not exist.

#

do_test loadext2-1.3 {

  sqlite3_auto_extension_sqr

  sqlite3_auto_extension_cube

  catchsql {

    SELECT sqr(2)

  }

} {1 {no such function: sqr}}

do_test loadext2-1.4 {

  catchsql {

    SELECT cube(2)

  }

} {1 {no such function: cube}}

# Functions do exist in a new database connection

#

do_test loadext2-1.5 {

  sqlite3 db test.db

  catchsql {

    SELECT sqr(2)

  }

} {0 4.0}

do_test loadext2-1.6 {

  catchsql {

    SELECT cube(2)

  }

} {0 8.0}

# Reset extension auto loading.  Existing extensions still exist.

#

do_test loadext2-1.7 {

  sqlite3_reset_auto_extension

  catchsql {

    SELECT sqr(2)

  }

} {0 4.0}

do_test loadext2-1.8 {

  catchsql {

    SELECT cube(2)

  }

} {0 8.0}

# Register only the sqr() function.

#

do_test loadext2-1.9 {

  sqlite3_auto_extension_sqr

  sqlite3 db test.db

  catchsql {

    SELECT sqr(2)

  }

} {0 4.0}

do_test loadext2-1.10 {

  catchsql {

    SELECT cube(2)

  }

} {1 {no such function: cube}}

# Register only the cube() function.

#

do_test loadext2-1.11 {

  sqlite3_reset_auto_extension

  sqlite3_auto_extension_cube

  sqlite3 db test.db

  catchsql {

    SELECT sqr(2)

  }

} {1 {no such function: sqr}}

do_test loadext2-1.12 {

  catchsql {

    SELECT cube(2)

  }

} {0 8.0}

# Register a broken entry point.

#

do_test loadext2-1.13 {

  sqlite3_auto_extension_broken

  set rc [catch {sqlite3 db test.db} errmsg]

  lappend rc $errmsg

} {1 {automatic extension loading failed: broken autoext!}}

do_test loadext2-1.14 {

  catchsql {

    SELECT sqr(2)

  }

} {1 {no such function: sqr}}

do_test loadext2-1.15 {

  catchsql {

    SELECT cube(2)

  }

} {0 8.0}

sqlite3_reset_auto_extension

autoinstall_test_functions

finish_test