Python dbapi2.connect函数代码示例

    def __conectar(self):
        """Método privado, que nos servirá para conectarnos a la base de datos."""

# Comprobamos si ya existe la base de datos
# para simplemente, conectarnos.

        if os.path.exists(self.__fichero):
            return sqlite.connect(self.__fichero)

        # En caso de que no exista, creamos la base de datos.

        else:

            conexion = sqlite.connect(self.__fichero)
            cursor = conexion.cursor()
# Creamos la tabla CLIENTES
            TABLA = """
                    CREATE TABLE CLIENTES (
                    ID INTEGER PRIMARY KEY,
                    NOMBRE VARCHAR(20),
                    APELLIDOS VARCHAR(40),
                    EMAIL VARCHAR(30),
                    TELEFONO VARCHAR(12),
                    EMPRESA VARCHAR(30),
                    CIFONIF VARCHAR(30),
                        );"""
                        # ejecutamos la sentencia
            cursor.execute(TABLA)
                        # MUY IMPORTANTE:
            conexion.commit()
                        # devolvemos la conexión
            return conexion

    def __init__(self, api_key='', debug=False, lang='fr'):

        self.api_key = self.ADDON.getSetting('api_tmdb')
        self.debug = debug
        self.lang = lang
        self.poster = 'https://image.tmdb.org/t/p/%s' % self.ADDON.getSetting('poster_tmdb')
        self.fanart = 'https://image.tmdb.org/t/p/%s'  % self.ADDON.getSetting('backdrop_tmdb')
        #self.cache = cConfig().getFileCache()

        try:
            #if not os.path.exists(self.cache):
            if not xbmcvfs.exists(self.CACHE):
                #f = open(self.cache,'w')
                #f.close()
                self.db = sqlite.connect(self.REALCACHE)
                self.db.row_factory = sqlite.Row
                self.dbcur = self.db.cursor()
                self.__createdb()
        except:
            VSlog('erreur: Impossible d ecrire sur %s' % self.REALCACHE )
            pass

        try:
            self.db = sqlite.connect(self.REALCACHE)
            self.db.row_factory = sqlite.Row
            self.dbcur = self.db.cursor()
        except:
            VSlog('erreur: Impossible de ce connecter sur %s' % self.REALCACHE )
            pass

def makeSQliteTables():
#2008-05-29 [email protected]
#This is pretty tricky...
#We first set up the SQLite and MySQL connector statements
#And then we grab all the counties from the county table
#on coolprime and push into a SQLite db. Once we have the
#counties we iterate through each county and grab the column
#headers so we can build a 'create xxxxx_county_reports' statement
#based on the structure of the table on coolprime. This way we 
#can mod the table structure at will and this code will adapt.
#Sweet!
#

    #SQLite
    global beachreports
    if(DEBUG == 0):
        beachreports = sqlite.connect(":memory:", isolation_level=None)
    
    else:
        beachreports = sqlite.connect("./beachreports.db", isolation_level=None)
    
    cur1 = beachreports.cursor()
    cur2 = beachreports.cursor()
    cur1.execute('create table counties (id integer primary key, county varchar(25))')
    cur1.execute('create table subscribers (id integer primary key, email varchar(25), county varchar(25))')

    #MySQL
    global db
    db = MySQLdb.connect(host=dbHost, user=dbUser, passwd=dbPass,db=dbDB)
    cursor1 = db.cursor()
    cursor2 = db.cursor()
    countyQuery = "SELECT county from counties ORDER BY county ASC"
    result = cursor1.execute(countyQuery)
    if (result != 0):
        for (myCounty) in cursor1:
            createStatement = ""
            county = "%s" % myCounty
            county_reports = "%s_county_reports" % county
            #print "County: %s" % county
            cur2.execute("INSERT into counties(county) VALUES(?)", (county, ))
            #get column headers
            columnQuery = "DESCRIBE %s" % county_reports
            result = cursor2.execute(columnQuery)
            index = 1
            if (result != 0):
                for (header) in cursor2:
                    if(index < result):
                       createStatement = createStatement + "%s %s," % (header[0],header[1])
                    else:
                       createStatement = createStatement + "%s %s" % (header[0],header[1])
                    index += 1
                createStatement = "create table " + county_reports + \
                "(" "id integer primary key," + createStatement + ")"
            if(DEBUG > 1):
                print "makeSQLiteTables(): createStatement = %s\n" % createStatement
            cur2.execute(createStatement)
    cur1.close()
    cur2.close()
    cursor1.close()
    cursor2.close()

