first sql source implementation

[bdrem.git] / data / bdrem.config.php.dist

diff --git a/data/bdrem.config.php.dist b/data/bdrem.config.php.dist
index 522a4772ad63909abc9ae774be9838432875c855..7af4ed0dc4f3e5907a311f29e3427a4df2f3b0dd 100644 (file)
--- a/data/bdrem.config.php.dist
+++ b/data/bdrem.config.php.dist
@@ -1,5 +1,28 @@
 <?php
+//source: birthday file
 $source = array('Bdf', '/path/to/birthday.bdf');
+
+//Source: SQL database
+$source = array(
+    'Sql',
+    array(
+        'dsn' => 'mysql:dbname=bdrem;host=127.0.0.1',
+        'user' => 'FIXME',
+        'password' => 'FIXME',
+        'table' => 'contacts',
+        'fields' => array(
+            'date' => array(
+                //column name => event title
+                'c_birthday' => 'Birthday'
+            ),
+            //column with name
+            'name' => 'c_name'
+        )
+    )
+);
+
+
 $daysBefore = 3;
 $daysAfter = 14;
+$locale = 'de_DE.UTF-8';
 ?>