Beispiel #1
0
    def read(self):
        name = self.name

        if len(name) < len(MDB_FOLDER) + len('.mdb') or name[-4:] != '.mdb' or name.index(MDB_FOLDER) != 0:
            raise ValueError("invalid name!")

        self.name = name[len(MDB_FOLDER):-4]
        bcolors.printc(bcolors.OKGREEN + bcolors.BOLD, 'read ' + name + '...')
        #read mdb file
        try:
            for row in io.read(name):
                self._data.append(row)
        except:
            pass
def initialize():
    """
        Not in use.
        This function is used to create picke objects from datasets.
        We already provide the pickle files.
    """
    ## To create initial record
    from meza import io
    record = io.read(home_folder + 'jee2009.mdb')
    result = []
    for i in range(384977):
        result.append(next(record))
    pickle.dump(result, open(home_folder + "jeeresult.pickle", "wb"))

    mark = []
    for r in result:
        mark.append(int(r['mark']))
    mark.sort(key=lambda i: -int(i))
    pickle.dump(mark, open(home_folder + "jeemark.pickle", "wb"))
Beispiel #3
0
def mdd():
    records = io.read('KD021216.mdb')
    print(next(records))
Beispiel #4
0
from meza import io

records = io.read(
    "C:\1UNRuniversityFolder\Dissertation\Chapter 2-snow-forest\obseravation_analysis\Jemez\valles_dep_0810.mat"
)  # only file path, no file objects
print(next(records))
# import csv
# import pyodbc

# mdb = r"D:\_MACIEK_\python_proby\proba\mdb\ZAKRES.mdb"
# drv = "{ODBC Driver 17 for SQL Server}"
# pwd = "pw"
# server = "tcp:myserver.database.windows.net"

# con = pyodbc.connect(
#     r"DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};"
#     r"DBQ=D:\_MACIEK_\python_proby\proba\mdb\ZAKRES.mdb"
# )
# cur = con.cursor()

# SQL = "SELECT * FROM ZASIEG"
# rows = cur.execute(SQL).fetchall()
# cur.close()
# con.close()

# with open(r"D:\_MACIEK_\python_proby\proba\mdb\aa.csv", "wb") as fou:
#     csv_writer = csv.writer(fou)
#     csv_writer.writerows(rows)

from meza import io

records = io.read(r"D:\_MACIEK_\python_proby\proba\mdb\ZAKRES.mdb")
print(next(records))
Beispiel #6
0
VERBOSE = True
path = os.path.dirname(__file__)


# path = path.replace("\\","/")
# print("/KD021216.MDB")
def mdb_to_pandas():
    subprocess.call(["mdb-schema", "KD021216.MDB", "mysql"])
    # Get the list of table names with "mdb-tables"
    table_names = subprocess.Popen(["mdb-tables", "-1", database_path],
                                   stdout=subprocess.PIPE).communicate()[0]
    tables = table_names.splitlines()
    sys.stdout.flush()
    # Dump each table as a stringio using "mdb-export",
    out_tables = {}
    for rtable in tables:
        table = rtable.decode()
        if VERBOSE: print('running table:', table)
        if table != '':
            if VERBOSE: print("Dumping " + table)
            contents = subprocess.Popen(
                ["mdb-export", database_path, table],
                stdout=subprocess.PIPE).communicate()[0]
            temp_io = StringIO(contents.decode())
            print(table, temp_io)
            out_tables[table] = pd.read_csv(temp_io)
    return out_tables


records = io.read('KD021216.MDB')  # only file path, no file objects
print(next(records))