Using pysqlite2

lolmcbride

Is it possible to use this for sending triggers to a sqlite db?Could
someone provide me with an example of how to do this please?
Thanks

Jun 2 '06 #1

Subscribe Reply

1890

Dennis Benzinger

lo********@goog lemail.com wrote:

Is it possible to use this for sending triggers to a sqlite db?Could
someone provide me with an example of how to do this please?
Thanks

Do you want to implement a trigger for a SQLite database in Python?

That won't work. Triggers in SQLite can only contain UPDATE, INSERT,
DELETE and SELECT statements http://sqlite.org/lang_createtrig ger.html>.

Bye,
Dennis

Jun 2 '06 #2

Gerhard Häring

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dennis Benzinger wrote:

lo********@goog lemail.com wrote:
Is it possible to use this for sending triggers to a sqlite db?Could
someone provide me with an example of how to do this please?
Thanks

Do you want to implement a trigger for a SQLite database in Python?

That won't work. Triggers in SQLite can only contain UPDATE, INSERT,
DELETE and SELECT statements http://sqlite.org/lang_createtrig ger.html>.

Yes, but you can fake it.

You can create a new SQL function using pysqlite's create_function , and
then just call that function in the trigger. In that Python function from
the trigger, you can then even access SQLite again.

I've attached a quick-and-dirty example.

Note that exceptions in functions get ignored currently, so you better
implement a try-except with some kind of logging during development,
otherwise you will wonder why nothing happens.

Also, older pysqlite releases won't provide useful error messages if you
have errors in the SQL you send to executescript() . Using a recent pysqlite
release is recommended if you plan to use executescript() .

- -- Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEgMQrdIO 4ozGCH14RArFaAK CU8lgwidMoNQ0GG KVwJ2GV9xPF8ACf TDhv
QVHvudLfoDGiIyF gHe5w6L4=
=bfUa
-----END PGP SIGNATURE-----

Jun 2 '06 #3

xera121

Many thanks Gerhard - the solution you offer is workable in the scope
of my project.
Gracias muchacho
Xera121

Jun 7 '06 #4

Similar topics

5901

Encryption using X509Certificate

by: rawCoder | last post by:

Hi All, I have a *.cer file, a public key of some one and I want to encrypt some thing using this public key. Can someone point me to a sample code for Encrypting some file using X509Certificate ( *.cer file ) so that it can be used to email as attachment. The real part is Encrypting using X509Certificate and CryptoServiceProvider.

.NET Framework

567

error using ICallbackEventHandler in ASP.Net 2.0

by: Mike | last post by:

When trying to compile (using Visual Web Developer 2005 Express Beta; frameworkv2.0.50215 ) the source code below I get errors (listed below due to the use of ICallBackEventHandler. Ultimately I want to use a callback from the client side to update webcontrols based on user input without using postback. I am seeking a way to stop the compile errors. using System; using System.Data;

.NET Framework

2645

using declaration question

by: Christopher Benson-Manica | last post by:

Why can't I use a class destructor in a using declaration: using MyClass::~MyClass; ? -- Christopher Benson-Manica | I *should* know what I'm talking about - if I ataru(at)cyberspace.org | don't, I need to know. Flames welcome.

C / C++

3491

is "using namespace std" good style?

by: beliavsky | last post by:

Many of my C++ programs have the line using namespace std; but the "Accelerated C++" book of Koenig and Moo has many examples where the library names are included one at a time, for example using std::cin; using std::cout;

C / C++

4905

Is 'using namespace std;' valid without 'namespace std {};' first?

by: Petter Reinholdtsen | last post by:

I ran into a problem on HP-UX 11.00 the other day, where it refused to compile a program using 'using namespace std;' at the top. The reason seem to be that the compiler refuses to accept 'using namespace std;' unless the std namespace was declared first. This triggered my curiosity, and I tried to find out what the ANSI C++ standard had to say about this. I'm unable to find a conclusion, and hope someone here have a clue to spare. ...

C / C++

2146

Correct usage of "using" with standard templates

by: john.burton.email | last post by:

I've done some extensive searching and can't seem to find an answer to this - Is it correct to using "using" with templates, for example: using std::vector; Or do I need to specify the type too: using std::vector<int>; Both seem to "work" on the compiler I have and I can't find any documentation saying which is correct, or are both correct?

C / C++

2286

Setting the encoding in pysqlite2

by: Michele Simionato | last post by:

An easy question, but I don't find the answer in the docs :-( I have a sqlite3 database containing accented characters (latin-1). How do I set the right encoding? For instance if I do this: #-*- encoding: latin-1 -*- from pysqlite2 import dbapi2 as sqlite import os DBFILE="/tmp/example.db"

Python

1023

pysqlite2 fetching from select different than pysqlite?

by: schwehr | last post by:

Hi All, I have some old pysqlite 1.x code that uses a pattern like this: cu.execute('SELECT weight FROM weights WHERE samplename="foo") row = cu.fetchone() weight=row It seems like lookups by name are no longer supported in pysqlite2. Is that true? And if not, and I want to do a SELECT * FROM table and go

Python

8247

Encrypt and Decrypt a file using .NET 2.0?

by: JDeats | last post by:

I have some .NET 1.1 code that utilizes this technique for encrypting and decrypting a file. http://support.microsoft.com/kb/307010 In .NET 2.0 this approach is not fully supported (a .NET 2.0 build with these methods, will appear to encrypt and decrypt, but the resulting decrypted file will be corrupted. I tried encrypting a .bmp file and then decrypting, the resulting decrypted file under .NET 2.0 is garbage, the .NET 1.1 build works...

C# / C Sharp

7904

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8398

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8400

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8051

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8267

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6725

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

3898

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2414

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1505

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP