Re: NEW: databases/sqlite2mdoc

On Fri, Jun 29, 2018 at 07:43:58PM +0200, Landry Breuil wrote:
> Hi,
>
> and now that sqlite2mdoc is in, here's the diff for the integration part
> into sqlite3 port. Note the less that 10% size increase in pkg size.
>
> 1953518 sqlite3-3.24.0.tgz
> 2187305 sqlite3-3.24.0p0.tgz
>
> Landry
>

I like it! ok jturner.

> Index: Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/sqlite3/Makefile,v
> retrieving revision 1.94
> diff -u -r1.94 Makefile
> --- Makefile 27 Jun 2018 04:55:34 -0000 1.94
> +++ Makefile 29 Jun 2018 17:42:02 -0000
> @@ -4,6 +4,7 @@
>
> DISTNAME = sqlite-autoconf-3240000
> PKGNAME= sqlite3-3.24.0
> +REVISION = 0
>
> SHARED_LIBS += sqlite3 37.3 # 8.6
>
> @@ -31,6 +32,10 @@
> -DSQLITE_ENABLE_DBSTAT_VTAB
>
> # update p5-DBD-SQLite's Makefile.PL if enabling -DSQLITE_ENABLE_COLUMN_METADATA
> +BUILD_DEPENDS = converters/sqlite2mdoc
> +post-install:
> + ${INSTALL_DATA_DIR} ${PREFIX}/man/man3
> + ${LOCALBASE}/bin/sqlite2mdoc -p ${PREFIX}/man/man3 ${PREFIX}/include/sqlite3.h
>
> NO_TEST= Yes
>
> Index: pkg/PLIST
> ===================================================================
> RCS file: /cvs/ports/databases/sqlite3/pkg/PLIST,v
> retrieving revision 1.4
> diff -u -r1.4 PLIST
> --- pkg/PLIST 23 Sep 2016 09:13:39 -0000 1.4
> +++ pkg/PLIST 29 Jun 2018 17:42:02 -0000
> @@ -8,3 +8,232 @@
> @lib lib/libsqlite3.so.${LIBsqlite3_VERSION}
> lib/pkgconfig/sqlite3.pc
> @man man/man1/sqlite3.1
> +@man man/man3/SQLITE_ACCESS_EXISTS.3
> +@man man/man3/SQLITE_CHANGESETAPPLY_NOSAVEPOINT.3
> +@man man/man3/SQLITE_CHANGESET_DATA.3
> +@man man/man3/SQLITE_CHANGESET_OMIT.3
> +@man man/man3/SQLITE_CHECKPOINT_PASSIVE.3
> +@man man/man3/SQLITE_CONFIG_SINGLETHREAD.3
> +@man man/man3/SQLITE_CREATE_INDEX.3
> +@man man/man3/SQLITE_DBCONFIG_MAINDBNAME.3
> +@man man/man3/SQLITE_DBSTATUS_LOOKASIDE_USED.3
> +@man man/man3/SQLITE_DENY.3
> +@man man/man3/SQLITE_DESERIALIZE_FREEONCLOSE.3
> +@man man/man3/SQLITE_DETERMINISTIC.3
> +@man man/man3/SQLITE_ERROR_MISSING_COLLSEQ.3
> +@man man/man3/SQLITE_FCNTL_LOCKSTATE.3
> +@man man/man3/SQLITE_INDEX_CONSTRAINT_EQ.3
> +@man man/man3/SQLITE_INDEX_SCAN_UNIQUE.3
> +@man man/man3/SQLITE_INTEGER.3
> +@man man/man3/SQLITE_IOCAP_ATOMIC.3
> +@man man/man3/SQLITE_LIMIT_LENGTH.3
> +@man man/man3/SQLITE_LOCK_NONE.3
> +@man man/man3/SQLITE_MUTEX_FAST.3
> +@man man/man3/SQLITE_OK.3
> +@man man/man3/SQLITE_OPEN_READONLY.3
> +@man man/man3/SQLITE_PREPARE_PERSISTENT.3
> +@man man/man3/SQLITE_ROLLBACK.3
> +@man man/man3/SQLITE_SCANSTAT_NLOOP.3
> +@man man/man3/SQLITE_SERIALIZE_NOCOPY.3
> +@man man/man3/SQLITE_SHM_NLOCK.3
> +@man man/man3/SQLITE_SHM_UNLOCK.3
> +@man man/man3/SQLITE_STATUS_MEMORY_USED.3
> +@man man/man3/SQLITE_STMTSTATUS_FULLSCAN_STEP.3
> +@man man/man3/SQLITE_SYNC_NORMAL.3
> +@man man/man3/SQLITE_TESTCTRL_FIRST.3
> +@man man/man3/SQLITE_TRACE_STMT.3
> +@man man/man3/SQLITE_UTF8.3
> +@man man/man3/SQLITE_VERSION.3
> +@man man/man3/SQLITE_VTAB_CONSTRAINT_SUPPORT.3
> +@man man/man3/SQLITE_WIN32_DATA_DIRECTORY_TYPE.3
> +@man man/man3/sqlite3.3
> +@man man/man3/sqlite3_aggregate_context.3
> +@man man/man3/sqlite3_aggregate_count.3
> +@man man/man3/sqlite3_api_routines.3
> +@man man/man3/sqlite3_auto_extension.3
> +@man man/man3/sqlite3_backup.3
> +@man man/man3/sqlite3_backup_init.3
> +@man man/man3/sqlite3_bind_blob.3
> +@man man/man3/sqlite3_bind_parameter_count.3
> +@man man/man3/sqlite3_bind_parameter_index.3
> +@man man/man3/sqlite3_bind_parameter_name.3
> +@man man/man3/sqlite3_blob.3
> +@man man/man3/sqlite3_blob_bytes.3
> +@man man/man3/sqlite3_blob_close.3
> +@man man/man3/sqlite3_blob_open.3
> +@man man/man3/sqlite3_blob_read.3
> +@man man/man3/sqlite3_blob_reopen.3
> +@man man/man3/sqlite3_blob_write.3
> +@man man/man3/sqlite3_busy_handler.3
> +@man man/man3/sqlite3_busy_timeout.3
> +@man man/man3/sqlite3_cancel_auto_extension.3
> +@man man/man3/sqlite3_changegroup.3
> +@man man/man3/sqlite3_changes.3
> +@man man/man3/sqlite3_changeset_iter.3
> +@man man/man3/sqlite3_clear_bindings.3
> +@man man/man3/sqlite3_close.3
> +@man man/man3/sqlite3_collation_needed.3
> +@man man/man3/sqlite3_column_blob.3
> +@man man/man3/sqlite3_column_count.3
> +@man man/man3/sqlite3_column_database_name.3
> +@man man/man3/sqlite3_column_decltype.3
> +@man man/man3/sqlite3_column_name.3
> +@man man/man3/sqlite3_commit_hook.3
> +@man man/man3/sqlite3_compileoption_used.3
> +@man man/man3/sqlite3_complete.3
> +@man man/man3/sqlite3_config.3
> +@man man/man3/sqlite3_context.3
> +@man man/man3/sqlite3_context_db_handle.3
> +@man man/man3/sqlite3_create_collation.3
> +@man man/man3/sqlite3_create_function.3
> +@man man/man3/sqlite3_create_module.3
> +@man man/man3/sqlite3_data_count.3
> +@man man/man3/sqlite3_data_directory.3
> +@man man/man3/sqlite3_db_cacheflush.3
> +@man man/man3/sqlite3_db_config.3
> +@man man/man3/sqlite3_db_filename.3
> +@man man/man3/sqlite3_db_handle.3
> +@man man/man3/sqlite3_db_mutex.3
> +@man man/man3/sqlite3_db_readonly.3
> +@man man/man3/sqlite3_db_release_memory.3
> +@man man/man3/sqlite3_db_status.3
> +@man man/man3/sqlite3_declare_vtab.3
> +@man man/man3/sqlite3_deserialize.3
> +@man man/man3/sqlite3_destructor_type.3
> +@man man/man3/sqlite3_enable_load_extension.3
> +@man man/man3/sqlite3_enable_shared_cache.3
> +@man man/man3/sqlite3_errcode.3
> +@man man/man3/sqlite3_exec.3
> +@man man/man3/sqlite3_extended_result_codes.3
> +@man man/man3/sqlite3_file.3
> +@man man/man3/sqlite3_file_control.3
> +@man man/man3/sqlite3_finalize.3
> +@man man/man3/sqlite3_get_autocommit.3
> +@man man/man3/sqlite3_get_auxdata.3
> +@man man/man3/sqlite3_get_table.3
> +@man man/man3/sqlite3_index_info.3
> +@man man/man3/sqlite3_initialize.3
> +@man man/man3/sqlite3_interrupt.3
> +@man man/man3/sqlite3_io_methods.3
> +@man man/man3/sqlite3_keyword_count.3
> +@man man/man3/sqlite3_last_insert_rowid.3
> +@man man/man3/sqlite3_limit.3
> +@man man/man3/sqlite3_load_extension.3
> +@man man/man3/sqlite3_log.3
> +@man man/man3/sqlite3_malloc.3
> +@man man/man3/sqlite3_mem_methods.3
> +@man man/man3/sqlite3_memory_used.3
> +@man man/man3/sqlite3_module.3
> +@man man/man3/sqlite3_mprintf.3
> +@man man/man3/sqlite3_mutex.3
> +@man man/man3/sqlite3_mutex_alloc.3
> +@man man/man3/sqlite3_mutex_held.3
> +@man man/man3/sqlite3_mutex_methods.3
> +@man man/man3/sqlite3_next_stmt.3
> +@man man/man3/sqlite3_open.3
> +@man man/man3/sqlite3_overload_function.3
> +@man man/man3/sqlite3_pcache.3
> +@man man/man3/sqlite3_pcache_methods2.3
> +@man man/man3/sqlite3_pcache_page.3
> +@man man/man3/sqlite3_prepare.3
> +@man man/man3/sqlite3_preupdate_hook.3
> +@man man/man3/sqlite3_progress_handler.3
> +@man man/man3/sqlite3_randomness.3
> +@man man/man3/sqlite3_rebaser.3
> +@man man/man3/sqlite3_release_memory.3
> +@man man/man3/sqlite3_reset.3
> +@man man/man3/sqlite3_reset_auto_extension.3
> +@man man/man3/sqlite3_result_blob.3
> +@man man/man3/sqlite3_result_subtype.3
> +@man man/man3/sqlite3_serialize.3
> +@man man/man3/sqlite3_session.3
> +@man man/man3/sqlite3_set_authorizer.3
> +@man man/man3/sqlite3_set_last_insert_rowid.3
> +@man man/man3/sqlite3_sleep.3
> +@man man/man3/sqlite3_snapshot.3
> +@man man/man3/sqlite3_snapshot_cmp.3
> +@man man/man3/sqlite3_snapshot_free.3
> +@man man/man3/sqlite3_snapshot_get.3
> +@man man/man3/sqlite3_snapshot_open.3
> +@man man/man3/sqlite3_snapshot_recover.3
> +@man man/man3/sqlite3_soft_heap_limit.3
> +@man man/man3/sqlite3_soft_heap_limit64.3
> +@man man/man3/sqlite3_sql.3
> +@man man/man3/sqlite3_status.3
> +@man man/man3/sqlite3_step.3
> +@man man/man3/sqlite3_stmt.3
> +@man man/man3/sqlite3_stmt_busy.3
> +@man man/man3/sqlite3_stmt_readonly.3
> +@man man/man3/sqlite3_stmt_scanstatus.3
> +@man man/man3/sqlite3_stmt_scanstatus_reset.3
> +@man man/man3/sqlite3_stmt_status.3
> +@man man/man3/sqlite3_str.3
> +@man man/man3/sqlite3_str_appendf.3
> +@man man/man3/sqlite3_str_errcode.3
> +@man man/man3/sqlite3_str_finish.3
> +@man man/man3/sqlite3_str_new.3
> +@man man/man3/sqlite3_strglob.3
> +@man man/man3/sqlite3_stricmp.3
> +@man man/man3/sqlite3_strlike.3
> +@man man/man3/sqlite3_system_errno.3
> +@man man/man3/sqlite3_table_column_metadata.3
> +@man man/man3/sqlite3_temp_directory.3
> +@man man/man3/sqlite3_test_control.3
> +@man man/man3/sqlite3_threadsafe.3
> +@man man/man3/sqlite3_total_changes.3
> +@man man/man3/sqlite3_trace.3
> +@man man/man3/sqlite3_trace_v2.3
> +@man man/man3/sqlite3_unlock_notify.3
> +@man man/man3/sqlite3_update_hook.3
> +@man man/man3/sqlite3_uri_parameter.3
> +@man man/man3/sqlite3_user_data.3
> +@man man/man3/sqlite3_value.3
> +@man man/man3/sqlite3_value_blob.3
> +@man man/man3/sqlite3_value_dup.3
> +@man man/man3/sqlite3_value_subtype.3
> +@man man/man3/sqlite3_version.3
> +@man man/man3/sqlite3_vfs.3
> +@man man/man3/sqlite3_vfs_find.3
> +@man man/man3/sqlite3_vtab.3
> +@man man/man3/sqlite3_vtab_collation.3
> +@man man/man3/sqlite3_vtab_config.3
> +@man man/man3/sqlite3_vtab_cursor.3
> +@man man/man3/sqlite3_vtab_nochange.3
> +@man man/man3/sqlite3_vtab_on_conflict.3
> +@man man/man3/sqlite3_wal_autocheckpoint.3
> +@man man/man3/sqlite3_wal_checkpoint.3
> +@man man/man3/sqlite3_wal_checkpoint_v2.3
> +@man man/man3/sqlite3_wal_hook.3
> +@man man/man3/sqlite3_win32_set_directory.3
> +@man man/man3/sqlite3changegroup_add.3
> +@man man/man3/sqlite3changegroup_delete.3
> +@man man/man3/sqlite3changegroup_new.3
> +@man man/man3/sqlite3changegroup_output.3
> +@man man/man3/sqlite3changeset_apply.3
> +@man man/man3/sqlite3changeset_apply_strm.3
> +@man man/man3/sqlite3changeset_concat.3
> +@man man/man3/sqlite3changeset_conflict.3
> +@man man/man3/sqlite3changeset_finalize.3
> +@man man/man3/sqlite3changeset_fk_conflicts.3
> +@man man/man3/sqlite3changeset_invert.3
> +@man man/man3/sqlite3changeset_new.3
> +@man man/man3/sqlite3changeset_next.3
> +@man man/man3/sqlite3changeset_old.3
> +@man man/man3/sqlite3changeset_op.3
> +@man man/man3/sqlite3changeset_pk.3
> +@man man/man3/sqlite3changeset_start.3
> +@man man/man3/sqlite3rebaser_configure.3
> +@man man/man3/sqlite3rebaser_create.3
> +@man man/man3/sqlite3rebaser_delete.3
> +@man man/man3/sqlite3rebaser_rebase.3
> +@man man/man3/sqlite3session_attach.3
> +@man man/man3/sqlite3session_changeset.3
> +@man man/man3/sqlite3session_create.3
> +@man man/man3/sqlite3session_delete.3
> +@man man/man3/sqlite3session_diff.3
> +@man man/man3/sqlite3session_enable.3
> +@man man/man3/sqlite3session_indirect.3
> +@man man/man3/sqlite3session_isempty.3
> +@man man/man3/sqlite3session_patchset.3
> +@man man/man3/sqlite3session_table_filter.3
> +@man man/man3/sqlite_int64.3
>

--
James Turner