def main(options):

    filename_database = options["--database"]
    name_table        = options["--table"]

    print("\npyprel database examples\n")

    if os.path.exists(filename_database):
        print("create database {database}".format(
            database = filename_database
        ))
        create_database(filename = "database.db")

    print("access database {filename}".format(
        filename = filename_database
    ))
    database = dataset.connect(
        "sqlite:///{filename_database}".format(
            filename_database = filename_database
        )
    )
    table = database[name_table]

    print("add data to database")
    table.insert(dict(
        name     = "Legolas Greenleaf",
        age      = 2000,
        country  = "Mirkwood",
        uuid4    = str(uuid.uuid4())
    ))
    table.insert(dict(
        name     = "Cody Rapol",
        age      = 30,
        country  = "USA",
        activity = "DDR",
        uuid4    = str(uuid.uuid4())
    ))

    print(
"""
database tables:\n{tables}
\ntable {table} columns:\n{columns}
\ntable {table} row one:\n{row}
""".format(
            tables  = database.tables,
            table   = name_table,
            columns = database[name_table].columns,
            row     = [entry for entry in table.find(id = "1")]
        )
    )

    print("table {table} printout:\n".format(
        table = name_table
    ))

    print(
        pyprel.Table(
            contents = pyprel.table_dataset_database_table(
                table = database[name_table]
            )
        )
    )