1 files changed, 0 insertions, 50 deletions
diff --git a/sqlplain/doc/strip_blanks.py b/sqlplain/doc/strip_blanks.py
deleted file mode 100644
index 25ad41e..0000000
--- a/sqlplain/doc/strip_blanks.py
+++ /dev/null
@@ -1,50 +0,0 @@
-"""
-Take a table with a primary key and some nullable text fields.
-Strip leading spaces in all text fields and
-replace the fields which are all blanks with None.
-
-usage:
-
-$ python %s <db-uri> <table>
-
-"""
-
-import os, sys
-from sqlplain import connect, util
-from sqlplain.table import KTable
-
-def strip(value):
-    "value is None or a string"
-    if value is None: # do nothing
-        return None
-    return value.strip() or None    
-            
-def get_text_fields(conn, table, exclude=()):
-    'Returns the text fields of a table, possibly excluding some of them'
-    names = []
-    for row in util.get_descr(conn, table):
-        if row.type_code == 1 and row.name not in exclude:
-                names.append(row.name)
-    return names
-
-def replace_blanks(conn, tablename):
-    # conn.chatty = True
-    pkeys = util.get_kfields(conn, tablename)
-    textfields = get_text_fields(conn, tablename, exclude=pkeys)
-    tbl = KTable.type(tablename, pkeys, textfields)(conn)
-    for row in tbl.select():
-        kw = dict((tf, strip(getattr(row, tf))) for tf in textfields)
-        newrow = row._replace(**kw)
-        if newrow != row:
-            tbl.update_row(newrow)
-            print newrow
-        else:
-            sys.stdout.write('.')
-            sys.stdout.flush()
-
-if __name__ == '__main__':
-    try:
-        uri, tablename = sys.argv[1:]
-    except ValueError:
-        sys.exit(__doc__ % sys.argv[0])
-    replace_blanks(connect(uri), tablename)