he adopts Fido: >>> herb_fido.owner = uncle_bob >>> herb_fido.save() >>> bob_fido = herb_fido # rename our variable for clarity Retrieving Data The real strength of our database is in how it allows migrations module works with SQLite, MySQL and Postgres, and will even allow you to do things like drop or rename columns in SQLite! Here is an example of how you might write a migration script: from playhouse original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Release 2.10.2 >>> herb_fido.owner = uncle_bob >>> herb_fido.save() >>> bob_fido = herb_fido # rename our variable for clarity 1.2.3 Retrieving Data The real strength of our database is in how it allows migrations module works with SQLite, MySQL and Postgres, and will even allow you to do things like drop or rename columns in SQLite! Here is an example of how you might write a migration script: from playhouse original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Herb’s house, so he adopts Fido: herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity Retrieving Data The real strength of our database is in how it allows must exist first in order to be replaced. Example of replacing the value of an existing key: # Rename the "posts" category to "notes". nrows = (APIResponse .update(json_data=APIResponse.json_data original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Herb’s house, so he adopts Fido: herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity Retrieving Data The real strength of our database is in how it allows to be replaced. Example of replacing the value of an existing key: Parameters: Parameters: # Rename the "posts" category to "notes". nrows = (APIResponse .update(json_data=APIResponse.json_data original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Herb’s house, so he adopts Fido: herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity Retrieving Data The real strength of our database is in how it allows Parameters: exist first in order to be replaced. Example of replacing the value of an existing key: # Rename the "posts" category to "notes". nrows = (APIResponse .update(json_data=APIResponse.json_data original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Documentation, Release 3.3.0 herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity 1.2.3 Retrieving Data The real strength of our database is in how it allows must exist first in order to be replaced. Example of replacing the value of an existing key: # Rename the "posts" category to "notes". nrows = (APIResponse .update(json_data=APIResponse.json_data.replace( original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Documentation, Release 3.4.0 herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity 1.2.3 Retrieving Data The real strength of our database is in how it allows must exist first in order to be replaced. Example of replacing the value of an existing key: # Rename the "posts" category to "notes". nrows = (APIResponse .update(json_data=APIResponse.json_data.replace( original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field:

Herb’s house, so he adopts Fido: herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity Retrieving Data The real strength of our database is in how it allows original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field: migrator.add_not_null('story', 'modified_date'), ) Renaming a table: migrate( migrator.rename_table('story', 'stories_tbl'), ) Adding an index: # Specify the table, column names, and whether

Documentation, Release 3.5.0 herb_fido.owner = uncle_bob herb_fido.save() bob_fido = herb_fido # rename our variable for clarity 1.2.3 Retrieving Data The real strength of our database is in how it allows original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field: previous page) migrator.add_not_null('story', 'modified_date'), ) Renaming a table: migrate( migrator.rename_table('story', 'stories_tbl'), ) Adding an index: # Specify the table, column names, and whether

original name of the column, and its new name. migrate( migrator.rename_column('story', 'pub_date', 'publish_date'), migrator.rename_column('story', 'mod_date', 'modified_date'), ) Dropping a field: migrator.add_not_null('story', 'modified_date'), ) Renaming a table: migrate( migrator.rename_table('story', 'stories_tbl'), ) Adding an index: # Specify the table, column names, and whether Whether the column should be droppe with CASCADE. rename_column(table, old_name, new_name) table (str) – Name of the table containing column to rename. old_name (str) – Current name of the column. new_name