def deleteFavourite(meta, content):
    try:
        meta = json.loads(meta)
        imdb = meta['imdb']
        if 'title' in meta: title = meta['title']
        if 'tvshowtitle' in meta: title = meta['tvshowtitle']

        try:
            dbcon = database.connect(control.favouritesFile)
            dbcur = dbcon.cursor()
            dbcur.execute("DELETE FROM %s WHERE id = '%s'" % (content, imdb))
            dbcon.commit()
        except:
            pass
        try:
            dbcon = database.connect(control.databaseFile)
            dbcur = dbcon.cursor()
            dbcur.execute("DELETE FROM favourites WHERE imdb_id = '%s'" % imdb)
            dbcon.commit()
        except:
            pass

        control.refresh()
        control.infoDialog(control.lang(30412).encode('utf-8'), heading=title)
    except:
        return

 def onPlayBackStopped(self):
     '''
     Called when playback is stopped (normal or otherwise)
     
     Checks to see if we've watched more than watch_percent. If so, then the bookmark is deleted and 
     watchedCallback is called if it exists.
     If we didn't play at all, raises a playback failed exception.
     Otherwise, save a new bookmark at the furthest watched spot.
     '''
     addon.log('> onPlayBackStopped')
     self._playbackLock.clear()
     
     playedTime = self._lastPos
     addon.log('playedTime / totalTime : %s / %s = %s' % (playedTime, self._totalTime, playedTime/self._totalTime))
     if playedTime == 0 and self._totalTime == 999999:
         raise PlaybackFailed('XBMC silently failed to start playback')
     elif (((playedTime/self._totalTime) > self.watch_percent) and (self.video_type == 'movie' or (self.season and self.episode))):
         addon.log('Threshold met.')
         if self.watchedCallback: self.watchedCallback()
         db = sqlite.connect(DB_PATH)
         db.execute('DELETE FROM bookmarks WHERE plugin=? AND video_type=? AND title=? AND season=? AND episode=? AND year=?', (self.plugin, self.video_type, self.title, self.season, self.episode, self.year))
         db.commit()
         db.close()
     else:
         addon.log('Threshold not met. Saving bookmark')
         db = sqlite.connect(DB_PATH)
         db.execute('INSERT OR REPLACE INTO bookmarks (plugin, video_type, title, season, episode, year, bookmark) VALUES(?,?,?,?,?,?,?)',
                   (self.plugin, self.video_type, self.title, self.season, self.episode, self.year, playedTime))
         db.commit()
         db.close()

