![]() I would advocate that for your team collaboration needs, you pick a tool that's exclusive to work, though not everyone agrees on this. As I write this, for example, I'm using at least two team collaboration tools, but the notifications are silenced so that I can check in periodically as the breaks in my work allow for it, just as I silence social media notifications when I really need to get stuff done. And it's equally important to be able to give yourself the space to work uninterrupted when you have tasks that require longer periods of concentration. There's still a perception out there in some circles that chat applications can be a distraction, and I do believe it's important to have a commitment to reel in off-topic threads before they create a cognitive disruption. Whether your colleagues are sitting across the room from you or on the other side of the planet, the ability to communicate in real-time makes many conversations faster, easier, and can help reduce confusion that might emerge in asynchronous communication. ![]() One collaboration tool which has become indispensable is team chat. What tools work best for you depends a bit on your situation, but might include anything from mailing lists for email communication, Git or Subversion for version control, a wiki or Etherpad for collaborative authoring, a shared task list for organizing workflow, or even a full-fledged project management suite. In any collaborative environment, it's important to have good tools for communication. Last_eventid_file.write(this_last_eventid) Last_eventid_file = open(last_eventid_filepath,'w') Print("%s eventID=%s, transactionID=%s, transactionStatus=%s" % (indexTime, row, row, row))Įxcept _mssql.MssqlDatabaseException as e: Sql_query = 'SELECT ' columns ' FROM ' table ' WHERE ' countkey ' > ' str(last_eventid) ' ORDER BY ' countkeyĬonn = _nnect(sql_server, sql_uname, sql_pw, database) # SELECT TOP 1000 eventID, transactionID, transactionStatus FROM table WHERE eventID > lastEventID ORDER BY eventID # Fetch 1000 rows starting from the last event read ('Error: ' last_eventid_filepath ' file not found! Starting from zero. ('Error: failed to read last_eventid file, ' last_eventid_filepath '\n') Real exception handler would be more robust Last_eventid = int(last_eventid_file.readline()) Last_eventid_file = open(last_eventid_filepath,'r') If os.path.isfile(last_eventid_filepath): # Open file containing the last event ID and get the last record read ![]() Last_eventid_filepath = "" # user supplies correct path Sql_server = "SQLserver" #Address to database serverĬolumns = 'TOP 1000 eventID, transactionID, transactionStatus' This script has been made cross-compatible with Python 2 and Python 3 using python-future. FreeTDS 0.63 or newer (*nix and Mac OS X platforms only). ![]() It assumes you have all the necessary libraries referenced in the script. The Python version of the example accesses a Microsoft SQL Server database. The code has been simplified for readability and does not necessarily represent best coding practices. Here is a python version of the database poll example. Update eventID in last_eventid file Script example, poll a database (Python) # WHERE eventID > lastEventID AND ROWNUM <= 1000 ORDER BY eventIDĭefine path to file that holds eventID of last record read # WHERE eventID > lastEventID LIMIT 1000 ORDER BY eventID # SELECT eventID, transactionID, transactionStatus FROM table # WHERE eventID > lastEventID ORDER BY eventID # SELECT TOP 1000 eventID, transactionID, transactionStatus FROM table # writes them to stdout for indexing by splunk, ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |