def __delattr__(self, name):
# BaseConnection has a delattr that forbids
# all deletion. Not helpful.
if name in self.__dict__:
self.__dict__.pop(name)
else:
BaseConnection.__delattr__(self, name)
def __init__(self, *arg, **kwargs):
while 1:
try:
Connection.__init__(self, *arg, **kwargs)
self.pid = os.getpid()
break
except:
pass
def __init__(self, *arg, **kwargs):
while 1:
try:
Connection.__init__(self, *arg, **kwargs)
self.pid = os.getpid()
break
except:
pass
def __init__(self, *arg, **kwargs):
while 1:
try:
logging.debug('connect with %s %s', arg, kwargs)
Connection.__init__(self, *arg, **kwargs)
self.pid = os.getpid()
break
except:
logging.error(traceback.format_exc())
def __init__(self, *arg, **kwargs):
while 1:
try:
logging.debug('connect with %s %s', arg, kwargs)
Connection.__init__(self, *arg, **kwargs)
self.pid = os.getpid()
break
except:
logging.error(traceback.format_exc())
def _connect(**conn_override) -> Connection:
conn_args = dict(host=settings.DB_HOST,
user=settings.DB_USER,
password=settings.DB_PASS,
port=settings.DB_PORT)
if not empty(settings.DB_NAME):
conn_args['database'] = settings.DB_NAME
conn_args = {**conn_args, **conn_override}
return Connection(**conn_args)
def Connect(*args, **kwargs):
# import pymysql.cursors
# # Connect to the database
# connection = pymysql.connect(host='localhost',
# user='******',
# password='',
# db='ATEC_DB_MYSQL',
# charset='utf8mb4',
# cursorclass=pymysql.cursors.DictCursor)
"""Factory function for connections.Connection."""
from MySQLdb.connections import Connection
return Connection(*args, **kwargs)
def Connect(*args, **kwargs):
"""Factory function for connections.Connection."""
from MySQLdb.connections import Connection
return Connection(*args, **kwargs)
from dataset import InputDataSet
from selected_result import SelectResult
import configparser
conf_dir = dirname(dirname(abspath(__file__)))
config = configparser.ConfigParser()
config.read(join(conf_dir, 'app.conf'), encoding='utf-8')
SYS_USER = os.getenv("USER") # get system user
CONFIG = {
'user': config['DB']['user'] if SYS_USER == 'dimasty' else 'root',
'password': config['DB']['user'] if SYS_USER == 'dimasty' else '',
'host': config['DB']['host'],
'database': config['DB']['database']
}
db = Connection(**CONFIG)
dbc = db.cursor()
db.set_character_set('utf8')
dbc.execute('SET NAMES utf8;')
dbc.execute('SET CHARACTER SET utf8;')
dbc.execute('SET character_set_connection=utf8;')
def usage():
print("\nThis is the usage function\n")
print("Usage: " + sys.argv[0] + " -f <file> or --data-file=<file>]")
def get_duplicate_name():
try:
dbc.execute(queries.FIND_PERSON_DUPLICATES)
import datetime
import time
from MySQLdb.connections import Connection
from MySQLdb.cursors import DictCursor
def timeUnix():
return int(time.time())
if __name__ == '__main__' :
connect = Connection(host='192.168.1.2',user='******',passwd='5OpqU7zv324a7KJxu@4d',db='xiaolajiao',port=3306,charset='utf8')
cursor = connect.cursor(cursorclass=DictCursor)
cursor.execute(""" select * from shouji_goods WHERE is_promote = 1 AND promote_cycle>0 """)
rows = cursor.fetchall()
for goods in rows:
# print(datetime.datetime.fromtimestamp(goods.get('promote_end_date')).strftime('%Y-%m-%d %H:%M:%S'))
if(goods.get('promote_end_date')<=timeUnix()):
startDate = goods.get('promote_end_date')
endDate = int(goods.get('promote_end_date')) + int(goods.get('promote_cycle'))*24*3600
cursor.execute(""" update shouji_goods SET promote_start_date=%s,promote_end_date=%s WHERE goods_id=%s""" % (startDate,endDate,goods.get('goods_id')))
cursor.close()
connect.close()
def __init__(self, *arg, **kwargs):
Connection.__init__(self, *arg, **kwargs)
self.pid = os.getpid()
def _critical_commit(self):
try:
BaseConnection.commit(self)
finally:
self.exit_critical_phase_at_transaction_end()
def _critical_rollback(self):
try:
BaseConnection.rollback(self)
finally:
self.exit_critical_phase_at_transaction_end()
def _critical_query(self, query):
return BaseConnection.query(self, query)
def close(self):
self.__close_watchers()
BaseConnection.close(self)
def db(self):
return self.__db if isinstance(self.__db,Connection)\
else Connection(host=dbhost, user=dbuser, passwd=dbpass, db=dbname)
