AarchonWiki

User Tools

Site Tools

Trace:
lua:db:exec

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
lua:db:exec [2016/02/08 05:00] – vodurlua:db:exec [2016/02/08 05:37] (current) – vodur
Line 1: Line 1:
-db.exec( statement )+<font 18px/inherit;;inherit;;inherit>** db.exec( statement ) **</font>
  
 Execute sql statement. Execute sql statement.
  
 If statement is a query, return value is a table with the query results. If statement is a query, return value is a table with the query results.
 +
 +See also [[:lua:db:escape|db.escape()]].
 +
 +===== Examples: =====
  
 Check if a table exists: Check if a table exists:
Line 11: Line 15:
   -- table doesn't exist, do something here   -- table doesn't exist, do something here
 end end
 +</code>
 +
 +\\
 +Create a table:
 +
 +<code lua>
 +db.exec[[CREATE TABLE grraka_animals(
 +                     animal_name TEXT,
 +                     location TEXT)]]
 </code> </code>
  
Line 16: Line 29:
  
 <code lua> <code lua>
-db.exec[[INSERT INTO grraka_animals( animal_name, location ) VALUES( "Dog", "land")]]+db.exec[[INSERT INTO grraka_animals( animal_name, location ) VALUES( 'Dog', 'land')]]
 </code> </code>
  
-Create a table:+Bulk insert using transaction:
  
 <code lua> <code lua>
-db.exec[[CREATE TABLE grraka_animals( +local animals= 
-                     animal_name TEXT, +{ 
-                     location TEXT)]]+{animal_name="Aardvark",location="land" }, 
 +{animal_name="Albatross",location="air" }, 
 +{animal_name="Alligator",location="water" }, 
 +{animal_name="Alpaca",location="land" }, 
 +{animal_name="Ant",location="land" } 
 +} 
 + 
 +db.exec[[BEGIN]] 
 +for _,entry in pairs(animals) do 
 +    db.exec( ([[INSERT INTO grraka_animals(animal_name, location) 
 +                      VALUES( '%s', '%s')]]):format( db.escape(entry.animal_name), db.escape(entry.location)) 
 +end 
 +db.exec[[END]]
 </code> </code>
  
Line 30: Line 55:
  
 <code lua> <code lua>
-local result=[[SELECT animal_name, location FROM grraka_animals ORDER BY animal_name]]+local result=db.exec[[SELECT animal_name, location FROM grraka_animals ORDER BY animal_name]]
  
 for _,row in result do for _,row in result do
Line 36: Line 61:
 end end
 </code> </code>
 +
 +See sqlite3 general documentation for further reference on statements.
  
lua/db/exec.1454907648.txt.gz · Last modified: 2016/02/08 05:00 by vodur