Check out tag, “a command line tool to manipulate tags on Mac OS X 10.9 Mavericks files, and to query for files with those tags”. The GitHub repository has installation instructions (there are Homebrew and MacPorts packages).
Docstrings are stored as metadata under the :doc key. This is probably the number 1 most apparent use of metadata. Return and parameter types can be optionally tagged with metadata to improve performance by avoiding the overhead of reflecting on the types at runtime. These are also known as “type hints.” #^String is a type … Read more
sp_helptext works to get the sql that makes up a trigger. The text column in the syscomments view also contains the sql used for object creation.
My guess is, it’s from the old times when packaging meta data was not common then. In PEP 8 one is encouraged to use the _version_ top level variable to hold the revision id of the versioning system in use. This dates back to 2001-05-01. PEP 396 is superseding this for module _version_ attributes. For … Read more
Here is how to add example.png as album cover into example.mp3 with mutagen: from mutagen.mp3 import MP3 from mutagen.id3 import ID3, APIC, error audio = MP3(‘example.mp3’, ID3=ID3) # add ID3 tag if it doesn’t exist try: audio.add_tags() except error: pass audio.tags.add( APIC( encoding=3, # 3 is for utf-8 mime=”image/png”, # image/jpeg or image/png type=3, # … Read more
Use Pillow, it’s a fork of PIL that is still in active development, and supports python3. Here I use a dict generator to map the exif data to a dict from PIL import Image, ExifTags img = Image.open(“/path/to/file.jpg”) exif = { ExifTags.TAGS[k]: v for k, v in img._getexif().items() if k in ExifTags.TAGS }
Found the solution: ALTER TABLE tableA CHANGE ts ts BIGINT AFTER id; See this for complete details: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn
I don’t know of a way using matplotlib, but you can add metadata to png’s with PIL: f = “test.png” METADATA = {“version”:”1.0″, “OP”:”ihuston”} # Create a sample image import pylab as plt import numpy as np X = np.random.random((50,50)) plt.imshow(X) plt.savefig(f) # Use PIL to save some image metadata from PIL import Image from … Read more
Use extended properties. For example to add an extended property to a table in the dbo schema you can use: EXEC sys.sp_addextendedproperty @name=N'<NameOfProp>’, @value=N'<Value>’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’,@level1name=N'<Table>’ You can update them: EXEC sys.sp_updateextendedproperty @name=N’MS_Description’, @value=N’My Description’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’ ,@level1name=N'<YOUR TABLE NAME>’ You can read them like: SELECT * FROM fn_listextendedproperty (NULL, ‘schema’,’dbo’, ‘table’, ‘<yourtable>’, … Read more
If you want to see magic names whether documented or not, go to the Lib directory and run: egrep -oh ‘__[A-Za-z_][A-Za-z_0-9]*__’ *.py | sort | uniq That produces: ‘__all__’ ‘__args__’ ‘__author__’ ‘__bases__’ ‘__builtin__’ ‘__builtins__’ ‘__cached__’ ‘__call__’ ‘__class__’ ‘__copy__’ ‘__credits__’ ‘__date__’ ‘__decimal_context__’ ‘__deepcopy__’ ‘__dict__’ ‘__doc__’ ‘__exception__’ ‘__file__’ ‘__flags__’ ‘__ge__’ ‘__getinitargs__’ ‘__getstate__’ ‘__gt__’ ‘__import__’ ‘__importer__’ ‘__init__’ ‘__ispkg__’ … Read more