def configure(): print('\n /--------------------\\ ') print(' | Welcome to AIKIF | ') print(' \--------------------/ \n') print('This script asks for a folder to save to, and builds the database scripts.') print('You can do this manually by setting creating the file ' + settings_file ) print('in your current folder (' + cur_fldr + ')') print('') fldr = get_local_config() if fldr == '': fldr = ask_for_folder() print('Folder = ' + fldr) import create_database create_database.main()
def configure(): print('\n /--------------------\\ ') print(' | Welcome to AIKIF | ') print(' \--------------------/ \n') print('This script asks for a folder to save to, and builds the database scripts.') print('You can do this manually by setting creating the file ' + settings_file ) print('in your current folder (' + cur_fldr + ')') print('') fldr = get_local_config() if fldr == '': fldr = ask_for_folder() print('Folder = ' + fldr) import create_database create_database.main()
import create_sound import create_labels import create_frames import create_database # Splits the Video up into Pictures create_frames.main() # Takes the List of Labels and Timeintervals and converts them into a list of frame and label create_labels.main() # Extracts the Features of one Batch of Frames each time, creating the Feature Database # Expected Runtime: 30h create_database.main() # Extracts the Sound from the Videos # Saves the Sound to Sound-Frames # Extracts the Sound Features # Expected Runtime: 10h create_sound.main()
def main(): #name = input("What is the name of the masterfile? Include the file extension (for example, searchResults.csv).\n").strip() #try: # master_list = pd.read_csv("..//data//{}".format(name)) #except FileNotFoundError as e: # print(e) # print("Make sure the masterfile is located in a directory called data.") # return options = sys.argv c = 5 if "--help" in options: print(""" Usage: weedmaps_scrape.py [options] -name <name_of_masterfile> Pipeline options: --create Creates a new SQL database for data scraped from Weedmaps --skip-scrape Skips scraping data from Weedmaps --API-limit-pause <int> Sets number of seconds to retry an API call to Weedmaps if Weedmaps returns an "API limit exceeded" message """) return if "-name" not in options: print("Please specify a name for the master file.") return else: name = options[options.index("-name") + 1] nocsv = name.replace(".csv", "") if "--API-limit-pause" in options: c = int(options[options.index("--API-limit-pause") + 1]) # Stage 1 if "--create" in options: print("Deleting existing Weedmaps database\n") datafiles = glob.glob("..\\data\\*") # checking if weedmaps.db already exists if sum([True for x in datafiles if "weedmaps.db" in x]): delete_database.main() else: print("No existing Weedmaps database found. Moving on.") print("\nStage 1: Create database") create_database.main() else: print("Skipping Stage 1: Create database") # Stage 2 print("\nStage 2: Clean master file") clean_master_data.main(name) # Stage 3 if "--skip-scrape" in options: print("\nSkipping Stage 3: Scraping Weedmaps") else: print("\nStage 3: Scraping Weedmaps") scrape_weedmaps.main(c) # Stage 4 print("\nStage 4: Creating .csv files from SQL database") output_csv.main() # Stage 5 print("\nStage 5: Clean Weedmaps store file") clean_weedmaps.main() # Stage 6 print("\nStage 6: Joining master file and weedmaps scrape") join_master_and_weedmaps.main(nocsv) # Stage 7 print("\nStage 7: Suggesting Weedmaps stores for unjoined stores in master file") create_matches.main(nocsv) print("\nFinished. You may now use the interface to manually join stores.")
def run(self): """Run database creation script.""" create_database.main([self.config]) with self.output().open('w') as f: f.write(str(self)) return
''' LOGGER.info('Listing active customers') query = cm.Customer.select().where( cm.Customer.customer_status == 'active').count() LOGGER.info(f'{query} customers are active') return query def print_customers(): """ Prints all customer info from the database. """ all_records = cm.Customer.select() for person in all_records: print( f"Customer id: {person.customer_id}\nFirst Name: {person.customer_name}\n" f"Last Name: {person.customer_last_name}\n" f"Home Address: {person.customer_address}\nPhone Number: {person.customer_phone}\n" f"Email Address: {person.customer_email}\nStatus: {person.customer_status}\n" f"Credit Limit: ${person.customer_limit}\n") if __name__ == "__main__": cb.main() # print(add_customers_csv()) print("print all customer's info from the database") print(print_customers()) print(list_active_customers())
import create_database, preprocessing, unsupervised, update_db, supervised_test, unsupervised_test if __name__ == '__main__': create_database.main('500_kmann.csv') preprocessing.main() unsupervised_test.main() # supervised_test.main() update_db.main()
sys.path.append('/home/mathewsa/Desktop/confinement_table/codes+/') import fast_efit06 from fast_efit06 import path_shot sys.path.append('/home/mathewsa/Desktop/confinement_table/codes+/') import data_acquire_MDSplus sys.path.append('/home/mathewsa/Desktop/confinement_table/codes+/') import insert_columns_and_populate_training sys.path.append('/home/mathewsa/Desktop/confinement_table/codes+/') import create_database sys.path.append('/home/mathewsa/Desktop/confinement_table/codes+/') import populate_new_database import sqlite3 sqlite_old_file = '/home/mathewsa/Desktop/am_transitions.db' #location of old database try: create_database.main( ) #creates confinement_table in database (old = new = same database here) except: print('Table already exists') populate_new_database.main( ) #inserts rows at every 1ms in confinement table of database sqlite_new_file = '/home/mathewsa/Desktop/am_transitions.db' #location of new database table_old_name = 'transitions' #name of old table in old db table_new_name = 'confinement_table' #name of new table in new db column1 = 'shot' column2 = 'id' column3 = 'present_mode' column4 = 'next_mode' column5 = 'time' column6 = 'time_at_transition' # Connecting to the database file
def test_03_create_database(self): result = c_d.main(self.hostname, self.username, self.password) self.assertTrue(result)