def main(argv):
    if len(argv) != 3:
        print >> sys.stderr, "Syntax: %s old.db new.db" % argv[0]
        print >> sys.stderr, "New db must exist but have no contents."

    con1 = sqlite.connect(argv[1])
    con1.text_factory = str
    cur1 = con1.cursor()
    con2 = sqlite.connect(argv[2])
    cur2 = con2.cursor()

    # Convert table board
    cur1.execute('SELECT id, title FROM board')
    for result in cur1.fetchall():
        cur2.execute(u'INSERT INTO board (id, title) VALUES (%s, %s)' %
                     tuple([sqlquote(x) for x in result]))
    # Convert for table forum
    cur1.execute('SELECT id, boardid, title FROM forum')
    for result in cur1.fetchall():
        cur2.execute(u'INSERT into forum (id, boardid, title) VALUES '\
                     u'(%s, %s, %s)' % tuple(
                         [sqlquote(x) for x in result]))
    # Convert for table message
    cur1.execute('SELECT id, forumid, boardid, mdate, mtime, mto, mfrom, reference, subject, body FROM message')
    for result in cur1.fetchall():
        cur2.execute(u'INSERT into message (id, forumid, boardid, mdate, mtime, mto, mfrom, reference, subject, body) VALUES '\
                     u'(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' % tuple(
                         [sqlquote(x) for x in result]))
    con2.commit()
    con2.close()

    def __init__(self, dbPath=".", dbName="UbuWeb.db", dbURL=None, updateURL=None, init=True, xbmc=True):
        # TODO
        # Make option to check status of database
        self.dbPath = os.path.join(dbPath, dbName)
        self.dbURL = dbURL
        self.updateURL = updateURL

        if init:
            if not os.path.exists(dbPath):
                os.makedirs(dbPath)
                if dbURL is not None:
                    self.getDB(self.dbURL)

                    self.db = sqlite.connect(self.dbPath)
                    self.db.text_factory = str
                else:
                    self.db = sqlite.connect(self.dbPath)
                    self.db.text_factory = str
                    self.createUbuWebDB()
                    self.parseFilmListingPage(numLinks=None, startLink=16)
            else:
                self.db = sqlite.connect(self.dbPath)
                self.db.text_factory = str
                if self.updateURL is not None:
                    self.checkDB()

def create_database(driver, database, username=None, password=None, 
                    hostname=None):
    if driver == 'sqlite':
        db = SqliteDatabase(database)
        return db
    elif driver == 'mysql':
        db = MysqlDatabase(database, username, password, hostname)
    elif driver == 'postgres':
        # TODO
        raise DatabaseDriverNotSupported
    else:
        raise DatabaseDriverNotSupported
                
    # Try to connect to database
    try:
        db.connect().close()
        return db
    except AccessDenied, e:
        if password is None:
            import sys
            import getpass

            # FIXME: catch KeyboardInterrupt exception
            # FIXME: it only works on UNIX (/dev/tty),
            #  not sure whether it's bug or a feature, though
            oldout, oldin = sys.stdout, sys.stdin
            sys.stdin = sys.stdout = open('/dev/tty', 'r+')
            password = getpass.getpass()
            sys.stdout, sys.stdin = oldout, oldin
            
            return create_database(driver, database, username, password, 
                                   hostname)
        raise e

 def _initialiseDB(self):
     from sqlite3 import dbapi2 as sqlite
     self._dbFile = os.path.join(self._g.DATA_PATH, 'art.db')
     self._db = sqlite.connect(self._dbFile)
     self._createDB()
     self._menuFile = os.path.join(self._g.DATA_PATH, 'menu-%s.db' % self._g.MarketID)
     self._menuDb = sqlite.connect(self._menuFile)

    def __init__(self, path, db_name="base.db"):
        '''constructor'''
        self.path = path
        self.db_name = db_name

        self.events = {}
        self.groups = {}
        self.accounts = {}

        full_path = os.path.join(path, db_name)

        if os.path.exists(full_path + "copy"):
            shutil.copy(full_path + "copy", full_path)

        self.connection = sqlite.connect(full_path)
        self.cursor = self.connection.cursor()

        if self.__need_clean():
            self.__clean()

        self.connection = sqlite.connect(full_path)
        self.cursor = self.connection.cursor()

        self._count = 0

        try:
            self._create()
        except sqlite.OperationalError:
            self._load_events()
            self._load_groups()
            self._load_accounts()
            self._load_account_by_group()

 def __init__(self,db_filename):
     self.db_filename = db_filename
     if not os.path.isfile(self.db_filename):
         self.con = sqlite.connect(self.db_filename)
         self.con.execute("create table data (key PRIMARY KEY,value)")
     else:
         self.con = sqlite.connect(self.db_filename)

