<commit_before>import pypyodbc
import pymysql
import os
from configparser import ConfigParser
from lib.database import Database
from lib.quickbooks.entity import Entity
from lib.quickbooks.invoice import *
from lib.quickbooks.credit_memo import *
from lib.quickbooks.customer import *
from lib.quickbooks.sales_order import *

conf = ConfigParser()
conf.read_file(open('config.ini'))

# configuration
mysql_host = conf.get('mysql', 'host')
mysql_port = conf.getint('mysql', 'port')
mysql_user = conf.get('mysql', 'user')
mysql_password = conf.get('mysql', 'password')
mysql_db = conf.get('mysql', 'schema')
qodbc_dsn = conf.get('qodbc', 'dsn')

# set defaults
Entity.company_file = conf.get('company', 'file_number')

#if(conf.get('company', 'refresh_from')):
#    Entity.last_entry_datetime = conf.get('company', 'refresh_from')


rackspace = Database(pymysql.connect(host=mysql_host, port=mysql_port, user=mysql_user, passwd=<PASSWORD>, db=mysql_db, use_unicode=True, charset="utf8"))
quickbooks = Database(pypyodbc.connect('DSN='+qodbc_dsn, autocommit=True))

print('connected')

#Customer(quickbooks, rackspace).sync()

#Invoice(quickbooks, rackspace).sync()
#InvoiceItem(quickbooks, rackspace).sync()
#InvoiceLink(quickbooks, rackspace).sync()

#CreditMemo(quickbooks, rackspace).sync()
#CreditMemoItem(quickbooks,rackspace).sync()
#CreditMemoLink(quickbooks,rackspace).sync()

#SalesOrder(quickbooks,rackspace).sync()
#SalesOrderItem(quickbooks,rackspace).sync()
#SalesOrderLink(quickbooks,rackspace).sync()

#Estimate(quickbooks,rackspace).sync()
#EstimateItem(quickbooks,rackspace).sync()
#EstimateLink(quickbooks,rackspace).sync()

rackspace.disconnect()
quickbooks.disconnect()

print('disconnected')<commit_msg>Add estimates to sync<commit_after>import pypyodbc
import pymysql
import os
from configparser import ConfigParser
from lib.database import Database
from lib.quickbooks.entity import Entity
from lib.quickbooks.invoice import *
from lib.quickbooks.credit_memo import *
from lib.quickbooks.customer import *
from lib.quickbooks.sales_order import *
from lib.quickbooks.estimate import *

conf = ConfigParser()
conf.read_file(open('config.ini'))

# configuration
mysql_host = conf.get('mysql', 'host')
mysql_port = conf.getint('mysql', 'port')
mysql_user = conf.get('mysql', 'user')
mysql_password = conf.get('mysql', 'password')
mysql_db = conf.get('mysql', 'schema')
qodbc_dsn = conf.get('qodbc', 'dsn')

# set defaults
Entity.company_file = conf.get('company', 'file_number')

#if(conf.get('company', 'refresh_from')):
#    Entity.last_entry_datetime = conf.get('company', 'refresh_from')


rackspace = Database(pymysql.connect(host=mysql_host, port=mysql_port, user=mysql_user, passwd=<PASSWORD>, db=mysql_db, use_unicode=True, charset="utf8"))
quickbooks = Database(pypyodbc.connect('DSN='+qodbc_dsn, autocommit=True))

print('connected')

#Customer(quickbooks, rackspace).sync()

#Invoice(quickbooks, rackspace).sync()
#InvoiceItem(quickbooks, rackspace).sync()
#InvoiceLink(quickbooks, rackspace).sync()

#CreditMemo(quickbooks, rackspace).sync()
#CreditMemoItem(quickbooks,rackspace).sync()
#CreditMemoLink(quickbooks,rackspace).sync()

#SalesOrder(quickbooks,rackspace).sync()
#SalesOrderItem(quickbooks,rackspace).sync()
#SalesOrderLink(quickbooks,rackspace).sync()

Estimate(quickbooks,rackspace).sync()
EstimateItem(quickbooks,rackspace).sync()
EstimateLink(quickbooks,rackspace).sync()

rackspace.disconnect()
quickbooks.disconnect()

print('disconnected')
{'fraction_non_alphanumeric': 0.14797820476053913, 'fraction_numerical': 0.0005735589331803843, 'mean_word_length': 8.965714285714286, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4641507', 'n_tokens_mistral': 1192, 'n_tokens_neox': 1149, 'n_words': 195}