Here's how sqlite-utils triggers works:

Lines 1266 to 1277 in 9c67cb9

    
           ): 
        
               "Show triggers configured in this database" 
        
               sql = "select name, tbl_name as [table], sql from sqlite_master where type = 'trigger'" 
        
               if tables: 
        
                   quote = sqlite_utils.Database(memory=True).quote 
        
                   sql += " and [table] in ({})".format( 
        
                       ", ".join(quote(table) for table in tables) 
        
                   ) 
        
               ctx.invoke( 
        
                   query, 
        
                   path=path, 
        
                   sql=sql,

Running it from a SQL query makes it easy to support modifiers like --csv and -t.

	):
	"Show triggers configured in this database"
	sql = "select name, tbl_name as [table], sql from sqlite_master where type = 'trigger'"
	if tables:
	quote = sqlite_utils.Database(memory=True).quote
	sql += " and [table] in ({})".format(
	", ".join(quote(table) for table in tables)
	)
	ctx.invoke(
	query,
	path=path,
	sql=sql,

Uh oh!

sqlite-utils indexes command #263

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions

`sqlite-utils indexes` command #263