def update_musicbrainzid( type, info ):
    log( "Updating MusicBrainz ID", xbmc.LOGDEBUG )
    artist_id = ""
    try:
        if type == "artist":  # available data info["local_id"], info["name"], info["distant_id"]
            name, artist_id, sortname = get_musicbrainz_artist_id( info["name"] )
            conn = sqlite3.connect(addon_db)
            c = conn.cursor()
            c.execute('UPDATE alblist SET musicbrainz_artistid="%s" WHERE artist="%s"' % (artist_id, info["name"]) )
            try:
                c.execute('UPDATE lalist SET musicbrainz_artistid="%s" WHERE name="%s"' % (artist_id, info["name"]) )
            except:
                pass
            conn.commit
            c.close()
        if type == "album":
            album_id = get_musicbrainz_album( info["title"], info["artist"], 0 )["id"] 
            conn = sqlite3.connect(addon_db)
            c = conn.cursor()
            c.execute("""UPDATE alblist SET musicbrainz_albumid='%s' WHERE title='%s'""" % (album_id, info["title"]) )
            conn.commit
            c.close()
    except:
        print_exc()
    return artist_id

    def __conectar(self):
        """Método privado, que nos servirá para conectarnos a la base de datos."""

# Comprobamos si ya existe la base de datos
# para simplemente, conectarnos.

        if os.path.exists(self.__fichero):
            return sqlite.connect(self.__fichero)

        # En caso de que no exista, creamos la base de datos.

        else:

            conexion = sqlite.connect(self.__fichero)
            cursor = conexion.cursor()
            #CREAMOS LA TABLA ZONAS
            TABLA = """
                    CREATE TABLE ZONAS (
                    ID INTEGER PRIMARY KEY,
                    CODIGOPOSTAL VARCHAR(20),
                    TIPOZONA VARCHAR(30),
                    CANTIDADFOLLETOS VARCHAR(20),
                    PRECIOPORMILLAR VARCHAR(30),
                    PRECIOTOTAL VARCHAR(20)"""
            cursor.execute(TABLA)
            #CREAMOS LA TABLA BUZONEOS
            conexion.commit()
                        # devolvemos la conexión
            return conexion

    def _merge(self):
        if not os.path.isfile(self._fromdb):
            raise OriginError("%r is not a file." % self._fromdb)

        new = sqlite.connect(self._fromdb)
        self._fromcursor = new_cursor = new.cursor(_DictCursor)

        if not os.path.isfile(self._todb):
            raise DestinationError("%r is not a file." % self._todb)

        old = sqlite.connect(self._todb)
        self._tocursor = old_cursor = old.cursor(_DictCursor)

        new_tables = new_cursor.execute(
                "SELECT name FROM sqlite_master "
                "WHERE type='table'").fetchall()
        for table in new_tables:
            name = table['name']
            # Verify that this table is in the older db, or not
            old_table = old_cursor.execute(
                    "SELECT name FROM sqlite_master "
                    "WHERE type='table' AND name=?", (name, )).fetchone()

            if old_table is None:
                # The older db does not have this table, create it there as
                # well the related triggers.
                print "Adding the table '%s' and related triggers." % name
                if self._dryrun:
                    continue
                self._create_table(name)
                self._create_triggers(name)

            else:
                self._merge_table(name)
                self._merge_triggers(name)

    def __init__(self, sqlite_file, maf_file, target_seqname):
        """Indexes or loads the index of a MAF file"""

        import os
        
        try:
            from sqlite3 import dbapi2 as _sqlite
        except ImportError:
            from Bio import MissingPythonDependencyError
            raise MissingPythonDependencyError("Requires sqlite3, which is "
                                               "included Python 2.5+")
        
        self._target_seqname = target_seqname
        self._maf_file = maf_file
        
        # make sure maf_file exists, then open it up
        if os.path.isfile(self._maf_file):
            self._maf_fp = open(self._maf_file, "r")
        else:
            raise ValueError("Error opening %s -- file not found" % (self._maf_file,))
        
        # if sqlite_file exists, use the existing db, otherwise index the file
        if os.path.isfile(sqlite_file):
            self._con = _sqlite.connect(sqlite_file)
            self._record_count = self.__check_existing_db()
        else:
            self._con = _sqlite.connect(sqlite_file)
            self._record_count = self.__make_new_index()
            
        # lastly, setup a MafIterator pointing at the open maf_file
        self._mafiter = MafIterator(self._maf_fp)