#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
#  try-add-sqlite-01.py
#
#  Copyright 2021 myke <<EMAIL>>
#
#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
#  MA 02110-1301, USA.
#
#

import sqlite3
conn = sqlite3.connect(':memory:')
conn.enable_load_extension(True)



# ~ conn.enable_load_extension(True)
# ~ extfile = "libsqlitefunctions.dll"
# ~ conn.execute("SELECT load_extension('%s')" % extfile)

# ~ # just a stupid test to check if SpatiaLite really works
# ~ for row in conn.execute("SELECT ST_AsText(MakePoint(11.5, 42.5, 4326))"):
    # ~ print(row)


#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
#  try-add-sqlite-01.py
#
#  Copyright 2021 myke <<EMAIL>>
#
#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
#  MA 02110-1301, USA.
#
#

import sqlite3
conn = sqlite3.connect(':memory:')
conn.enable_load_extension(True)



# ~ conn.enable_load_extension(True)
# ~ extfile = "libsqlitefunctions.dll"
# ~ conn.execute("SELECT load_extension('%s')" % extfile)

# ~ # just a stupid test to check if SpatiaLite really works
# ~ for row in conn.execute("SELECT ST_AsText(MakePoint(11.5, 42.5, 4326))"):
    # ~ print(row)


#!/usr/bin/env python # -*- coding: utf-8 -*- # #  try-add-sqlite-01.py # #  Copyright 2021 myke <<EMAIL>> # #  This program is free software; you can redistribute it and/or modify #  it under the terms of the GNU General Public License as published by #  the Free Software Foundation; either version 2 of the License, or #  (at your option) any later version. # #  This program is distributed in the hope that it will be useful, #  but WITHOUT ANY WARRANTY; without even the implied warranty of #  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the #  GNU General Public License for more details. # #  You should have received a copy of the GNU General Public License #  along with this program; if not, write to the Free Software #  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, #  MA 02110-1301, USA. # # # ~ conn.enable_load_extension(True) # ~ extfile = "libsqlitefunctions.dll" # ~ conn.execute("SELECT load_extension('%s')" % extfile) # ~ # just a stupid test to check if SpatiaLite really works # ~ for row in conn.execute("SELECT ST_AsText(MakePoint(11.5, 42.5, 4326))"): # ~ print(row)