Search found 6 matches

by Ram668000
Tue Nov 03, 2020 6:33 am
Forum: General Discussion
Topic: How to load SQL data into MongoDB using python script
Replies: 3
Views: 11385

How to load SQL data into MongoDB using python script

Hi Team,

Please help on bellow requirement.

Need to load data from SQL DB to Mongo DB using python script. Please help on same
by Ram668000
Tue Nov 03, 2020 6:30 am
Forum: General Discussion
Topic: SQL results to MS Teams using Python in table format
Replies: 7
Views: 18990

Re: SQL results to MS Teams using Python in table format

Thank you all. Issue was resolved
by Ram668000
Fri Sep 25, 2020 2:02 pm
Forum: General Discussion
Topic: SQL results to MS Teams using Python in table format
Replies: 7
Views: 18990

Re: SQL results to MS Teams using Python in table format

I think I like this formatting a bit better, and iterating over lists is more efficient. df = pd.read_sql(sql_query, conn) results = str(df).split(' ') columns = ['Status', 'Enum', 'Booking Status'] database_table_output = [] for i in range...
by Ram668000
Fri Sep 25, 2020 2:01 pm
Forum: General Discussion
Topic: SQL results to MS Teams using Python in table format
Replies: 7
Views: 18990

Re: SQL results to MS Teams using Python in table format

There's no "table" in Python. In generic terms, I think you'd want an associative array. Python supports dictionaries, which is a collection of key-value pairs. Keys and values can be of any data type I believe. There may be a more efficient or pythonic way to do this, but implement first...
by Ram668000
Fri Sep 25, 2020 7:38 am
Forum: General Discussion
Topic: SQL results to MS Teams using Python in table format
Replies: 7
Views: 18990

SQL results to MS Teams using Python in table format

Hi Team, Have wrote a small python script to send results to MS teams , when am try to sending it coming as string format. My Code: import pymsteams import pandas as pd import numpy as np import pyodbc from tabulate import tabulate server = ‘ServerName’ database = ‘DBName’ username = ‘username’ pass...

Go to advanced search