Automated Csv Import To Mysql Server Code Example


Example: automated csv import to mysql server

#!/bin/bash IMPORTED_FILE_PATH=/path/to/your/imported/file.csv TABLENAME=target_table_name DATABASE=db_name TMP_FILENAME=/tmp/${TABLENAME}.cvs # do nothing if imported file does not exist [ -f "$IMPORTED_FILE_PATH" ] || exit 0 # if temporary file exists, then it means previous import job is running. Also do nothing [ -f "$TMP_FILENAME" ] && exit 0 # Move it to tmp and rename to target table name mv "$IMPORTED_FILE_PATH" "$TMP_FILENAME" mysqlimport --user=mysqlusername --password=mysqlpassword --host=mysqlhost --local $DATABASE $TMP_FILENAME rm -f "$TMP_FILENAME"

Comments

Post a Comment

Popular posts from this blog

Chrome Ipad Extensions Code Example

Example: chrome extension on ipad No, Chrome extensions do not work on iPad or iPhone. There is no web browser for the iPad that allows a desktop-level extension. It is not Apple’s policy to allow developers to include downloadable module engines in their apps, for multiple reasons which also include Apple’s security restrictions.
Read more

AngularJS $on Event Handler Trigger Order

Answer : Very good question. Event handlers are executed in order of initialization. I haven't really thought about this before, because my handlers never needed to know which one run first, but by the look of you fiddle I can see that the handlers are called in the same order in which they are initialized. In you fiddle you have a controller controllerA which depends on two services, ServiceA and ServiceB : myModule .controller('ControllerA', [ '$scope', '$rootScope', 'ServiceA', 'ServiceB', function($scope, $rootScope, ServiceA, ServiceB) {...} ] ); Both services and the controller define an event listener. Now, all dependencies need to be resolved before being injected, which means that both services will be initialized before being injected into the controller. Thus, handlers defined in the services will be called first, because service factories are initialized before contro...
Read more