"""
Paradox directory to SQL
(c)2009 RAB
"""
import glob
import os

def run(s):
    print s
    os.system(s)

dirname = os.sys.argv[1]
files = glob.glob('%s/*.db' % dirname)
files += glob.glob('%s/*.DB' % dirname)

for source in files:
    target = source.lower().split('/')[-1][:-2] + 'sql'
    if os.path.exists(target):
        continue
    run('php paradox2sql.php %s > %s' % (source, target))