Changes between Version 11 and Version 12 of S3/DataImportCLI

Timestamp:

06/13/14 11:55:49 (11 years ago)

Author:

MattS

Comment:

syntax highlighting

S3/DataImportCLI

@@ -6 +6 @@
 
 Start the web2py CLI with the Eden data model environment:
-{{{
+{{{#!python
 python web2py.py -S eden -M
 }}}
 
 Override authorization:
-{{{
+{{{#!python
 auth.override = True
 }}}
 
 Define the target resource:
-{{{
+{{{#!python
 resource = s3db.resource("project_activity")
 }}}
 
 Import data:
-{{{
+{{{#!python
 success = resource.import_xml(open("filename.csv", "rb"),                   # CSV format requires file handle, XML accepts filename
                               format="csv",                                 # "xml", "json" or "csv"
@@ -31 +31 @@
 
 See errors (error message and error tree are returned in any case, even with ignore_errors=True):
-{{{
+{{{#!python
 print success                 # prints a JSON message with the error message and the JSONified error tree
 print resource.error          # prints the error message
@@ -39 +39 @@
 
 Do not forget to commit the import (if you want to keep it):
-{{{
+{{{#!python
 db.commit()
 }}}
 
 If you were only testing (e.g. to see validation errors), and now want to discard the import, you can either leave the shell without calling {{{db.commit()}}} - or you do an explicit:
-{{{
+{{{#!python
 db.rollback()
 }}}