Mercurial > python-cmd2

changeset 367:d34f3e8d895f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
working out fileutil
author cat@eee
date Thu, 18 Feb 2010 15:15:29 -0500
parents 40cba30b6125
children 0816cdb5a7db
files docs/pycon2010/fileutil.script
diffstat 1 files changed, 13 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/docs/pycon2010/fileutil.script	Thu Feb 18 15:15:29 2010 -0500
@@ -0,0 +1,13 @@
+import os
+import os.path
+
+for (dirpath, dirnames, filenames) in os.walk('/home/cat/proj/sqlpython/sqlpython'):
+    for fname in filenames:
+        fullfilename = os.path.join(dirpath, fname)
+        stats = os.stat(fullfilename)
+        binds['path'] = dirpath
+        binds['name'] = fname
+        binds['bytes'] = stats.st_size
+        cmd("""INSERT INTO cat.files (path, name, bytes)
+               VALUES (%(path)s, %(name)s, %(bytes)s)""")
+