File manager - Edit - /home/newsbmcs.com/public_html/static/img/logo/MySQLdb.tar
Back
times.py 0000644 00000007252 15030565733 0006254 0 ustar 00 """times module This module provides some Date and Time classes for dealing with MySQL data. Use Python datetime module to handle date and time columns. """ from time import localtime from datetime import date, datetime, time, timedelta from MySQLdb._mysql import string_literal Date = date Time = time TimeDelta = timedelta Timestamp = datetime DateTimeDeltaType = timedelta DateTimeType = datetime def DateFromTicks(ticks): """Convert UNIX ticks into a date instance.""" return date(*localtime(ticks)[:3]) def TimeFromTicks(ticks): """Convert UNIX ticks into a time instance.""" return time(*localtime(ticks)[3:6]) def TimestampFromTicks(ticks): """Convert UNIX ticks into a datetime instance.""" return datetime(*localtime(ticks)[:6]) format_TIME = format_DATE = str def format_TIMEDELTA(v): seconds = int(v.seconds) % 60 minutes = int(v.seconds // 60) % 60 hours = int(v.seconds // 3600) % 24 return "%d %d:%d:%d" % (v.days, hours, minutes, seconds) def format_TIMESTAMP(d): """ :type d: datetime.datetime """ if d.microsecond: fmt = " ".join( [ "{0.year:04}-{0.month:02}-{0.day:02}", "{0.hour:02}:{0.minute:02}:{0.second:02}.{0.microsecond:06}", ] ) else: fmt = " ".join( [ "{0.year:04}-{0.month:02}-{0.day:02}", "{0.hour:02}:{0.minute:02}:{0.second:02}", ] ) return fmt.format(d) def DateTime_or_None(s): try: if len(s) < 11: return Date_or_None(s) micros = s[20:] if len(micros) == 0: # 12:00:00 micros = 0 elif len(micros) < 7: # 12:00:00.123456 micros = int(micros) * 10 ** (6 - len(micros)) else: return None return datetime( int(s[:4]), # year int(s[5:7]), # month int(s[8:10]), # day int(s[11:13] or 0), # hour int(s[14:16] or 0), # minute int(s[17:19] or 0), # second micros, # microsecond ) except ValueError: return None def TimeDelta_or_None(s): try: h, m, s = s.split(":") if "." in s: s, ms = s.split(".") ms = ms.ljust(6, "0") else: ms = 0 if h[0] == "-": negative = True else: negative = False h, m, s, ms = abs(int(h)), int(m), int(s), int(ms) td = timedelta(hours=h, minutes=m, seconds=s, microseconds=ms) if negative: return -td else: return td except ValueError: # unpacking or int/float conversion failed return None def Time_or_None(s): try: h, m, s = s.split(":") if "." in s: s, ms = s.split(".") ms = ms.ljust(6, "0") else: ms = 0 h, m, s, ms = int(h), int(m), int(s), int(ms) return time(hour=h, minute=m, second=s, microsecond=ms) except ValueError: return None def Date_or_None(s): try: return date( int(s[:4]), int(s[5:7]), int(s[8:10]), ) # year # month # day except ValueError: return None def DateTime2literal(d, c): """Format a DateTime object as an ISO timestamp.""" return string_literal(format_TIMESTAMP(d)) def DateTimeDelta2literal(d, c): """Format a DateTimeDelta object as a time.""" return string_literal(format_TIMEDELTA(d)) release.py 0000644 00000000162 15030565733 0006544 0 ustar 00 __author__ = "Inada Naoki <songofacandy@gmail.com>" __version__ = "2.2.7" version_info = (2, 2, 7, "final", 0) __pycache__/cursors.cpython-310.pyc 0000644 00000036622 15030565733 0013175 0 ustar 00 o �h�? � @ s� d Z ddlZddlmZ e�d�g d��ejejB �ZG dd� d�Z G d d � d �Z G dd� d�ZG d d� d�ZG dd� d�Z G dd� de ee �ZG dd� de e e �ZG dd� deee �ZG dd� dee e �ZdS )zyMySQLdb Cursors This module implements Cursors of various types for MySQLdb. By default, MySQLdb uses the Cursor class. � N� )�ProgrammingError� )z'\s*((?:INSERT|REPLACE)\b.+\bVALUES?\s*)z6(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))z(\s*(?:ON DUPLICATE.*)?);?\s*\Zc @ s& e Zd ZdZdZddlmZmZmZm Z m Z mZmZm Z mZmZmZ dZdd� Zdd � Zd d� Zdd � Zdd� Zdd� Zdd� Zdd� Zdd� Zdd� Zdd� Zdd� Zd1dd�Zd1d d!�Zd1d"d#�Z d$d%� Z!d&d'� Z"d2d)d*�Z#d+d,� Z$d3d-d.�Z%d/d0� Z&eZeZe Z e Z eZeZe Z eZeZeZdS )4� BaseCursora A base for Cursor classes. Useful attributes: description A tuple of DB API 7-tuples describing the columns in the last executed query; see PEP-249 for details. description_flags Tuple of column flags for last query, one entry per column in the result set. Values correspond to those in MySQLdb.constants.FLAG. See MySQL documentation (C API) for more information. Non-standard extension. arraysize default number of rows fetchmany() will fetch i r )� MySQLError�Warning�Error�InterfaceError� DatabaseError� DataError�OperationalError�IntegrityError� InternalErrorr �NotSupportedErrorNc C s@ || _ d | _d | _d| _d| _d | _d | _d | _d | _d | _ d S )Nr r ) � connection�description�description_flags�rowcount� arraysize� _executed� lastrowid�_result� rownumber�_rows)�selfr � r �E/usr/local/CyberPanel/lib/python3.10/site-packages/MySQLdb/cursors.py�__init__A s zBaseCursor.__init__c C sh d | _ d | _d | _d | _| jr| j�� d | _| j}|d u r d S |�� dkr2|�� |�� dks&d S d S �Nr ) r r r r r �discardr �next_result�discard_result�r �conr r r �_discardN s �zBaseCursor._discardc C sF z| j du rW d| _ d| _dS | �� W d| _ d| _dS d| _ d| _w )z6Close the cursor. No further queries will be possible.N)r r r$ �r r r r �closeb s � �zBaseCursor.closec C � | S �Nr r% r r r � __enter__l � zBaseCursor.__enter__c G s ~| � � d S r( )r&