App-Office-Contacts

 view release on metacpan or  search on metacpan

Changelog.ini  view on Meta::CPAN

[Module]
Name=App::Office::Contacts
Changelog.Creator=Module::Metadata::Changes V 2.05
Changelog.Parser=Config::IniFiles V 2.82

[V 2.04]
Date=2014-02-06T14:06:00
Comments= <<EOT
- Add code for Pg and MySQL re utf8 in the DBI attributes.
See App::Office::Contacts::Util::Logger. See lines 44 .. 57.
- Default to mysql_enable_utf8 = 1 and pg_enable_utf8 = 0 in the config file. See lines 48 .. 52.
I'm using pg_enable_utf8 = 0 in order to make my code work under DBD::Pg V 3.0.0.
EOT

[V 2.03]
Date=2014-01-23T10:36:00
Comments= <<EOT
- Switch from bareword file handles to lexically-named file handles. This stops these types of msgs:
Use of bareword filehandle in open at lib/App/Office/Contacts/Database/Library.pm line 74.
- Not that I don't use the JS '$.uiBackCompat = false;', I had to re-write some of the JS to not use
obsolete features of jQuery UI.

Changes  view on Meta::CPAN

Revision history for Perl extension App::Office::Contacts.

2.04  Thu Feb  6 14:06:00 2014
	- Add code for Pg and MySQL re utf8 in the DBI attributes.
		See App::Office::Contacts::Util::Logger. See lines 44 .. 57.
	- Default to mysql_enable_utf8 = 1 and pg_enable_utf8 = 0 in the config file. See lines 48 .. 52.
		I'm using pg_enable_utf8 = 0 in order to make my code work under DBD::Pg V 3.0.0.

2.03  Thu Jan 23 10:36:00 2014
	- Switch from bareword file handles to lexically-named file handles. This stops these types of msgs:
		Use of bareword filehandle in open at lib/App/Office/Contacts/Database/Library.pm line 74.
	- Not that I don't use the JS '$.uiBackCompat = false;', I had to re-write some of the JS to not use
		obsolete features of jQuery UI.

2.02  Thu Nov 13 15:11:00 2013
	- Replace decode/encode('utf8', $x) with decode/encode('utf-8', $x).

lib/App/Office/Contacts.pm  view on Meta::CPAN

Yes. L<Text::CSV::Encoded> is used in C<App::Office::Contacts::Util::Import> to read data/fake.people.txt.

See L</Creating and populating the database> for a discussion of scripts/populate.fake.people.pl.

Do a search for Brocard, the author of the original L<GraphViz>, and you will find LE<233>on Brocard.

Also, see lines 48 .. 52 in the config file for options to control the utf8 setting in the connect() attributes
as used by L<DBI>. These are the defaults:

	mysql_enable_utf8 = 1
	# pg_enable_utf8 == 0 for DBD::Pg V 3.0.0 in my code.
	pg_enable_utf8    = 0
	sqlite_unicode    = 1

These values are used in App::Office::Contacts::Util::Logger lines 44 .. 57.

=head2 Why not allow multiple Facebook and Twitter tags per org or person?

This is under consideration.

lib/App/Office/Contacts/Util/Logger.pm  view on Meta::CPAN

{
	my($self)   = @_;
	my($config) = $self -> module_config;
	my($attr)   =
	{
		AutoCommit => defined($$config{AutoCommit}) ? $$config{AutoCommit} : 1,
		RaiseError => defined($$config{RaiseError}) ? $$config{RaiseError} : 1,
	};
	my(%driver) =
	(
		mysql_enable_utf8 => qr/dbi:MySQL/i,
		pg_enable_utf8    => qr/dbi:Pg/i,
		sqlite_unicode    => qr/dbi:SQLite/i,
	);

	for my $db (keys %driver)
	{
		if ($$config{dsn} =~ $driver{$db})
		{
			$$attr{$db} = defined($$config{$db}) ? $$config{$db} : 1;
		}

share/.htapp.office.contacts.conf  view on Meta::CPAN

#dsn            = dbi:mysql:database=contacts
dsn             = dbi:Pg:dbname=contacts
log_table_name  = log
pg_bytea        = 0
pg_text         = 1
RaiseError      = 1
username        = contact
password        = contact
max_note_length = 10000

mysql_enable_utf8 = 1
# pg_enable_utf8 == 0 for DBD::Pg V 3.0.0 in my code.
pg_enable_utf8    = 0
sqlite_unicode    = 1

# Identification stuff (for the About tab)
# ----------------------------------------

program_author  = Ron Savage
program_faq_url = /assets/templates/app/office/contacts/faq.html
program_name    = App::Office::Contacts